DatabaseDesignLogicalModelsNormalizationandThe.pptVIP

Database Design: Logical Models: Normalization and The Relational Model University of California, Berkeley School of Information IS 257: Database Management Announcements I will be away next week Instead we will have an informal workshop to work on issues of choosing and designing your personal Databases Lecture Outline Review Conceptual Model and UML Logical Model for the Diveshop database Normalization Relational Advantages and Disadvantages Lecture Outline Review Logical Design for the Diveshop database Normalization Relational Advantages and Disadvantages DiveShop ER Diagram Lecture Outline Review Conceptual Model and UML Logical Model for the Diveshop database Normalization Relational Advantages and Disadvantages Database Design Process Logical Model: Mapping to a Relational Model Each entity in the ER Diagram becomes a relation. A properly normalized (next time) ER diagram will indicate where intersection relations for many-to-many mappings are needed. Relationships are indicated by common columns (or domains) in tables that are related. We will examine the tables for the Diveshop derived from the ER diagram DiveShop ER Diagram Customer = DIVECUST Dive Order = DIVEORDS Line item = DIVEITEM Shipping information = SHIPVIA Dive Equipment Stock= DIVESTOK Dive Locations = DEST Dive Sites = SITE Sea Life = BIOLIFE BIOSITE -- linking relation Shipwrecks = SHIPWRK Mapping to Other Models Hierarchical Need to make decisions about access paths Network Need to pre-specify all of the links and sets Object-Oriented What are the objects, datatypes, their methods and the access points for them Object-Relational Same as relational, but what new datatypes might be needed or useful (more on OR later) Lecture Outline Review Logical Model for the Diveshop database Normalization Relational Advantages and Disadvantages Normalization Normalization theory is based on the observation that relations with certain properties are more effective in inserting, updating and deleting data