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, 22.06.2019 17:00
Which of the following is not contained on the slide show toolbar? a. next button b. slide button c. close button d. pen tool
Answers: 1
question
Computers and Technology, 22.06.2019 18:10
Assume that to_the_power_of is a function that expects two int parameters and returns the value of the first parameter raised to the power of the second parameter. write a statement that calls to_the_power_of to compute the value of cube_side raised to the power of 3 and that associates this value with cube_volume.
Answers: 1
question
Computers and Technology, 22.06.2019 19:00
The fourth generation of computers emerged between 1970s and 1980s. which technological advancement brought about this generation of computers? which computer architecture was used most in this generation?
Answers: 3
question
Computers and Technology, 24.06.2019 13:00
Your mom wants to purchase a laptop computer. she said she wants her new computer to be able to play her dvds so she can listen to music and wants to know what type of optical drives will play her disk. which type of drive should she look for?
Answers: 1
You know the right answer?
Consider the relation R, which has attributes that hold schedules of courses and sections at a unive...
Questions
question
English, 06.05.2021 17:30
question
Mathematics, 06.05.2021 17:30
question
Mathematics, 06.05.2021 17:30
Questions on the website: 13722367