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).
Geschreven voor
- Instelling
- ICT 3722
- Vak
- ICT 3722
Documentinformatie
- Geüpload op
- 30 juli 2021
- Bestand laatst geupdate op
- 30 juli 2021
- Aantal pagina's
- 6
- Geschreven in
- 2020/2021
- Type
- Tentamen (uitwerkingen)
- Bevat
- Vragen en antwoorden
Onderwerpen
-
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
Ook beschikbaar in voordeelbundel