Question: 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
Get step-by-step solutions from verified subject matter experts
