Question: Write and run the SQL statements necessary to create the tables and their referential integrity constraints. For the database solutions for the Review Questions about

Write and run the SQL statements necessary to create the tables and their referential integrity constraints.
  • For the database solutions for the Review Questions about the Art-Course-Database, see the list, data and database files supplied and use:
  • Microsoft Access:
  • DBC-e07-Art-Course-Database-CH03-AppE.accdb
  • SQL Server 2014 Express Edition:
  • DBC-e07-MSSQL-Art-Course-Database-Create-Tables.sql
  • DBC-e07-MSSQL-Art-Course-Database-Insert-Data.sql
  • DBC-e07-MSSQL-Art-Course-Database-SQL-Queries-CH03.sql
  • NOTE: Create a database diagram for the database
  • Oracle Database 11g Release 2:
  • DBC-e07-ODB-Art-Course-Database-Create-Tables.sql
  • DBC-e07-ODB-Art-Course-Database-Insert-Data.sql
  • DBC-e07-ODB-Art-Course-Database-SQL-Queries-CH03.sql
  • MySQL 5.6:
  • DBC-e07-MySQL-Art-Course-Database-Create-Tables.sql
  • DBC-e07- MySQL -Art-Course-Database-Insert-Data.sql
  • DBC-e07- MySQL -Art-Course-Database-SQL-Queries-CH03.sql

Step by Step Solution

★★★★★

3.55 Rating (173 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Assumptions CustomerNumber and CourseNumber are surrogate keys starting at 1 and incrementing by 1 For Microsoft Access CREATETABLE CUSTOMER CustomerNumber Int NOT NULL CustomerLastName Char25 NOT NUL... View full answer

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 Database Concepts Questions!

Q:

Suppose that tables T1 and T2 have a 1:N relationship, with T2 as the child. Show the SQL statements necessary to remove table T1. Make your own assumptions about the names of keys and foreign keys.

Q:

Not all versions of this database include referential integrity constraints for all foreign keys. Use whatever commands are available for the RDBMS you are using, investigate if any referential...

Q:

Using the tables in your answer to Review Question 8.44, show the SQL statements necessary to change the relationship back to 1:N. Assume that the first row in the qualifying rows of the intersection...

Q:

The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. CUSTOMER (CustomerNumber, CustomerLastName,...

Q:

the question is listed in proper order The following is a set of tables for the Art Course database shown in Figure 1- 12. For the data for these tables, use the data shown in Figure 1-12. CUSTOMER...

Q:

The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. CUSTOMER (CustomerNumber, CustomerLastName,...

Q:

1. Grading Database Expansion: Expand on the grading database from prior exercises. Construct and execute an SQL query that calculates your cumulative grade in this course as of the present date....

Q:

Can someone please help me with this assignment! Im so lost on how to do it. Please explain on how you get the answers to this. Thank you! I need answers from question 3.1 to 3.5 Chapter 3 Exercise...

Q:

for the SQL statements you will create in the exercises that follow. Run the SQL that you create in your personal database in the AWS SQL Server. To do this work you will need to sign on to SQL...

Q:

The following is a set of tables for the Art Course database shown in Figure 1-10. For the data for these tables, use the data shown in Figure 1-10. CUSTOMER (CustomerNumber, CustomerLastName,...

Q:

Let S be the set of all ordered pairs of real numbers. Define scalar multiplication and addition on 5 by (x1, x2) = (x1, x1, x2) (x1, x2) (y1, y2) = (x1 + y1, 0) We use the symbol to denote the...

Q:

Briefly describe and how it is used.

Q:

P3.3 (LO 2, 3, 4) (Income Statement, Retained Earnings, Periodic Inventory) Presented below is the trial balance of Thompson Ltd. at December 31, 2025. Thompson Ltd. Trial Balance December 31, 2025...

Q:

Javier recently graduated and started his career with DNL Inc. DNL provides a defined benefit plan to all employees. According to the terms of the plan, for each full year of service working for the...

Q:

Describe the advantages and disadvantages of application-provided security. AppendixLO1

Q:

Explain how a database could be recovered via reprocessing. Why is this generally not feasible? AppendixLO1

Q:

Define the terms rollback and rollforward. AppendixLO1

Q:

Future value with perlodic rates. Denise has her heart set on being is millionaire. She decides that at the end of every yoac, the will put away $4,600 into her 7 want to be a millonare account" her...

Q:

7% 11.00 $20,000.00 7 3 Yield to maturity (Expected/Current) 4 Number of years to Future Liability 5 Future Liability 6 7 8 9 Coupon rate 10 Maturity (Years) 11 Face value 12 13 14 15 Bond 1 5.00% 12...

Q:

1. Campus Package Delivery (CPD) provides transportation services in and around Paradise. Its profits have been declining, and management is planning to add a package express service that is expected...