pastwork.docx

    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

                                                                                                                                      Order Now