[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)