subject

Consider the relation R, which has attributes that hold schedules of courses and sections at a university;
R = {Course_no, Sec_no, Offering_dept, Credit_hours, Course_level, Instructor_ssn, Semester, Year, Days_hours, Room_no, No_of_students}.
Suppose that the following functional dependencies hold on R:

{Course_no} → {Offering_dept, Credit_hours, Course_level}
{Course_no, Sec_no, Semester, Year} → {Days_hours, Room_no, No_of_students, Instructor_ssn}
{Room_no, Days_hours, Semester, Year} → {Instructor_ssn, Course_no, Sec_no}

(a) What normal form is the relation in? Explain your answer.
(b) Try to determine which sets of attributes form keys of R. How would you normalize this relation?

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 09:00
Which is the highest level of the hierarchy of needs model? a. humanity b. intrapersonal c. team d. interpersonal
Answers: 1
question
Computers and Technology, 23.06.2019 15:30
Hey so i was just trying out some game hacks so i took a paste from online and built it in my visual studio and then suddenly my computer was working or clicking on stuff on its own am i hacked?
Answers: 1
question
Computers and Technology, 23.06.2019 17:00
The more powerful, 60 volt cables and the main power shut-off on an hev are both colored orange.
Answers: 1
question
Computers and Technology, 23.06.2019 22:20
If i uninstall nba 2k 19 from my ps4 will my career be gone forever?
Answers: 2
You know the right answer?
Consider the relation R, which has attributes that hold schedules of courses and sections at a unive...
Questions
question
Mathematics, 14.11.2020 02:20
question
Mathematics, 14.11.2020 02:20
question
English, 14.11.2020 02:20
question
Mathematics, 14.11.2020 02:20
question
Mathematics, 14.11.2020 02:20
Questions on the website: 13722363