1CREATE TABLE table_name (
2 id INT NOT NULL IDENTITY(1, 1),
3 name NVARCHAR (100) NULL,
4 school NVARCHAR (100) NULL,
5 PRIMARY KEY (ID)
6);
1CREATE TABLE books (
2 id INT NOT NULL IDENTITY PRIMARY KEY,
3 title VARCHAR(100) NOT NULL,
4 primary_author VARCHAR(100),
5);
6