In implementing the ER model provided, you must complete the following tasks: • Create all the relations in a Microsoft Access database. Consider each attribute in every table and make appropriate...

In implementing the ER model provided, you must complete the following tasks:


•    Create all the relations in a Microsoft Access database. Consider each attribute in every table and make appropriate choices regarding data types & sizes, indexes, required/not required and validation rules. Your choices should be appropriate for each attribute and should support data integrity. (Note: see the Data Integrity section below for specific data integrity requirements)
•    Create relationships as appropriate. Enforce referential integrity for all appropriate relationships in the database. Apply cascade update and/or delete options wherever necessary.
•    Review the default index created by Access for each table. You should ensure that the indexes follow the guidelines given in the unit textbook.
•    Populate the database with sample data of your own. You must include sufficient sample data to test your queries and report