CMIS 320 Homework 2

Homework 2

Instructions

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)