DBMS implementation
Running Head:“SQL Queries” 1
“SQL Queries” 7
“SQL Queries”
Student’s Name:
Tutor’s Name:
Date:
CREATE TABLE Artist (
Artist_ID INT PRIMARY KEY AUTO_INCREMENT,
Name char (255) NOT NULL,
address VARCHAR (255) NOT NULL,
);
INSERT INTO Artist(Name, address)
VALUES('Justine','3950 North 1st Street CA 95134'),
('Drake','5000 North 1st Street CA 95134'),
('Rihana','3000 North 1st Street CA 95134'),
(‘Ariana','4000 North 1st Street CA 95134'),
('Snoop','5000 North 1st Street CA 95134'),
(‘Shakur','6000 North 1st Street CA 95134'),
('Jayz','7000 North 1st Street CA 95134'),
('Birdingfield','8000 North 1st Street CA 95134'),
('Jackson','9000 North 1st Street CA 95134'),
('Sam','10000 North 1st Street CA 95134');
Show table Artist;
CREATE TABLE Label (
Label_ID INT PRIMARY KEY AUTO_INCREMENT,
Name char (255) NOT NULL,
);
INSERT INTO Artist(label)
VALUES('Justine'),
('Drake'),
('Rihanna'),
(‘Ariana',),
('Snoop',),
(‘Shakur'),
('Jayz'),
('Birding field'),
('Jackson'),
('Sam');
CREATE TABLE Event (
Event_ID INT PRIMARY KEY AUTO_INCREMENT,
Date datetime,
);
CREATE TABLE organizers (
organizer_ID INT PRIMARY KEY AUTO_INCREMENT,
Name char (255) NOT NULL,
address VARCHAR (255) NOT NULL,
);
INSERT INTO organizers (Name, address)
VALUES('Justine','3950 North 1st Street CA 95134'),
('Drake','5000 North 1st Street CA 95134'),
('Rihana','3000 North 1st Street CA 95134'),
(‘Ariana','4000 North 1st Street CA 95134'),
('Snoop','5000 North 1st Street CA 95134'),
(‘Shakur','6000 North 1st Street CA 95134'),
('Jayz','7000 North 1st Street CA 95134'),
('Birdingfield','8000 North 1st Street CA 95134'),
('Jackson','9000 North 1st Street CA 95134'),
('Sam','10000 North 1st Street CA 95134');
CREATE TABLE Release (
Release _ID INT PRIMARY KEY AUTO_INCREMENT,
Date datetime,
);
CREATE TABLE producer (
Producer_ID INT PRIMARY KEY AUTO_INCREMENT,
Name char (255) NOT NULL,
);
INSERT INTO producer (Name)
VALUES('Justine'),
('Drake'),
('Rihanna'),
(‘Ariana',),
('Snoop',),
(‘Shakur'),
('Jayz'),
('Birding field'),
('Jackson'),
('Sam');
CREATE TABLE Manager (
Manager_ID INT PRIMARY KEY AUTO_INCREMENT,
Name char (255) NOT NULL,
);
INSERT INTO Manager (Name)
VALUES('Justine'),
('Drake'),
('Rihanna'),
(‘Ariana',),
('Snoop',),
(‘Shakur'),
('Jayz'),
('Birding field'),
('Jackson'),
('Sam');
CREATE TABLE Album (
Album_ID INT PRIMARY KEY AUTO_INCREMENT,
Title char (255) NOT NULL,
FOREIGN KEY (Label_ID) REFERENCES Label (Label_ID),
FOREIGN KEY (Artist_ID) REFERENCES Artist(Artist_ID),
Year year,
);
INSERT INTO Album (Title)
VALUES('Justine'),
('Drake'),
('Rihanna'),
(‘Ariana',),
('Snoop',),
(‘Shakur'),
('Jayz'),
('Birding field'),
('Jackson'),
('Sam');
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