1
4
Artist
PK Artist_ID (varchar)
Name (char)NOT NULL
Event
PK Event_ID(varchar)
Date(datetime)
Organizers
PK Organizer_ID(varchar)
Name(char) NOT NULL
Manager
PK Manager_ID(varchar)
Name(char) NOT NULL
Album
PK Album_ID(varchar)
Title(char) NOT NULL
FK Artist_ID(varchar)
Year(year)
FK Label_ID(varchar)
Label
PK Label_ID(varchar)
Name(char) not null
(
Producer
PK Producer_ID(varchar)
Name(char) NOT NULL
Release
PK Release_ID(varchar)
Date(datetime)
11
*
*
1
The following Is the DDL SQL statement that is used to create the Musician database:
mysql> CREATE DATABASE Musician;
mysql> use musician
mysql> create table Artist
-> (Artist_ID varchar (255) PRIMARY KEY,
-> Name char (255) NOT NULL);
mysql> CREATE TABLE Label
-> (Label_ID varchar (255) PRIMARY KEY,
-> Name char (255) NOT NULL);
mysql> CREATE TABLE Event
-> (Event_ID varchar (255) PRIMARY KEY,
-> Date datetime);
mysql> CREATE TABLE Organizers
-> (Organizer_ID varchar (255) PRIMARY KEY,
-> Name char (255) NOT NULL);
mysql> CREATE TABLE Producer
-> (Producer_ID varchar (255) PRIMARY KEY,
-> Name char (255) NOT NULL);
mysql> CREATE TABLE Manager
-> (Manager_ID varchar (255) PRIMARY KEY,
-> Name char (255) NOT NULL);
mysql> CREATE TABLE Album
-> (Album_ID varchar (255) PRIMARY KEY,
-> Title char (255) NOT NULL,
-> FOREIGN KEY (Label_ID) REFERENCES Label(Label_ID),
-> Year year,
-> FOREIGN KEY (Artist_ID) REFERENCES Artist(Artist_ID);
Reference
Captain, F. A. (2018). Six-step relational database design: A step by step approach to relational database design and development. Fidel A Captain.
Embley, D. W., & Thalheim, B. (2012). Handbook of conceptual modeling: Theory,
Schmidt & Brodie, M. L. (2018). Relational database systems: Analysis and comparison. Springer Science & Business Media.
Safety Engineering and Risk Analysis. https://doi.org/10.1115/imece2016-66791