Database Design: Entity Relationship Diagram, Assumptions, Logical and Physical Design

Running head: DATABASE
Database
Name of Student-
Name of University-
Author’s Note-

DATABASE1
Table of Contents
Entity Relationship Diagram...........................................................................................................1
List of Assumptions and Business Rules.........................................................................................1
Logical Design.................................................................................................................................2
Physical Design...............................................................................................................................3
Implementing Database...................................................................................................................5
Bibliography....................................................................................................................................6

DATABASE2
Entity Relationship Diagram
Figure 1: ERD Diagram
(Source: Created by author using Visio)
List of Assumptions and Business Rules
Assumptions:
1. The system allows many customers to be registered in the system with their unique customer
id and their phone number.
2. One particular customer might have many booking ids as because they can book more than
one time in HDCA.