Question: 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

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, and TOY. Ensure that the ItemNum field is the primary key and that the ItemNum field in the OrderLine table is a foreign key that must match the primary key of the Item table.

Step by Step Solution

★★★★★

3.38 Rating (167 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

To create the necessary integrity constraints on the Item table and establish a relationship with th... 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 DDBMS must ensure that no two sites create a database object with the same name. One solution to this problem is to create a central name server. What are the disadvantages with this approach?...

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...

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...

SHIPMENT_LINE SHIP_ID INV_ID SL_QUANTITY SL_DATE_RECEIVED Number Number Number Date/ Time 25 09/10/2006 2 25 09/10/2006 2 25 5 200 6 200 7 200 12 100 08/15/2006 13 100 08/25/2006 23 50 08/15/2006 24...

MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and Arizona. MovinOn provides a truck, driver, and one or more moving assistants to move residential...

PLEASE ONLY NEED THE SQL AND THE TABLES FOR THIS WOULD TRULY APPRECIATE UNDERSTANDING THIS! MovinOn Inc. is a moving company that provides moving and storage services in California, Nevada, and...

I need a 10 page paper for my MIS class. Please do not copy and paste as my school is getting stricter on plagiarism. I have attached the assignment and the sample \fData Analytic Thinking 1 Data...

please help me to find the answer for part 1, part3 and part4 Queensland University of Technology QUT Business School School of Accountancy AYB 339 Accountancy Capstone Integrated Case Study Semester...

Individual Final Project Create A Database System Purpose: To demonstrate the ability to propose, implement, and query the database. Problem: MovinOn Inc. is a moving company that provides moving and...

Triple-F Health Club (Family, Fitness, and Fun) offers tennis, swimming, and other physical fitness facilities to its members. There are four of these clubs in the metropolitan area. Each club has...

A W 10 x 60 wide-flange beams is subjected to a bending moment M of such magnitude that the flanges yield but the web remains linearly elastic. (a) Calculate the magnitude of the moment M if the...

When records were first kept ) = ( 0 , the population of a rural town was 3 4 0 people. During the following years, the population grew at a rate of P ' ( t ) = 3 0 ( 1 t 2 ) . a . What is the...

Consider the following policy. A Net Single Premium (NSP) is to pay for a whole life insurance policy to be issued to a person of age x, which provides $10,000 of insurance for the first 20 years,...

Q.9 Find ix usim mesh malyus Fig 10 Fig-10 4V 3ix 34 To Fig-1o 10 Use mesh analysis lo delermine Ihe branch tuorests as shoun im nlw im Fig-11. 10i2 Y 13 Z10 12 5v JOV

theta means temperature 2) Using the data below, use a mathematical software to make an Arrhenius plot and determine the activation energy 01C 565 728 757 780 kI s-1 1.10 x 10-3 0.380 0.871 1.67...

(Click on the following icon , in order to copy its contents into a spreadsheet.) Russia's Balance of Payments Assumptions (millions of US$) 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 A....

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 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...

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...

i need help with this assignment and build a table in excel or apex please send a photo of the whole chart included for this work Project Scenario: I'm the owner of a small online media rentals...