The key information is collected from the students during their

VU SydneyVictoria University
College of Engineering and Science
NIT5130: Database Analysis and Design
Semester 1, 2018Campus: SydneyDue Date: Week 11 – Sunday 10 June 2018 @ 23.55Scenario for assignmentSuppose 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.IO BackgroundIO, as the acronym recommends, is planned to help the students by providing a friendly place
where they can meet other part-time or full-time students. Facilities and services include: a pool
table, tea and coffee, a kitchen, few games and a number of social events for the students to
attend. If the students have an hour break among classes then they can come to the IO lounge
and relax on the couches, play pool, chat over a coffee and so on. In regard for these facilities to
stay hygienic and well maintained, certain rosters are set up for the student members. These
rosters are generated from the database of students wishing to volunteer for a particular job or
jobs. From time to time notices and documents are sent out to the members to remind them of
their allocated duties and to inform them of upcoming events and activities.VU SydneyA range of jobs that need to be accomplished at the IO lounge require volunteers to complete
certain tasks like, washing windows, vacuuming floors, mopping etc, and these may need to be
done at certain times of the day and/or week. IO would like the database to keep track of the tasks
required in each job. They would also like a record of who does what job on what day and whether
it was completed or not. Moreover, University faculties, schools and the course, that students are
in, are very significant to IO so that they can categorize people into study groups and for
mentoring purposes. A new member can be introduced to people doing the same course or in the
same faculty or school. IO would like the database entry screens to be designed for simple and
easy navigation of information in the database. The first screen should contain contact details. The
second screen should be about what IO can do for them, and the third screen should be what the
student can do for IO.How IO process worksAt the time of enrolment, the interested students fill out a form giving their contact details to IO.
They also indicate whether they would like to help out in the duties involved within the university.
The databases are updated with new members every year. This guarantees that the current
database is up-to-date. Reports are then generated from the database that helps the IO team
synchronize and locate volunteers.
The database reports make it easy and simple to generate rosters, mailing lists, organise social
functions and meet nutritional needs of the students. IO would like the make the data entry as
simple and easy as possible for the student enrolment. They would like the reports to be easy to
produce. They also recommended that each school in the university should be linked to its
associated Faculty. So that somebody cannot enter “Faculty of Information Technology” and
“School of Law” as this is incorrect.Task 1: Database Modelling (Total marks: 50%)1.1. Develop an Entity Relationship (ER) model to characterize the information require…

Assignment status: Already Solved By Our Experts

( USA, AUS, UK & CA  PhD. Writers )


Leave a Reply

Your email address will not be published. Required fields are marked *