Develop an entity relationship diagram (erd) for project

Assignment Help Database Management System
Reference no: EM13949636

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

The company 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 not be converted to relational tables. Develop the diagram using VISIO or Word.

Reference no: EM13949636

Questions Cloud

Combustor of a simple open gas turbine power plant : Methane (CH4) at 258C, enters the combustor of a simple open gas turbine power plant and burns completely with 400% of theoretical air entering the compressor at 258C, 1 atm. Products of combustion exit the turbine at 5778C, 1 atm.
Combustion chamber operating : Liquid ethanol (C2H5OH) at 778F, 1 atm enters a combustion chamber operating at steady state and burns completely with dry air entering at 3408F, 1 atm. The fuel flow rate is 50 lb/s, and the equivalence ratio is 0.8. Products of
Rate of heat transfer for the combustion chamber : If the combustion products exit at 560 K, 1 atm, determine the rate of heat transfer for the combustion chamber, in kW. Repeat for an exit temperature of 298 K.
Calculate profit change attributable to productivity changes : Calculate the partial productivity ratios for each year. Can you say that produc- tivity has improved? Explain. Calculate the profit change attributable to productivity changes.
Develop an entity relationship diagram (erd) for project : The company 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 syst..
Find financial statements for any for profit : Complete a ratio analysis for that company's last year's financial data. At a minimum, list and discuss the company performance vs. its industry average for these 4 ratios:
Analyse the latest financial statements : Analyse the latest financial statements of a mining company ‘Mining Projects Group Limited, MPG' and come up with a conclusion with supporting data or information whether to invest in the company or not.
Determine the equivalence ratio : 1. Octane (C8H18) enters an engine and burns with air to give products with the dry molar analysis of CO2, 10.5%; CO, 5.8%; CH4, 0.9%; H2, 2.6%; O2, 0.3%; N2, 79.9%. Determine the equivalence ratio.
Distribution transformer : The data in the table attached  were obtained when open circuit and short circuit tests were performed on a single phase 50kVa, 2400:240 V, 60 Hz distribution transformer Please show all steps and explanations

Reviews

Write a Review

 

Database Management System Questions & Answers

  Evaluate use of a distributed dbms structure is appropriate

Evaluate whether the use of a distributed DBMS structure is appropriate and identify the optimization techniques that should be factored in to enhance the operations of the database in your design.

  Display the students for each class in the main form

Create a new custom form that contains a subform, the main from will contain the classes and the subform will contain the students , when the user navigate the classes from the main form, the subform will display the students for each class in the..

  Create a table with the following column headings

You learned that WIPO is the global arbitrator for all intellectual property-related issues. Read any two cases for the year 2007 on cybersquatting. Create a table with the following column headings.

  Improved processesdatabases are installed to help solve

improved processesdatabases are installed to help solve problems improve processes or provide a benefit to the

  Analyse and comprehend a provided er diagram

Analyse and comprehend a provided ER diagram and Database Schema and to implement a database based on the provided ER diagram and Database Schema

  Alexander, the great: strength, weakness and contributions

There were immense qualities for Alexander, the great as a leader. One of the greatest qualities a leader should have is ambition.

  Represent data for sales of individual stores

Explain how you will visually represent the data for the sales of the individual stores and for the time period shown. You want to show the change in sales for each store over time for the past three years.

  Draw context diagram that represent supply ordering system

Draw a context diagram that represents a Supply Ordering System (SOS).

  Design a clean and normalized database

Design a clean and normalized database that handles books for a library application. You need to consider the following rules before you design the database: All books are mapped to categories. For example, the book Distributed Operating System bel..

  Create a query using list of values match

Create a list the holds the student grade (A, A-, B+,..), modify the appropriate table to accept only the grades in the list(you need to explain why you selected the above table to record the student grade).

  Write a create table statement for the department table

Write a CREATE TABLE statement for the EMPLOYEE TABLE.  Email is required and is an alternate key, and the default value of Department is Human Resources.  Cascade updates but not deletions from DEPARTMENT to EMPLOYEE.

  Query using a literal character string

query specifying specific columns query using a column alias query using the concatenation operator query using a literal character string

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd