module-2

Open Ended

How do you think applying relational algebra can help in managing and analyzing data within a database system?

Multiple Choice

Which of the following best describes the significance of the relational database model in modern data management?

• It allows for efficient organization and retrieval of data using tables and relationships.

• It is primarily used for graphical data representation.

• It is only suitable for small datasets.

• It eliminates the need for data security measures.

Multiple Choice

Which of the following best describes a relational database?

• A collection of tables, each storing a different entity

• A single table storing all information

• A collection of unrelated data files

• A set of spreadsheets with no defined relationships

Open Ended

Explain how a one-to-many relationship between clients and projects is implemented in a relational database.

Multiple Select

Which of the following are true about a relation in a relational database?

• Each row is distinct

• The order of columns is important

• Each entry in the table can have multiple values

• All values in a column must match the column name

Open Ended

What is the purpose of qualifying column names with table names in a relational database?

Multiple Choice

Which column serves as the primary key in the Clients table?

• ClientID

• ClientName

• Street

• Zip

Multiple Choice

Which field serves as the primary key in the Clients table, and why is it considered the primary key?

• ClientName, because it is unique for each client

• Street, because it is always different

• ClientID, because it uniquely identifies each row

• Zip, because it is a number

Multiple Choice

Based on the JC Consulting database structure, which tables have their primary keys underlined, and what does this representation signify?

• All tables have their primary keys underlined, which signifies the unique identifier for each table.

• Only the Employees and Clients tables have underlined keys, which signifies the most important columns.

• No tables have underlined keys; it is just for formatting.

• Only the Projects table has an underlined key, which signifies a foreign key.

Open Ended

Explain the difference between a primary key and a foreign key using the Clients and Projects tables as examples.

Multiple Choice

In the context of Query-By-Example (QBE), what is the purpose of the design grid in the lower pane of the window?

• It displays the results of the query.

• It is used to specify which fields to include in the query results, sort order, criteria, and other instructions.

• It lists all available tables in the database.

• It shows the relationships between tables.

Open Ended

Describe the steps involved in adding a table to a query using Query Design View in Access.

Multiple Choice

In the context of queries, what happens when you run a query in Access?

• It creates a copy of the data

• It modifies the original data

• It does not create a copy of the data

• It deletes the original data

Multiple Choice

Which two query views are commonly used in this module for creating simple queries in Access?

• Datasheet View and Design View

• Form View and Report View

• Table View and SQL View

• PivotTable View and Layout View

Multiple Select

Which of the following are comparison operators that can be used in query criteria?

• =

• >

• <

• >=

Open Ended

Explain the difference between AND and OR criteria when creating compound conditions in a query. Provide an example of when you would use each.

Open Ended

What is a computed field, and why is it beneficial to calculate values such as discounts or taxes using computed fields rather than entering them manually?

Multiple Choice

Which of the following statements about using field names in expressions in Access is correct?

• Field names must always be enclosed in square brackets, even if they do not contain spaces.

• Field names with spaces require square brackets, but it is a good habit to use them for all field names.

• You should never use square brackets in Access expressions.

• Square brackets are only used for numeric fields.

Open Ended

Explain the process of creating a computed field in Access and how the results are displayed.

Multiple Choice

Which of the following aggregate functions returns the minimum field value in a group of records?

• Avg

• Max

• Min

• Sum

Multiple Select

Select all the correct statements about criteria in Access queries.

• Date criteria is surrounded by # symbols.

• Text criteria is surrounded by quotation marks.

• You cannot add criteria to the query grid for grouping queries.

• Access does not automatically add # symbols around date criteria.

Open Ended

Describe how specifying a sort order in Access can affect the output of a query and why it might be important to include a secondary sort field.

Multiple Choice

When creating queries that select data from more than one table, why is it recommended to define relationships in the Relationships window ahead of time?

• Because it allows queries to automatically join related tables, saving time during query creation.

• Because it ensures that each query can only use a single table at once.

• Because it permanently locks the structure of the database, preventing further changes.

• Because it automatically removes redundant data across all queries.

Multiple Choice

Which of the following best describes the purpose of an update query in a database?

• It permanently deletes all records that meet certain criteria.

• It makes a specified change to all records that satisfy the query criteria.

• It allows you to undo changes made during a batch update process.

• It only retrieves data from multiple tables without making changes.

Multiple Choice

What happens if you run a delete query without specifying any criteria?

• Only the first record in the table is deleted.

• The query returns an error and does not run.

• All records in the table are permanently deleted.

• The database creates a backup before deleting records.

Multiple Choice

What is the primary purpose of a make-table query in a database?

• To permanently delete records that meet specific criteria.

• To update multiple records at once in a batch process.

• To create a new table as a copy of the data selected by the query.

• To automatically back up the entire database.

Open Ended

Reflecting on the learning objectives, which topic do you feel most confident about, and which one would you like to explore further?

Multiple Choice

Which of the following is NOT a learning objective for this module?

• Describe the relational database model

• Explain Query-By-Example (QBE)

• Create a new programming language

• Apply relational algebra