Express the relationships between all entities for each

Assignment Help Computer Engineering

Reference no: EM13468207

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.

Reference no: EM13468207

Questions Cloud

How does your perception compare to the definitions : write a 700- to 1050-word paper describing your personal perception of organized crime upon entering this course.

What actions should a manager in the selected industry take : what actions should a manager in the selected industry take to identify and protect the tangible property rights of the

Explain how needs and expectations of stakeholders : programs must often cater to the needs or expectations of many stakeholders which may include the program administrator

What special issues arise in international business : what special issues arise in international business transactions? identify two such issues and discuss what managers

Express the relationships between all entities for each : a. a piano manufacturer wants to track all pianos it makes. each piano has a unique serial number and a manufacturing

Select a business contract transaction you are familiar : select a business contract transaction you are familiar with or can easily research. you may use a transaction

What are some important aspects of being sure that local : law enforcement can not be everywhere all the time. it is important that citizens are also on the look-out so to say.

Have a minimum of 12 academic resources peer-reviewed : instructions are very specific and very detailed.since you have now explored and had experience with all of the parts

How do government regulatory agencies and laws affect : how do government regulatory agencies and laws affect organizations? choose one or two specific regulatory requirements

User Account

All Pages