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 1–3 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
- Spring '08
- Databases, security information, Alexander Dekhtyar