Ch14_Logic8e_Solutions - Programming Logic and Design 8e Solutions 14-1 Programming Logic and Design 8th Edition Chapter 14 REVIEW QUESTIONS 1 A field

Ch14_Logic8e_Solutions - Programming Logic and Design 8e...

This preview shows page 1 - 4 out of 25 pages.

Programming Logic and Design, 8e Solutions 14- Programming Logic and Design, 8th Edition Chapter 14 REVIEW QUESTIONS 1.A field or column that uniquely identifies a row in a database table is a(n) _____. a.variableb.identifierc.principald.key 2.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
Image of page 1
Programming Logic and Design, 8e Solutions 14- 5.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 attribute 6.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
Image of page 2
Programming Logic and Design, 8eSolutions 14-officeNumber, phoneNumber, daysOfWeekInOffice). In this example, the relationship is _____. a.one-to-oneb.one-to-manyc.many-to-manyd.impossible to determine
Image of page 3
Image of page 4

You've reached the end of your free preview.

Want to read all 25 pages?

  • Fall '15
  • Relational model, Database normalization, Second normal form, Citizenship Award

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors