94%(36)34 out of 36 people found this document helpful
This preview shows page 1 - 4 out of 25 pages.
Programming Logic and Design, 8eSolutions 14-Programming Logic and Design, 8th EditionChapter 14REVIEW QUESTIONS1.A field or column that uniquely identifies a row in a database table is a(n) _____.a.variableb.identifierc.principald.key2.Which of the following is nota feature of most database management software?3.Before you can enter any data into a database table, you must do all of the following except _____.4.Which of the following is the best key for a table containing a landlord’s rental properties?1
Programming Logic and Design, 8e5.A table’s notation is: tblClients(socialSecNum, lastName, firstName, clientNumber, balanceDue). You know that _____.a.the primary key is socialSecNumb.the primary key is clientNumberc.there are four candidate keysd.there is at least one numeric attribute6.You can extract subsets of data from database tables using a(n) _____.7.A database table has the structure tblPhoneOrders(orderNum,custName,custPhoneNum,itemOrdered,quantity). Which SQL statement could be used toextract all attributes for orders for item AB3333?8.Connecting two database tables based on the value of a column (producing a virtual view of a new table) is a _____ operation.9.Heartland Medical Clinic maintains a database to keep track of patients. One tablecan be described as: tblPatients(patientId, name, address, primaryPhysicianCode). Another table contains physician codes along with other physician data; it is described as tblPhysicians(physicianCode, name, 2
Programming Logic and Design, 8eSolutions 14-officeNumber, phoneNumber, daysOfWeekInOffice). In this example, the relationship is _____.