![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 26.02.2020 03:57 nikkih1225
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](/tpl/images/cats/User.png)
Answers: 1
Another question on Computers and Technology
![question](/tpl/images/cats/informatica.png)
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](/tpl/images/cats/informatica.png)
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](/tpl/images/cats/informatica.png)
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](/tpl/images/cats/informatica.png)
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](/tpl/images/cats/mat.png)
![question](/tpl/images/cats/mat.png)
Mathematics, 02.09.2021 17:20
![question](/tpl/images/cats/mat.png)
Mathematics, 02.09.2021 17:20
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/mkx.png)
Arts, 02.09.2021 17:20
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/en.png)
English, 02.09.2021 17:20
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/en.png)
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/istoriya.png)
History, 02.09.2021 17:20
![question](/tpl/images/cats/mat.png)
Mathematics, 02.09.2021 17:20
![question](/tpl/images/cats/mat.png)
Mathematics, 02.09.2021 17:20
![question](/tpl/images/cats/himiya.png)
![question](/tpl/images/cats/himiya.png)
![question](/tpl/images/cats/ekonomika.png)
![question](/tpl/images/cats/istoriya.png)
![question](/tpl/images/cats/istoriya.png)
History, 02.09.2021 17:20
![question](/tpl/images/cats/fizika.png)