Databases - Table & Entities

Flat file databases use only one table.

• True
• False

Which of these statements is correct?

• All of these
• Rows in a database table are usually called "records".
• Columns in a database table are usually called "fields".
• Some columns in a database can't be left blank.

Databases keep data in:

• Tables
• Queries
• Forms
• Reports

Tables store data about Entities

• True
• False

Every attribute has a number of associated entities.

• False
• True

Information about an entity is stored in attributes

• True
• False

All tables in a database are connected through relationships.

• False
• True

If one of the entities stored in a database is a magic wands on a shelf, it might have all of these attributes except:

• Supplier's address
• Supplier ID
• Price
• Quantity

The following two attributes from different tables will form a relationship:

• Supplier's ID and Item Supplier
• Quantity purchased and Quantity left
• Item name and supplier's ID

The following is not a valid type of a relationship:

• one-to-all
• one-to-one
• one-to-many
• many-to-many