Management has requested that the following information is maintained in the database:
a. Provide an Entity-Relationship Diagram (ERD) with Chen Style to describe the scenario provided. Show entities, attributes, and relationships, including cardinality and ordinality. Provide explanations for any relevant assumptions
b. Provide the physical database tables involved in the relationship between Products and Returns. Show the keys. Explain your solution.
c. Provide the sample SQL code to insert some plausible data in a table for “Return”, respecting data types and constraints.
d. Provide the sample SQL code to display how many returns a customer (ID = 10) has made that were paid with “Credit Card”.