Databases

When building a database for a customer where would you find the key information you need for your design?

In the...

• Entity Relationship Diagram

• Client Brief

• Field Properties

• Tables

The things that you identify from the client brief that are key to measuring how effective your database design has been are called...

• Entities

• Forms

• Success Criteria

• Fields

What is this an example of?

• An Entity Relationship Diagram

• A Table

• Different forms

• A query

This shows a...

• 1:n

  (One to many relationship)

• m:n

  (Many to many relationship)

• 1:1

  (One to one relationship)

Entities have...

• A client brief

• Forms and Queries

• Success criteria

• Attributes and Relationships

Entities and their Attributes are entered into a database as...

• Forms and queries

• Tables and fields

• Relationship Diagrams

• Reports

Queries in a database are used primarily to...

• Retrieve data

• Validate data

• Input data

• Store data

Forms in a database are primarily used to...

• Store data

• Retrieve data

• Validate data

• Input data

Reports are used primarily to...

• Input data

• Validate data

• Display retrieved data

• Query data

Which of these is not a valid search type?

• Single criteria

• Multiple criteria

• Wildcard

• Bubble search