Computers and Technology, 19.03.2020 01:09 JvGaming2001

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?

Answers: 1

Show answers

Another question on Computers and Technology

Computers and Technology, 22.06.2019 08:30

Active listen eliminates barries to communication true or false

Answers: 1

Answer

Computers and Technology, 22.06.2019 13:30

In which phase does software coding and testing happen in the spiral model? the spiral model does not have a separate testing phase. both, software coding and testing occurs during the phase.

Answers: 3

Answer

Computers and Technology, 23.06.2019 11:00

In the context of the box model, what is the difference between a margin and a padding? a. a padding lies outside a box border, while a margin lies inside it. b. a padding lies inside a box border, while a margin lies outside it. c. a padding can be adjusted independently, while a margin depends on the size of its box. d. a padding depends on the size of its box, while a margin can be adjusted independently.

Answers: 3

Answer

Computers and Technology, 24.06.2019 01:30

Suppose a cpu with a write-through, write-allocate cache achieves a cpi of 2. what are the read and write bandwidths (measured by bytes per cycle) between ram and the cache? (assume each miss generates a request for one block.)

Answers: 1

Answer

You know the right answer?

Consider the relation courses (C, T,H, R,S, G), whose attributes may be thought informally as course...

Questions