Question: 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
Get step-by-step solutions from verified subject matter experts
