Critical Thinking QuestionsCase 1-2Now that Phil has created the tables and determined the primary and foreign keys, he needs to determine the data types for the fields in each table. What data type should Phil use for the Hourly Pay Rate field? Why?
What will be an ideal response?
Phil should use the Currency data type because monetary values will be stored in the field.
You might also like to view...
You should avoid using lossy compression for any file that you want to keep as the start file for further editing because _____.
What will be an ideal response?
(Airline Reservations System) A small airline has just purchased a computer for its new au- tomated reservations system. You have been asked to program the new system. You are to write a program to assign seats on each flight of the airline’s only plane (capacity: 10 seats). Your program should display the following menu of alternatives—Please type 1 for "First Class" and Please type 2 for "Economy". If the person types 1, your program should assign a seat in the first class section (seats 1-5). If the person types 2, your program should assign a seat in the economy section (seats 6-10). Your program should print a boarding pass indicating the person’s seat number and whether it is in the first class or economy section of the plane. Use a one-dimensional array to represent the seating ch
What will be an ideal response?
Case-Based Critical Thinking Questions
? Case 1: LuvUrPetThe database for a pet supply company includes the following table, named tblCollar, that contains product data for pet collars. The ItemDesc and Color fields contain text. The ItemNum, Price, and Quantity fields contain numbers. ItemNum ItemDesc Color Price Quantity 2358 leather studded collar black 30.00 35 2693 leather collar brown 25.00 25 3547 striped collar red 20.00 75 3855 striped collar blue 15.00 42 3764 striped collar green 15.00 48 5782 solid collar pink 12.00 36 5785 solid collar red 12.00 10 5787 solid collar blue 10.00 15 Which of the following clauses would allow a user to select the records for collars with a cost of between 10 and 20? A. WHERE Price >= @Price1 AND Price <= @Price2 B. WHERE @Price1 < Query < @Price2 C. WHERE Price <= 10 AND Price >= 20 D. WHERE Price LIKE 10 AND Price LIKE 20
Which of the installation method does not require any user input?
a. Restore/Refresh b. Multiboot c. Parted Installation d. In-place Upgrade e. Unattended Installation