Question

Consider the following E-R diagram address name In creditHrs tile Buildings description cID oPhone officeNo Courses N Teaches Offices academicYr N scmester ID P Takes Locates Semesters M N banner N 1 stulD Faculty facuName Advises Students 99n rank phones stuName email EName IName [Choose] Identify a simple attribute Two email Partial participation The number of candidate keys for the entity Phones type Students is total participation The Advises relationship type is of degree One stuName Three The participation of Students in Advises is meaning that every entity of the entity set Students must be related to a faculty entity via Advises. Choose called

Answer 1

1.Simple Attribute: A simple Attribute is one that can store a single value.

Here, stuName is the simple Attribute and email is not a simple Attribute. An email have many parts such as domain name, username etc.,

Answer: stuName

2. Candidate key is a set of keys that can be used to uniquely identify an record in the table.

Here, in an ER diagram, we represent The candidate keys as the combined of underlined attributes.

Here, we can observe that Students have 3 attributes that are underlined, they are:

• Stuid
• Ssn
• Email

So, the candidate key is (stuid,ssn,email)

Answer: One

3.Binary or degree=2

The degree of a relationship is the number of entities that participate in a relationship.

Here, Advises has two entities that are participating in the relationship.

They are: Faculty and Students

Answer: Two.

4. Answer: Total Participation

Students and Advises is a Total Participation because every every entity in Students must be related to a Faculty entity that is using Advises.

Also, the total participation is denoted by a double line as shown in the figure between Advises and Students.

≠=============================≠

If you have any doubts, please comment down here in the comment box.

Please hit a like if you liked the answer.

Happy learning.!!