lec02.365

lec02.365 - . . Fall 2007 CPE/CSC 365: Introduction to...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the 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

Page1 / 4

lec02.365 - . . Fall 2007 CPE/CSC 365: Introduction to...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online