Database Design

1
Database Design

• Chapter 1

2
What is a relational database?

• Types of databases
• Early database models
• Relational database model
• Relational database managementsystem

3
Types of Databases

• Operational
• used in day to day life
• when there is need to collect, maintain, modify
  data
• Analytical
• historical and time-dependant data
• statistical data over long periods of time
• rarely changed

4
Early Database Models

• Hierarchical Database Model
• Relationships expressed in terms of parent/child
• Enforced referential integrity
• cannot support complex relationships
• Network Database Model
• Relationships expressed in terms of owner/member
• more complex queries than HDM
• user has to be familiar with structure

5
Relational Database Model

• Data stored in relations of tables
• Tables, Records, Fields
• Relations based on shared field between tables
• Supports complex relationships queries
• Structured Query Language
• Unique field in table (primary key in access)
  order in which records are stored is unimportant.

6
Advantages to RDM

• Built in multi-level integrity
• Logical and physical data independence from
  database applications
• Guaranteed data consistency and accuracy
• Easy data retrieval

7
Relational Database Management System

• Software program (like access)
• used to create, maintain, modify, manipulate
  relational database
• Create applications to interact with database
• Client/Server applications