FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 2: Building a Database and Defining Table Relationships

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information. Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information. Using appropriate database design guidelines, answer the following questions. -Based on the information to be included in the database, what is the best way to avoid data redundancy in the database?

A) store data for each field in only one table (excluding the common field)
B) store data for each field in multiple tables (excluding the common field)
C) create a composite primary key (including the common field)
D) change field properties for all fields to require data input

E) A) and B)
F) A) and C)

Correct Answer

verified

Show Answer

Question 32

Multiple Choice

Review LaterAdd Note

Review Later

Which data type allows both positive and negative numbers as field values?

A) Number
B) Date/Time
C) AutoNumber
D) Short Text

E) B) and C)
F) A) and D)

Correct Answer

verified

Show Answer

Question 33

Short Answer

Review LaterAdd Note

The ____________________ data type is not subject to round-off error when calculated, unlike the Number data type with decimal values.

The "one" table in a one-to-many relationship is the ____________________ table.

Performing a(n) ____________________ is the process of relating tables in a database based on a common field.

MATCHING -The term used when the same data is stored in more than one place which can cause inconsistencies in the database.

Predefined display formats for fields with the Date/Time data type may be chosen from the ____ field property.

Formatting Date/Time fields changes only the way data is displayed, not the field ____.

The F6 key toggles the Access table workspace between the Table Design grid and the Field Properties pane.

The ____ property specifies the number of decimal places displayed to the right of the decimal point.

In order to define table relationships, each table being joined must contain a common field.

Which symbols would be used to create a custom date format that would display July 4, 2016 as 7/04/16?

The way field values are stored, displayed, and processed in an Access database is determined by the ____________________.

Which data type would be most logical to use for a field named BillPaid to indicate if an invoice has been paid?

The "many" side of a one-to-many relationship is represented by the ____________________ at the end of the join line.

____________________ values are never allowed by Access in the primary key field.

Syed and Marino Li own a small furniture consignment shop in Atlanta, GA. Syed is designing a database that will allow them to keep track of item information and seller information. Each item is assigned to one seller; however, each seller may be assigned multiple items in the database. The database will contain the following information: item identification number, item description, seller code, condition of item, retail price of item, item quantity, date item received, condition of item, date the item is sold, the final sale price of the item, seller name, seller address, and seller contact information. Using appropriate database design guidelines, answer the following questions. -Based on the information to be included in the database, which of the following possible field names would be the best common field to include in two or more tables?

It is important that data being imported from a text file into Access are separated by a character, such as a comma, which defines the text file as a(n) ____ text file.

Akae plans to develop a database for his small DJ business that will include his music catalog, artists, clients, purchases, equipment, and vendors. Akae has identified that the following information will be included in the database: · artist · song and year · client name · client address · client contact information · vendor · purchases · equipment · equipment inventory and rental -Given the information Akae would like to include in his database, how many tables would be optimal if similar information is grouped into tables?

MATCHING -The Access database view that allows users to define or modify a table structure or field properties in a table.