CSC4480: Principles of Database Systems

CSC4480: Principles of Database Systems

Lecture 2: Data Models/Entity Relationship Model

Steps in Designing a Relational Database

? Requirements and Specification

? This involves scoping out the requirements and limitations of the database

? Conceptual Design

? This involves using a data model (e.g Entity Relationship Model) to represent the requirements of the specifications

? Logical Design

? This involves translating the conceptual design into tables and relationships expressed in a data model and implemented in a DBMS.

Slide 2

Importance of Database Design

? A foundation for good applications ? Is a communication tool that facilitates the interaction among the

designer, the application's programmer, and the end user ? Both an art and a science

Slide 3

Defining Data Models

? Models are simplified abstractions of real world events or conditions

? A data model is the relatively simple representation using graphic, of facts (data) that are used to describe real world events, objects, or ideas

? A data model illustrates what data are being represented (of interest for the end use or system) and how the data elements relate to each other

? A data model represents data characteristics, relationships, constraints, and transformations.

Slide 4

The importance of Data Models

? Facilitates communication ? Gives various views of the database ? Organizes data for various users ? Provides an abstraction for the creation of good a database

Slide 5

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download