Based on the sample ERD (See attached file). Create a logical database design that depicts the primary
Question:
Based on the sample ERD (See attached file). Create a logical database design that depicts the primary and foreign keys. Write also metadata for all the relations involved in the given problem.
TABLE 1-1 Example Metadata for Class Roster
Data Item Metadata
Name Type Length Min Max Description Source
Course Alphanumeric 30 Course ID and name Academic Unit
Section Integer 1 1 9 Section Number Registrar
Semester Alphanumeric 10 Semester and Year Registrar
Name Alphanumeric 30 Student name Student IS
ID Integer 9 Student ID (SSN) Student IS
Major Alphanumeric 4 Student Major Student IS
GPA Decimal 3 0.0 4.0 Student grade point average Academic Unit
Auditing and Assurance Services
ISBN: 978-0077862343
6th edition
Authors: Timothy Louwers, Robert Ramsay, David Sinason, Jerry Straws