Sql Codes For Ict 3722 Assingment
CREATE TABLE BOOK ( Book_id NUMERIC(5) NOT NULL PRIMARY KEY, AuthId NUMERIC(5) , Types_id NUMERIC(5), Name VARCHAR(20), Page_count NUMERIC(5) ); CREATE TABLE AUTHOR ( AuthId NUMERIC (5) NOT NULL PRIMARY KEY, Name CHAR(15), Surname CHAR(20), ); CREATE TABLE STUDENT( Student_id NUMERIC(5) NOT NULL PRIMARY KEY, Name VARCHAR(20), Surname VARCHAR (20), Gender VARCHAR(20), Date_of_birth DATETIME
Document information
- Uploaded on
- July 30, 2021
- File latest updated on
- July 30, 2021
- Number of pages
- 2
- Written in
- 2020/2021
- Type
- Exam (elaborations)
- Contains
- Answers