Question: If you wanted to produce a listing of the file
If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the filestructure?
Answer to relevant QuestionsWhat data redundancies do you detect? How could those redundancies lead toanomalies?Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure. (The file is meant to be used as a teacher class assignment schedule. One of the many problems with data redundancy ...What is an ERDM, and what role does it play in the modern (production) database environment?What is logical independence?Identify each relationship type and write all of the business rules.
Post your question