Welcome to your Grade 11 Information Technology chapter 3
After carefully reading the following 30 questions, choose the correct answer.
1.
What is a collection of related data and its description?
2.
Which type of database contains a logically related set of tables?
3.
In a relational database table, what are the rows called?
4.
What are the columns in a database table called?
5.
Which field in a table has a unique value for each record?
6.
What attribute in a table matches the primary key of another related table?
7.
Which software is used to implement a relational database?
8.
What is a graphical tool used for representing a logical data model?
9.
In an ERD, what is used to represent an entity?
10.
In an ERD, what shape represents an attribute?
11.
Which shape in an ERD represents a relationship?
12.
What is a database object in Microsoft Access used to search for and compile data?
13.
Which Microsoft Access object is a container for database objects like tables and queries?
14.
What defines the type of data a field can store, such as text or number?
15.
Which relationship exists when a record in Table A is associated with many records in Table B?
16.
Which language is used to write statements for retrieving data in MS Access?
17.
What view in MS Access is used to enter data into a table?
18.
What must be established between tables to retrieve data from two or more tables through a query?
19.
Which tool in MS Access helps create a query step-by-step?
20.
By adding what to a query design is it possible to retrieve specific data from a table?
21.
In a relational data model, entities are represented as:
22.
Which of the following is NOT a valid data type name for a field in MS Access?
23.
What is used as a navigational link to retrieve data from related tables?
24.
Which part of the ERD represents properties of an entity?
25.
What is the term for a uniquely identifiable thing about which data is stored?
26.
Which Access window is used to define the structure of a table?
27.
How many fields can a primary key consist of?
28.
Which of the following is an example of an entity mentioned in the textbook?
29.
In MS Access, where do you select fields to include in your query?
30.
What is the first step to create a query using Query Design?
