COM
Ch14_Logic8e_Solutions

Ch14_Logic8e_Solutions - Programming Logic and Design 8e...

Info icon This preview shows pages 1–4. Sign up to view the full content.

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. variable b. identifier c. principal d. key 2. Which of the following is not a 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

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

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 socialSecNum b. the primary key is clientNumber c. there are four candidate keys d. 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 to extract 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 table can 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, 8e Solutions 14- officeNumber, phoneNumber, daysOfWeekInOffice) . In this example, the relationship is _____. a. one-to-one b. one-to-many c. many-to-many d. impossible to determine
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 4
This is the end of the preview. Sign up to access the rest of the document.
  • Fall '15
  • Relational model, Database normalization, Second normal form, Citizenship Award

{[ snackBarMessage ]}

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