Assignment about What is Database Design and Development?

Running head: DATABASE DESIGN AND DEVELOPMENT
DATABASE DESIGN AND DEVELOPMENT
Name of the Student
Name of the University
Author Note

DATABASE DESIGN AND DEVELOPMENT
1
ERD
An Entity Relationship Diagram represents the real-world objects as entities, attributes
and relationship between them (Dunn and Nel 2017). The entities and their attributes can be
identified with the help of the business process of the company. It also helps in defining the
business rules of the system.
Figure 1: CQ Air conditioning services ER Diagram
Source: created by author

DATABASE DESIGN AND DEVELOPMENT
2
Data Dictionary
Data Dictionary represents the physical schema of the design. It shows the attributes, data
types, data sizes, required attribute and description of the attributes (Malcher and Kuhn 2019).
The data dictionary for the CQ Air conditioning services is given below:
Customer Table
Attributes Data Type Size Permitted Value Required Key
CustomerID varchar 10 Yes Primary Key
Name varchar 50 Yes
Address varchar 50 No
Contact int 10 Yes
Email varchar 50 Contains ‘@’ No
Premises Table
Attributes DataTyp
e
Size Permitted Value Required Key
PremisesID varchar 10 Yes Primary
Key
ContactPerson varchar 50 Yes
PremisesType varchar 50 investment units, house or
Offices
Yes
Address varchar 50 Yes