This preview shows pages 1–3. 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: . . Fall 2007 CPE/CSC 365: Introduction to Database Systems Alexander Dekhtyar . . Overview of the Course Databases and DBMS in a nutshell Data Views of data: conceptual : captures relationships in the data. (CPE 366) logical : captures the format of the data as understood by DBMS. (CPE 365) physical : represents the exact way the data is stored and accessed by DBMS. (CPE 468) Logical View of data Data models historical network hierarchical modern relational object-oriented object-relational emerging semistructured (XML) 1 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)....
View Full Document
- Spring '08