Download MIS 3353 Final Exam Review Newest 2025. Questions & Correct Verified Answers. Graded A and more Exams Computer Science in PDF only on Docsity!
MIS 3353 Final Exam Review Newest
2025. Questions & Correct Verified
Answers. Graded A
A "primary key" is... – ANS Required for each record. A company includes information about its customers in a database table called Customer. Each line within this table includes a customer's name, phone number, address, and date of birth. These lines are called... ` - ANS Records A relation has only one value in its primary key, is fully atomic, and no non- key values predict other non-key values. What normal form is this relation in? – ANS 3NF A relation includes columns that are not fully atomic and a transitive dependency, but no partial functional dependencies. What normal form is it in? - ANS0NF An attribute for which an instance's value can only be one or zero is called a(n)... - ANSBinary Attribute Assuming no fields/keys are misnamed, which of the following multiple- table queries would you expect to run without errors? - ANSSELECT Mountain.GPSLat, Mountain.GPSLon, Location.StateName FROM Mountain, Location
WHERE Mountain.LocID = Location.LocID ORDER BY Location.LocID; Assuming that the table and fields referenced are valid, which of the following queries have appropriate syntax and would work without error? - ANSSELECT PlayerName, Position, Height FROM Roster WHERE Height > 63 ORDER BY Position; Choose the best answer. A report that details, in 30-day increments, the outstanding payments owed to a company is... - ANSAn output. Consider the Singer table below. In which field is there a data duplication issue that should probably be corrected through normalization? (Primary key denoted with , foreign key denoted with †.) SingerID SingerName VoiceType DOB Weight 1 Erma Peterson Soprano 5/15/1990 145 2 Johann Götterfunk Baritone 4/15/1975 145 3 Janet Smith Soprano 5/4/1990 119 4 Esperanza Trujillo Mezzo-Soprano 12/28/1970 137 5 Johann Fujimori Tenor 8/1/1983 225 6 Evan Gatuzzo Baritone 11/28/1969 215 - ANSVoiceType
SELECT ManufacturerName AS Manufacturer, AVG(Price) AS Average_Price FROM SimplifiedSales - ANSGROUP BY ManufacturerName Given the following two tables (Product, Manufacturer), which one of the following is an example of a foreign key? Product ProductID MfrID Name Price Qty 5006 2 Ball Peen Hammer 6.99 47 5007 1 5-lb. Mallet 9.99 11 5009 2 10-lb. Mallet 11.49 6 Manufacturer MfrID MfrName 1 Arcturus Tools 2 Nemesis Manufacturing Supply - ANSThe MfrID field in the Product table. In a company's database, a given table... - ANSCan include millions of records. In the default revenue cycle ERD, why are there three different relationships between Employee and ShipmentOut? - ANSThe three lines enables the "segregation of duties" among the picking, packing, and shipping activities.
In the relationship between and ShipmentOut, why is the one-side cardinality optional-one rather than mandatory-one? - ANSThis allows a sales order to exist without it having been shipped yet. Once data within a database are normalized... - ANSFields are atomic and there are no data duplication issues. Recording each customer's assigned credit limit in the database... - ANSIs a form of control. The best aggregate function clause to use to determine the total amount each customer spent on shoes would be the following: - ANSSUM(ListPrice*Quantity) Threat exposure... - ANSReflects a combination of both the magnitude and probability of a threat. Under the _____ _____ method of invoicing, all orders delivered within a given month are invoiced on a single invoice at the end of the month. - ANSbalance forward UPS, FedEx, and the US Postal Service would most reasonably be... - ANSInstances in the Carrier entity. Using a database that includes information about every opera ever written, I want to write a query that displays information only about those operas
Which of the following describes a case of a partial functional dependency?
- ANSIn an associative entity with a composite primary key, one or more attributes can be predicted by just one part of the primary key. Which of the following describes a case where there is an "atomicity problem" that could be solved through normalization? - ANSA column in the table can be further broken down into meaningful parts. Which of the following is not a clause in a SELECT query? - ANSSORT BY Which of the following is true regarding inputs, processes, and outputs? - ANSA vendor's invoice is an input, a SQL query is a process, and a sales invoice is an output. Which of the following most clearly describes an example of a transitive dependency? - ANSA foreign key in a table predicts the value of another foreign key in the same table. Which of the following negative outcomes can result from a lack of atomicity? - ANSMay not be able to SORT BY a meaningful data point (e.g., a last name). Which of the following statements is true regarding normal forms? - ANS3NF is more normalized than 2NF, since 3NF should have fewer data duplication issues.
Which of the following terms represents a customer receiving a 5% discount if paying within 12 days of receiving an invoice, while invoices are considered due within 80 days of receipt? - ANS5/12Net Which of the following WHERE clauses would include only those records from the Customer table where the customer's last name (the LastName field) starts with Y and the customer's birthday (DOB field) falls some time after 1994? - ANSWHERE LastName LIKE 'Y%' AND DOB > '1994-12-31' Which of the following WHERE clauses would include only those records in the output for which the value of UniformNumber is 1, 3, 5, or 7? - ANSWHERE UniformNumber IN (1, 3, 5, 7) Which of the following WHERE clauses would include only those records in the output where the value in the Destination field is something OTHER than Norman? - ANSWHERE Destination <> 'Norman' Which of the following would be considered a "threat" to an organization? (Mark any/all that apply.) - ANSMeteor striking the production facility Paying the same invoice multiple times Inconsistent quality of manufactured products Which of the following, based strictly on syntax, would NOT run correctly in SQL Server? (Select any/all that apply.) - ANSSELECT V.VesselID, T.TripID, T.Destination, T.Duration
