Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the ERD below. Which of the following statement is / are true about th ERD? Select all that applies: a ) An INSTRUCTOR may

Consider the ERD below. Which of the following statement is/are true about th ERD? Select all that applies:
a) An INSTRUCTOR may be a DEAN
b) An INSTRUCTOR, may have more than one DEGREE
c) A STUDENT may exist without being in a DEPT.
d) Each instance of INSTRUCTOR can be identified by the Degree attribute.
e) The GPA of a STUDENT is a derived attribute.
f) A COLLEGE must have at least one DEPT
S) STUDENT has an attribute that is a composite attribute.
The DEAN of a COLLEGE must be an INSTRUCTOR.
A DEPT may exist without employing an INSTRUCTOR
There are 6 identifying relationships in the ERD.
k) INSTRUCTOR may exist without being employed in a specific DEPT.
A DEPT may have at most only one Dphone.
m) Each DEPT must have a chair always.
n) A COURSE may have more than 1 INSTRUCTOR.
o) A COURSE needs information about the DEPT to uniquely identify its instances
Each instance of SECTION can be identified by the SecNO attribute.
An INSTRUCTOR must teach at least one course.
r) DEPT must offer at least one COURSE
s) A DEPT may exist without having STUDENT.
A COLLEGE must a DEAN and only 1 DEAN is allowed.
An INSTRUCTOR may teach several courses
Each instance of COURSE can be identified by the CCode attribute.
W) STUDENT has an attribute that is a multi-valued attribute.
W) STUDENT has an attribute that is a multi-valued attribute.
x) A SESSION may be taught by more than 1 INSTRUCTOR
y) A STUDENT may take several SECTION at the same time.
An INSTRUCTOR can work for only one DEPT
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Readings In Database Systems

Authors: Michael Stonebraker

2nd Edition

0934613656, 9780934613651

More Books

Students also viewed these Databases questions

Question

What is meant by Career Planning and development ?

Answered: 1 week ago

Question

What are Fringe Benefits ? List out some.

Answered: 1 week ago