ECE 56200 - Introduction to Data Management

Lecture Hours: 3 Credits: 3

Counts as:
CMPE Special Content Elective
EE Elective

Normally Offered: Fall - odd years

Catalog Description:
Emphasis is on the design of systems that can manipulate and retrieve data from large databases using high level formal languages. Topics covered are: data models and data independence, normalization in relational databases, development of high level query languages for relational and hierarchical models, visual query languages, object oriented systems and object oriented databases. The course includes a project that accounts for about twenty percent of the grade for the course.

Course Objectives:
To acquaint graduate students with up-to-date knowledge of the theory of relational and object oriented data bases and the development of database systems for applications.

Required Text(s):
  1. An Introduction to Data Base Systems, Volume I, 8th Edition, C.J. Date, Addison Wesley, 2003, ISBN No. 0321197844.

Recommended Text(s): None.

Learning Outcomes:

A student who successfully fulfills the course requirements will have demonstrated:
  1. an ability to design relational queries using relational algebra, calculus, and SQL and perform retrieval of data from a relational DBMS using SQL. [1,2]
  2. an ability of understanding and programming database triggers. [7]
  3. an ability to develop complex queries involving temporal data. [1,6]
  4. an ability to design relational database and carry out the normalization process . [1,2,7]

Lecture Outline:

Weeks Topic
0.5 1. Knowledge and data and information
1 2. Representation of knowledge in conventional date base system
0.5 3. Semantic modelling: entity relationship
0.5 4. Overview of data base management
1 5. Relational data structure
0.5 6. Relational integrity rules
1.0 7. Relational algebra
1.0 8. First order predicate calculus
1.0 9. Relational calculus
1.0 10. QBE
1.0 11. Data manipulation by SQl on Oracle DBMS
1.0 12. Normal forms (paper by Salzburg) and formal design theory of data bases
1.0 13. Knowledge intensive data models in engineering: Object oriented framework; Visual query language for graphical interaction
0.5 14. Association algebra: a mathematical foundation for object oriented databases
0.5 15. Object oriented intelligent computer integrated design, process planning and inspection.
0.5 16. Intelligent computer integrated manufacturing
0.5 17. Computer supported cooperative work