CIS 670: Introduction to Database Systems
Description
Data models and languages; database organization, database design, and
integrity; the use of database systems.
Level, Credits, Class Time Distribution, Prerequisites
| Level |
Credits |
Class Time Distribution |
Prerequisites |
|
U G |
3 |
Three one-hour lectures |
CIS 570 |
Quarters Offered, General Information, Exclusions, Cross-Listings, etc.
Objectives
- Master using relational databases.
- Master using relational data languages including SQL and
relational algebra.
- Master using suitable mechanisms for data independence including
the use of
data models, languages and views to achieve data independence.
- Master designing the logical structure of databases.
- Be familiar with architecting and designing database management systems.
- Be familiar with requirements for physical database design.
- Be exposed to object-oriented and network data models and their
comparative strengths.
Texts
- Elmasri, Navathe, Fundamentals of Database Systems.
| Relationship to ABET Criterion 3 |
Relationship to CSE Program Objectives |
| a |
b |
c |
d |
e |
f |
g |
h |
i |
j |
k |
| XXX |
|
XX |
|
XX |
X |
|
|
|
|
XXX |
|
| 1a |
1b |
1c |
2a |
2b |
3a |
3b |
3c |
4a |
4b |
| XXX |
XX |
XX |
|
|
|
|
X |
XXX |
X |
|
Topics
| No. of Wks. |
Topics |
|
2 |
Overview of DBMS & Database Design |
|
3 |
Relational Data Model and Languages |
|
2 |
Relational DB Design and Normalization Principles |
|
1 |
Comparison of Models and Languages |
|
2 |
System Implementation |
Grading Plan
| Homeworks Problems |
40% |
| Midterm Exam | 30% |
| Final Exam | 30% |
Preparer Information and Date:
Syllabus prepared by Doug Kerr, last modified April 30, 1999.