Overview

In Module 3 of MIS 3353, students will learn the core principles of database design and implementation, focusing on both theoretical and practical aspects of structuring and building databases. This module includes:

Logical Design: Students will learn how to transform business requirements into structured database models. They will understand how to organize data logically by defining tables, attributes, and relationships, ensuring efficiency and reducing redundancy.
Normalization: The module covers the process of organizing data into well-structured databases by applying the rules of normalization (1NF, 2NF, and 3NF). Students will gain an understanding of how to eliminate anomalies and optimize the database structure.
Physical Design: Students will explore how to create a physical database schema, choosing appropriate data types, indexing strategies, and ensuring data integrity. The focus will be on developing designs that enhance performance and scalability in real-world environments.
Implementation: The final stage of the module involves using SQL to create, read, update, and delete (CRUD) operations. Students will build and populate a database in SQL Server, bringing their designs to life through hands-on exercises.

By the end of this module, students will be able to design and implement efficient databases, applying best practices in logical design, normalization, and physical database creation. These skills form the foundation for further learning in advanced database topics and data management systems.

Module Objectives

In this module, the activities, content, and assignments will guide your learning process to ensure you can:

MO8: Identify and explain normal forms (0NF, 1NF, 2NF, and 3NF) and normalize a database schema to 3NF.
MO9: Develop an effective physical database design that aligns with normalized schema and performance considerations.
MO10: Utilize CREATE, READ, UPDATE, and DELETE (CRUD) operations to build and populate a small database in SQL Server.

Module To-Do List

Here's everything you need to do and remember for this module:

Review the required resources in TopHat Textbooks
Complete the Quizzes in TopHat
Complete the Participation Exercises
Complete the Homework Assignment
Complete the Module Reflection