Question: Can someone help me make a database named db_Library SQL using CMD? 4 tables only. Please screenshot all results!! Here's all the information: Metadata for
Can someone help me make a database named db_Library SQL using CMD? 4 tables only. Please screenshot all results!!
Here's all the information:
Metadata for the tables
| TB_Author |
|
|
| TB_Book |
|
|
| Author_Num |
| Int |
| Book_Title |
| varchar(50) |
| Author_Last |
| varchar(30) |
| Book_Code |
| varchar(4) |
| Author_First |
| varchar(30) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| TB_Publisher |
|
|
| TB_Type |
|
|
| Publisher |
| varchar(50) |
| Type |
| varchar(3) |
| Publisher_Code |
| varchar(2) |
| Paperback | varchar(1) | |
|
|
|
|
|
|
|
|
Data to be inserted
| AUTHOR_NUM | AUTHOR_NAME | BOOK_CODE | TITLE | PUBLISHER_CODE | PUBLISHER_NAME | TYPE | PAPERBACK |
| 3 | Vernor Vintage | 0180 | A Deepness in the Sky | TB | Toe TBL_Books | SFI | Y |
| 5 | Peter Straub | 0189 | Magic Terror | FA | Fawcett TBL_Books | HOR | Y |
| 18 | Albert Camus | 0200 | The Stranger | VB | Vintage TBL_Books | FIC | N |
| 11 | Gary Wills | 0378 | Venice | SS | Simon and Schuster | ART | N |
| 4 | Dict Francis | 0808 | The Edge | JP | Jove Publications | HOR | Y |
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
