| |
| Course: | INFO605 - Intro to Database Management |
|
|
| On Campus Offering: | Spring (eve) |
|
| Online Offering: | Fall, Winter, Summer |
| | Faculty: | Grillo, Peter
Hu, Xiaohua Tony
Song, Il-Yeol
Li, Jiexun Jason
|
|
| Extended Course Description: | Catalog Course Description:
A first course in database management systems. Covers database design, data manipulation, and database integrity. Emphasizes concepts and techniques related to the entity-relationship model and relational database systems. Discusses normalization up to the third normal form and commercial query languages.
Pre-requisites and Co-requisites:
INFO 503 Introduction to Information Systems Analysis (Prerequisite or co-requisite)
Curriculum Role:
This course is offered to students who have no formal training in Database system and presents basic theory and technology for database design
Course Rationale:
This course establishes the theoretical background of relational databases , database query language and database design. This course is offered for students who want to be a database expert for conceptual database design.
Course Outcomes:
Upon successful completion of this course, a student will be able to:
• Understand evolving roles of database systems in an enterprise
• Learn the fundamental concepts necessary for the design, use, integrity maintenance, and implementation of database systems
• Design a database using the extended entity-relationship model
• Translate an entity-relationship diagram into a relational schema
• Understand the issues and problems in relational database systems
• Learn relational algebra, update propagation and contemporary query languages
• Understand first, second, and third normal forms
Course Content:
Principal topics and the approximate number of weeks devoted to each are:
• The basic concepts and components of DBMS (1)
• Database design and the entity-relationship model (3.5)
• Relational database systems including integrity constraints and relational algebra (1.5)
• Commercial query languages (2)
• Functional dependencies and normalization (1)
• Other advanced concepts (1)
Presentation:
Note: Presentation method may vary somewhat from section to section.
Presentation will be by lecture.
Assessment:
Note: Assessment method may vary somewhat from section to section.
Evaluation is based on assignments, project, and examination.
|
|
| Previous | Course List | Course Offerings | Next |
|
|
