Your database should include the following tables: OWNER INFORMATION PET INFORMATION PERSONNEL SUPPLIES PROCEDURES The SUPPLIES TABLE, containing all supplies related to the practice, and the PROCEDURES TABLE, listing different types of procedures and their associated prices, will not have a primary key, because there is nothing unique in them that needs to be noted. But they will need a foreign key to associate them with tables they will need to pull information from. For the tables that need a primary key, please let Access assign a primary key for you. There are duplicate records for owners-an owner having more than one pet, for example. How would you eliminate this redundancy in normalizing the database? Please incorporate your answer into this assignment by fixing this problem in the database. Enter data into each table such that each table has NO LESS THAN 15 RECORDS Tables must be related to one another Scrub all the data in your database by amending or removing any data that is incorrect, incomplete, improperly formatted, or duplicated. Normalize your data to 2d normal form. Determine whether or not you have enough data in your database to help the owner of the practice make good business decisions-that is, could you tell the owner of the practice what to do to increase profits or reduce loss, based on the data already in the database. If not, explain this and suggest solutions in your commentary Your database should include the following tables: OWNER INFORMATION PET INFORMATION PERSONNEL SUPPLIES PROCEDURES The SUPPLIES TABLE, containing all supplies related to the practice, and the PROCEDURES TABLE, listing different types of procedures and their associated prices, will not have a primary key, because there is nothing unique in them that needs to be noted. But they will need a foreign key to associate them with tables they will need to pull information from. For the tables that need a primary key, please let Access assign a primary key for you. There are duplicate records for owners-an owner having more than one pet, for example. How would you eliminate this redundancy in normalizing the database? Please incorporate your answer into this assignment by fixing this problem in the database. Enter data into each table such that each table has NO LESS THAN 15 RECORDS Tables must be related to one another Scrub all the data in your database by amending or removing any data that is incorrect, incomplete, improperly formatted, or duplicated. Normalize your data to 2d normal form. Determine whether or not you have enough data in your database to help the owner of the practice make good business decisions-that is, could you tell the owner of the practice what to do to increase profits or reduce loss, based on the data already in the database. If not, explain this and suggest solutions in your commentary
