ERD HELP
gg_3112a. 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.
- 10 years ago
- 50
Purchase the answer to view it
- erd_piano_and_tablet.docx
Purchase the answer to view it
- erd_help.doc
- answer_3a.vsd
- answer_3b.vsd
Purchase the answer to view it
- cardinalities.docx
Purchase the answer to view it
- cmis_320_relational_database_concept_piano_manufacturer.doc
Purchase the answer to view it
- question_2.docx
- These are problems exercises quesions 1 2 5 and 6
- Business Calculus problem in Documents, Problem #2 only
- First National Bank’s president congratulates you on successfully managing her network’s addressing issues. She then shares the information that she’s about to...
- 2x+y=1 2x+y=-3
- graph each quadratic function. identify the vertex,minimum or maximum, axis of symmetry, and zeros of the function f(x)=-2x^2+8
- Bill Gibson is collecting his car from the garage how many Km can he travel on a full tank of...
- Name the coefficient, the like terms, and the constants. 4.3x + 5y - 3 5.2x - 7 6.4x - 7x + 3x 7. 6xy...
- 3/25*1/6+((7/5)(35/11))
- 8x^10-2
- Literature Writing