10 CT Analysing Data Wk7 PostQuiz

When modelling a Student entity, which of the following is an attribute?

• Enrolment

• Course

• Date of Birth

• Registration event

In an event-based model, “Payment Received” is best classified as a(n):

• Entity

• Attribute

• Event

• Relationship

In a relational database, the link between Customer and Order tables is usually implemented with:

• Identical primary keys in both tables

• A foreign key in Order referencing Customer

• A lookup list in Customer

• A composite key of Product attributes

“One department employs many employees” exemplifies which cardinality?

• 1:1

• 1:Many

• Many:Many

• Recursive

A spreadsheet is more usable than a database when you need to:

• Perform multi-table joins

• Create a quick pivot chart on one table

• Enforce referential integrity

• Handle millions of rows

A core usability advantage of a relational DB over a spreadsheet is its ability to:

• Spell-check automatically

• Visualise data instantly

• Enforce data types and relationships

• Edit multiple cells at once

Which SQL statement returns all distinct customer regions from Sales?

• SELECT UNIQUE region FROM Sales;

• SELECT DISTINCT region FROM Sales;

• SELECT region UNIQUE FROM Sales;

• SELECT region FROM Sales DISTINCT;

Grouping sales by month and region in a report mainly supports:

• Backup

• Validation

• Data summarisation

• Data entry

Producing several interface prototypes during design allows you to:

• Skip user testing

• Guarantee lower cost

• Evaluate options against usability requirements

• Omit documentation

The best criterion for choosing a preferred database design is:

• Fewer tables

• Meets functional and performance requirements

• Prettiest ER diagram

• Most sample data entered