Parramatta City Council Car Park System: Database Design Report

This report presents a comprehensive database design for the Parramatta City Council car park system. It begins with a conceptual database design, including a detailed data dictionary that defines entities such as Customer, Ticket, Parking Spaces, Tariff, and Fault, along with their attributes, data types, and constraints. An ER-Diagram visually represents the relationships between these entities. The report then proceeds to the logical database design, providing another ER-Diagram and demonstrating database visualization through tables, specifying primary and foreign keys to ensure data integrity and relational structure. The report concludes with a bibliography citing relevant database design resources.

Running head: THE CONCEPTUAL AND LOGICAL DATABASE DESIGN
The Conceptual and Logical Database Design
Name of the Student
Name of the University

1THE CONCEPTUAL AND LOGICAL DATABASE DESIGN
Table of Contents
1. Conceptual Database Design:..........................................................................................2
1.1 Data Dictionary:.........................................................................................................2
1.2 ER-Diagram:..............................................................................................................6
2. Logical Database Design:................................................................................................7
2.1 Entity Relationship Diagram:....................................................................................7
2.2 Database Visualization through Table:......................................................................7
Bibliography:.....................................................................................................................10

2THE CONCEPTUAL AND LOGICAL DATABASE DESIGN
1. Conceptual Database Design:
1.1 Data Dictionary:
Entity Attribute Name Descriptio
n
Data Type
and Length
Nulls Multi-valued
Customer CustID The unique
value for
identifying
row
4 Fixed
character
No No
Name The name
of the
customer
20 Variable
Character
No No
Address The
address of
the
customer
30 Variable
Character
No No
Contact The contact
number of
the
customer
10 Variable
Character
No No
Entity Attribute Name Descriptio
n
Data Type
and Length
Nulls Multi-valued

3THE CONCEPTUAL AND LOGICAL DATABASE DESIGN
Ticket TicketNo The unique
value for
identifying
row
4 Fixed
character
No No
IssueDate The date of
car parking
entry
20 Variable
Character
No No
IssueTime The time of
car parking
entry
30 Variable
Character
No No
IssueMachine Machine
from which
the ticket
was issued
10 Variable
Character
No No
Entity Attribute Name Descriptio
n
Data Type
and Length
Nulls Multi-valued
Parking
Spaces
Space Number The unique
number for
defining all
the rows
4 Fixed
character
No No
SpaceQuantity The total
amount of
4 Fixed
character
No No

4THE CONCEPTUAL AND LOGICAL DATABASE DESIGN
space
available
OccupiedSpace The total
used space
currently
20 Variable
Character
No No
LeftSpace Total
remaining
space
30 Variable
Character
No No
Isfull The car
parking
space is full
2 Fixed
Character
No No
Entity Attribute Name Descriptio
n
Data Type
and Length
Nulls Multi-valued
Tariff TariffCode The unique
value for
identifying
row
4 Fixed
character
No No
StartTime The date of
car parking
entry
20 Variable
Character
No No
EndTime The time of
car parking
30 Variable
Character
No No

5THE CONCEPTUAL AND LOGICAL DATABASE DESIGN
entry
Entity Attribute Name Descriptio
n
Data Type
and Length
Nulls Multi-valued
Fault FaultID The unique
value for
identifying
row
4 Fixed
character
No No
Date The date of
fault
occurrence
20 Variable
Character
No No
Time The time of
fault
occurrence
30 Variable
Character
No No
Description The
equipment
name and
description
of the fault
255 Variable
Character
No No

6THE CONCEPTUAL AND LOGICAL DATABASE DESIGN
1.2 ER-Diagram:
Figure 1: The Conceptual Diagram of Parramatta City Council Car Park System
(Source: Created by Author)

7THE CONCEPTUAL AND LOGICAL DATABASE DESIGN
2. Logical Database Design:
2.1 Entity Relationship Diagram:
2.2 Database Visualization through Table:
Entity Attribute Name Description Key Referential
Constraints

8THE CONCEPTUAL AND LOGICAL DATABASE DESIGN
Customer CustID The unique
value for
identifying
row
Primary Key
Name The name of
the customer
Address The address of
the customer
Contact The contact
number of the
customer
Entity Attribute
Name
Description Data Type
and
Length
Key Referential
Constraints
Ticket TicketNo The unique
value for
identifying row
4 Fixed
character
Primary
CustID The primary
key of customer
entity
4 Fixed
character
Foreign Customer->Ticket
IssueDate The date of car
parking entry
20
Variable