138 PartDatabase Analysis FIGURE 2-26 Grade report GRADE REPORT FALL SEMESTER 2015 ID: 268300458 NAME CAMPUS ADDRESS: MAJOR Emily Williams 208 Brooks Hall TITLE NSTRUCTOR INSTRUCTOR GRADE COURSE ID NAME LOCATION Codd B104 IS 465Systen Analysis 2-34. The ls Married To relationship in Figure 2-12a would a. State the business rule for each relationship and then seem to have an obvious answer in Problem and Exercise state the cardinality of each relationship. Explain the 2-33d that is, until time plays a role in modeling data Draw a data model for the PERSON entity type andb. From your own understanding, identify the probable same attributes and identifiers for each entity. Are there any the Is Married To relationship for each of the following variations by showing the appropriate cardinalities and c. Suppose library offers books only for staff who can a. All we need to know is who a person is currently married to, if anyone. (This is likely what you repre- sented in your answer to Problem and Exercise 2-33d.) b. We need to know who a person has ever been married issue only one book. Will this have an impact on the relationship between members and Books issued entity? How? Will there be any impact on any other Suppose, through this ER model, the library wishes to c. We need to know who a person has ever been married to, if anyone, as well as the date of their marriage and send an overdue mail to their members who have not returned the books in due time. Suggest how this can the date, if any, of the dissolution of their marriage. be achieved. State your assumptions, if any dThe same situation as in c, but now assume (which you likely did not do in c) that the same two people can remarry each other after a dissolution of a prior 2-36, Figure 2.28 shows two diagrams (A and B), both of which are legitimate ways to represent that a stock has history of many prices. Which of the two diagrams do you consider a better way to model this situation marriage to each other e. In history, and even in some cultures today, there may be no legal restriction on the number of people 2-37. Modity Figure 2-11a to model the following additional information requirements: The training director decides tor each employee who completes each class who (what employees) should be notified of the course comple tion. The training director needs to keep track of which employers are notified about each course completion by a student. The date of notification is the only attribute to whom one can be currently married. Does your answer to part c of this Problem and Exercise handle this situation or must you make some changes (if so, 2-35. Consider the figure provided which represents a situation of members of a library who get books issued and return recorded about this notification. 2-38. Review Figure 2-8 and Figure 2-22 a. Identify any attributes in Figure 2-22 that might be Justify your suggestions. Redraw the ERD to reflect composite attributes but are not shown that w any changes you suggest. Identify any attabutes in Figure 2-22 that might be multivalued attributes but are not shown that way Justify your suggestions. Redraw the ERD to reflect FIGURE 2-27 E-R diagram for Problem and Exercise 2-35 c. Is it possable for the same attribute to be both com- posite and multivalued? If no, justify your answer; if The members can be students, staff or faculty and their details are stored in Member entity. A member can issue yes, give an example (Hint Consider the CUSTOMER attributes in Figure 2-22) no more than 10 books. All the books details are stored in 2-39. Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions K- (--) -n 138 (139 of 691 ) ,0,0 734% 7