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: 3

Another question on Computers and Technology

question
Computers and Technology, 22.06.2019 11:00
Ihave an iphone 8plus should i get another phone like samsung note 9 or s9 ? ?
Answers: 2
question
Computers and Technology, 22.06.2019 15:00
When designing content as part of your content marketing strategy, what does the "think" stage represent in the "see, think, do, care" framework?
Answers: 3
question
Computers and Technology, 22.06.2019 22:00
Discuss the ways in which electronic information associated with payments is addressed in terms of security. include encryption, secure sockets layers, and secure electronic transactions in your discussion. are there any other ways that consumers and businesses can keep their payment information secure in an electronic commerce environment? do you feel that your information is safe when conducting electronic business? why or why not?
Answers: 1
question
Computers and Technology, 23.06.2019 07:00
Why were most movies from the late 1890s until the early 1930s only filmed in black and white? there were only a few people who could afford the technology to produce color motion pictures back then. audiences did not want color motion pictures until later. the film used to make color motion pictures often overheated, which was a safety hazard, so it was generally not allowed. color films had to be hand-colored, frame by frame.
Answers: 3
You know the right answer?
Consider the relation courses (C, T,H, R,S, G), whose attributes may be thought informally as course...
Questions
Questions on the website: 13722363