Directions: Be sure to make an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure to use correct English spelling and grammar. Sources must be cited in APA format. Your response should be around a minimum of (1) single-spaced page to a maximum of (2) single-spaced pages in length; refer to the “Assignment Format” page for specific format requirements.
Be sure to include your name, student number, address, the name of this course (K11 Database Processing), and the name of the project (“Lesson 3”) on each page you submit. If we cannot identify your work, we cannot give you credit.
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 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.
-
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?
Order Management
Premium Service
- 100% Custom papers
- Any delivery date
- 100% Confidentiality
- 24/7 Customer support
- The finest writers & editors
- No hidden charges
- No resale promise
Format and Features
- Approx. 275 words / page
- All paper formats (APA, MLA, Harvard, Chicago/Turabian)
- Font: 12 point Arial/Times New Roman
- Double and single spacing
- FREE bibliography page
- FREE title page
0% Plagiarism
We take all due measures in order to avoid plagiarisms in papers. We have strict fines policy towards those writers who use plagiarisms and members of QAD make sure that papers are original.