Database Modelling for International Office of Victoria University

Student details

Contents
1 Task 1 Database modelling.......................................................................................................................3
1.1 Entity relationship diagram..........................................................................................................3
1.2 Business rules..............................................................................................................................3
1.3 3NF relations................................................................................................................................3
1.4 Data Dictionary............................................................................................................................4
Bibliography................................................................................................................................................7
Appendix.....................................................................................................................................................7
Wordpress implementation...................................................................................................................10

Introduction
This report discusses the design and the development of the International Office of Victoria University.
The report presents the steps that are followed to design the database from coming up with an entity
relationship diagram and then deriving entities to perform normalization. The entities achieved in 3NF
are then used to create a data dictionary which is used in the implementation of the database. The
database is then used to create forms and reports using wordpress.

1 Task 1 Database modelling
1.1 Entity relationship diagram
Figure 1: ER Diagram
1.2 Business rules
 A student has one or more special diets although its not a must for a student to have a special
diet.
 A student is only supposed to enroll for one course
 A faculty has one or more schools
 A school offers one or more courses.
 The lodge offers one or more facilities and services to the students
 A facility or service at the lodge results to one or more jobs for the volunteering students.
 A student can volunteer for a job at the lodge. Its not a must for every student to volunteer for a
job at the lodge.
 Jobs in the lodge results to a roaster of the work to be done by the volunteering students
1.3 3NF relations
 Students (studentNO,firstName,familyName,phoneNO,streetNO,city,state,postcode,type)
 Volunteership (volunteershipID, rosterID, studentNO)
 Special_diet (dietID,studentNO,details)
 Course (courseID,courseName,duration,schoolID)