Exam (elaborations)
ICT3722 ASSIGNMENT SEMESTER 1 &2 DATABASE PRACTICE WITH ANSWERS 100%CORRECT INCLUSIVE OF SQL CODES
- Course
- Institution
Question 1. Write an SQL code that will generate the following tables: (8mks) 1 Book table. 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) ); 2.Author table. CREATE TABLE AUTHOR ...
[Show more]