Exam Practice CS2203 - Databases 1

The address of a student can be defined using street, city, state, and zip code. What type of attribute should be used to represent the address of a student?

• a) Single valued attribute

• b) Multi-valued attribute

• c) Derived attribute

• d) Composite attribute

For the relationship represented in the figure below, which of the following is true

• a) An instructor can teach more than one course but does not have to teach any course

• b) An instructor must teach at least one course

• c) A course has to be taught by more than one instructor

• d) A course can be taught by more than one instructor but doesn’t have to be taught by any instructor

In an Entity-Relationship model, which concept is generally used to represent a student?

• a) Entity

• b) attribute

• c) constraint

• d) Relationship set

For the relationship represented in the figure below, which of the following is true?

• a) Each instructor teaches one or more courses

• b) Each instructor has one and only one course

• c) Each course is taught by zero and one instructor

• d) Each course is taught by many instructors

The E-R model is used to build a conceptual model.

• a) True

• b) False

Given only the following part of an E-R diagram, what does the hash mark across the relationship line near the entity in the figure below indicate?

• a) A minimum cardinality of zero

• b) A minimum cardinality of one

• c) A maximum cardinality of one

• d) Both b & c

For the relationship represented in the figure below, which of the following is true?

• a) Each instructor teaches one or more courses

• b) Each instructor has one and only one course

• c) Each course is taught by zero and one instructor

• d) Each course is taught by many instructors

“A student can attend six courses, each with a different instructor. Each instructor has 30 students.” 

What is the type of relationship between students and instructors?

• a) weak

• b) one-to-one

• b) one-to-many

• d) many-to-many

All instances of a given entity set have the same attributes in the E-R Model.

• a) True

• b) False

Given only the following part of an E-R diagram, what does the circle across the relationship line near the entity in the figure below indicate?

• a) A minimum cardinality of zero

• b) A minimum cardinality of one

• c) A maximum cardinality of one

• d) A maximum cardinality of many