M6302xHz

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)