N5 Database Design

What does the term 'entity' describe in database design?

• A Table

• A field

• A record

• A feeling

In database design, what do entities become during implementation?

• Tables

• Chairs

• Books

• Windows

What are attributes in the context of an entity?

• Specific characteristics of an entity

• A type of animal

• A kind of food

• A type of weather

Which of the following is an example of an attribute for a country?

• Name

• Color

• Taste

• Sound

Which of the following is a type of field used in databases?

• Text

• Animal

• Planet

• Color

What type of field would you use for storing a phone number in a database?

• Text

• Number

• Currency

• Date/Time

Which field type is used for storing money values in a database?

• Currency

• Hyperlink

• Yes/No

• Calculated

Which field type allows you to store a link to a website?

• Hyperlink

• Number

• Date/Time

• OLE Object - Graphic

What does a primary key do in a table?

• Identifies a unique field

• Connects two tables

• Stores data

• Deletes data

What is a foreign key used for?

• To delete a table

• To connect two tables

• To create a new table

• To sort data