Database Design Process for Victoria University Accommodation Department

COVER PAGE

Contents
Introduction................................................................................................................ 3
1 Task 1...................................................................................................................... 3
1.1 ERD................................................................................................................ 3
1.2 Business rules................................................................................................ 3
1.3 3NF relations.................................................................................................. 4
1.4 Data Dictionary.............................................................................................. 7
Task 2....................................................................................................................... 10
PhPMyAdmin implementation................................................................................... 10
Wordpress forms and reports................................................................................13
Conclusion................................................................................................................ 15

Introduction
This report presents a discussion on the database design process for the proposed
database system intended for Victoria University accommodation department. The
database system is supposed to help the university to keep track and maintain data
in an efficient way. The design process follows the standard top-down approach of
designing the database.
1 Task 1
1.1 ERD
Figure 1: Entity relationship diagram
1.2 Business rules
 The university consists of many faculties