3nphVaW9

1DROP TABLE IF EXISTS personnel, loans, loan_item;
2
3CREATE TABLE personnel(
4personal_ID VARCHAR(8) PRIMARY KEY,
5role VARCHAR(20) NULL
6
7);
8
9CREATE TABLE loans(
10loan_ID INT PRIMARY KEY,
11personal_ID VARCHAR(8) FOREIGN KEY REFERENCES Personnel(Personal_ID),
12checked_out_date DATE NOT NULL,
13return_by DATE NOT NULL,
14return_date DATE NULL
15);
16
17
18CREATE TABLE loan_item(
19PRIMARY key(item_ID, loan_ID),
20item_ID INT,
21loan_ID INT FOREIGN KEY REFERENCES loans(loan_ID),
22artifact_ID INT FOREIGN KEY REFERENCES artifact(artifact_ID),
23slide_ID INT FOREIGN KEY REFERENCES silde(slide_ID),
24ISBN VARCHAR(10) FOREIGN KEY REFERENCES book(ISBN)
25);