Answered step by step
Verified Expert Solution
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 isare 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 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 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 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 multivalued attribute.
W STUDENT has an attribute that is a multivalued attribute.
x A SESSION may be taught by more than INSTRUCTOR
y A STUDENT may take several SECTION at the same time.
An INSTRUCTOR can work for only one DEPT
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started