Required: 8 pts
a. A partial E-R diagram for the registration system is shown below. This diagram follows the REA conventions discussed in class. Complete the diagram as follows:
1. Fill in the names of the missing entities. 2. Show the cardinalities of the various relationships in the diagram. (Note: In the text we usually show the association between agents and events. In some situations, it may be more appropriate to represent the association between products/services and agents. In the registration system, professors are associated with courses rather than specific registration events.)
b. Summarize the design of the tables in the registration system using the following format:
Table Primary Key Foreign Key Informational (other) attributes Student Professor Course Registration Registration_Detail
Using budget data, how many Apple iPhone 4’s would have to have been completed for Danshui Plant No. 2 to break even? 2. Using budget data, what was the total expected cost per unit if all manufacturing and shipping overhead (both variable and fixed) were allocated to...