Identify the degree and cardinalities of the relationship.

Homework 2
For each of the following descriptions:


A. A piano manufacturer wants to track all pianos it makes. Each piano has a unique serial number and a manufacturing completion date. Each instrument represents exactly one piano model, all of which have an identification number and model. The company produces thousands of pianos of a certain model, and the design is specified before any single piano exists.


B. A vendor builds multiple types of tablet computers. Each has a type identification number and a name. The key specifications for each type include amount of storage and display type. The company uses multiple processor types, exactly one of which is used for a specific tablet type. The same processor can be used in multiple types of tablets. Each processor has a manufacturer and a manufacturer’s unique code that identifies it.


C.  Each individual tablet computer manufactured by the vendor is identified by the type identification number and a serial number that is unique within the type identification.  The vendor wants to maintain information about when each tablet is shipped to a customer.


Perform the following tasks:


1. Identify the degree and cardinalities of the relationship.

2. Express the relationships graphically with an E-R diagram.


Document your work into a single, well-organized, well-written word document and submit no later than due date.


Name the file “XXX_ASSIGN2.doc(x), where XXX are your initials.  Please adhere to the naming convention for naming your file.

(Use the attached blank word document and send with it without renaming)

Type of paper Academic level Subject area
Number of pages Paper urgency Cost per page: