Nodejs: Database Design

What tool can we use to visualize the structure and relationships of a database?

• SQL

• ERD

• ARN

• None of the options

What is the full meaning of ERD in the context of designing a database?

• Entity-Relationship Diagram

• Entry-Relationship Diagram

• Entity-Revelation Daigram

• Entropy-Relationship Diagram

Consider this scenario:

A user can have many vehicles.

What type of relationship exist between the user and the vehicle?

• one-to-many

• one-to-one

• many-to-one

• many-to-many

Consider this scenario:

Vehicle can only belong to one user.

What type of relationship exist between the user and the vehicle

• one-to-many

• one-to-one

• many-to-one

• many-to-many

Consider this scenario:

Vehicles can have more than one users

What type of relationship exist between the user and the vehicle

• one-to-one

• one-to-many

• many-to-one

• many-to-many

When we have a many-to-many relationship between two entities, how would you handle the relationship?

• create an intermediary entity that show a one-to-many relationship between the two entities

• create an intermediary entity that show a one-to-one relationship between the two entities

• create an intermediary entity that show a many-to-many relationship between the two entities

• create an intermediary entity that show no relationship between the two entities

In a one-to-many relationship between two table, where should the foreign key be placed?

• In the "one" table

• in the "many" table

• in both tables

• none of the tables

What represents a person, place, thing or concept?

• Entity

• Rows

• Columns

• Data

When defining attributes for an entity, which of these options is required in the attribute?

• index

• data type

• schema

• constraint

Which type of relationship exists when one record in a table is related to many records in another table, but each of those related records can only be related to one specific record in the first table?

• one-to-one

• one-to-many

• many-to-one

• many-to-many