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