Database Design Quiz

What is the ER model?

• A model for designing databases.

• A programming language.

• A type of computer network.

What are the entities in the system?

• Professor, Course, Student, and Enrollment.

• Teacher, Class, Student, and Payment.

• Department, Subject, Teacher, and ID.

What data does each professor have?

• ID, first name, last name, department, and email.

• ID, first name, last name, date of birth, and department.

• Name, phone number, email, and address.

What is the relationship between professor and course?

• One to many.

• Many to many.

• One to one.

What is the relationship between student and course?

• Many to many.

• One to many.

• One to one.

What is an attribute?

• A characteristic of an entity.

• A type of database.

• A programming command.

What data does each enrollment have?

• ID, course, date, and final grade.

• Student name, course name, year, and credits.

• Professor name, department, semester, and grade.

What is Atomicity?

• A transaction is fully completed or not done at all.

• A process where data can be altered partially.

• A setting for automatic data saving.

What is a one-to-one relationship?

• A record in one table is related to one in another.

• Each record in a table links to many others.

• It links multiple records in each table.

What is the purpose of the ER model at the university?

• To manage data for professors, courses, and students.

• To handle the university’s financial data.

• To create a student schedule automatically.