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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started