Questions from Database Systems

Q: Write the SQL code that will produce a listing for the data

Write the SQL code that will produce a listing for the data in the EMP_2 table in ascending order by the bonus percentage. Figure P7.9 the contents of the EMP_2 table

Q: Write the query to show the invoice number, the customer number

Write the query to show the invoice number, the customer number, the customer name, the invoice date, and the invoice amount for all customers with a customer balance of $1,000 or more. (Figure P8.7)...

Q: Write the query that will show the invoice number, the invoice

Write the query that will show the invoice number, the invoice amount, the average invoice amount, and the difference between the average invoice amount and the actual invoice amount. (Figure P8.8) FI...

Q: Write the query that will write Oracle sequences to produce automatic customer

Write the query that will write Oracle sequences to produce automatic customer number and invoice number values. Start the customer numbers at 1000 and the invoice numbers at 5000.

Q: The ABC Car Service & Repair Centers are owned by the SILENT

The ABC Car Service & Repair Centers are owned by the SILENT car dealer; ABC services and repairs only SILENT cars. Three ABC Car Service & Repair Centers provide service and repair for the entire sta...

Q: Suppose you have been asked to create an information system for a

Suppose you have been asked to create an information system for a manufacturing plant that produces nuts and bolts of many shapes, sizes, and functions. What questions would you ask, and how would the...

Q: Suppose you perform the same functions Noted in Problem 2 for a

Suppose you perform the same functions Noted in Problem 2 for a larger warehousing operation. How are the two sets of procedures similar? How and why are they different?

Q: Using the same procedures and concepts employed in Problem 1, how

Using the same procedures and concepts employed in Problem 1, how would you create an information system for the Tiny College example in Chapter 4?

Q: Write the proper sequence of activities in the design of a video

Write the proper sequence of activities in the design of a video rental database. (The initial ERD was shown in Figure 9.9.) The design must support all rental activities, customer payment tracking, a...

Q: In a construction company, a new system has been in place

In a construction company, a new system has been in place for a few months and now there is a list of possible changes/updates that need to be done. For each of the changes/updates, specify what type...