This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: . . Winter 2008 CPE/CSC 366: Database Modeling, Design and Implementation Alexander Dekhtyar . . Database Design in a Nutshell Six steps of Database Design Step 1: Requirements analysis. Collect information from customer about data; desired features of the database; information needs. Step 2: Conceptual Database Design. Develop high-level description of data, describe constraints. High-level design: often done using Entity-Relatioship diagrams (E-R diagrams). Step 3: Logical Database Design. Select a DBMS, convert high-level design into (relational) database design ( database schema ) in Data Definition Language (DDL) of the DBMS. DDL for relational databases is a part of SQL. Steps 13 are main steps in database design. Thee more steps, enhance the Logical design. Step 4: Schema Refinement. Logical database design is analyzed and (po- tentially) improved. Goal of schema refinement: have database schema in one of normal forms ....
View Full Document
This note was uploaded on 05/19/2008 for the course CSC 365 taught by Professor Dekhtyar during the Spring '08 term at Cal Poly.
- Spring '08