CREATE TABLE employee (
id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT,
forenmame VARCHAR(100) NOT NULL,
lastname VARCHAR(100) NOT NULL,
gender ENUM('M', 'F', 'O', 'U' COMMENT 'M = Male, F = Female, O = Other, U = Unknown',
position VARCHAR(255) NOT NULL,
PRIMARY KEY (id)
) ENGINE=InnoDB;
CREATE TABLE member ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, forename VARCHAR(100) NOT NULL, surname VARCHAR(100) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB;
CREATE TABLE media ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, media_type VARCHAR(50) NOT NULL COMMENT 'E.g. DVD, Blu-Ray etc.', title VARCHAR(255) NOT NULL, genre VARCHAR(100) NOT NULL, release_date DATETIME DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB;
CREATE TABLE rental ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, member_id INT(11) UNSIGNED NOT NULL, media_id INT(11) UNSIGNED NOT NULL, employee_id INT(11) UNSIGNED NOT NULL, date_borrowed DATETIME DEFAULT NOW(), date_returned DATETIME DEFAULT NULL, overdue TINYINT(1) DEFAULT 0 COMMENT '1 = Overdue, 0 = Not overdue)', status VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB;
CREATE TABLE feedback ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, rental_id INT(11) UNSIGNED NOT NULL, feedback VARCHAR(255) DEFAULT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB; CREATE TABLE location ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, location VARCHAR(255) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB;
CREATE TABLE stock ( id INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, media_id INT(11) UNSIGNED NOT NULL, location_id INT(11) UNSIGNED NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB;
INSERT INTO employee (id, forenmame, lastname, gender, position) VALUES (1, 'John', 'Snow', 'M', 'Sales';
INSERT INTO member (id, forename, surname) VALUES (2, 'Mike', 'Tyson';
INSERT INTO media (id, media_type, title, genre, release_date) VALUES (6, 'DVD', 'Pirates of The Caribbean', 'Fantasy', '2003-06-28 00:00:00';
INSERT INTO rental (id, member_id, media_id, employee_id, date_borrowed, date_returned, overdue, status) VALUES (3, 2, 6, 1, '2018-06-21 14:22:13', '2018-06-22 10:14:39', 0, NULL);
INSERT INTO feedback (id, rental_id, feedback) VALUES (4, 3, 'It was great thanks!';
INSERT INTO location (id, location) VALUES (5, 'Cardiff'; INSERT INTO stock (id, media_id, location_id) VALUES (3, 6, 5);
Last reply 20 hours ago
Is MathsFM French Alevels good for a CS degree at top uni (OX, UCL, Durham etc)Last reply 2 days ago
OCR A-level Computer Science Paper 1 (H446/01) - 12th June 2023 [Exam Chat]Last reply 2 weeks ago
OCR A-level Computer Science Paper 2 (H446/02) - 19th June 2023 [Exam Chat]Last reply 3 weeks ago
AQA A-level Computer Science Paper 1 (7517 1A - 1E) - 12th June 2023 [Exam Chat]Last reply 4 weeks ago
Not receiving any response from University of Birmingham.Last reply 3 months ago
OCR GCSE Computer Science Paper 1 (J277/01) - 19th May 2023 [Exam Chat]Last reply 3 months ago
AQA GCSE Computer Science Paper 2 (8525/2) - 25th May 2023 [Exam Chat]Last reply 20 hours ago
Is MathsFM French Alevels good for a CS degree at top uni (OX, UCL, Durham etc)Last reply 2 days ago
OCR A-level Computer Science Paper 1 (H446/01) - 12th June 2023 [Exam Chat]Last reply 2 weeks ago
OCR A-level Computer Science Paper 2 (H446/02) - 19th June 2023 [Exam Chat]Last reply 3 weeks ago
AQA A-level Computer Science Paper 1 (7517 1A - 1E) - 12th June 2023 [Exam Chat]Last reply 4 weeks ago
Not receiving any response from University of Birmingham.Last reply 3 months ago
OCR GCSE Computer Science Paper 1 (J277/01) - 19th May 2023 [Exam Chat]Last reply 3 months ago
AQA GCSE Computer Science Paper 2 (8525/2) - 25th May 2023 [Exam Chat]