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, 21.06.2019 13:00
"in program arrays12.java a swap method is called. does the swap method exchange parameter values x and y? "
Answers: 3
question
Computers and Technology, 22.06.2019 11:00
How does a policy manual an organization? a. it boost productivity. b. it create awareness in employees about the organization’s values. c. it employees achieve targets. d. it safeguards the organization from liabilities.
Answers: 1
question
Computers and Technology, 22.06.2019 20:00
What statement best describes operating systems? it’s possible for modern computers to function without operating systems. most operating systems are free or very inexpensive. operating systems are managed by the computer’s microprocessor (cpu). operating systems manage the computer’s random access memory (ram).
Answers: 1
question
Computers and Technology, 23.06.2019 19:00
Choose the correct citation for the case which established the "minimum contacts" test for a court's jurisdiction in a case. select one: a. brown v. board of education of topeka, 347 u.s. 483 (1954). b. international shoe co. v. washington, 326 u.s. 310 (1945) c. haynes v. gore, 531 u.s. 98 (2000). d. international shoe co. v. washington, 14 u.s. code 336.
Answers: 1
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
Mathematics, 18.09.2019 20:20
Questions on the website: 13722362