For each of the descriptions below, perform the following tasks(32points) :

• Identify the degree and cardinalities of the relationship.
• Express the relationships in each description graphically with an E-R diagram.

e. Ebony and Ivory, a piano manufacturer, wants to keep track of all the pianos it makes individually. Each piano has an identifying serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and a name. In addition, the company wants to maintain information about the designer of the model. Over time, the company often manufactures thousands of pianos of a certain model, and the model design is specified before any single piano exists.

f. Ebony and Ivory (see (e) above) employs piano technicians who are responsible for inspecting the instruments before they are shipped to the customers. Each piano is inspected by at least two technicians (identified by their employee number). For each separate inspection, the company needs to record its date and a quality evaluation grade.

g. The piano technicians (see (f) above) have a hierarchy of reporting relationships: some of them have supervisory responsibilities in addition to their inspection role and have multiple other technicians report to them. The supervisors themselves report to the chief technician of the company.

h. Chiclets Electronics (C E) builds multiple types of tablet computers. Each type has a type identification number and a name. The key specifications for each type include the amount of storage space and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet computer type; obviously, the same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturers unique code that identifies it.

2-32. Figure 2-26 shows a grade report that is mailed to students at the end of each semester. Prepare an ERD reflecting the data contained in the grade report. Assume that each instructor has to teach one or more courses, and each course is taught by one instructor.

MILLENNIUM COLLEGE GRADE REPORT FALL SEMESTER 2018 ID: 268300458 NAME: CAMPUS ADDRESS: MAJOR: Emily Williams 208 Brooks Hall Information Systems TITLE GRADE COURSE ID INSTRUCTOR NAME INSTRUCTOR LOCATION IS 350 IS 465 Database Mgt. System Analysis Codd Parsons B104 B317 A