In MySql (1) Create the tables needed to implement your database (2) Define primary keys and foreign
Fantastic news! We've Found the answer you've been seeking!
Question:
In MySql
(1) Create the tables needed to implement your database
(2) Define primary keys and foreign keys
(3) Define the relationships among your tables.
(4) Define any necessary referential integrity constraints between your tables.
(5) Add sample data to the database tables (each table should have at least 10 rows).
The red color attributes are the primary key and green color attributes are the foreign key of the relation.
- The Customer relation has the details of the customer.
- Each customer has a sign up id. It was stored in the relation User, with CustId has the foreign key. (Referential integrity constraints)
- The song relation has the details of the song
- The purchase relation has details of the purchase made by the customer. A purchase will have single song only. (Referential integrity constraints)
- The album relation contains the details of all albums with its artist id detail. A album will have a single artist. (Referential integrity constraints)
- The genre relation has the details of different genres available.
- Song_Genre_Album relation has the details of the song title and its genre and Album title.
Related Book For
Core Concepts Of Accounting Information Systems
ISBN: 9780470507025
11th Edition
Authors: Nancy A. Bagranoff, Mark G. Simkin, Carolyn Strand Norman
Posted Date: