[ERD] The More Music
Tables (6)
Album
- Album ID — Primary key — NOT NULL
- Artist ID — Foreign key → Artist.Artist ID — NOT NULL
- Title
- Field (Artist)
- Label
- Release Date
- Field (Prime Cost)
- Field (Genre (K-pop? Pop? Rock? Jazz? Classic? Etc?))
Artist
- Artist ID — Primary key — NOT NULL
- Name
- Age
- Gender
- Articles
Copy Of Artist (Order)
- Artist ID (Order ID) — Primary key — NOT NULL
- Artist ID (Customer ID) — Foreign key → Customer.Artist ID — NOT NULL
- Name (Order Date)
- Age (Total Price)
- Gender (Payment Method)
- Articles (Delivery)
Copy Of Artist2 (Inventory)
- Artist ID (Inventory ID) — Primary key — NOT NULL
- Album ID — Foreign key → Album.Album ID — NOT NULL
- Name (Quantity on Hand)
- Age (Quantity Available)
Copy Of Copy Of Artist (Order Item)
- Artist ID (Order Item ID) — Primary key — NOT NULL
- Artist ID (Order ID) — Foreign key → Copy Of Artist.Artist ID — NOT NULL
- Album ID — Foreign key → Album.Album ID — NOT NULL
- Name (Quantity)
- Age (Sales Price)
Customer
- Artist ID (Customer ID) — Primary key — NOT NULL
- Name
- Age (ID)
- Gender (Password)
- Articles (SSN)
- Field (Address)
- Field (Phone Number)
- Field (Birthday)
- Field (Occupation)
- Field (Wedding Anniversary)
- Field (Defalut Payment Method)
- Field (Registration Date)
- Field (E-mail Address)