Use the Relational Data Model to design a database that stores customers’ online activity

Subject:Computer SciencePrice:4.87 Bought7

Share With

Use the Relational Data Model to design a database that stores customers’ online activity.

• customers book purchases

• reviews

• ratings

Complete the following-

*List the relationships between your entities

*List any relationship-specific attributes.

*Convert your set of entities, attributes and relations into a database schema.

*Specifically, write down the table names, the columns in each table, and specify which columns are primary keys and which ones are foreign keys.

*Using your database design, write an SQL query to retrieve the customer ID's (or customer names, either is fine) of all customers that gave the book "Alice in Wonderland" a rating of 5. Using your database design, write an SQL query to insert a new purchase done by customer John Smith, whose ID is 1234, to the book "The Three Musketeers", whose ID is 5678.