Question: Using the schema, tables, and data you created in Exercise 1 (The picture below): Examine the candidate keys in each table. Write ALTER TABLE statements

Using the schema, tables, and data you created in Exercise 1 (The picture below):

Examine the candidate keys in each table.

Write ALTER TABLE statements for each table to create Primary Keys and Foreign Keys where applicable.

Test the statements in your schema to make sure they work.

Using the schema, tables, and data you created in Exercise 1 (The

Tables Customer ?len columns ? CUSCODE ? CUS-LNAME - CUS FNAME ? CUS-INITIAL ? CUS-AREACODE ? CUS-PHONE ? CUS-BALANCE Indexes Foreign Keys Triggers ?| | invoice ?len columns ? INVNUMBER ? CUSCODE ? INVDATE ? INVSUBTOTAL - - - - INV TAX ? INV TOTAL Indexes Foreign Keys Triggers ?- | line Columns ? INVNUMBER ? LINENUMBER ? PCODE ? LINEUNITS ? LINEPRICE ? LINE TOTAL Indexes Foreign Keys Triggers - - - - - ? product ?len columns ? PCODE ? PDESCRIPT ? P. INDATE ? P.Q0H ? PMIN ? PPRICE ? PDISCOUNT ? V-CODE Indexes Foreign Keys Triggers - - - - - vendo ? Columns ? VCODE ? V-NAME ? VCONTACT ? VAREACODE ? V PHONE - - - V STATE ? VORDER Indexes Foreign Keys Triggers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

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!

Using the schema, tables, and data you created in Exercise 1: Examine the candidate keys in each table. Write ALTER TABLE statements for each table to create Primary Keys and Foreign Keys where...

My name is Salam Abdulhussein and I need this to be done as soon as possible. Please follow the steps one by one and make sure everything is correct Global Bike, Inc. ERP for Sales / Collection USING...

/* IVY TECH COMMUNITY COLLEGE DBMS130 M02 Hands-On Lab Assignment Constructing the Database */ /* (5 points) After completing your SQL below, upload your Script and Run it until all errors are...

Database Design SQL Exercises #2 - Using CoopSQL-avia_company database (MySQL) 6/6/2017 For the following exercises, open the CoopSQL-avia_company database (instructor provided in MySQL), and write...

/* IVY TECH COMMUNITY COLLEGE DBMS130 M02 Hands-On Lab Assignment Constructing the Database */ /* (5 points) After completing your SQL below, upload your Script and Run it until all errors are...

For database applications course 2.10 LAB - Implement independent entity (Sakila) Implement a new independent entity phone in the Sakila database. Attributes and relationships are shown in the...

points) After completing your SQL below, upload your Script and Run it until all errors are resolved. I WILL GRADE this script directly in APEX. You will be adding DB Objects to the HOL DB that were...

Instructions: Write the SQL statements to create the output described in the Problems below. ALL queries should return data Problems: 1) Write the SQL commands to produce a query that lists ALL the...

. Open a text editor to begin writing your SQL script that will contain your SQL statements. ( You may use any program that allow you to create . sql files ( e . g . , Notepad, Wordpad, Notes,...

Two heavily industrial areas are located 10 miles apart, as shown in the figure. if the concentration of particulate matter (in parts per million) decreases as the reciprocal of the square of the...

A man takes 10 hours to go to a place and come back, by walking both ways at contact speed He could have gained 2 hours by riding both the ways at a constant speed, The distance covered in the whole...

Which of the following statements is false? A . Social Security will provide most indrviduals with an equal wage teplacernent percentage dunng retirement. B . Bocause of the high cost, mary smal...

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Go to the website of the Federal Reserve Bank of St. Louis (http://www.stlouisfed.org) to find some information about the Fed. Find a map of the Federal Reserve districts. If you live in the United...

Suppose that the T-account for First National Bank is as follows: Assets Liabilities Reserves $100,000 Deposits $500,000 Loans 400,000 a. If the Fed requires banks to hold 5 percent of deposits as...

Imagine that you intend to buy a portfolio of ten stocks with some of your savings. Should the stocks be of companies in the same industry? Should the stocks be of companies located in the same...