Based on the report below conduct the normalization and draw the Relational Data
ID: 3916058 • Letter: B
Question
Based on the report below conduct the normalization and draw the Relational Database (Tables and relationship). You can make the assumptions.
Explanation / Answer
STUDENT- PERSONAL DETAILS TABLE
STUDENT- ID
STUDENT- NAME
STUDENT EMAIL
STUDENT PHONE
ADDRESS
GENDER
Here student email and student phone are also unique in the table but if they get changed or updated student personal detail will get changed accordingly, so making separate table for student email and student phone is not necessary.
STUDENT –ACADEMICS table
STUDENT- ID
No (COURSE NUMBER)
GRADES
STATUS(ACTIVE/INACTIVE)
COURSE-NAMES table
COURSE NUMBER
COURSE NAME
INSTRUCTOR-PERSONAL DETAILS TABLE
INSTRUCTOR NAME
INSTRUCTOR EMAIL
NO.(COURSE NUMBER)
COURSE-DURATION TABLE
NO. (COURSE-NUMBER)
INSTRUCTOR-EMAIL
INSTRUCTOR-NAME
COURSE START DATE
COURSE FINISH DATE
Here we have to repeat instructor email because to identify the instructor we have to use these two attributes.
I am assuming you have multiple extension numbers to represent the different blocks of building.
In those extension there are multiple location having different room numbers in those locations.
COURSE_LOCATION_ROOM TABLE
LOCATION_NAME
NO.(COURSE NUMBER)
ROOM No. AND EXTENSION
COURES_DAY_TIME_TABLE
NO.(COURSE NUMBER)
DAY
START TIME
END TIME
STUDENT- ID
STUDENT- NAME
STUDENT EMAIL
STUDENT PHONE
ADDRESS
GENDER
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.