Database Design Concepts and Notation Quiz

Which of the following best describe a ‘primary key’?

A unique, non-null identifier for a record in a database table
A reference which relates two database tables to one another
The title of a database table to differentiate it from every other table in the database

Which of the following options best describes a ‘foreign key’?

A unique, non-null identifier for a record in a database table
A reference which relates two database tables to one another
The title of a database table to differentiate it from every other table in the database

The following image shows a data entity relationship diagram for a video uploading platform, using crow’s foot notation. Fill in the blanks to describe the relationship shown.

A user can have [one, zero, many] (and only, or) [one, zero, many] video/videos, while a video can have [one, zero, many] (and only, or) (one, zero, many) user/users.

The following image shows a data entity relationship diagram for a video uploading platform, using UML/class notation. Fill in the blanks to describe the relationship shown.

A user can have [one, zero, many] (and only, or) [one, zero, many] video/videos, while a video can have [one, zero, many] (and only, or) (one, zero, many) user/users.

Given the following two data entities for owners and pets, select the most appropriate way to model their relationship.

In the context of dimensional data modelling (aka Kimball data modelling), which of the following statements best describe a dimension?

A data entity which contains descriptive attributes
A data entity which contains numeric measures of 'real world' processes
A data entity which answers contextual questions like "who, what, where, why, when and how"
A data entity that can contain both additive and non-additive measures

Which of the following data entity names would typically be considered dimensions?

Wages
Customer
Product
Sales

In the context of dimensional data modelling (aka Kimball data modelling), which of the following statements best describe a fact?

A data entity which contains descriptive attributes
A data entity which contains numeric measures of 'real world' processes
A data entity which answers contextual questions like "who, what, where, why, when and how"
A data entity that can contain both additive and non-additive measures

Which of the following data entity names would typically be considered facts?

Wages
Customer
Product
Sales

What is a data mart?
What is the purpose of a data mart?
How can it benefit a business?

Give a brief (3-5 sentences) answer discussing the above questions.

To help support the community, why not copy and paste your answer in one of the discussion forum to spark some interesting discussions?

There is no ‘one correct’ answer to this question, you will receive credit for an attempt.

This response will be awarded full points automatically, but it can be reviewed and adjusted after submission.

Bootcamp 1: Business & Design

Participants 8

Database Design Concepts and Notation Quiz

Trent

Quiz Summary

Information

Results

Results

Categories

1. Question

2. Question

3. Question

4. Question

5. Question

6. Question

Hint

7. Question

8. Question

9. Question

10. Question

Responses