Objectives:
The state of the art in data and information processing. Approaches and applications in centralized and distributed databases and information bases. Conceptual and logical database design, based on the Entity Relationship model. Combining conceptual design and functional analysis together for a more powerful design methodology. Translation of the conceptual model to different logical models and vice versa. To illustrate the design concepts with a large case study. Computerized database design tools. Other contemporary topics in databases including object databases, intelligent databases, and distributed multimedia databases. Class participation and hands-on lab efforts are important.
Prerequisites: CS 450/550 or equivalent experience
Textbook:
C. Batini, S. Ceri, and S. B. Navathe Conceptual Database Design, An Entity-Relationship Approach Benjamin/Cummings Publishing, Inc. 1992
S. Shen: Shen's Interactive Guide to Internet Resources; http://www.odu.cs.edu/ shen/ietir
References:
ACM Transactions on Database Systems Communications of the ACM Proceedings of Int. Conf. on VLDB ACM Computing Survey Proceedings of Int. Conf. on ER Approach Database Programming &Design Tutorial: Object-Oriented Computing, IEEE IEEE Computer
Outline:
1. Database, knowledge base, and information base. 2. Distributed multimedia databases, applications and implementations. 3. Traditional database and design: Conceptual design methodologies View design and view integration Refining a database model Data model documentation and maintenance 4. Functional analysis with dataflow model 5. Combining conceptual design with functional analysis 6. Case study 7. Database design using Entity-Relationship models 8. From ER model to relational, network, and hierarchical models, and vice versa 9. Computerized database design tools 10. Object-oriented databases 11. Intelligent databases