Faculty Syllabus

• Each student is responsible for monitoring his/her email account frequently. 
• Students are not permitted to use AI in this course
• Students should check for e-mail and class announcements
• Students are expected to find out class assignments for missed classes and make up missed work. 
• Students are expected to find out if any changes have been made in the class or assignment schedule.
• Students are responsible for submitting a completed assignment. Make sure it is submitted otherwise you earn a zero.
• Written work must be presented in a professional manner. Work that is not submitted in a professional manner will not be evaluated and will be returned as unacceptable.
  • There is a craft to writing.  Spelling, grammar, punctuation and diction (word usage) are all tools of that craft.  Writing at the collegiate level will show careful attention to these elements of craft.  Work that does not exhibit care with regard to these elements will be considered as inadequate for college writing and graded accordingly. 
• Students are expected to take the examinations on the designated dates.  If you are unable to take the exam on the scheduled date and know in advance, you are to make arrangements with your professor before the designated date.   

Late Work:  Assignments, including postings on discussion threads, are to be completed on time according to the timeline posted by the instructor. It is important to keep up and complete work on time.  There are no make-up exams without prior consent of the instructor. You will be deducted 10% of your grade if you submit your assignment past the due date. Assignments submitted more than a week late will earn a zero. Note that you cannot submit a late discussion post. Discussions not submitted by the due date will earn a zero

Approved Course Texts/Readings: First Day

Database Systems Design, Implementation, and Management – 13th Edition By

Coronel/Morris – Thompson/Course Technology

ISBN 978-1-337-62790-0

Oracle 12c: SQL Set by taskforce

Author:           Casteel

Edition:           1st

Publisher:       Cengage

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 21c from the Oracle website.  A remote database can minimize trips to ACC computer labs to complete assignments. See courseroom for how to video.

1. Recognize the basic concepts of the analysis and design of a database.

2. Summarize the process of Database Development and Administration using SQL.

3. Enhance Programming and Software Engineering skills and techniques using SQL.

4. Develop a basic understanding of background materials needed for technical support SQL.

5. Solve Database problems using the Oracle DBMS by applying SQL commands to

Create, Insert, Update, and Retrieve a simple database.

6. Recognize the services provided by a Database Management System.

7. Recognize the use and application of the Relational Database Model.

8. Recognize Transaction Processing and Multi-user Database support.

9. Recognize the difference between a Production transaction database and a

Data Warehouse.

10. Recognize the Client/Server structures used in Database Management Systems.

11. Develop and complete the design and Implementation of a basic database solution using the Oracle Database Management System. 

SCANS (Secretary’s Commission on Achieving Necessary Skills):

The following list summarizes the SCANS competencies addressed in this particular course:

Grade will be assigned based both on concepts and practical application. Exams, quizzes, and lab projects will be a part of the grade.  An overall grade will be assigned on the following grading scale: