Question: Use the relation schemas below to write a SQL statement to create Item table, specify primary key and foreign keys as necessary. ListPrice and UnitCost

Use the relation schemas below to write a SQL statement to create Item table, specify primary key and foreign keys as necessary. ListPrice and UnitCost cannot be a negative number or 0. Name cannot be null. ListPrice is always higher than UnitCost. For the foreign key Supplier (references Suppplier(SuppID)), set CASCADE on update and SET NULL on delete.

Category(CategoryID, Name, Descn)

Product(ProductID, CategoryID FK ref Category(CategoryID), Name Descn, Image)

Item(ItemID, ProductID FK ref Prodcut(ProductID), ListPrice, UnitCost, Supplier FK ref Supplier(SuppID), status, name, image)

Supplier(SuppID, name, status, addr1, addr2, city, state, zip, phone)

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!

QUESTION 1 (a) Describe the main characteristics of the database approach and contrast it with the file-based approach. (b) The following records are saved in spreadsheet (see Figure 1). [4 marks]...

Write an SQL statement to create a table room with the attributes (roomNo,hotelNo,hotelName,address,city,type,price,floor,guestNo), specify that the attribute roomNo cannot be null, the attributes...

** Please don't use hand writing and don't copy and paste *** I want unique answer .. write the number of question .. Thank you Q1: You are in charge of creating a small database for a store that...

Write the DDL statements to create the physical database in PostgreSQL for the EER in question 3. Once created, write the SQL statement to insert the following data. You may make up data for any...

Group Project - Part III Kim's Flower Inc. Purchasing (Expenditure) Cycle Requirements: The final part of the project requires your team to implement the logical data model in MS Access. Please read...

The Review Questions 7.3 to 7.40, from the Kroenke book starting page 357, have been duplicated below, to assist in the completion of this Lab Assignment. RQ Questions 7.1, 7.2 and 7.3 are answered...

I am working on my final project in an SQL class using MYSQL. I am working my way through it but it is going slow so I think that I may need a little bit of help to finish in time. If I could get a...

Introduction to databases FALL 20 Assignment III Based on the database schema that was used in assignment I, answer the following questions: 1. Write the business rules that are reflected by the...

Assuming you are a production manager in a semiconductor manufacturing company in Penang. Due to the ease of the COVID-19 movement order, the border is now open for foreign workers to work in...

As a subject matter expert (SME), you will be asked to make presentations for organizations, institutions, and your community. These accountants will be joining your audit firm in the forensic...

What is the purpose of determining the value of the home to be insured on a Homeowners policy?

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

The manager must actively communicate with the job sharers and accept the fact that they might not be immediately available for consultation.

A job-sharing agreement should be written that clearly spells out performance expectations, work schedules for each employee, and any other management concerns.

Meeting schedules, work assignments, and vacation schedules need to be carefully coordinated. Job sharers should plan overlap times during which to meet and communicate.