Concepts and methodology of data base planning, design, development, and management of the computerized data base of a management information system. The emphasis is on logical data base design and a study of hierarchical, network, and relational implementations. Normalization exercises are completed relative to the logical design of relational data bases. Exercises and assignments use a relational DBMS package.

Learning outcomes

Upon completion of this course, students should:

• learn the concepts of Entity-Relationship (ER) model and Unified Modeling Languages (UML)

• be able to design and draw a model for a database application

• learn the concepts of Normalization and appreciate why it is important to the database design

• appreciate the benefits and realize the constraints and limitations of database management systems

• gain an experience on how database systems can be constructed using commercial DBMS products

• develop technical writing, teamwork, and presentation skills

• learn concepts of data warehouses and data mining

• learn concepts of database administration

• learn how to conduct research on issues related to database management