Write and run the sql statements necessary to create tables


Problem

1. Write and run the SQL statements necessary to create the tables and their referential integrity constraints.

2. Populate the tables with data.

3. Write and run an SQL query to list all occurrences of Adv. Pastels. Include all associated data for each occurrence of the class.

4. Write and run an SQL query to list all students and courses they are registered for. Include, in this order, CustomerNumber, CustomerLastName, CustomerFirstName, Phone, CourseNumber, and AmountPaid.

The response should include a reference list. Double-space, using Times New Roman 12 pnt font, one-inch margins, and APA style of writing and citations.

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: Write and run the sql statements necessary to create tables
Reference No:- TGS02112787

Expected delivery within 24 Hours