Given the ER diagram above, answer the following questions: Name an entity type that has more than 2 relationships. Name one ket attribute and the entity type it belongs to. Name one one-to-one relationship and the entity types it relates. Name one many-to-many relationship and its entity types. Name one relationship attribute. What is the cardinality of relationship ‘employs’? What is the cardinality of relationship ‘textUsed’? Name one weak entity type Does it have a partial key? If yes, name it. Name its identifying entity type Name its identifying relationship

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question
100%

Question 1

 

Given the ER diagram above, answer the following questions:

  1. Name an entity type that has more than 2 relationships.
  2. Name one ket attribute and the entity type it belongs to.
  3. Name one one-to-one relationship and the entity types it relates.
  4. Name one many-to-many relationship and its entity types.
  5. Name one relationship attribute.
  6. What is the cardinality of relationship ‘employs’?
  7. What is the cardinality of relationship ‘textUsed’?
  8. Name one weak entity type
    1. Does it have a partial key? If yes, name it.
    2. Name its identifying entity type
    3. Name its identifying relationship
Question 1
Ofice
destame
depcode
lasName
fisName
facid
rark
Depannent
empys
Credits
Facuty
Raed
Major
hasMajor
chairs
frstame
Evaluation
Sudent
lastName
studentid
IN
date
ing
en
gade
teaches
N
schedule
Class
textubed
oom
Texbock
stie
aher
year
secton
counato
depcode
psher
Given the ER diagram above, answer the following questions:
a. Name an entity type that has more than 2 relationships.
b. Name one ket attribute and the entity type it belongs to.
c. Name one one-to-one relationship and the entity types it relates.
d. Name one many-to-many relationship and its entity types.
e. Name one relationship attribute.
f. What is the cardinality of relationship 'employs'?
g. What is the cardinality of relationship 'textUsed'?
h. Name one weak entity type
i. Does it have a partial key? If yes, name it.
ii. Name its identifying entity type
iii.
Name its identifying relationship
Transcribed Image Text:Question 1 Ofice destame depcode lasName fisName facid rark Depannent empys Credits Facuty Raed Major hasMajor chairs frstame Evaluation Sudent lastName studentid IN date ing en gade teaches N schedule Class textubed oom Texbock stie aher year secton counato depcode psher Given the ER diagram above, answer the following questions: a. Name an entity type that has more than 2 relationships. b. Name one ket attribute and the entity type it belongs to. c. Name one one-to-one relationship and the entity types it relates. d. Name one many-to-many relationship and its entity types. e. Name one relationship attribute. f. What is the cardinality of relationship 'employs'? g. What is the cardinality of relationship 'textUsed'? h. Name one weak entity type i. Does it have a partial key? If yes, name it. ii. Name its identifying entity type iii. Name its identifying relationship
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Enhanced ER Model
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education