Exam (elaborations)
ICT3722 ASSIGNMENT SEMESTER 1 &2 DATABASE PRACTICE WITH ANSWERS 100%CORRECT INCLUSIVE OF SQL CODES
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 ( AuthId NUMBER(5) NOT NULL PRIMARY KEY, Name CHAR(15), Surname CHAR(20), ); Question 2 (5 Marks) The tables below in Appendix A shows the contents of the tables that you have generated in Question 1, populate these tables with data as shown in the relevant table by doing the following: 1 Write the code that populates the Book table. Submit this code. (5) INSERT IN.................................................
Show more
Read less
Institution
ICT 3722
Module
ICT 3722
Whoops! We can’t load your doc right now. Try again or contact support.
Written for
- Institution
- ICT 3722
- Module
- ICT 3722
Document information
- Uploaded on
- July 30, 2021
- File latest updated on
- July 30, 2021
- Number of pages
- 6
- Written in
- 2020/2021
- Type
- Exam (elaborations)
- Contains
- Questions & answers
Subjects
-
tutorial letter 10432021 database practice ict3722 semesters 1amp2 computer science note this is a fully online module and therefore it is only available on myunisa assignment 04 a
$18.49
Get access to the full document:
100% satisfaction guarantee
Immediately available after payment
Both online and in PDF
No strings attached
Also available in package deal
Package deal
THIS BUNDLE CONTAINS ICT3722 ASSIGNMENT SEMESTER 1 & 2 DATABASE PRACTICE WITH ANSWERS + SQL CODES ALL TOGETHER TO SUBMITTED ON 2 - 08 - 2021.
3
2021
$ 34.47
More info
