Answered step by step
Verified Expert Solution
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
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
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