Week1 - Data Modeling, Entity Relationship Model / Explore

Database Design and Data Modeling Questions

A single set of related data values is referred to as

(b) record

Data Models in DBMS are classified into ______ categories.

(b) 4

A ________ in a table represents a relationship among a set of values.

(c) row

Form of data model which focuses concepts in same way as data stored in computer system is classified as

(a) low level data models

Collection of all concepts that must be used to describe database structure is called

(c) database model

Which of the following decisions would be part of Physical Database Design?

(b) An index file will be created on the last name of students in the Student table

One course is taught by only one instructor. But one instructor teaches many courses. Hence the cardinality between course and instructor is

(d) Many-to-One

One department has multiple instructors. But instructor belongs to only one department. Hence the cardinality between department and instructor is

(b) One-to-Many

A relational database consists of a collection of

(a) tables

First step in designing high level conceptual data model is

(d) requirement analysis

Here we are going to design an Entity Relationship (ER) model for a college database. Say we have the following statements.

• A college contains many departments
• Each department can offer any number of courses
• Many instructors can work in a department
• An instructor can work only in one department
• For each department there is a Head
• An instructor can be head of only one department
• Each instructor can take any number of courses
• A course can be taken by only one instructor
• A student can enroll for any number of courses
• Each course can have any number of students

From the statements given, the entities are

(b) Department Course Instructor Student

Entity Relationship Diagrams are output from the following phase of Database Development:

(b) Conceptual Data Modeling

One course can be enrolled by many students and one student can enroll for many courses. Hence the cardinality between course and student is

(c) Many-to-Many

One department offers many courses. But one particular course can be offered by only one department. Hence the cardinality between department and course is

(b) One-to-Many Relationship

One department has multiple instructors. But instructor belongs to only one department. Hence the cardinality between department and instructor is

(b) One-to-Many