Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Given the file structure shown below, answer the following questions: AUTHOR_NUM AUTHOR_NAME BOOK_CODE TITLE PUBLISHER_CODE PUBLISHER_NAME TYPE PAPERBACK 3 Vernor Vintage 0180 A Deepness in
Given the file structure shown below, answer the following questions:
AUTHOR_NUM | AUTHOR_NAME | BOOK_CODE | TITLE | PUBLISHER_CODE | PUBLISHER_NAME | TYPE | PAPERBACK |
3 | Vernor Vintage | 0180 | A Deepness in the Sky | TB | Toe TBL_Books | SFI | Y |
5 | Peter Straub | 0189 | Magic Terror | FA | Fawcett TBL_Books | HOR | Y |
18 | Albert Camus | 0200 | The Stranger | VB | Vintage TBL_Books | FIC | N |
11 | Gary Wills | 0378 | Venice | SS | Simon and Schuster | ART | N |
4 | Dict Francis | 0808 | The Edge | JP | Jove Publications | HOR | V |
- Is the given structure free from possible anomalies? If not, what are the foreseen anomalies?
- What are the various data sources in the file structure shown above?
- Given your answer in number 2, what are the new tables that you would create in order to eliminate data redundancy?
- Provide the metadata of these tables.
- With the newly created tables, draw the ERD and its cardinalities using Crows foot notation.
- Provide at least 2 business rules based on the created ERD.
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