Database Analysis and Design Assignment

Database Analysis and Design

Table of Contents
INTRODUCTION........................................................................................................... 3
TASK 1........................................................................................................................ 3
Entity relationship Diagram-............................................................................... 3
TASK 2........................................................................................................................ 8
1. Implement your data dictionary to create a relational database....................8
2. The queries, view(s), and report of database relational tables....................11
Design Forms and Report......................................................................................... 13
4. A form for the director to fill in the jobs for the up-coming week with the
volunteers available......................................................................................... 15
5. Report that lists all the people with particular dietary requirements of student
information....................................................................................................... 16
6. A report that prints the students address details.........................................17
CONCLUSION............................................................................................................ 18
REFERENCES............................................................................................................. 19

LIST OF FIGURES
Illustration Index
Illustration 1: figure 1............................................................................................... 10
Illustration 2: Figure:2.............................................................................................. 11
Illustration 3: Figure:3.............................................................................................. 11
Illustration 4: Figure: 4............................................................................................. 12
Illustration 5: Figure: 5............................................................................................. 12
Illustration 6: Figure: 6............................................................................................. 13
Illustration 7: Figure: 7............................................................................................. 14
Illustration 8: Figure:8.............................................................................................. 14
Illustration 9: Figure :9............................................................................................. 15
Illustration 10: Figure: 10......................................................................................... 16
Illustration 11: Figure:11.......................................................................................... 16
Illustration 12: Figure:12.......................................................................................... 17
Illustration 13: Figure: 13......................................................................................... 17
Illustration 14: Figure : 14........................................................................................ 18
Illustration 15: Figure: 15......................................................................................... 18
Illustration 16: Figure: 16......................................................................................... 19
Illustration 17: Figure: 17......................................................................................... 20
Illustration 18: Figure: 18......................................................................................... 20
Illustration 19: Figure :19......................................................................................... 21
Illustration 20: Figure :20......................................................................................... 21
Illustration 21: Figure:21.......................................................................................... 22
Illustration 22: Figure :22......................................................................................... 22
Illustration 23: Figure: 23......................................................................................... 23

INTRODUCTION
Database management system is a technique for managing the business process which
help for identifying the need and requirement of organization this report will describe the
database of Victoria university. A database of Victoria university is been developed and
implemented. It will store and manage data of student and various other facilities provided by
college. Apart from this, information related to upcoming events and activities are also entered in
database (McMinn and et.al., 2017). This database system is designed for student to access the
system for checking all information. It is a type of relational database system that is all
relationship defined in between entities. Database table used in the organization and used third
normal form that is no data dependencies and data redundancy. This system is designed
according to the need and requirement of system.
The website is developed on Word-press and database is created on PHP MyAdmin panel. It
contains all information in the website. This website provides the opportunity for student to fill
the form and update their information. Plugin is used for designing form and it is useful for
designing an effective database system.

TASK 1
Entity relationship Diagram-
Fig: 1
Entity relationship diagram is a graphical representation which establishes connection between
different entities and attributes (Tocco and et.al., 2018). Entity relationship diagram is represent the
structure of database therefore, it also represents the relationship between tables. This diagram is enclosed
with the entities and attributes.
There are important components applicable in this diagram such as entities and attributes. These
attributes are helpful for creating an effective relationship in database system (Crowson and et.al.,
2018 ).

Entities:
The important entities used in this ER diagram for database as following:
Director_table
Roaster_table
Student_table
Job_table
parent_table
Department_table
volunteer_table
Attributes:
All the above attributes of above entities are following:
1. Student_table (Student_id, student_name, student_email, student_contact no,
student_city, student_state)
2. Volunteer_table (volunteer_id, volunteer_name, volunteer_position, volunteer_roaster,
student_id)
3. Roaster_table (Roaster_schedule, roaster_date, roaster_time, director_is, student_id)
4. Parent_table (parent_id, parent_name, parent_contact, parent_email, student_id)
5. Job_table (Job_id, Job_name, Job_type, student_id)
6. Department_table (department-id, department_name, student_id, volunteer_id)
7. Director_table (director_id, director_name, director_email, director_contact no, Job_id)
Relationship:
1. One or more student can be connected with volunteers.
2. One or more associated with parents.
3. Many departments associated with many volunteers.
4. One director associated with many departments.
5. One director maintain many jobs.