ERD Diagram Scenario based

You are designing an ER diagram for a university database. There are two main entities: "Student" and "Course." Students can enroll in multiple courses, and each course can have multiple students.

What type of relationship exists between Student and Course?

• Many-to-Many relationship.

• One-to-Many relationship.

• Many-to-One relationship.

• One-to-One relationship.

In a university database, student records are stored. Each student is assigned a unique student ID, and they also have a unique email address. However, email addresses can change over time.

What is the candidate key for the "Students" table in this scenario?

• Student ID

• Email Address

• Both Student ID and Email Address

• Neither Student ID nor Email Address

  You are designing a database for an e-commerce platform. Each customer has a unique email address, and you want to ensure that this email address is used as a unique identifier for customer accounts.

Which key should you use?

• Primary Key

• Candidate Key

• Composite Key

• Foreign Key

Based on the diagram, which is the entity?

• STUDENT

• matrix

• address

• age

Consider this scenario:

Vehicles 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

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

For the following two ENTITIES, which is the appropriate relationship:
CUSTOMER / ORDER

• One to One
• One to Many
• Many to Many

If an employee can work at one company a time and the company can have many employees, then the relationship between entities employee and company is considered ____

• 1 to many

• 1 to 1

• many to many

• none of these

The relationship between the entities country and government is _________

• one to many

• one to one

• many to many

• none of these