NmsVNQFt

1CREATE TABLE IF NOT EXISTS autors
2(
3	autor_id INT(2) NOT NULL UNIQUE AUTO_INCREMENT,
4	autor_name VARCHAR(100) NOT NULL,
5	PRIMARY KEY (autor_id)
6);
7CREATE TABLE IF NOT EXISTS books
8(
9	book_id INT(2) NOT NULL UNIQUE AUTO_INCREMENT,
10	book_title VARCHAR(100) NOT NULL,
11	autor_id SET(SELECT book_id FROM autors) NOT NULL,
12	PRIMARY KEY (book_id),
13	FOREIGN KEY (autor_id) REFERENCES autors (autor_id)
14);