ICT3722ANSWERS TUTORIALS LETTER
Write an SQL code that will generate the following tables: 1.Book table. 2.Author table 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) Populate the rest of the tables as in Appendix A. (Do not submit the code).
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
- 6
- Written in
- 2020/2021
- Type
- Exam (elaborations)
- Contains
- Questions & 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