Questions from Database Systems

Q: Write the SQL code that will create the table structure for a

Write the SQL code that will create the table structure for a table named EMP_1. This table is a subset of the EMPLOYEE table. The basic EMP_1 table structure is summarized in the table below. (Note...

Q: Using the output shown in Figure P7.29 as your guide

Using the output shown in Figure P7.29 as your guide, generate the listing of customer purchases, including the subtotals for each of the invoice line numbers. (Hint: Modify the query format used to...

Q: Having created the table structure in Problem 1, write the SQL

Having created the table structure in Problem 1, write the SQL code to enter the first two rows for the table shown in Figure P7.2. Figure P7.2 The contents of the EMP_1 table Figure P...

Q: Assuming the data shown in the EMP_1 table have been

Assuming the data shown in the EMP_1 table have been entered, write the SQL code that will list all attributes for a job code of 502. ATTRIBUTE (FIELD) NAME DATA DECLARATION  EMP_NUM CHAR(3)  E...

Q: Write the SQL code that will save the changes made to the

Write the SQL code that will save the changes made to the EMP_1 table. ATTRIBUTE (FIELD) NAME DATA DECLARATION  EMP_NUM CHAR(3)  EMP_LNAME VARCHAR(15)  EMP_FNAME VARCHAR(15)  EMP_INITIAL...

Q: Write the SQL code to change the job code to 501 for

Write the SQL code to change the job code to 501 for the person whose employee number (EMP_NUM) is 107. After you have completed the task, examine the results, and then reset the job code to its origi...

Q: What is the difference between a column constraint and a table constraint

What is the difference between a column constraint and a table constraint?

Q: What are “referential constraint actions”?

What are “referential constraint actions”?

Q: Rewrite the following WHERE clause without the use of the IN special

Rewrite the following WHERE clause without the use of the IN special operator. WHERE V_STATE IN (‘TN’, ‘FL’, ‘GA’)

Q: Explain the difference between an ORDER BY clause and a GROUP BY

Explain the difference between an ORDER BY clause and a GROUP BY clause.