Question: Create the following tables. The underlined bold column names are the primary keys. Make sure to specify the primary and foreign key constraints in your

Create the following tables. The underlined bold column names are the primary keys. Make sure to specify the primary and foreign key constraints in your create table statements.

customer: (cus_code:integer, cus_lname:varchar(20), cus_fname:varchar(20), cus_initial:char, cus_areacode:integer,cus_phone:integer).

invoice: (inv_number:integer, cus_code:integer, inv_date:date,

foreign key cus_code references customer(cus_code))

line: (inv_number:integer, prod_code:integer ,line_units:integer,

foreign key (inv_number) references Invoice(inv_number),

foreign key (prod_code) references Product (prod_code) )

product:(prod_code:integer, prod_desc:varchar(50), prod_price:integer, prod_quant:integer,vend_code:integer,

foreign key (vend_code) referenecs Vendor(vend_code))

vendor:(vend_code:integer,vend_name:varchar(30),vend_contact:varchar(30),vend_areacode:integer,vend_phone:integer)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To create the tables as specified you need to ensure that the primary keys and foreign keys are prop... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

A density histogram of the scores (in points) on an algebra test is shown in Fig. 69. Some of the bars have been left blank on purpose. a. Estimate M. b. Estimate . c. Estimate s. d. Estimate s2....

Insert the following data in the tables usinginsert into statements: customer: 10010, Johnson, Albert, A, 612, 8442573 10011, Edwards, Leona, K, 763, 8941238 10012, Smith, Walter, W, 612, 8942285...

Homework #3 Due: see Syllabus Total: 20 Points What to submit: Submit SQL commands used to answer Part 1, Part 2, and Part 3. Make sure that your SQL script runs without any errors. Submit screen...

Submit SQL commands used to answer Part 1, Part 2, and Part 3. Make sure that your SQL script runs without any errors. Submit screen shots of running commands for Part 2. Submit answers to Part 4...

Database Management Systems This one question 4 part. Please give all necessary things. Thanks What to submit: Submit SQL commands used to answer Part 1, Part 2, and Part 3. Make sure that your SQL...

Screen shot all table and answer about this database problem Submit SQL commands used to answer Part 1, Part 2, and Part 3. Make sure that your SQL script runs without any errors. Submit screen shots...

Submit SQL Script that includes SQL statements to answer Part 1, Part 2, and Part 4. Make sure that your SQL script runs without any errors. Create the following tables. The underlined bold column...

ANSWER Q4, HAVE INCLUDED ALL PARTS FOR REFERENCE BUT JUST ANSWER QUESTION 4: SQL QUERIES Question 1 (5 Points): Creating the database: Create a database using your name. Then create the following...

MYSQL Part 1 (5 Points): Creating the database: Create the following tables. The underlined bold column names are the primary keys. Make sure to specify the primary and foreign key constraints in...

i want help for these new requirements (first and second photo) and i put my master page and site map from my pervious sheet (sheet 6) Open the previous website (SHEET6) and do the following: -...

Part 1 (3 Points): Creating the database: Create the following tables. The underlined column names are the primary keys. Make sure to specify the primary and foreign key constraints in your create...

Record your responses on the spreadsheet template. On January 1, 2014, Bernard Ltd. issues 500 5% bonds with a face value of $1 000. The bonds mature on December 31, 2023, and pay interest...

When planning your meeting with the HR department you think of the different facilitation techniques you can use, to get the group to come up with ideas around how to inform the rest of the company...

Question 1 ( 2 points ) The substituted basis rule causes the unrecognized gain or loss on a non - taxable exchange to be embedded in the basis of the qualifying property acquired True False

8:37 * N. 80% i ... OBJECTIVES: Create relationships Create a Pivot Table from Related Tables Create a PivotChart Modify the PivotChart The major section in this chapter :ontinuation is: Data...