Complete the task described in question 3.58 on page 134 of your text. Consider the table. STAFF_Meeting(EmployeeName, ProjectName, Date) The rows of this...
car.faComplete the task described in question 3.58 on page 134 of your text.
Consider the table.
STAFF_Meeting(EmployeeName, ProjectName, Date)
The rows of this table record the fact that an employee from a particular project attended a meeting on a given date. Assume that a project meets a most once per day. Also, assume that only one employee represents a given project, but that employees can be assigned to multiple projects.
a. state the functional dependencies in STAFF_MEETING
b. Transform this table into one or more tables in BCNF. State the primary keys, candidate keys, foreign keys, and referential integrity constraints.
C. Is your design in part B an improvement over the original table? What advantages and disadvantages does it have?
12 years ago
999999.99
Answer(0)
Bids(0)
other Questions(10)
- Kim Woods
- INF220- Ashford University
- 6 pages About astronomy.
- Psychology Online exam
- POLITICAL SCIENCE MOVIE REVIEW. " DO THE RIGHT THING" - film title
- C++
- business statistics
- Both Piagets Model of Cognitive Development and Kohlbergs Model of Moral Development are outlined in stages, with one stage building off of the previous stage. Put yourself in the role of parent, teacher and juvenile justice judge and then in each role
- payment links
- MGT 601 week 4 DQ 2
