7rQDV2Rz

1DROP DATABASE IF EXISTS store;
2CREATE DATABASE store;
3USE store;
4
5CREATE TABLE Discs (
6	DiscId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
7	Album VARCHAR(255) NOT NULL,
8    Price FLOAT(3,2) NOT NULL,
9	PRIMARY KEY (DiscID)
10);
11
12CREATE TABLE Customers (
13	CustomerId INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
14	Name VARCHAR(255) NOT NULL,
15	Album VARCHAR(255) NOT NULL,
16	Copies INTEGER,
17	PRIMARY KEY (CustomerId),
18	CONSTRAINT FKC1 
19		FOREIGN KEY FKalbum (Album) 
20		REFERENCES Discs (DiscID)
21		ON DELETE CASCADE
22		ON UPDATE CASCADE
23);
24
25INSERT INTO Discs (Album, Price) VALUES ("Big Booty", 23.94);
26INSERT INTO Discs (Album, Price) VALUES ("Empires", 40.00);
27INSERT INTO Customers (Name, Album, Copies) VALUES ("Joe", "motown", 12)