Exam 2: Building a Database and Defining Table Relationships

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?

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

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

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

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

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

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

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?

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

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

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

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

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

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

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.

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

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

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?

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

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