Search Header Logo

Database Design Quiz Week 2

Authored by Atisang Molapo

Computers

University

Used 3+ times

Database Design Quiz Week 2
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which notation uses rounded corners (soft boxes) for entities in ER diagrams?

Crow’s Foot

Chen’s Notation

Barker’s Notation

UML

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is a mandatory attribute marked with in ER diagrams?

Lowercase "o"

Asterisk (*)

Hash (#)

Exclamation mark (!)

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which of the following is an example of a non-relational database?

MySQL

MongoDB

PostgreSQL

Microsoft SQL Server

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Resolving a many-to-many relationship typically involves:

Deleting one entity

Adding an associative entity

Using abbreviations

Ignoring the relationship

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which component of a relationship indicates whether it is required to exist?

Degree

Optionality

Name

Cardinality

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the purpose of a Unique Identifier (UID)?

To store redundant data

To distinguish one instance from another

To calculate derived values

To name relationships

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which data category includes pre-computed summaries for faster queries?

Fact Data

Summary Data

Reference Data

Metadata

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Microsoft

Continue with Microsoft

or continue with

Facebook

Facebook

Apple

Apple

Others

Others

Already have an account?