|
COURSE SYLLABUS |
||||||||||||||||
|
Course Number: CPT 242 Course Title: Database |
||||||||||||||||
|
Class Hours Per week: 3 |
Lab Hours Per Week: 0 |
Credits Awarded: 3 |
||||||||||||||
|
Catalog Description: |
This course introduces database models and the fundamentals of database design. Topics include database structure, database processing, and application programs which access a database. |
|||||||||||||||
|
Entry Level Skills: |
The student should have experience using Microsoft Access. The student should also have basic programming skills. |
|||||||||||||||
|
Pre-requisites: |
CPT 178, CPT 234 |
|||||||||||||||
|
Co-requisites: |
None |
|||||||||||||||
|
Text(s)/Required
Materials: |
· Text(s): Databases: Design, Development & Deployment, Second Edition, Peter Rob and Elie Semaan, McGraw Hill © 2004 · Storage media: USB flash drive |
|||||||||||||||
|
Course Competencies
and Objectives: |
Upon satisfactory completion of the course, the student should be able to: · Describe the components of a database management system. · Design, develop and normalize a complete database management system from specifications. · Create and maintain database tables. · Define table relationships. · Create, run and save queries. · Sort and filter records. · Create and customize forms, reports and labels. · Create and run macros. · Develop an effective user interface. |
|||||||||||||||
|
Major Course
Topics: |
Database terminology. Primary, foreign and composite keys. Entity and referential integrity. Relationship types. Entity Relationship Diagrams Normalization The database design process. The database implementation process. Designing and building tables. Designing and building queries. Designing and building forms. Designing and building reports. Using macros and switchboards. Developing a user interface. |
|||||||||||||||
|
Grade Calculation
Method: |
There will be a Mid Term Exam at the end of the seventh week of the semester and a Final Exam at the end of the course. Short quizzes will be given throughout the semester. A major, ongoing, semester long project will be undertaken to design and implement a database from a specification provided by the instructor. At the end of the term, the final grade is calculated as follows:
|
|||||||||||||||
|
Additional Information
Pertaining to Grades: Students must earn a minimum grade of ‘C’ in all CPT/IST courses used to fulfill graduation requirements of a Computer and Information Technology program. |
||||||||||||||||
|
Prepared by |
Date written or
revised: 6/28/2006 |
|||||||||||||||