Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Are any determinants you highlighted in #1 not a candidate key of the ASSIGNMENT entity? If so, list those determinants / functional dependency(ies), in standard
- Are any determinants you highlighted in #1 not a candidate key of the ASSIGNMENT entity? If so, list those determinants / functional dependency(ies), in standard notation.
- Based on what you determined in questions 2-4, and considering future growth, is it necessary to split the ASSIGNMENT entity into multiple entities? If so, list the themes of all entities.
- For each theme identified in question #5, use standard entity/relation notation to describe each entity. Use natural keys only, do not include foreign keys, and assign attributes properly to their theme.
- Keeping future growth of the firm in mind and ease of use/understanding, consider whether it makes sense to modify any of the natural keys used in #6 to incorporate the surrogate key concept. If so, what would the new entity / relation structure(s) look like? Use standard entity/relation notation. Identify foreign keys. Hint: If any attribute in an entity (Entity A) is part of a primary key for A and also serves as a foreign key to another entity (Entity B), you would both underline and italicize the attribute in As notation.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
College Accounting A Practical Approach
Authors: Jeffrey Slater
12th edition
978-0132772068, 133468100, 013277206X, 9780133468106, 978-0133133233
