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                     =                 160   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 July 15 2024.  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.