Question: Assume the Part table has been created, but there are no integrity constraints. Create the necessary integrity constraint to ensure that the only allowable values

Assume the Part table has been created, but there are no integrity constraints. Create the necessary integrity constraint to ensure that the only allowable values for the Class field are AP, HW, and SG. Ensure that the PartNum field is the primary key and that the PartNum field in the OrderLine table is a foreign key that must match the primary key of the Part table.

Step by Step Solution

★★★★★

3.43 Rating (162 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

SQL For the Part table CHECK Class IN AP HW SG PRIMARY KEY PartNum For the OrderLine table FOREIGN ... 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

Document Format (1 attachment)

671-CS-DB (982).docx

120 KBs Word File

Students Have Also Explored These Related Databases Questions!

1. Create a view named LargeSlip using the data in the MarinaNum, SlipNum, RentalFee, BoatName, and OwnerNum columns in the MarinaSlip table for those slips with lengths of 40 feet. Display the data...

In the following exercises, you will use the data in the TAL Distributors database shown in Figure 2-1 in Chapter 2. (If you use a computer to complete these exercises, use a copy of the original TAL...

In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21 through 1-25. (If you use a computer to complete these exercises, use a copy of the...

Assume the Item table has been created, but there are no integrity constraints. Create the necessary integrity constraint to ensure that the only allowable values for the Category field are PZL, GME,...

can please someone help me with this assignment Solmaris Condominium Group Case In the following exercises, you will use the data in the Solmaris Condominium Group database shown in Figures 1-21...

Using SQL Server Management Studio (SSMS) 2016 or 2017: 1. Drop the Index OwnerCityState 2. Assume the CondoUnit table has been created, but there are no integrity constraits. Create the necessary...

Vital source: Art as LA ALEKS. Bo Waldru... Vitalsource: Art as L... 5 Letter from a Birmi... Lamar University Pr MISY 3310 - Access Assignment Total Points: 100 Premiere Products - Data Management...

the following relational algebra questions based on tables S1 and S2 (below) Question 1 What is the output of S1 S2 ? The row identified by sid 22 The rows identified by sid 31 and 58 The row...

uantitative Analysis BA 452 Homework 3 Questions Homework 3 covers the theory and applications in Lessons I-6 and I-7. This document has four parts: Objectives of doing your homework. Assignment of...

This problem refers to the radial keratotomy study data from Problem 12 in Chapter 8. Suppose that we want to compare the average change in refraction for males and females, controlling for baseline...

At the beginning of 2011, Terra Lumber Company purchased a timber tract from Boise Cantor for $3,200,000. After the timber is cleared, the land will have a residual value of $600,000. Roads to enable...

The first shows the desired output and the second my code. I tried to do the same pd . DataFrame... but it's not working for me . I want to display loss and val _ loss in a table. Can you please...

Which statement is right about Digital Advertising. a. It allows companies to use data to target certain groups of people. b. It takes advantage of mediums like mobile apps, websites, search engines,...

A(n) _____ is a person, place, object, event, or idea for which you want to store and process data. a. Attribute b. Entity c. Relationship d. Flat file

Which of the following is not a problem associated with redundancy? a. Prevents orphan records b. Makes updating data more cumbersome and time-consuming c. Can lead to inconsistencies d. Results in...

Explain how redundant data often leads to poorer decision making.

Problem 10-13 Consider the following data for three different companies: ($000 Omitted) Owens Arrow Alpha Net cash provided (used) by: Operating activities $(2,000) $2,700 $(3,000) Investing...

1. An overview of a firm's cost of debt To calculate the after-tax cost of debt, multiply the before-tax cost of debt by Andalusian Limited (AL) can borrow funds at an interest rate of 10.20% for a...

In its 2011 income statement, Jefferson Inc. repeated net income of $1,430 and depreciation expense of $230. On its 2012 income statement, the company reported net income of $2,310 and depreciation...