Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Guaranteed Higher Grade!

NIT1201 Introduction To Database Systems

tag 1 Download 6 Pages / 1,468 Words tag 27-07-2021
  • Course Code: NIT1201
  • University: Victoria University
    icon

    MyAssignmentHelp.com is not sponsored or endorsed by this college or university

  • Country: Australia

Question:

You have been commissioned to develop a database system that is capable of growing as WMUED does.
The database needs to keep a record of:
• All student basic information
• All staff basic information
• All student enrolment information
• All teaching allocation
• All assessments and results
• Timetable for all units in both semesters

Further, it should be possible to generate a report on:
• Course enrolment including number of students who enrol newly or continuously
• Unit enrolment including number of students who enrol newly or repeat
• Teaching staff allocation including staff information, class type, time and room location
• Assessment results of individual students for all enrolled units
• Student performance of a particular unit including all assessment results and final marks,sorted based on grades and surnames.

Steps you need to take to develop your database application
1. Complete the analysis and design of your database application
a. List the business rules for your system (do not get distracted by red herrings in the scenario!).
b. Identify the entities and relationships in your system.
c. Identify the characteristics of the entities in your system.
d. Develop an ER diagram to model your system.
e. Develop table structures from the ER model.
f. Conduct a dependency analysis of the table structures and normalize your tables where appropriate, to at least 3NF.
g. Create a data dictionary for your database
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

Cite This Work

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

My Assignment Help. (2021). Introduction To Database Systems. Retrieved from https://myassignmenthelp.com/free-samples/nit1201-introduction-to-database-systems/database-maintains.html.

My Assignment Help (2021) Introduction To Database Systems [Online]. Available from: https://myassignmenthelp.com/free-samples/nit1201-introduction-to-database-systems/database-maintains.html
[Accessed 07 December 2022].

My Assignment Help. 'Introduction To Database Systems' (My Assignment Help, 2021) <https://myassignmenthelp.com/free-samples/nit1201-introduction-to-database-systems/database-maintains.html> accessed 07 December 2022.

My Assignment Help. Introduction To Database Systems [Internet]. My Assignment Help. 2021 [cited 07 December 2022]. Available from: https://myassignmenthelp.com/free-samples/nit1201-introduction-to-database-systems/database-maintains.html.


Stuck on Any Question

Our best expert will help you with the answer of your question with best explanation.

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

Phone no. Missing!

Please enter phone for your order updates and other important order related communication.

loader
250 words
Error goes here

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

We Can Help!

Get top notch assistance from our best tutors !
Excel in your academics & career in one easy click!

icon

Other Samples

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

icon

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?