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
Written for
- Institution
- ICT 3722
- Course
- ICT 3722
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
Subjects
- type
-
begin tran drop table borrow drop table book drop table student drop table author drop table types1 create table book bookid numeric5 not null primary key
-
authid numeric5
Also available in package deal