Answer the following questions with reference to how the ER model in Figure 17.13 maps to relational tables.
The ER diagram in Figure 17.13 shows only entities and primary key attributes. The absence of recognisable named entities or relationships is to emphasize the rule-based nature of the mapping rules described in Step 2.1 of logical database design.
(a) How many relations will represent the ER model?
(b) How many foreign primary keys are mapped to the relation representing X?
(c) Which relation(s) will have no foreign key?
(d) Using only the letter identifier for each entity, provide appropriate names for the relations mapped from the ER model.
(e) If the cardinality for each relationship is changed to one-to-one with total participation for all entities; how many relations would be derived from this version of the ER model?
(a) 6
(b) 2 - The primary keys of entities X and D as they have a 0ne-to-many relationship with X and they are on the one side and therefore send a copy of their primary keys to X. Once mapped to X – the copies of primary keys are referred to as foreign keys.
(c) Relations A, C and D
(d) Relation A
Relation B
Relation C
Relation CX (Representing the many-to-many relationship between entities C and X)
Relation XE (Entity X and E merge as there is a one-to-one relationship with total (i.e. full)
participation relating these entities).
Relation D
(e) 1 (Relation ABCXDE)
You might also like to view...
What are the keyboard shortcuts for Show Hidden Characters?
What will be an ideal response?
Evidence found during an illegal search is knows as ________________.
a. Contaminated b. Fruit of a poisonous tree c. Libelous d. Exculpatory
To change a slide's theme, click the Design tab on the Ribbon.
Answer the following statement true (T) or false (F)
Case-Based Critical Thinking Questions ? Case 12-2 Your cousin Rebecca knows that you are an experienced Excel user. She has created a workbook and needs input from three fellow workers. She wants to retain her workbook as the original copy. She will need your help in collecting input. ? ? Comments are a powerful collaboration tool, giving team members the ability to offer insights and make suggestions about the workbook and its content. Now Rebecca would like to review the comments by clicking the _______.
A. View Tab, then click Next in the Comments groups B. Review Tab, then click Next in the Comments groups C. Home Tab, then click Next in the Comments groups D. Edit Tab, then click Next in the Comments groups