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
You can place an order similar to this with us. You are assured of an authentic custom paper delivered within the given deadline besides our 24/7 customer support all through.
Latest completed orders:
# | topic title | discipline | academic level | pages | delivered |
---|---|---|---|---|---|
6
|
Writer's choice
|
Business
|
University
|
2
|
1 hour 32 min
|
7
|
Wise Approach to
|
Philosophy
|
College
|
2
|
2 hours 19 min
|
8
|
1980's and 1990
|
History
|
College
|
3
|
2 hours 20 min
|
9
|
pick the best topic
|
Finance
|
School
|
2
|
2 hours 27 min
|
10
|
finance for leisure
|
Finance
|
University
|
12
|
2 hours 36 min
|