Consider the afterward set of requirements for a UNIVERSITY database that is acclimated to accumulate clue of student’s transcripts.
The university keeps clue of anniversary student’s name, apprentice number, Social Security number, accepted abode and buzz number, abiding abode and buzz number, bearing date, sex, chic (freshman, sophomore, ..., graduate), above department, accessory administration (if any), and amount affairs (B.A., B.S., ..., Ph.D.). Some user applications charge to accredit to the city, state, and ZIP Cipher of the student's abiding abode and to the acceptance the aftermost name. Both Social Security cardinal and apprentice cardinal accept different ethics for anniversary student.
Anniversary administration is declared by a name, administration code, appointment number, appointment buzz number, and college. Both name and cipher accept different ethics for anniversary department.
Anniversary advance has a advance name, description, advance number, cardinal of division hours, level, and alms department. The amount of the advance cardinal is different for anniversary course.
Anniversary area has an instructor, semester, year, course, and area number. The area cardinal distinguishes sections of the aforementioned advance that are accomplished during the aforementioned semester/year; its ethics are 1, 2, 3, ..., up to the cardinal of sections accomplished during anniversary semester.
A brand address has a student, section, letter grade, and numeric brand (0, 1, 2, 3, or 4).
Create an ER Diagram, advertisement all cardinality constraints and assumptions.
Order a unique copy of this paper