Reference no: EM132311263 , Length: word count : 3000

Assignment

Scenario for assignment

Suppose the Victoria University, International Office (IO) needs a database to assist simple and fast data entry and print reports. The key information is collected from the students during their enrolment. In order to make this process fast and easy for the students, the data entry has to be as capable as possible. If the data entry takes too long the student may become unconcerned in joining the university.

The director at IO requires reporting features to facilitate them to help with rostering, roles and membership email lists. Some such reports include: organising a roster for the volunteers, finding all of the people interested in organizing a social function, printing a list of contacts etc.

This will be achieved by creating a database using PhPMyAdmin and WordPress (for forms and reports design) and making use of supporting features like: forms, queries and reports. A user manual is necessary to this project as the managers are novice computer users and will require assistance for using the database.

Task 1: Database Modelling

1.1. Develop an Entity Relationship (ER) model to characterize the information requirements of business illustrates in the case study mentioned above. The diagram of your ER model must:

A. Demonstrate all necessary entities

B. Demonstrate all attributes

C. The relationships between entities

D. Demonstrate unique identifiers and nature of interaction among entities

1.2. Discovered business rules for your ERD

1.3. Map the Entity Relationship Diagram (ERD) into a set of relations in at least Third Normal Form (3NF). You should show that each relation satisfies the rules for 1NF, 2NF, and 3NF.

For example STUDENT (StudentID, FirstName, SecondName, Phone). This relation is in 1NF as it does not contain any repeating groups and show primarykey

Task 2: Database Implementation

A. Implement your data dictionary to create a relational database in PhPMyAdmin.

B. Populate the database with sample data. Adequate sample data must be included to show that the queries, view(s), and report(s) work properly

C. Design the following three forms and two reports, requiring a separate query to assure every of the following information needs:

1. A Student information entry form

2. A form to allow the director to change Member details and update the job and roster information without losing data integrity

3. A report that prints the students address details

4. A form for the director to fill in the jobs for the up-coming week with the volunteers available

5. A report that lists all of the people with particular dietary requirements so that this can be given to the chef before social functions