The Logical and Physical Database Design Methodologies
Overview/Description Target Audience Expected Duration Lesson Objectives Course Number Overview/Description
When designing a database – after the requirements are gathered from the organization and the conceptual ERD has been approved – the logical design, and then the physical design can be completed. The logical design consists of taking the conceptual diagram and converting it to represent the logical implementation of the database; this includes identifying the entities, attributes, and the relationships that will exist. This also includes normalizing the database to remove redundant information. After the logical database design, the physical database needs to be implemented. Implementing the physical design includes actually creating the tables, determining the columns and their specifications, and determining indexes and views. This course discusses how to complete the logical database design and how to implement the physical database design.
Individuals looking to gain an understanding of concepts and practices required to design relational databases