Notate primary keys in each table with solid underlining, 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:- Notate primary keys in each table with solid underlining

Qn, a firm whether to make or buy a part required in its operation. cost an...

a firm whether to make or buy a part required in its operation. cost and volume estimate are as follows annual fixed cost make $15000 buy none, variable cost make $60 buy $80, annu

Describe henry did tax work for joe electrician, Henry did tax work for Joe...

Henry did tax work for Joe electrician. Bill was $900, Hnery reduced it to $600. Joe did wrok for Henry at cost of $700. Henry gave Joe a check for $400, said remaining $300 was th

Explain how can differences in the cultures of two countries, How can diffe...

How can differences in the cultures of two countries create ethical issues in our business operations? A key to answering this question is to first understand culture, particularly

Explain ddi communications model, What`s the use of DDI communications mode...

What`s the use of DDI communications model most typically used by and for 1st level supervisors?

Describe how preferred outcomes are derived in the short run, Discuss how p...

Discuss how preferred outcomes are derived in the short run?

Define the coordinate of potential sites for hospital, Suppose a new hospit...

Suppose a new hospital is to be built to provide emergenct medical healthcare service to 5 town w coordinates (5,6), (1,3), 13,7), (11,2), (18,1) on a map. The exisiting transporta

Display the demand data, The demand for a product for the past 30 periods i...

The demand for a product for the past 30 periods is shown below. Determine the reorder point, R, and order-up-to-level, S, for this product for the next 6 periods (periods 31-36).

Explain companys strengths and weaknesses, How can value-chain analysis hel...

How can value-chain analysis help identify a companys strengths and weaknesses?

Explain e-activity evaluate the lessons, From the e-Activity, evaluate the ...

From the e-Activity, evaluate the lessons learned in this chapter to determine which single lesson would be most beneficial to the company you researched. Provide specific examples

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