This course covers how to complete a logical database design and how to implement the physical database. After the requirements are gathered from the organization and the conceptual ERD has been approved, you will learn that the logical design model consists of taking the conceptual diagram and converting it to represent the logical implementation of the database. In this course, you will learn about identifying the entities, attributes, and the relationships that will exist and about normalizing the database to remove redundant information. You will also learn about creating tables, choosing columns and their specifications, and determining indexes and views.
Learning Objectives
Converting ERDs to Relational Tables
- start the course
- describe the logical data model and its advantages
- define entities in the logical data model for designing a database
- identify the different categories of attributes that are used in a logical data model
- define the data types for attributes in a logical data model
- define DEFAULT and CHECK constraints and nullability for attributes in a logical data model
- describe the different keys used in a logical data model
- describe referential integrity and foreign key constraints for a logical data model
- define relationships in a logical data model for designing a database
- define advanced relationships in a logical data model
- model entity supertypes and subtypes in a logical data model
- resolve many-to-many relationships when building a logical data model
Normalization
- describe normalization in relation to designing a database
- perform first normal form when designing a database
- perform second normal form when designing a database
- perform third normal form when designing a database
- perform BCNF when designing a database
- perform fourth and fifth normal forms when designing a database
Physical Database Design
- determine the factors in selecting a DBMS for the physical database
- describe the physical database design phase
- transform entities to tables in the physical database design
- transform attributes to columns in the physical database design
- implement views into a physical database
- implement indexes into a physical database - Clustered and Non-Clustered Indexes
- implement indexes into a physical database - Hash and Bitmap Indexes
Practice: Logical & Physical Implementation
- create a logical data model and implement the physical database