Posted: January 24th, 2016
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) |
Place an order in 3 easy steps. Takes less than 5 mins.