Database Design

Learning Outcomes

Upon successful completion of this course, students are expected to be able to understand the role of databases in organization and information systems; create a relational database schema based on a conceptual model and any other data storage requirements otherwise identified; document database structure including tables, fields, and indexes according to standards; able to use SQL to construct, secure and access the database; understand the fundamental principles of different data architecture.

Topics

The course introduces the concept of information modeling, which emphasizes the importance of grouping the information into specific categories before it is transferred to the actual database design. At the end of the course, an implementation phase is discussed to ensure the students are well aware of any implications that might develop from improper information modeling. In addition this course also aims to introduce students to the concept of database design by predicting the use of future retrieval systems. Students understand that both a consideration of the data model and awareness of the retrieval system to be applied are required in designing a database. Consequently, new concepts are introduced, such as Query Processing and Optimization, Transaction Processing Concepts, and Concurrency Control Techniques. This will lead students to understand the method of database tuning, functional dependencies, and normalization for RDB that will help them to understand more advanced course in the next semester.

Prerequisite : IS101 – Introduction to IT 100