The Logical and Physical Database Design Methodologies
Descripció: Curs The Logical and Physical Database Design Methodologies
Formació en Database Design Fundamentals
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.