Database Design Elements

Who is the end user?

• the person who designs the system

• the person who will use the system

• the person who tests the system

• the person who evaluates the final system

The end user requirements should be identified at the start.

• True

• False

This shows what tables are needed in a database and how they are related

• Data Dictionary

• Wireframe

• Entity Relationship Diagram

• Navigation Structure Diagram

Which statement correctly describes what is meant by a data dictionary

• A table containing details of files types used in the database

• A table listing the field headings and associated properties, used in the database

• A table listing the objects created as part of the database

• A table containing data to be input into the database

Which statement correctly defines the term entity?

• A heading given to an item of data in a database

• A single person, object or transaction represented in a database

• A control button represented in a menu in a database

• A name used to save a new report in a database

What must be common between two tables to create a relationship?

• A field name

• Characters
• Files
• Names

Which is the best example of a primary key?

• Driver's License Number
• Pet's name

• Price
• First and Last Name

What is the definition of a Primary Key?

• The first field in a database table

• A field in a table that contains a unique identifier for each record in the table

• A field in a database that can only contain two values

• A field in the database that has the same value for each record

What is the definition of a Foreign Key?

• A field in a table that is written in another language

• A field in a table that links to the World Wide Web

• A field in a table that cannot be edited or accessed by users

• When the primary key field of one table appears in another

How would you define a relational database?

• A database consisting of data relating to families

• An online database

• A database linked to another database

• A database consisting of multiple tables, that are linked using keys