Explain microsoft visio erd, Operation Management

Assignment Help:

Review the information currently housed in Huffman Trucking%u2019s database, in the Entities and Attributes for Fleet Truck Maintenance file on the virtual Organizations site. (Customers, facilities, employees, and capital)

Create a Microsoft Visio ERD, based on the relations in the Entities and Attributes for Fleet Truck Maintenance file and any additional information needed to normalize the database.

• Notate primary keys in each table with solid underlining.

• Notate foreign keys in each table with dashed underlining.

• Notate new attributes that do not exist in the existing database with italic font.

Create normalized tables in a Microsoft Word document or a Microsoft Excel spreadsheet for the fleet truck maintenance database.

Indicate primary keys, foreign keys, and new attributes as in the entity relationship diagram.

There are 2 parts to this. I will give maximum points to anyone who completes them all. Half points for each part


Related Discussions:- Explain microsoft visio erd

Describe a manufacturing company preparing to build a plant, A manufacturin...

A manufacturing company preparing to build a new plant is considering three potential locations for it. The fixed and variable costs for each alternative location are presented bel

Explain how does national culture affect strategy, How does national cultur...

How does national culture affect strategy? To what extent do different approaches to strategy, different ways of thinking about strategy, reflect different underlying cultural assu

Compute the schedule variance or cost performance index, A project to build...

A project to build a new bridge seems to be going very well since the project is well ahead of schedule and costs seem to be running very low. A major milestone has been reached wh

Explain ethernet network with a fddi network, A bridge that is used to conn...

A bridge that is used to connect an Ethernet network with a FDDI network must be practicing what type of bridging?

Calculate percentage of the time the inspector is idle, At a border vehicle...

At a border vehicles arrive at the rate of 9 per minute in a Poisson distribution. For simplicity in this problem assume that there is only one lane and one inspector who can inspe

What are the advantages of a permanent arbitrator, What are the differences...

What are the differences between the FMCS and the AAA in their methods of selection of arbitrators? What are the advantages of why some employers and unions contract the use of a p

Net profit margin, Net profit margin: 1. Transportation firm now ...

Net profit margin: 1. Transportation firm now spends 60 percent of the sales revenue it receives in the supply chain, and has a net profit margin of 6 percent. The compan

Management consultant firm, After working for 30 years, Ramjee Somjee Dutt ...

After working for 30 years, Ramjee Somjee Dutt opted for VRS and started a courier company and did very well in the first four years. He was now looking for expansion of his busine

Write Your Message!

Captcha
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