Page 1 of 1
Problem 1: (50 points) CUSTOMER CustomeriD First_Name Last_Name City State Zip_Code Phone Birthdate Registation_Date ORD
Posted: Tue Apr 26, 2022 12:30 pm
by answerhappygod
- Problem 1 50 Points Customer Customerid First Name Last Name City State Zip Code Phone Birthdate Registation Date Ord 1 (97.71 KiB) Viewed 49 times
Problem 1: (50 points) CUSTOMER CustomeriD First_Name Last_Name City State Zip_Code Phone Birthdate Registation_Date ORDER OrderID Order Date Payment Method OrderType Customer SHIPPED_ORDER ShippedOrderID ShippingMethod SUPBSCRIPTION SubscriptionID Subscription_Type ORDER_CONTENT ShippedOrderid Albumid Quantity PLAY_HISTORY SubscriptionID SongID Play_Date PlayCount ALBUM AlbumID AlbumTitle AlbumPrice Release Date SONG SonRID Song_Title Play_Time AlbumID SONG_ALBUM SongID SONG_ARTIST Song|D Artisti GenreID SONG_GENRE SongID ARTIST ArtistID Artist_Name Debut_Date GENRE GenrelD Genre_Name Statement: Write an SQL script to create the above database and insert some data in the tables. You must insert data in all tables as Assignment 5 may require you to retrieve data from the tables you create in this assignment. Make sure you chose appropriate data typesand make sure you add the required constrains to enforce the rules on the above relational model such as primary keys and foreign keys.