Normalization and ER diagrams
The answer to this question should be completed in Draw.io and submitted for grading.
How to use Draw.io
https://youtu.be/VgTRNqn2fn0
1. (40 points) With the information provided below, create a normalized ER diagram (third normal form) in draw.io for the entities in the Academic Database (School Management System). Add in the data relationship lines between entities.
For your convenience, here is a summary of how the Academic Database (School Management System) works:
o A School/University has many Departments which offer courses to students in a given academic session.
o Each of these courses is taught by a faculty.
o Students enroll for different courses in an academic session.
o Besides the registration details, the parent information of the student also needs to be maintained by the University/School.
o The Department maintains the students attendance details which would decide the eligibility of the student to take up the exams for that academic session.
o For each academic session, exams are conducted, and the results are shared with the student within a stipulated period.
o The Department also maintains a log of the Faculty login and logout time for their reporting needs.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.