WHY ARE WE STILL USING ORACLE 11G EXPRESS ?

As technology has advanced  there have been advances in Oracle releases -- -- however-- --  the more recent Oracle releases require significantly more hardware/software support - that is -- since Oracle is a business use  product  more than a home use product -- recent Oracle release require the software/hardware configuration to be "Professional" in configuration rather then "Home" configuration -- 

AND

for the purposes of this course which is fundamental in nature -- the older release is adequate  as a leaning tool

Course Description: 

            Credit Hours: 3

            Classroom Contact Hours per week: 3

            Laboratory Contact Hours per week: 3

Applications development using database programming techniques emphasizing database structures, modeling, and database access. This course instructs the student in the essential concepts and design methodology for the Relational Database Model as implemented by Oracle. Other topics include: the Data Definition Language, the Data Manipulation Language, database normalization, transaction processing, security, multi-user problems and solutions.  

Transferability of workforce courses varies. Students interested in transferring courses to another college should speak with their Area of Study (AoS) advisor, Department Chair, and/or Program Director.

Course Rationale:  This course is designed as a survey course to teach students to design, implement, and maintain databases. The Relational Database Model and the SQL language will be emphasized. On-line Transaction Processing Systems will be studied and contrasted with Distributed Database Management Systems and Data Warehousing Systems. Web databases will be introduced. The Oracle DBMS will be used throughout the course in Lectures and in labs.

This course is part of the Computer Information Technology Database Certificate plan. Completion of this course provides the student with the initial knowledge required in preparation for consideration as an entry level database programmer, and acts as preparation for Oracle Certification test .

Pre-requisite:  COSC1315 Fundamentals of Programming,  COSC1336  Programming Fundamentals  or department approval.

Course Objectives/ Learning Outcomes:

 Establish a basic understanding of the analysis and design of a database.
 Establish a basic understanding of the process of Database Development and  Administration using SQL.
 Enhance Programming and Software Engineering skills and techniques using SQL.
 Establish a basic understanding of background materials needed for technical  support using SQL.
Solve Database problems using Oracle11g Express with Oracle 12c SQL  by applying SQL commands to Create, Insert, Update, and Retrieve a  simple database.
Understand the services provided by a Database Management System.
Understand the use and application of the Relational Database Model.
Understand Transaction Processing and Multi-user Database support.
Understand the difference between a Production transaction database and a Data Warehouse.
Understand the Client/Server structures used in Database Management Systems.
Design and Implement a basic database using the Oracle Database Management

SCANS ITEMS COMPETENCIES:

CODE DESCRIPTION ITSE2309 LEVEL
F1     READING: Locates, understands, and interprets written information in prose and documents such as manuals, graphs, and schedules 2
F3     ARITHEMETIC: Performs basic computations; uses basic numerical concepts such as whole  numbers, etc. 2
F4     MATHEMATICS: Approaches practical problems by choosing appropriately from a variety of mathematical techniques. 2
F5     LISTENING: Receives, Attends to, interprets, and responds to verbal messages and other cues. 2
F9     PROBLEM SOLVING: Recognizes problems and devises and implements plan of action 2
F10  SEEING THINGS IN THE MINDS EYE: Organizes and processes symbols, pictures, graphs, objects, and other information. 2
F12  REASONING: Discovers a rule or principle underlying the relationship between two or more objects and applies it when 2
C1   TIME: Selects goal relevant activities, ranks them, allocates time, and prepares and follows schedules.  2
C5   Acquires and evaluates information 2
C6   Organizes and maintains information 2
C7   Interprets and communicates information  2
C8   Uses computers to process information 2

Approved Course Text:  Set by taskforce

Database Systems Design, Implementation, and Management – 14th Edition By
Coronel/Morris – Thompson/Course Technology

ISBN 978-0-357-67303-4

Oracle 12c: SQL Set by taskforce

Author:          Casteel

Edition:          1st

Publisher:       Cengage

ISBN:             978-1-305-25103-8

Grading System:   Grade will be based both on concepts and practical application.

Grade Scale:
            90%  - 100%         A

            80%  -  89%          B

            70%  -  79%          C

            60%  -  69%          D

            0%    -  59%          F

Assignment composition

ORIENTATION QUIZ-- Due first three days of course

                1ea.   Orientation Quiz                                                                        =   10 Points
Lecture text book

            16ea.    End of Chapter  quizzes 10 points each                     =                150   Points
            16ea.    Chapter  Key Terms 4.69 points each                        =                   75   Points
             3ea.      Major Exams 125 point each                                    =                  375   Points

Lab text book

            12ea.   End of Chapter  quizzes  (7.5 points each)                             =    90  Points
            3ea.   Laboratory Assignment (100 points ea.)                                   =    300  Points    

                                                                                                               1000 total possible points          

Note:1) ALL COURSE WORK IS SUBMITTED/CONDUCTED IN BLACKBOARD

         2)    Allow an average of 15 hours per assignment

         3.     Multiple attempts on submitals will be averaged (max of three attempts)

         4)     Please be aware of the grading system which is using a weighted average method, as

                 such, --  for example – a grade of 80 on a lab quiz would be 80% of  7.5 points or 6

                 points

         5).    The format of exams multiple choice, short answer, essay, matching, combination.

         6)     Submissions/Assignments/Exams/Quizzes must be in the students own

                words  --Any Copy/pasting from any source -- such as from text -- end

                of text glossary terms— On line resources ---Definitions etc.--could be

                considered   plagiarism – the idea is for the student to use his/her own

                words this also address/includes the use of any AI support

           7) Assignments/quizzes/labs/exams --  submitted 7 days after due dates

                 are subject to a minimum 20%  penalty.  Assignments due within Competency 1
                 submitted within Competency 4 time frame are  subject to a 50% penalty 

           8)   Of special consideration --  Oracle is not Mac(Apple) compatible  -- as such  --

                   a student must  make appropriate accommodations 

The combined 27 lecture and lab based  quizzes are due as posted with schedule dates  and have an allowance of  seven days (grade period) before a penalty is applied.

Course/Class Policies:

For in-classroom courses:

Regular and punctual class and laboratory attendance is expected of all students.  If attendance or compliance with other course policies is unsatisfactory, the instructor may withdraw students from the class.

For  online courses:

Regular and timely use of Blackboard participation in discussions and completion of work is expected of all students.  If attendance or compliance with other course policies is unsatisfactory, the instructor may withdraw students from the class.

In the event the college or campus closes due to unforeseen circumstances (for example, severe weather or other emergency), the student is responsible for communicating with their professor during the closure and completing any assignments or other activities designated by their professor as a result of class sessions being missed.

Withdrawal Policy

The College defines withdrawals as occurring after the official reporting date of the semester, typically the 12th class day.  In addition, the Legislature has mandated the Rule of Six (see below).  There may also be financial aid issues.

It is the responsibility of each student to ensure that his or her name is removed from the rolls should they decide to withdraw from the class.  The instructor does, however, reserve the right to drop a student should he or she feel it is necessary.  If a student decides to withdraw, he or she should also verify that the withdrawal is recorded before the Final Withdrawal Date.  The Final Withdrawal Date for this semester is Nov 16th 2023.  The student is also strongly encouraged to keep any paperwork in case a roblem arises.

 Students are responsible for understanding the impact that withdrawal from a course may have on their financial aid, veterans’ benefits, and international student status.  Per state law, students enrolling for the first time in Fall 2007 or later at any public Texas college or university may not withdraw (receive a W) from more than six courses during their undergraduate college education. Some exemptions for good cause could allow a student to withdraw from a course without having it count toward this limit. Students are strongly encouraged to meet with an advisor when making decisions about course selection, course loads, and course withdrawals.

Incomplete's

A student may receive a temporary grade of “I” (Incomplete) at the end of the semester only if  the following conditions are considered: 

Students may request an Incomplete from their faculty member if they believe circumstances warrant.  The faculty member will determine whether the Incomplete is appropriate to award or not.  The following processes must be followed when awarding a student an I grade. 

1. Prior to the end of the semester in which the “I” is to be awarded, the student must meet with the instructor to determine the assignments and exams that must be completed prior to the deadline date.  This meeting can occur virtually or in person.  The instructor should complete the Report of Incomplete Grade form.

 I.  The student is unable to complete the course during the semester due to
              circumstances beyond their control

II. The student must have earned at least half of the grade points needed for a “C”
               by the end of the semester

2.      The faculty member will complete the form, including all requirements to complete the course and the due date, sign (by typing in name) and then email it to the student.  The student will then complete his/her section, sign (by typing in name), and return the completed form to the faculty member to complete the agreement.  A copy of the fully completed form can then be emailed by the faculty member to the student and the department chair for each grade of Incomplete that the faculty member submits at the end of the semester.   

3.      The student must complete all remaining work by the date specified on the form above.  This date is determined by the instructor in collaboration with the student, but it may not be later than the final withdrawal deadline in the subsequent long semester.  

4.      Students will retain access to the course Blackboard page through the subsequent semester in order to submit work and complete the course. Students will be able to log on to Blackboard and have access to the course section materials, assignments, and grades from the course and semester in which the Incomplete was awarded.  

5.      When the student completes the required work by the Incomplete deadline, the instructor will submit an electronic Grade Change Form to change the student’s performance grade from an “I” to the earned grade of A, B, C, D, or F. 

If an Incomplete is not resolved by the deadline, the grade automatically converts to an “F.”  Approval to carry an Incomplete for longer than the following semester or session deadline is not frequently granted.”

Course Topics:

 Lecture:

1)   Database Concepts  2)  Database Life Cycle  3)  Database Design  4)  Relational Database Model  5)  Distributed Database Management Systems  6)  Data Warehousing and Data Mining 7)  Entity Relationship Diagrams (ERD)  8)  Relational Schema  9)  Normalization of Database Tables  10)  Transaction Management and Concurrency  11)  Report Generation  12)  Database Administration  13)  Database Optimization

 Lab:   1)  SQL and Oracle   2)  SQL Commands to be discussed  3)  DML Commands – Select, Insert, Update, Delete,   4)  DDL Commands – Create Table, Drop Table, Create View, Alter, Grant    5)  Transaction Commands – Commit, Rollback  6)  Explore Development tools such as SQL Developer

Note: For on-line courses -a remote Oracle database to support required work is possible

by downloading Oracle 11g from the ACC Google Drive.  A remote database can minimize

  trips to ACC computer labs to complete assignments.

HEALTH & SAFETY PROTOCOLS  -- SUBJECT TO CHANGE

All ACC campuses and centers have one entrance for students and employees. The college is limiting facility access to faculty, essential staff, and students who are enrolled in Career and Technical Education courses. 

COLLEGE POLICIES

Campus Operations

Statement on Academic Integrity

Austin Community College values academic integrity in the educational process.  Acts of academic dishonesty/misconduct undermine the learning process, present a disadvantage to students who earn credit honestly, and subvert the academic mission of the institution. The potential consequences of fraudulent credentials raise additional concerns for individuals and communities beyond campus who rely on institutions of higher learning to certify students' academic achievements, and expect to benefit from the claimed knowledge and skills of their graduates. Students must follow all instructions given by faculty or designated college representatives when taking examinations, placement assessments, tests, quizzes, and evaluations.  Actions constituting scholastic dishonesty include, but are not limited to, plagiarism, cheating, fabrication, collusion, falsifying documents, or the inappropriate use of the college’s information technology resources.  Further information is available at https://www.austincc.edu/about-acc/academic-integrity-and-disciplinary-process

Student Rights & Responsibilities

Academic freedom is a foundation and hallmark of higher education.  In the context of college-level courses, it specifically refers to the rights of free expression and respect for others with differing opinions.  Students at the college have the rights accorded by the U.S. Constitution to freedom of speech, peaceful assembly, petition, and association. This concept is accompanied by an equally demanding concept of responsibility on the part of the student.  Just as you are expected to exercise these rights with respect for state and federal law in the larger world, you are expected to exercise these rights as a student with respect for the college’s standards of conduct.  These rights carry with them the responsibility to accord the same rights to others in the college community and not to interfere with or disrupt the educational process.  Students and faculty alike should enable a climate of mutual respect and civility while fostering the freedom to debate and discuss the merits of competing ideas.

Enrollment in the college indicates acceptance of the rules set forth in the student standards of conduct policy, which is administered through the office of the campus dean of student services. Due process, through an investigation and appeal process, is assured to any student involved in disciplinary action.

Senate Bill 212 and Title IX Reporting Requirements 

Under Senate Bill 212 (SB 212), the faculty and all College employees are required to report any information concerning incidents of sexual harassment, sexual assault, dating violence, and stalking committed by or against an ACC student or employee. Federal Title IX law and College policy also require reporting incidents of sex- and gender-based discrimination and sexual misconduct. This means faculty and non-clinical counseling staff cannot keep confidential information about any such incidents that you share with them.

If you would like to talk with someone confidentiality, please contact the District Clinical Counseling Team who can connect you with a clinical counselor on any ACC campus:  (512) 223-2616, or to schedule online:  https://www.austincc.edu/students/counseling . 

While students are not required to report, they are encouraged to contact the Compliance Office for resources and options:  Charlene Buckley, District Title IX Officer, (512) 223-7964;  compliance@austincc.edu .

If a student makes a report to a faculty member, the faculty member will contact the District Title IX

Student Complaints

A defined process applies to complaints about an instructor or other college employee. You are encouraged to discuss concerns and complaints with college personnel and should expect a timely and appropriate response. When possible, students should first address their concerns through informal conferences with those immediately involved; formal due process is available when informal resolution cannot be achieved.

Student complaints may include (but are not limited to) issues regarding classroom instruction, college services and offices on the basis of actual or perceived race, color, national origin, religion, age, gender, gender identity, sexual orientation, political affiliation, or disability.

Further information about the complaints process, including the form used to submit complaints, is available at: http://www.austincc.edu/students/students-rights-and-responsibilities/student-complaint-procedures

Statement on Privacy

The Family Educational Rights and Privacy Act (FERPA) protects confidentiality of students’ educational records. Grades cannot be provided by faculty over the phone, by e-mail, or to a fellow student.

Grades are posted in Blackboard – also of note – a weighted average method is used

Recording Policy

To ensure compliance with the Family Education Rights and Privacy Act (FERPA), student recording of class lectures or other activities is generally prohibited without the explicit written permission of the instructor and notification of other students enrolled in the class section.  Exceptions are made for approved accommodations under the Americans with Disabilities Act. 

Recording of lectures and other class activities may be made by faculty to facilitate instruction, especially for classes taught remotely through BlackBoard Collaborate or another platform.  Participation in such activities implies consent for the student to be recorded during the instructional activity.  Such recordings are intended for educational and academic purposes only.

Safety Statement

Health and safety are of paramount importance in classrooms, laboratories, and field activities. Students are expected to learn and comply with ACC environmental, health and safety procedures and agree to follow ACC safety policies.  Emergency Procedures posters and Campus Safety Plans are posted in each classroom and should be reviewed at the beginning of each semester.  All incidents (injuries/illness/fire/property damage/near miss) should be immediately reported to the course instructor. Additional information about safety procedures and how to sign up to be notified in case of an emergency can be found at http://www.austincc.edu/emergency

Everyone is expected to conduct themselves professionally with respect and courtesy to all. Anyone who thoughtlessly or intentionally jeopardizes the health or safety of another individual may be immediately dismissed from the day’s activity and will be referred to the Dean of Student Services for disciplinary action.

In the event of disruption of normal classroom activities due to an emergency situation or an illness outbreak, the format for this course may be modified to enable completion of the course. In that event, students will be provided an addendum to the class syllabus that will supersede the original version.

Campus Carry

The Austin Community College District concealed handgun policy ensures compliance with Section 411.2031 of the Texas Government Code (also known as the Campus Carry Law), while maintaining ACC’s commitment to provide a safe environment for its students, faculty, staff, and visitors.  Beginning August 1, 2017, individuals who are licensed to carry (LTC) may do so on campus premises except in locations and at activities prohibited by state or federal law, or the college’s concealed handgun policy.  In addition, concealed weapons are not allowed on ACC-sponsored field trips where the school owns or has chartered or leased vehicles for transportation.   

It is the responsibility of license holders to conceal their handguns at all times.  Persons who see a handgun on campus are asked to contact the ACC Police Department by dialing 222 from a campus phone or 512-223-7999.   Please refer to the concealed handgun policy online at http://austincc.edu/campuscarry

Discrimination Prohibited

The College seeks to maintain an educational environment free from any form of discrimination or harassment including but not limited to discrimination or harassment on the basis of race, color, national origin, religion, age, sex, gender, sexual orientation, gender identity, or disability.

Faculty at the College are required to report concerns regarding sexual misconduct (including all forms of sexual harassment and sex and gender-based discrimination) to the Manager of Title IX/Title VI/ADA Compliance.  Licensed clinical counselors are available across the District and serve as confidential resources for students.

Additional information about Title VI, Title IX, and ADA compliance can be found in the ACC Compliance Resource Guide available at: https://drive.google.com/file/d/1o55xINAWNvTYgI-fs-JbDyuaMFDNvAjz/view

Use of ACC email

All College e-mail communication to students will be sent solely to the student’s ACCmail account, with the expectation that such communications will be read in a timely fashion. ACC will send important information and will notify students of any college- related emergencies using this account. Students should only expect to receive email communication from their instructor using this account.  Likewise, students should use their ACCmail account when communicating with instructors and staff.  Information about ACC email accounts, including instructions for accessing it, are available at:  http://www.austincc.edu/help/accmail/questions-and-answers

For- On-line Courses – Use of an ACC Testing Center or approved remote location 

Under certain circumstances, examinations may have to be taken in a testing center. The ACC Testing Centers follow standard procedures so students know what to expect when they arrive to take their tests. Students should familiarize themselves with the student guidelines.

Students must present an ACC student ID card or government issued ID and know their ACC ID number before they can test.

It is necessary to check in at the Testing Center kiosk before taking a test. To check in, one must know the following information:

• Student ID number
• Course prefix and number
• Course synonym
• Course section number
• Test number
• Instructor’s name

Personal belongings such as backpacks, books, and electronic devices (including, but not limited to, cell phones and smart watches) are not allowed in the Testing Center. Possession of prohibited items or accessing unapproved resources in the testing room will result in the immediate termination of the exam and possible disciplinary action.

For additional information on using the Testing Center, please go to: http://www.austincc.edu/students/testing-services/instructional-testing

STUDENT SUPPORT SERVICES

The success of our students is paramount, and ACC offers a variety of support services to help, as well as providing numerous opportunities for community engagement and personal growth.

Student Support

ACC strives to provide exemplary support to its students and offers a broad variety of opportunities and services.  Information on these campus services and resources is available at  http://www.austincc.edu/students.

Student Accessibility Services

Students with documented disabilities who need classroom, academic, or other accommodations must request them through the office Student Accessibility Services (SAS).   SAS offices are located at each major campus.  Students are encouraged to request accommodations when they register for courses or at least three weeks before the start of the semester; otherwise, the provision of accommodations may be delayed.  Students who have received approval for accommodations from SAS for this course must provide the instructor with the document titled “Notice of Approved Accommodations” from SAS before accommodations will be provided. Accommodations will not be provided retroactively.  Arrangements by the instructor for academic accommodations can only be made after he or she receives the “Notice of Approved Accommodations” from the student.

Additional information about Student Accessibility Services is available at https://www.austincc.edu/offices/student-accessibility-services-and-assistive-technology

Academic Support

ACC offers academic support services on all of its campuses. These services, which include face-to-face and online tutoring, academic coaching, and supplemental instruction, are free to enrolled ACC students. Tutors are available in a variety of subjects ranging from accounting to pharmacology. Students may receive these services on both a drop-in and referral basis. Tutoring schedules can be found at:  https://www.austincc.edu/students/tutoring/tutoring-schedules

Library Services

ACC has a full-service library at each of its campuses to support ACC courses and programs and to provide students with research and assignment assistance from expert faculty librarians, computers, course reserves, laptop and tablet check out, study spaces, and copying, printing, and scanning services.  In addition, ACC students have full rights and privileges to access Library Services online 24/7 via the ACC Library website and students can use their ACCeID logins to access all online materials, including ebooks, articles from library databases, and streaming videos.   ACC Libraries also provide an “Ask a Librarian” service, which allows  students to reach a librarian 24/7 through online chat.  Faculty librarians are also available via email, phone, and in person seven days a week during hours of operation. Visit:

• Library Website: http://library.austincc.edu
• Ask a Librarian: https://library.austincc.edu/help/ask.php
• Library Hours of Operation by Location: https://library.austincc.edu/loc/
• Email: library@austincc.edu

In partnership with ACC’s Student Support Center, ACC Libraries also maintain a limited collection of textbooks for students to borrow. Priority access to the textbook collection is given to students receiving assistance. More information is available on the ACC website by searching “Student Support Center Textbook Collection.”

Student Organizations

ACC has over seventy student organizations, offering a variety of cultural, academic, vocational, and social opportunities.  They provide a chance to meet with other students who have the same interests, engage in service-learning, participate in intramural sports, gain valuable field experience related to career goals, and much else.  Student Life coordinates many of these activities, and additional information is available at http://sites.austincc.edu/sl/.

Personal Support

Resources to support students are available at every campus. To learn more, ask your professor or visit the campus Support Center. All resources and services are free and confidential. Some examples include, among others:

• Food pantries are located in all campus Student Life offices: https://sites.austincc.edu/sl/programs/foodpantry/.   
• Assistance with childcare or utility bills is available at any campus Support Center: http://www.austincc.edu/students/support-center.
• The Student Emergency Fund can help with unexpected expenses that may cause you to withdraw from one or more classes: http://www.austincc.edu/SEF.
• Help with budgeting for college and family life is available through the Student Money Management Office: http://sites.austincc.edu/money/.  
• Drop-in child care is available at Highland Campus: http://www.austincc.edu/students/child-care/child-watch-drop-in-center

Clinical Counseling services are available throughout the ACC Student Services District to address personal and or mental health concerns: http://www.austincc.edu/students/counseling .

If an emergency occurs during operational hours, please come to the Student Services Office and let the front intake staff know that you are experiencing a crisis. They will alert appropriate personnel. You may also contact the ACC District Police at 222 (on campus) or 223-7999 (off campus or cell phone).

After Hours:

If you are struggling with a mental health or personal crisis, call one of the following numbers to connect with resources for help. However if you are afraid that you might hurt yourself or someone else, call 911 immediately.

Free Crisis Hotline Numbers:

• Austin / Travis County 24 hour Crisis & Suicide hotline: 512-472-HELP (4357)
• The Williamson County 24 hour Crisis hotline: 1-800-841-1255
• Bastrop County Family Crisis Center hotline: 1-888-311-7755
• Hays County 24 Hour Crisis Hotline: 1-877-466-0660
• National Suicide Prevention Lifeline: 1-800-273-TALK (8255)
• Crisis Text Line: Text “home” to 741741
  • Substance Abuse and Mental Health Services Administration (SAMHSA) National Helpline:   1-800-662-HELP (4357)
• National Alliance on Mental Illness (NAMI) Helpline:1-800-950-NAMI (6264)

Illness

• Any ACC student or employee with symptoms or exposure to the COVID- virus should inform their professor(s) or supervisor and complete the college’s self reporting form: 
• https://cm.maxient.com/reportingform.php?AustinCC&layout_id=124