country
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
Add File

Error goes here

NIT5130 Database Analysis And Design

tag 0 Download6 Pages / 1,331 Words tag Add in library Click this icon and make it bookmark in your library to refer it later. GOT IT
  • Course Code: NIT5130
  • University: Victoria University
  • Country: Australia

Question:

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: 

  1. Demonstrate all necessary entities
  2. Demonstrate all attributes
  3. The relationships between entities
  4. 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.

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.

Task 2: Database Implementation

  1. Implement your data dictionary to create a relational database in PhPMyAdmin.
  2. Populate the database with sample data. Adequate sample data must be included to show that the queries, view(s), and report(s) work properly
  3. Design the followingthree forms and two reports, requiring a separate query to assure every of the following information needs:
  1. A Student information entry form
  1. A formto allow the director to change Member details and update the job and roster information without losing data integrity
  1. A reportthat prints the students address details
  1. A formfor the director to fill in the jobs for the up-coming week with the volunteers available
  1. A reportthat lists all of the people with particular dietary requirements so that this can be given to the chef before social functions
Download Sample Now

Earn back the money you have spent on the downloaded sample by uploading a unique assignment/study material/research material you have. After we assess the authenticity of the uploaded content, you will get 100% money back in your wallet within 7 days.

Upload
Unique Document

Document
Under Evaluation

Get Money
into Your Wallet

Total 6 pages, 1 USD Per Page

Cite This Work

To export a reference to this article please select a referencing stye below:

My Assignment Help. (2020). Database Analysis And Design. Retrieved from https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/develop-an-entity-relationship.html.

My Assignment Help (2020) Database Analysis And Design [Online]. Available from: https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/develop-an-entity-relationship.html
[Accessed 24 November 2020].

My Assignment Help. 'Database Analysis And Design' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/develop-an-entity-relationship.html> accessed 24 November 2020.

My Assignment Help. Database Analysis And Design [Internet]. My Assignment Help. 2020 [cited 24 November 2020]. Available from: https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/develop-an-entity-relationship.html.


From choosing the most interesting topic, writing your assignments to cite the sources, MyAssignmenthelp.com has got everything covered for you. We are the one-stop destination for any kind of assignment help Sydney solution you need in Australia. We have over 5000 professional experts who are experienced enough to deliver top assignment solution before the actual deadline. So what are you waiting for? Hurry up and order now!

Latest Management Samples

ELG40104 Academic English

Download : 0 | Pages : 3

Answer: Introduction The hotel business is increasing at a rapid speed and this is because of the rising requirement for the services as well as the increasing opportunities for travel.    Because of this the hotels are facing demanding customers as the requirements of the quality of growth with an increase in the use of hotel services for increase in the competitive ability of the hotel with respect to the customer loyalty is ext...

Read More arrow

FIN3CSF Case Studies In Finance

Download : 0 | Pages : 7
  • Course Code: FIN3CSF
  • University: La Trobe University
  • Country: Australia

Answer: Introduction: The aim of the assessment is to prepare an adequate investment portfolio, which could help in improving the level of returns from investment. In addition, the created portfolio also helps in understanding risk and return attributes of the investors, where 75% of the investment is conducted in Austrian equity,20% in ETP and LIC, and 15% in cash holdings. Moreover, with the help of portfolio income from investment would ev...

Read More arrow

5117COMP Data Structures And Algorithms

Download : 0 | Pages : 7
  • Course Code: 5117COMP
  • University: Liverpool John Moores University
  • Country: United Kingdom

Answer: This structure will be the best case because when searching for a number such as 7 we are going through three steps as shown in the diagram. The worst case In the worst case there will be six move as we search for the lowest number as shown in the diagram below. The linear search algorithm is a less efficient algorithm as compare to the binary search tree. In this algorithm we sequentially go through the entire list and goes on un...

Read More arrow

COMMGMT7001 Business Communication

Download : 0 | Pages : 3
  • Course Code: COMMGMT7001
  • University: The University Of Adelaide
  • Country: Australia

Answer: Business Communication Article One: 4 Things You Need to know about Group Dynamics in the Workplace The article’s main point is to help one understand group dynamics in the workplace. It gives a further understanding of why group dynamics is important and is critical to the success of the company. In the findings, the article verifies that poor workplace dynamic can greatly affect performance leading to a negative outcome o...

Read More arrow

ITDA1001 Database Designs Using Microsoft SQL Server

Download : 0 | Pages : 5
  • Course Code: ITDA1001
  • University: Royal Melbourne Institute Of Technology
  • Country: Australia

Answer: Purposes of E-R-Diagram and Techniques to secure databases The purpose to create an ER Diagram before the database is built The database design process requires the use of the ER diagrams as it is the database implementation foot prints that show the clear image of the resultant database that is required to be implemented, below are some of the purposes of E.R diagram in database design process. Due to its’ excellent visual ...

Read More arrow
Next

Save Time & improve Grade

Just share requirement and get customized Solution.

watch
question
We will use e-mail only for:

arrow Communication regarding your orders

arrow To send you invoices, and other billing info

arrow To provide you with information of offers and other benefits

Add File

Error goes here

1,498,900

Orders

4.9/5

Overall Rating

5,100

Experts

Our Amazing Features

delivery

On Time Delivery

Our writers make sure that all orders are submitted, prior to the deadline.

work

Plagiarism Free Work

Using reliable plagiarism detection software, Turnitin.com.We only provide customized 100 percent original papers.

time

24 X 7 Live Help

Feel free to contact our assignment writing services any time via phone, email or live chat. If you are unable to calculate word count online, ask our customer executives.

subject

Services For All Subjects

Our writers can provide you professional writing assistance on any subject at any level.

price

Best Price Guarantee

Our best price guarantee ensures that the features we offer cannot be matched by any of the competitors.

Our Experts

Assignment writing guide
student rating student rating student rating student rating student rating 5/5

285 Order Completed

99% Response Time

Eugene Baranowski

MBA in Supply Chain

London, United Kingdom

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

610 Order Completed

100% Response Time

Cheryl Zhao

PhD in Statistics

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 4/5

1309 Order Completed

100% Response Time

Gemmie Chen

MSc in Nursing

Singapore, Singapore

Hire Me
Assignment writing guide
student rating student rating student rating student rating student rating 5/5

154 Order Completed

97% Response Time

Harold Alderete

PhD in Economics

London, United Kingdom

Hire Me

FREE Tools

plagiarism

Plagiarism Checker

Get all your documents checked for plagiarism or duplicacy with us.

essay

Essay Typer

Get different kinds of essays typed in minutes with clicks.

edit

GPA Calculator

Calculate your semester grades and cumulative GPa with our GPA Calculator.

referencing

Chemical Equation Balancer

Balance any chemical equation in minutes just by entering the formula.

calculator

Word Counter & Page Calculator

Calculate the number of words and number of pages of all your academic documents.

Refer Just 5 Friends to Earn More than $2000

Check your estimated earning as per your ability

1

1

1

Your Approx Earning

Live Review

Our Mission Client Satisfaction

it was really helpful. i got my asssignment on time even before the deadline.it was written really well i am glad that I came to Myassignmenthelp.

flag

User Id: 401534 - 24 Nov 2020

Australia

student rating student rating student rating student rating student rating

very professional i got it before the due time i set, the sheet that was sent to me was very neat and very well done.

flag

User Id: 551988 - 23 Nov 2020

Australia

student rating student rating student rating student rating student rating

Great work! Really appreciate the help and efficiency. Very well organized. Thank you for your help.

flag

User Id: 522859 - 23 Nov 2020

Australia

student rating student rating student rating student rating student rating

given on time. well presented. and very helpful, trust these guys for all your work

flag

User Id: 142836 - 23 Nov 2020

Australia

student rating student rating student rating student rating student rating
callback request mobile
Have any Query?