LIBR 554/ARST 554: Database Design (Winter T1 2024)

Course Description

Goal:

The goal of this course is to provide students with knowledge and skills necessary to produce a well-designed database that enables the timely delivery of accurate information in a useful form

Objectives:

Upon completion of this course students will be able to:

• Explain basic database concepts and terminology
• Identify information needs within an organization
• Formulate user and organizational requirements for a database
• Design a conceptual model that satisfies these needs and requirements using a relational data / entity relationship model
• Normalize this relational data / entity relationship model
• Implement the corresponding logical model in a relational database management software (e.g. MS ACCESS, MS SQL Server, etc.)
• Design SQL queries for a relational database to satisfy users’ information needs

Content:

• Overview of databases and database design
• Components of a database
• Conceptual design and Entity Relationship Diagram (ERD)
• The relational model
• Normalization
• Logical design
• Querying a database using SQL
• Issues and Trends in DBMS
• Creating a database