Top Posters
Since Sunday
a
5
k
5
c
5
B
5
l
5
C
4
s
4
a
4
t
4
i
4
r
4
r
4
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
Heff Heff
wrote...
Go to Answer
Posts: 1330
Rep: 3 0
6 years ago
Which of the following functional dependency diagrams accurately represents the following situation:
•   A campus has many buildings.
•   Each building has a unique name.
•   Each building has many rooms.
•   All rooms in any given building are numbered sequentially starting at "101."
•   Each room has a certain capacity, although many rooms in the same building or different buildings may have the same capacity.
•   Each room is assigned to a single department.
•   A department may have many rooms in one or more buildings, each with the same or different capacities.
A) BuildingName → (RoomNumber, Capacity, Department)
B) RoomNumber → (BuildingName, Department, Capacity)
C) (Department, Capacity) → (BuildingName, RoomNumber)
D) (BuildingName, Capacity) → (Department, RoomNumber)
E) (BuildingName, RoomNumber) → (Capacity, Department)
Textbook 
Database Concepts

Database Concepts


Edition: 7th
Authors:
Read 33 times
1 Reply
Replies
Answer verified by a subject expert
bestavinashbestavinash
wrote...
#1
Top Poster
Posts: 675
Rep: 7 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

Heff Author
wrote...

6 years ago
Good timing, thanks!
klyn
wrote...

Yesterday
this is exactly what I needed
branbran2k16
wrote...

2 hours ago
This site is awesome
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1288 People Browsing
 124 Signed Up Today
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Related Images
  
 2225
  
 309
  
 388
Your Opinion
What's your favorite funny biology word?
Votes: 328
Previous poll results: Which industry do you think artificial intelligence (AI) will impact the most?