User Account

All Pages

Determining the entity relationship diagram

Assignment Help Business Management
Reference no: EM132302734

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: EM132302734

Questions Cloud

Create a chart that depicts the timeline of the disbursement : Using Microsoft Word or an equivalent such as OpenOffice, create a chart that depicts the timeline of the disbursement of the compensation.
What would that look like in a raptor flowchart : In other words, if the mean salary is $45000, all employees who earn between $40000 and $50000 should be displayed. What would that look like in a Raptor
What can be done to avoid each of the mistakes : Please list and explain at least four mistakes (traps) to decision making. Also, identify what can be done to avoid each of these mistakes (traps)?
What are the elements and your priorities : Bargaining mix - what are the elements and your priorities. Goals - all three goals (target, aspiration and bottomline) and anchors for them.
Determining the entity relationship diagram : Need help to design your plan for the scenario provided below. Your project plan should include the entity relationship diagram (ERD).
Discussing how disasters impact the economy and growth : Assume that you are writing for an uninformed reader that knows nothing about the topic and has not read what you read. Provide an introduction that gives.
What the employer could have done regarding the case : Sexual harassment is a concern for all employers. Find an article on the Internet regarding a sexual harassment case. Describe what the case was about.
Discuss the quality of the advertisement for target market : Using course concepts, discuss the quality of the advertisement for the target market
Describe vision and goal for successful completion of course : Describe your vision and goals for successful completion of the course. What is your vision and mission for long term success?

Reviews

Write a Review

Business Management Questions & Answers

  Research the objective

1. Research the objective.2. Explain if the design is a true experiment or a quasi-experiment. Justify your selection.3. Develop a hypothesis based on your research question.4. Evaluate your hypothesis according to the characteristics provided in the..

  Describe the forms of guidance

Describe the following forms of guidance and support you can provide to employees to enhance their performance:

  What kind of process do you think will be used

What kind of process do you think will be used to make the product? Would it be possible to produce a lot of the product in a short amount of time?

  Identify the issue problem or need you have discovered

Identify the issue, problem, or need you have discovered at your business; Mention the solution your paper will propose.

  Business management- analysis and briefing

Prepare a briefing, aimed at the CEO of an organisation, on a business story in the current business press. Students should use concepts studied to date to examine the story.

  How do you integrate python and mysql

How do you integrate Python and MySQL? Can you also explain how you iterate through a JSON field in a Python?

  The us foreign corrupt practices act

1. Does the FCPA place US firms at a competitive disadvantage globally? Why or why not? 2. In light of the global economic changes of the past 35 years, is the FCPA still valid? Does it go too far? Not far enough?

  Analyze three potential benchmarks from quality indicators

Analyze how benchmarks and milestones are involved in managing the use of quality indicators. Analyze three potential benchmarks and milestones from quality indicators that could be used for your plan.

  Organizational leaders are expected to create realistic

organizational leaders are expected to create realistic visions for their companies and the employees they guide but

  Deficiencies in business process management

How does Scrum (Agile) development address the deficiencies in Business Process Management (BPM) and Systems Development Life Cycle (SDLC)? Be specific and provide details on the benefits and drawbacks of the Scrum development approach.

  Law of one price being violated

Suppose you are shopping for a new automobile. You find the same car at two dealers but at different prices. Is the law of one price being violated? Why or why not?

  Communication across genders

Apply the following guidelines in ALL of your assignments: 1. Two full typed pages, double spaced. 2. Two citations, always place on Page 3. (Citation format does not matter- choose any format.)

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