Week 2 Review Questions.docx - Cynthia Toledo CIS 380 Ch 2&3 Review Chapter 2 Review Questions 1 What is a relation A two-dimensional table-style

Week 2 Review Questions.docx - Cynthia Toledo CIS 380 Ch...

This preview shows page 1 - 3 out of 7 pages.

Cynthia Toledo CIS 380 Ch 2&3 Review Chapter 2 Review Questions 1.What is a relation? 2.What is a relational database? 3.What is an unnormalized relation? Is it a relation according to the definition of the word relation? 4.How is the term attributeused in the relational model? What is a more common name for attribute? 5.Describe the shorthand representation of the structure of a relational database. Illustrate this technique by representing the database for Colonial Adventure Tours shown in Figures 1-15, 16, 1-17, 1-18, and 1-19in Chapter 1 1- . 6.What does it mean to qualify a field name? How would you qualify the Street field in the Client table?When you combine a column name with a table name. Ex. Consultant.ConsltNum 7.What is a primary key? What is the primary key for each table in the Colonial Adventure Tours database shown in Figures 1-15, 1-16, 1-17, 1-18, and 1-19in Chapter 1 ?
Image of page 1
8.How do you include a field in an Access query? 9.How do you indicate criteria in an Access query?Enter the condition in the appropriate column in the query design grid.10.How do you use an AND criterion to combine criteria in an Access query? How do you use an OR criterion to combine criteria?
Image of page 2
Image of page 3

You've reached the end of your free preview.

Want to read all 7 pages?

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture