Database Design for Universal Sport Company

Information Engineering
(SQL)
1

Contents
INTRODUCTION...........................................................................................................................3
MAIN BODY..................................................................................................................................3
TASK 1............................................................................................................................................3
Entity Relationship Diagram.......................................................................................................3
TASK 2............................................................................................................................................7
Implement the database to meet the requirement of Universal Sport database system...............7
CONCLUSION..............................................................................................................................18
REFERENCES..............................................................................................................................19
2

INTRODUCTION
Database is based on the collection of inter-related data which helps in efficient retrieval
insertion, deletion of data from different database system. It can be organised the data into
different form of tables, schemas, reports and views. The report is mainly focused Universal
sports company in which developed the database system to gather or collect information about
staff members and other participants. It will be proposed the system to keep record the employee
information and accessible for any time. Furthermore, the documentation will describe about the
entity relationship diagram for identifying the entities, attributes. However, it will be produced
the database tables to store information of each employees.
MAIN BODY
TASK 1
Entity Relationship Diagram
Figure 1 Entity Relationship Diagram
Entity relationship diagram is also known as entity relationship model which mainly graphical
representation that depicts relationship among objects, concepts, people, places or event within
information technology (Latukolan, Arwan and Ananta, 2019). Basically, ERR uses for data
modelling technique that can help for defining business processes or serve as foundation for
relational databases. ERD can provide the brief idea about the entire database design that can
3

help for used to determine information system requirements. Entity relationship model is useful
for organising data that can be represented by relational structure. Sometimes, it is not
sufficiently represent both unstructured as well as semi-structure.
Data dictionary
Entities Attributes
Instructor  Instructor_id (PK)
 Instructor_name
 Instructor_email
 Instructor_PhoneNo
 Instructor_sex
 Instructor_type
 Sport_id (FK)
Branches  Branch_code (PK)
 Branch_phone
 Branch_Name
 Branch_Address
 Member_id (FK)
Member  Member_id (FK)
 Memebership_type
 Member_name
 Member_name
4