subject

Consider the relation courses (C, T,H, R,S, G), whose attributes may be thought informally as course, teacher, hour, room, student, and grade. Let the set of FD'S for courses be C\rightarrowT, HR\rightarrowC, HT\rightarrowR. HS\rightarrowR. CS\rightarrowG. Intuitively, the first says that a course has a unique teacher, and the second says that only one course can meet in a given room at a given hour, The third says that a teacher can be in only one room at a given hour, and the fourth says the same about student. The last says that students get only one grade in a course

a) What are all the keys for courses?

b) Verify that the given FD's are their own minimal basis.

c) Use the 3NF synthesis algorithm to find a a lossless-join, dependency-preserving decomposition of R into 3NF relations. Are any of the relations not in BCNF?

ansver
Answers: 1

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 03:30
Identify at least three types of characteristics that you were asked about as you the computer identify a fruit.
Answers: 3
question
Computers and Technology, 22.06.2019 19:10
How might the success of your campaign be affected if you haven’t carefully completed all field data or if you accidentally insert the wrong merge field in the document?
Answers: 1
question
Computers and Technology, 22.06.2019 22:30
Alex’s family members live in different parts of the world. they would like to discuss the wedding plans of one of their distant relatives. however, alex wants all the family members to talk to each other simultaneously so that they can make decisions quickly. which mode of internet communication should they use? a. blog b. email c. wiki d. message board e. instant messaging
Answers: 2
question
Computers and Technology, 23.06.2019 01:00
Complete the sentence about a presentation delivery method
Answers: 2
You know the right answer?
Consider the relation courses (C, T,H, R,S, G), whose attributes may be thought informally as course...
Questions
question
Arts, 02.09.2021 17:20
question
Mathematics, 02.09.2021 17:20
question
Mathematics, 02.09.2021 17:20
Questions on the website: 13722367