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.;Perform the following tasks for both of the above;1. Identify and list the entities and attributes for each of these applications.;2. Express the relationships between all entities for each application using relationship sentence pairs.;3. Draw an ERD for each application using Visio or other drawing too.;Submit all items, in order, and with each step labeled clearly, for both applications in a single Word file.
Paper#70469 | Written in 18-Jul-2015Price : $57