Question
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started