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 Download1 Pages / 166 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:

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, 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 Sydney 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 (Total marks: 50%)
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: -Marks: 
A. Demonstrate all necessary entities
B. Demonstrate all attributes
C. The relationships between entities VU Sydney
D. Demonstrate unique identifiers and nature of interaction among entities
1.2. Discovered business rules for your ERD -Marks: 5%
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. 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. 
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 1 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/entity-of-the-database.html.

My Assignment Help (2020) Database Analysis And Design [Online]. Available from: https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/entity-of-the-database.html
[Accessed 17 January 2021].

My Assignment Help. 'Database Analysis And Design' (My Assignment Help, 2020) <https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/entity-of-the-database.html> accessed 17 January 2021.

My Assignment Help. Database Analysis And Design [Internet]. My Assignment Help. 2020 [cited 17 January 2021]. Available from: https://myassignmenthelp.com/free-samples/nit5130-database-analysis-and-design/entity-of-the-database.html.


Be it research papers, term papers, coursework/homework or any other academic writing, be assured of a top grade paper written with every conventions of writing in place, properly edited and formatted. Get the touch of best proffesionals in your paper. Referencing, grammatical check and multiple revisions are the core part of delivering any of our papers.Be it research papers, topics for various papers, dissertations, thesis and others, we have Phd experts for every field.

Latest Database Samples

CS665 Software Design And Patterns

Download : 0 | Pages : 2

Answer: My implementation has achieved a high degree of simplicity and understandability as a result of using objects to represent different objects specified in the requirements. Each object has its own methods and attributes. The objects interact with each other to form the complete program which is easy to understand because it is modular based thus it’s easy to understand. The solution to be implemented will be flexible because each ...

Read More arrow

ICT701 Relational Database Systems

Download : 0 | Pages : 8

Answer: Normalization is done through three steps; 1NF- step involves identifying any repeating groups and removing to normalize the table to 1NF. 2NF- This step involves removing any partial dependency in all relations. 3NF- This step involves removing any transitive dependency in all the relations. Although there are other levels of normalization, 3NF is the recommended level before implementing the entities as tables to form a database...

Read More arrow

NIT1201 Introduction To Database Systems

Download : 0 | Pages : 12
  • Course Code: NIT1201
  • University: Victoria University
  • Country: Australia

Answer: ID -  used to identify the primary keys and the foreign keys in the tables. For instance Match_ID, Round_ID, Ref_ID and Player_ID  are both primary keys and foreign keys in different tables. Round – is the game level or cycle. The Tournament has four levels which translate to four rounds. Role – is found in the player table. There are only three roles a player can partake in a team; leadership, being a primary p...

Read More arrow

ICT704 Non Relational Database Systems

Download : 0 | Pages : 5

Answer: We have a very simple database. There is one collection movies which contain a number of Movie documents. Each movie documents has a number of attributes which defines various attributes of movies. Mongo Db has a very important property. Unlike relational databases where data fields are empty if they don't have any value, Mongo DB do not even have a field if it does not have any value. We can simply skip that field from a document,. So...

Read More arrow

COMP3340 Data Mining

Download : 0 | Pages : 2
  • Course Code: COMP3340
  • University: The University Of Newcastle
  • Country: Australia

Answer: Introduction Web mining could be defined as the process of using the techniques of data mining and several algorithms in order to extract direct information form the internet. The primary aim of web mining is to search for patterns within the web based data (Langhnoja, Barot & Mehta, 2013). Discussion Real World Examples of Web Mining The results obtained from the usage of web mining could be applied in order to understand and ...

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,544,311

Orders

4.9/5

Overall Rating

5,108

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

1896 Order Completed

95% Response Time

Herman Berens

MSc in Psychology

London, United Kingdom

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

2279 Order Completed

97% Response Time

Zachary Perez

PhD in Computer Science and Information System

Washington, United States

Hire Me
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

453 Order Completed

98% Response Time

Howard Asuncion

LLM in Criminal Law

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

Good completion to my assignment.  My assignment editing was perfect, and I was very happy with that.  When I requested the expert to follow all the comments, he responded in perfect way.  The assignment was completed on the deadline and to my ...

flag

User Id: 394056 - 17 Jan 2021

Australia

student rating student rating student rating student rating student rating

The writer finished before the due date and the final result was excellent, happy with this one.

flag

User Id: 406130 - 17 Jan 2021

Australia

student rating student rating student rating student rating student rating

Excellent work I really appreciate about your work related to my entire assignments and hopefully i can contact you all again once i receive my final work from my university. Again i will take this opportunity to thanking you about all the supports...

flag

User Id: 573225 - 17 Jan 2021

Australia

student rating student rating student rating student rating student rating

The expert really proficient in their work and really helpful to your academic work.

flag

User Id: 587834 - 17 Jan 2021

Australia

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