100%(5)5 out of 5 people found this document helpful
This preview shows page 1 - 3 out of 7 pages.
Cynthia ToledoCIS 380Ch 2&3 ReviewChapter 2 Review Questions1.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 11-.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.ConsltNum7.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?
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?