Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Using the above figure as a reference write the SQL commands to create the SALE, SALE_TITLE_XREF and TITLE tables. Choose appropriate data types and

image text in transcribedimage text in transcribed

Using the above figure as a reference write the SQL commands to create the SALE, SALE_TITLE_XREF and TITLE tables. Choose appropriate data types and field widths for each field. Be sure to create appropriate constraint definitions for the primary and foreign keys, and be sure to create your tables in the correct order for the foreign key constraints. (You can assume the other table you need already exist) sale sale_id INT(11) name VARCHAR 100 start date DATE end date DATE discount FLOAT(12) sale_title_xref sale_id INT(11) tide id INT11) author author_id INT title the id INTOLD sitle id first name VARCHAR(20 last name VARCHAROO INT(11) name VARCHAR(100) author jd INT) publisher_id INT(11 name category.id INT(11) obituary birth date DATE deceased date DATE obituary text TEXT author id INTOLL publisher publisher_id INT) VARCHAR(100 sales.contact VARCHAR(100 category category_id INT(11) description VARCHAR(100

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Computer Networking A Top-Down Approach

Authors: James Kurose, Keith Ross

7th edition

978-0133594140

More Books

Students also viewed these Computer Network questions

Question

What are some of the reasons for poor decisions?

Answered: 1 week ago

Question

2. Do not crowd the student. Do not get in the students face.

Answered: 1 week ago