Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

E. Create database named QACS in your DBMS. F. Create a folder in your My Documents folder to save and store *.sql scripts containing the

E. Create database named QACS in your DBMS.

F. Create a folder in your My Documents folder to save and store *.sql scripts containing the SQL statements that you are asked to create in the remaining questions in this section.

For the SQL Server Management Studio, create a folder named QACS-Database in the Projects folder structure in your My Documents folder.

In the Oracle SQL Developer folder structure in your My Documents folder, create a folder named QACS-Database.

For the SQL Workbench, create a folder named QACS-Database in the Schemas folder in your My Documents folder.

G. Write SQL CREATE TABLE statements for each of these tables. Write CREATE TABLE statements for each of the tables using your answers to parts A-D, as necessary. Set the surrogate key values as shown above. Use FOREIGN KEY constraints to create appropriate referential integrity constraints. Set UPDATE and DELETE behavior in accordance with your referential integrity action design. Run these statements to create the QACS tables.

H. Explain how you would enforce the data constraint that SALE_ITEM.UnitPrice be equal to ITEM.ItemPrice, where SALE_ITEM.ItemID = ITEM.ItemID.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting

Authors: Ronald W Hilton

8th Edition

0073526924, 9780073526928

More Books

Students also viewed these Accounting questions

Question

What reward will you give yourself when you achieve this?

Answered: 1 week ago