User Account

All Pages

Identify which entities should be normalized

Assignment Help Basic Computer Science
Reference no: EM132322980

Need help to design your plan for the scenario provided below. Your project plan should include the entity relationship diagram (ERD).

Scenario

Imagine that you just started a new job at ABC Car Sales. You've been given the task of adding all the new and used car inventory to a new database management system (DBMS). You would like to manage the new and used car sales in the new DBMS.

Listed below are the categories of information that you will need to input in the new database for each type of inventory:

New Vehicle InventoryUsed Vehicle InventoryVIN NumberVIN NumberPricePriceMakeMakeModelModelYearYearExterior ColorExterior ColorInterior ColorInterior ColorTransmission (Manual/Automatic)Transmission (Manual/Automatic)Engine (# of cylinders)Engine (# of cylinders)MileageMileageFully loaded (Yes/No)Fully loaded (Yes/No)Carfax Report (Yes/No)

You will also want to track the following types of information for new and used car sales, including specific customer data.

New Car SalesUsed Car SalesSales ID NumberSales ID NumberVIN NumberVIN NumberCustomer IDCustomer IDAdvertised PriceAdvertised PricePurchase PricePurchase PriceFinanced (Yes/No)Financed (Yes/No)Date soldDate soldCustomerCustomer IDFirst NameLast NameAddressPhone NumberSales ID Number

Instructions

For Part I of the final project, complete the following steps. Your normalized entity relationship diagram can be created by hand, or in PowerPoint. If you decide to hand-write ERD, please scan and submit it as a PDF fie. If you create ERD in PowerPoint, please submit as a PowerPoint file.

  1. Identify which entities should be normalized.
  2. Create normalized entity relationship diagram. In your diagram,
  • show the relationship between the tables
  • include notations and symbols as needed

Drawing your ERD

Reference no: EM132322980

Questions Cloud

Find the height of the building : Question - A surveyor stands 100 feet from a building and sights the top of the building at a 55o angle of elevation. Find the height of the building
Considered for new tech organization : Why risk management needs to be considered for New Tech Organization? Convince management to use risk management to ensure their fielded
What would be the result of the security breach : What would be the result of the security breach, and how long do you think it would to recover from it?
Develop the drp policy using given information : In recent years, organizations have witnessed the impact of having effective and non-effective business continuity plans and disaster recovery plans.
Identify which entities should be normalized : Need help to design your plan for the scenario provided below. Your project plan should include the entity relationship diagram (ERD).
Solve the triangle ABC : Question - Solve the triangle ABC
Discuss the social changes caused by the computer revolution : Discuss the social changes caused by the computer revolution in the past hundred years
Identify the correct statements about screen resolution : Identify the correct statements about screen resolution. Check All That Apply
Solve the equation : Question - Solve the equation: (4/(z-2)) - (z+6/z+1) = 1

Reviews

Write a Review

Basic Computer Science Questions & Answers

  What are some examples of when a data compression utility

What are some examples of when a data compression utility can be used for information stored on a computer's hard drive?

  How many hours are one million seconds

How many hours are one million seconds? How many days? Answer these questions by doing all arithmetic in your head.

  Appear on four tosses of a coin

Suppose four heads appear on four tosses of a coin. What is the probability that a head will appear face up on the next toss of the coin?

  Economy from a supply and demand standpoin

Discuss the sharing economy from a supply and demand standpoint. How do companies like Uber and Airbnb affect supply and demand in the markets for shared rides (taxis, limos, etc.) and rented rooms, respectively?

  Predictor in the training data

Future data to be classified will be lists purchased from other sources, with demographic (but not purchase) data included. It was found that ‘‘refund issued'' was a useful predictor in the training data?

  Elasticity of demand between petrol and fuel-efficient

Is the cross-price elasticity of demand between petrol and fuel-efficient small cars positive or negative?

  Progress procedure programming

What are the sections involved in Progress procedure programming?

  Explain reads and writes using lipner-s matrix

Who in Lipner's model can make this change? Explain the reads and writes necessary to make this change and justify the read and write using Lipner's matrix.

  Outsourcing to difference vendors to handle it-is activities

Discuss the pros and cons of selecting (outsourcing to) three different vendors to handle three different IT/IS activities.

  Quality of digital video output

Identify and explain the three factors that influence the quality of digital video output.

  Find the centerline velocity and the volumetric flow rate

Water flows through a 6-in.-diameter horizontal pipe at a rate of 2.0 ft3 /s and a pressure drop of 4.2 psi per 100 ft of pipe. Determine the friction factor.

  Experience in programming with tree data structures

Objective: To gain experience in programming with tree data structures; to practise building larger applications from a variety of data structures; to gain awareness of managing resources (both space and time) in programming with tree data structu..

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!

Submit Assignment

Academics

Major Subjects

Majors

Get In Touch

whatsapp: +1-415-670-9521

Phone: +1-415-670-9521

Email: [email protected]

TERMS & POLICIES

HELP & SUPPORT

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