|
 |
Revised
06 Sep 2006 |
|
|
Introduction
|
COURSE DESCRIPTION
District Curriculum
Oracle: Data Modeling and Relational Database Design
Top-down, systematic approach to developing a relational database and
defining requirements as entities, attributes, and relationships.
Developing an entity-relationship (ER) diagram that accurately reflects the business.
Mapping the ER diagram to an initial database design.
Prerequisites: CIS105 or permission of instructor.
The course is offered in a hybrid format where traditional class time will be replaced
with online activities or other technology enabled assignments to be completed outside of the classroom.
|
COURSE COMPETENCIES
| |
| 1. | Describe the stages of the database development process. |
| 2. | Develop basic and complex data models. |
| 3. | Map simple and complex ER diagrams to an initial database table design. |
| 4. | State the principles of normalization. |
| 5. | Understand the principals of referential integrity. |
|
|
COURSE WORK
|
| Weekly course work includes reading, class lecture review, and activities and projects.
|
| Tests include quizzes and a final exam.
|
| Projects/Activities involve the hands-on application of the course material
to solve problems and will involve work outside of scheduled class time.
|
The course Syllabus is accesible through the link at the left.
The syllabus and the course web pages are subject to change and any changes to the syllabus or material on the course web pages will be announced in class.
|
|
|
|
|
|
