(Solved) : Import Storevisits Memberindex Storeinformation Tables Uasamsclub Database Assess Entity R Q29965371 . . . .

Import STORE_VISITS, MEMBER_INDEX, and STORE_INFORMATION tablesfrom the UA_SAMSCLUB database and assess the entity and referentialintegrity of the three tables.

1. Write the queries to assess the entity integrity for eachtable.

2. Write the queries to assess the referential integrity for thetwo relationships (STORE_VISITS and MEMBER_INDEX, STORE_VISITS andSTORE_INFORMATION).

3. If there are any entity or referential integrity issues,suggest a solution to address these issues and explain why you takethis approach.

4. Write the queries to implement the solution proposed inquestion 4.

5. Prepare a brief report with the queries used and theexplanations of how you addressed any data integrity issues.

Expert Answer

An answer will