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

What are some instances that would explain strategic groups, What are some ...

What are some examples that would explain strategic groups?

Countries that are leading the export import of merchandise, The wtos intl ...

The wtos intl trade statistics is an annual report that provides comprehensive comparable updated statistics on trade in merchandise and commercial services. This report allows for

Define what is the probability that you will make money, The owner of Firew...

The owner of Firewood-2-Go is considering buying a hydraulic wood splitter which sells for $60000. He figures it will cost an additional $80 per cord to purchase and split wood wit

Why customer driven analytics to make managerial decisions, 1) What assumpt...

1) What assumptions are necessary when using customer driven analytics to make managerial decisions? 2) How does the IT strategy of 7/11 influence other aspects of the business

Describe the use of strike replacements, Itemize and discuss the different ...

Itemize and discuss the different types of strikes and lock outs, their roles in labour relations and their legal restrictions in private and public sectors. Discuss the use of str

Explain what is the bonds'' coupon rate, Metal Fabricators just issued $1,0...

Metal Fabricators just issued $1,000 par 20-year bonds. The bonds sold for $758.18 and pay interest semi-annually. Investors require a rate of 9% on the bonds. What is the bonds' c

Explain should audio cables buy the new equipment, Audio cables, INC. is cu...

Audio cables, INC. is currently manufacturing an adapter that has a variable cost of $.50 per unit and a selling price of $1.00 per unit. Fixed cost are $14,000. Current sales volu

Labour intensity - operations function, Labour Intensity - Operations Funct...

Labour Intensity - Operations Function Labour intensity is defined as the ratio of the labour cost incurred to the value of the plant and equipment employed. It is important t

Explain widget is identical and requires a machining cycle, 3,000 widgets m...

3,000 widgets must be machined on workstation during week. Each widget is identical and requires a machining cycle time (Tc) of 36.5 minutes. All of the machining centres in the sh

Explain challenges has the european union consortium faced, Describe what c...

Describe what challenges has the European Union Consortium faced in the last 2-3 years

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