MIS 3353 Final

E

Fred's Slow Mail Order Company sells stuff through the mail. When customers want to buy something, they call a salesperson and place the order. That sales person records the order. At the end of each week, a sales supervisor reviews all the week's sales and approves them (or rejects them). Following approval, all orders are shipped out the next Tuesday. Assuming that all employees involved in the process are represented by records in the Employee table and that sales orders are recorded (and approval/rejection noted) in the SalesOrder entity, what would the cardinality be on the Employee side of the relationship with SalesOrder that represents order approval? A. One to many B. Zero to one C. Zero to many D. Many to many E. One and only one

A

Given the Following ERD, what would probably be the best foreign key constraint for the bird relation? A. Foreign Key HouseID references House Null Allowed On Delete Set Null B. Foreign Key HouseID references House Not Null On Delete Restrict C. No foreign key constraint applicable for the Bird relation D. Foreign Key HouseID references House Null Allowed On Delete Cascade E. Foreign Key BirdID references Bird Not Null On Delete Restrict

E

Given the table below (named Results_T), what would be the output of the following query? SELECT State, COUNT(UserID) FROM Results_T WHERE State IN (59, 64) GROUP BY State; A. 4 B. 5 C. 59, 4 D. 9 E. Row 1:59, 4 Row 2:64, 1

E

If you were writing a query and wanted to show data for all columns returned in the query, which of the following could you use as your SELECT clause? A. SELECT DISTINCT ROW B. SELECT ALL COLUMNS C. SELECT ALL D. SELECT E. SELECT *

C

In which case would you identify a field as an index field when creating a data dictionary? A. The field can be predicted by another non-key field. B. The field conforms to the Law of Optimization as discussed in class. C. The field is often part of the WHERE statement in SQL queries. D. The field is rarely referenced in any reports. E. The field can be used as part of an aggregate function.

B

Type of accounts receivable system that permits a customer payment on an account balance is called a(n) __________ system. A. Closed Invoice B. Balance-forward C. None of the above D. Circular billing E. Open Invoice

D

Which of the following documents is created by a manager who recognizes the need to stock up on inventory of a certain raw material? A. Bill of Materials B. Move Ticket C. Vendor Invoice D. Purchase Requisition E. Raw Material Bill of Materials

A

Which of the following would be necessary (though perhaps not sufficient) to bring the following relation, called T_Bird, into 3NF (where * = PK, † = FK)? A. Create two separate tables by splitting HouseID and HouseSize into a separate table, but retaining HouseID as a foreign key in T_Bird. B. Change some values of HouseID to remove duplication of data, then move the HouseColor column into a reference table. C. Convert both BirdID and HouseID to foreign keys, then add a new primary key. D. Create two separate tables by splitting HouseID and HouseSize into a separate table, adding BirdID as a foreign key in that table. E. Create a reference table for HouseSize with primary key SizeID, then include SizeID as a foreign key in T_Bird.