NIT5130 Database Analysis and Design Assignment Problem

Assignment Help Database Management System
Reference no: EM132379083

Victoria University
College of Engineering and Science
NIT5130: Database Analysis and Design Assignment
Semester 2, 2019
Campus: Sydney

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.

IO Background

IO, 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.

A 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 works

At 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

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

Discovered business rules for your ERD

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.

Data dictionary:

Your report you must also include a data dictionary. You should briefly describe all entities and attributes are included, descriptions are clear, reasonable field formats, etc. For example,

 

Attributes

 

Meaning

Data Type

Other

Student No.

A     unique identifier of Students

Integer(8)

Index - Yes (No Duplicate)

Given Name

First name of students

Text(20)

Example, "Reuben"

Family Name

Family name                of

students

Text(20)

Example, "Steel"

Phone No.

Phone no. of students

Integer(12)

Not Null

Street No.

Street no. of students

Integer(6)

Not Null

City

City where

students live

Text(10)

Example, "Melbourne"

State

State where student

belong

Integer(6)

Example, "Victoria"

Post code

Postcode of students

Integer(8)

Not Null

Job Type

Job type of students

Text(15)

Example, "Part -Time"

Positions

Positions of Students

Text(20)

Example, "Mentoring"

Roaster

Schedule of work

Date        & Time

DD/MM/YYYY

Facility Type

Type       of facility

Text(20)

Example, "pool-table"

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

Reference no: EM132379083

Questions Cloud

Define the subject area and why is the subject important : Introduction section: this section provides an overview or background of the topic and its purpose, including. Define the subject area and why is this subject.
Why is walmart struggling with their expansion in china : Read the following article and answer in 175 words or more. Why is Walmart struggling with their expansion in China? What could Walmart have done differently.
How much of the $3 million note is classified as long-term : How much of the $3 million note is classified as long-term in the December 31 financial statements? Parton owes $3 million that is due on February 28.
Find the articles on telecommuting and blue work strategies : Find research articles on telecommuting and other "Blue Work" strategies. Develop a 3 page, double-spaced paper (not counting references or cover letter) that.
NIT5130 Database Analysis and Design Assignment Problem : NIT5130 Database Analysis and Design Assignment help and solution, Victoria University, Assessment help - Implement your data dictionary to create a relational
Skeletal muscle and respiratory pumps : Which of the following is a requirement for both the skeletal muscle and respiratory pumps to work?
What is his standard deduction : Jeremy has one qualifying dependent child who lives with him. Jeremy qualifies to file as head of household and has $31,700 in itemized deductions.
Evaluate risks of the portfolio presented in chapter : Chapter 22 presented a case study in creating value from uncertainty, and chapter 25 presented the use of efficient frontier analysis in SRM.
What is real gdp for benjiland in 2011 : Benjiland has a nominal GDP of 128 million in 2011 and 142 million in 2012. The price level in 2011 was 100 and in 2012 rose to 106.

Reviews

len2379083

9/30/2019 4:00:45 AM

The report must be your own group’s work, i.e., it must be the result of your own reading, thought and discussion, and the expression of the ideas must be yours. The submitted work will therefore comprise: a) Your group’s report b) Relevant designs and support material c) Sources detailed in a reference section d) Declaration form (See Appendix A) Report writing • Assignment cover page (must include, group names, student ID’s, subject name, your website name, lecturer name) • Introduction of your database system • Summary of database included functions • Database screen shots and their descriptions • References (if any)

len2379083

9/30/2019 4:00:33 AM

Information of your Group Members • Identify the members of your team with full names and student numbers. Groups are to consist of three to four members only. • Regulate your own group efforts. Any problems that arise, such as group members not contributing a fair amount of the work, must be resolved within the group. Lecturer and tutors will not intervene – so select your group members carefully.

len2379083

9/30/2019 4:00:20 AM

Grade Description A Confirmed a clear understanding of the concepts and issues applicable to the tasks, and their wider implications, in a substantiated view that was organised and cohesive. Demonstrated a very high level of scholarship. Used fluent and persuasive language with assurance and precision, to achieve a highly effective communication with the reader. B Demonstrated understanding of the complexities of the concepts and issues relevant to the tasks. Achieved effective selection and ordering of ideas. Demonstrated a high level of scholarship. Presented a view on the proposition with confidence, using fluent and persuasive language C Recognized major aspects of the tasks. Demonstrated an adequate level of scholarship. Achieved a coherent ordering of ideas and expressed a view in clear and accurate language D Recognized some aspects of the tasks. Demonstrated some evidence of scholarship. Presented some ideas relevant to the proposition. Demonstrated adequate organisation and language control

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd