Create the entity relationship diagram

Assignment Help Data Structure & Algorithms

Reference no: EM1380277

Create the entity relationship diagram (ERD) for your project database based on the initial data requirements.

The firm that we are working on distributes many products, like secure bolts and screws, to many different construction companies. In order for the company to be successful it is important for them to keep a reliable and accurate inventory system.

As part of the diagram, include
entities
attributes
primary keys
relationships
cardinalities (both minimum and maximum)
The ERD should include documentation of design decisions. It should conform to instruction through Chapter 4 of the text, but should not be converted to relational tables. Develop the diagram using VISIO or Word.

Reference no: EM1380277

Questions Cloud

Question about damaged database : Suppose if you were one of the users of a damaged database, discuss how would you be affected by such a failure and what measures could you take to prevent it?

Implementing one to one relationships : Explain the different ways of implementing one to one relationships. Suppose you are maintaining information on offices and faculty.

Database design activities : Assume Ray wishes to start a DVD rental program at his stores that he plans to call Henry's DVD Club. He refers to each of his consumers as members.

Professional codes of ethics : Select one of the Professional Codes of Ethics associated with IT. If you were to complete a assignment related to securing the connectivity in your firm and its business partners.

Create the entity relationship diagram : Create the entity relationship diagram for your project database based on the initial data requirements.

Analyzing the use of database in an organization : Examine the use of databases in your company. Include what database applications are used. Conclude through proposing improvements.

Describe specific steps in the hiv life cycle : How could these three cell types be clearly and simply distinguished from each other in an experimental laboratory and how and where do these different cell types differentiate to their mature functional characteristics?

Find capacity of a particular airplane type : Consider the entities and their attributes. You should 1st determine what entities want to track. Next determine what attributes are required for each entity, and what relations exist between these entities.

Design adatabase to keep track of all students at university : Discuss how you would design a database to keep track of all students at a university. Explain tables, Primary Keys, Foreign Keys, relationships, attributes, Candidate Keys.

User Account

All Pages