Database Design - PowerPoint PPT Presentation

About This Presentation
Title:

Database Design

Description:

... 1. What is a relational database? Types of databases ... Types of Databases. Operational. used in day to day life. when there is need to collect, maintain, ... – PowerPoint PPT presentation

Number of Views:53
Avg rating:3.0/5.0
Slides: 8
Provided by: rev2
Learn more at: http://cse.unl.edu
Category:

less

Transcript and Presenter's Notes

Title: 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
Write a Comment
User Comments (0)
About PowerShow.com