fb
$20 Bonus + 25% OFF
$20 Bonus + 25% OFF
Securing Higher Grades Costing Your Pocket? Book Your Assignment at The Lowest Price Now!
loader
Add File

Error goes here

Files Missing!

Please upload all relevant files for quick & complete assistance.

Stuck on Your Question?

Get 24x7 live help from our Top Tutors. All subjects covered.

250 words

Error goes here

Students Who Viewed This Also Studied

1 Page
presantation

One slide Presentation. of Family Life & Community in Black Country in 1800 centuries, Include how they lived, how hard they worked, social life & etc ...

Type

Assignment

Subject

1 Page
Science

Identify the various components of the health sector and evaluate their importance in the delivery of health care & Understand and compare the theory and practice of managing operational systems i ...

Type

Assignment

Subject

1 Page
Taxation Law

Explain clearly in which condition somebody can or cannot claim fringe benefits and state whether emma can or cannot claim fringe benefit. ...

Type

Thesis

Subject

22 Pages
Business Management

Choose a public health issue, a population and a population group of personal interest.  You will be required to choose: 1. A specific communicable disease, non-communicable disease or injury 2. ...

Type

Essays

Subject

Archie‟s Luxury Motors

Question

Answered

Archie‟s Luxury Motors is a car dealership that specializes in high-end luxury vehicles in addition to offering the biggest selection of local and international vehicles from the world‟s most popular manufacturers in all price brackets. Rather than being situated in the middle of the hustle and bustle of a large metropolis, Archie's Luxury Motors enjoys an idyllic rural setting in the beautiful open countryside. The dealership currently records its data manually, keeping records in hardcopy, with individual files being held for different car sale transactions. This process is slow, laborious and not very secure. As repeating fields and human error are being attributed to most of the errors occurring, this reflects badly on the company‟s image. The dealership would therefore like to turn its manually kept information into a computerized database to help automate processes. In addition, at this point in time due to the amount of manual transactions, there is a large cost associated with keeping track of the cars currently in the dealership‟s possession. The owner, Archie, would like to reduce the losses and cut down unwanted costs and expenses by keeping track of all car sale transactions and information regarding the dealership‟s customers and sales agents. To do this effectively, Archie has decided to automate all administrative duties in relation to the process of recording car sale transactions and car display shows. When a customer is first interested in purchasing a car from the dealership, they complete a form that contains their personal details along with their desired car features (see Appendix 1 – “New Customer Questionnaire Form"). The dealership‟s business premise is to match cars with customers based on the features that a car has, and the features that a customer desires. The form lists the most basic categories of common car features (i.e. Comfort and Convenience, Safety and Security, etc.) but the complete list is far more extensive. Alternatively, some customers are motoring enthusiasts and leave the features section blank on the form. Instead, they inquire directly to the sales agent about which car they are after. Furthermore, the dealership not only records which features a car contains, but also its model and the car manufacturer. In the car industry, many manufacturers follow what is known as a „product line architecture‟. This means that rather than wasting time and money on a brand new model design, the manufacturer would rather make small changes to an already markettested model. For each model, its type must be recorded (e.g. sedan, 4WD, etc.) and its previous model, if applicable. For each manufacturer, its name and region (i.e. Europe, Asia, Oceania, etc.) must be recorded. Archie offers a VIP program where customers can subscribe to become VIPs of the dealership. This program is designed to entice customers to have a long-term relationship with the company. In addition, the dealership organizes contests every month where VIPs can win monetary prizes and other spontaneous gifts. If a customer decides to become a VIP, he/she has an option to create a user account on the company‟s website in order to participate in these contests. Information that must be recorded about each contest includes the contest number, the starting and ending dates, along with the prize description. Participation in contests is not compulsory; therefore the user accounts participating in a contest and the winner must also be recorded. CSE4DBF (2015) – Assignment 1, Part 1 Page 3/6 Once the customer has decided to purchase a specific vehicle after conversing with one of the dealership‟s sales agents, a Bill Of Sale is completed to follow regulations (see Appendix 2 – “Vehicle Bill Of Sale Form"). The car‟s 17 digit VIN number is recorded, along with the customer‟s and sales agent‟s details. In addition to the fields contained in Appendix 2, the dealership also keeps track of the date that the car entered the dealership, the price that the dealership paid for the car, and the price that the car is on sale for. At the dealership, there is a hierarchy amongst the sales agents. Senior agents are the most experienced and best negotiators. Each senior agent is assigned to supervise at least one junior agent. Each junior agent has only one supervisor. When a junior agent is promoted to senior, the date of promotion must be recorded. This is due to the commission policy at Archie‟s Luxury Motors. Senior agents receive a commission for each sale where the agreed price with the customer is greater than the “for sale” price in the database (the asking price). The actual amount of commission depends on how many years that the agent has been a senior for. For example, for an agent who has been a senior for 5 years, the commission for a sale would be calculated as: (AgreedPrice – AskingPrice) * 5%, where the agreed price is greater than the asking price. Note that the percentage amount is always calculated in full years. For all sales agents, their ID, name and date of birth is also recorded. Given that the dealership is situated on an extensive block of land, Archie decided to construct a multi-million dollar car showroom and test track in order to boost revenue. The dealership offers the chance for a group of people (known as a Viewing Party) to come and view/test drive exotic cars on premise (see Appendix 3 – “Viewing Party Form"). To boost market research, Archie offers special deals to viewing parties who are part of an organization or those who are international guests. The success of Archie‟s viewing parties has recently led to many international businesses hosting special work functions at the dealership. It is important to note that some cars are so breathtaking that it is common for the same viewing party to view a particular car more than once. Discounts are offered to viewing parties who make more than three visits in a calendar year. TASKS: 1. You are required to develop an EER model for the above problem description. The ER should contain all necessary information such as entities, attributes, primary keys, relationships (including specialization/generalization if any), cardinalities, and participation (including (min, max)). You must have at least one specialization/generalization or union type in your EER diagram. Any assumptions should also be stated clearly. If assumptions are made, it is important to make sure that the assumptions reflect possible real practice for a car dealership and do not contradict with the problem description above. Assignment should be typed, not written/drawn by hand. Use CASE tool or any software to draw figures in your assignment. [75%] 2. Apply Normalization Techniques (Bottom-Up approach) on Appendices 1, 2 and 3 to come up with BCNF tables.

Archie‟s Luxury Motors

Answer in Detail

Solved by qualified expert

Get Access to This Answer

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Hac habitasse platea dictumst vestibulum rhoncus est pellentesque. Amet dictum sit amet justo donec enim diam vulputate ut. Neque convallis a cras semper auctor neque vitae. Elit at imperdiet dui accumsan. Nisl condimentum id venenatis a condimentum vitae sapien pellentesque. Imperdiet massa tincidunt nunc pulvinar sapien et ligula. Malesuada fames ac turpis egestas maecenas pharetra convallis posuere. Et ultrices neque ornare aenean euismod. Suscipit tellus mauris a diam maecenas sed enim. Potenti nullam ac tortor vitae purus faucibus ornare. Morbi tristique senectus et netus et malesuada. Morbi tristique senectus et netus et malesuada. Tellus pellentesque eu tincidunt tortor aliquam. Sit amet purus gravida quis blandit. Nec feugiat in fermentum posuere urna. Vel orci porta non pulvinar neque laoreet suspendisse interdum. Ultricies tristique nulla aliquet enim tortor at auctor urna. Orci sagittis eu volutpat odio facilisis mauris sit amet.

Tellus molestie nunc non blandit massa enim nec dui. Tellus molestie nunc non blandit massa enim nec dui. Ac tortor vitae purus faucibus ornare suspendisse sed nisi. Pharetra et ultrices neque ornare aenean euismod. Pretium viverra suspendisse potenti nullam ac tortor vitae. Morbi quis commodo odio aenean sed. At consectetur lorem donec massa sapien faucibus et. Nisi quis eleifend quam adipiscing vitae proin sagittis nisl rhoncus. Duis at tellus at urna condimentum mattis pellentesque. Vivamus at augue eget arcu dictum varius duis at. Justo donec enim diam vulputate ut. Blandit libero volutpat sed cras ornare arcu. Ac felis donec et odio pellentesque diam volutpat commodo. Convallis a cras semper auctor neque. Tempus iaculis urna id volutpat lacus. Tortor consequat id porta nibh.

28 More Pages to Come in This Document. Get access to the complete answer.

MyAssignmenthelp.com has been helping students of USA for over a decade now. We have dedicated teams of experts who provide assignment help to students in New York City, Boston, Chicago, etc. Owing to their extensive knowledge and years of experience in academic writing, they successfully cater to searches can someone do my assignment in USA or can experts write my assignments.

More Archie‟s Luxury Motors: Questions & Answers

Q

One slide Presentation. of Family Life & Community in Black Country in 1800 centuries, Include how they lived, how hard they worked, social life & etc ...

View Answer
Q

Identify the various components of the health sector and evaluate their importance in the delivery of health care & Understand and compare the theory and practice of managing operational systems in health organisationsin New Zealand ...

View Answer
Q

Explain clearly in which condition somebody can or cannot claim fringe benefits and state whether emma can or cannot claim fringe benefit. ...

View Answer
Q

Choose a public health issue, a population and a population group of personal interest.  You will be required to choose: 1. A specific communicable disease, non-communicable disease or injury 2. One of the following populations: ï‚· Australia ï‚· Another country or global region 3. A po ...

View Answer

Content Removal Request

If you are the original writer of this content and no longer wish to have your work published on Myassignmenthelp.com then please raise the content removal request.

Choose Our Best Expert to Help You

expert
student rating student rating student rating student rating student rating
Matias Burton

Ph.D. in English Literature from Brown University

900 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Ryan Williams

Master's in Ancient History

13 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Lowe Short

PhD in Statistics with Specialization in Statistical Computing

600 - Completed Orders

Hire Me
expert
student rating student rating student rating student rating student rating
Carson Bragg

PhD in Management with Specialization in Project Management

3158 - Completed Orders

Hire Me

Still in Two Minds? The Proof is in Numbers!

33845 Genuine Reviews With a Rating of 4.9/5.

student rating student rating student rating student rating student rating
09 Dec 2021

Audit

Essay: 12 Pages, Deadline: 16 days

Tutor wrote a good essay , with all references, this assignment is highly recommended

flag User ID: 8***60 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
09 Dec 2021

Audit

Course Work: 1 Page, Deadline: 1 day

happy with the content they provided me and was able to get a good grade in the assessment

flag User ID: 2***65 North fitzroy, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Assignment

Essay: 3 Pages, Deadline: 2 days

Impecable work, a fantastic Essay, Grammar and punctuation flawless. The concept explained in details. all sources cited correctly

flag User ID: 6***40 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 2 Pages, Deadline: 9 days

Thank you for the hard work and help on my assignment, I got an A and I will be using this expert again.

flag User ID: 5***56 San Francisco, United States

student rating student rating student rating student rating student rating
08 Dec 2021

Statistics

Course Work: 1 Page, Deadline: 14 hours

Great service. Quick response time. I was very satisfied with the chat responses and the work I have got

flag User ID: 8***62 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Geography

Programming: 2 Pages, Deadline: 2 days

first i want to appreciate your help, thank you so much, it was an amazing job, on time, organized, I am really satisfied with what they have done to ...

flag User ID: 8***26 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Assignment

Essay: 3 Pages, Deadline: 13 hours

perfect explanation well explained no plagiarism. i was not marked for any grammar or spelling

flag User ID: 8***81 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Database

Programming: 2 Pages, Deadline: 8 days

ho can i put this , keep been great and keep helping people cause you all really done help me out a lot of time and i am keep using you all website un ...

flag User ID: 5***08 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Programing

Programming: 10 Pages, Deadline: 7 days

excellent work..great writing...on time delivery super expert...excellent work..great writing...on time delivery super expert....excellent work..great ...

flag User ID: 4***78 London, Great Britain

student rating student rating student rating student rating student rating
08 Dec 2021

Civil Engineering

Course Work: 1 Page, Deadline: 13 hours

it was very fast and convenience, i feel very confidence, quick response very expert no long wait till they assign my assignment. thank you so much.

flag User ID: 8***26 United States

student rating student rating student rating student rating student rating
09 Dec 2021

Audit

Essay: 12 Pages, Deadline: 16 days

Tutor wrote a good essay , with all references, this assignment is highly recommended

flag User ID: 8***60 United Kingdom, Great Britain

student rating student rating student rating student rating student rating
09 Dec 2021

Audit

Course Work: 1 Page, Deadline: 1 day

happy with the content they provided me and was able to get a good grade in the assessment

flag User ID: 2***65 North fitzroy, Australia

student rating student rating student rating student rating student rating
08 Dec 2021

Assignment

Essay: 3 Pages, Deadline: 2 days

Impecable work, a fantastic Essay, Grammar and punctuation flawless. The concept explained in details. all sources cited correctly

flag User ID: 6***40 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Management

Assignment: 2 Pages, Deadline: 9 days

Thank you for the hard work and help on my assignment, I got an A and I will be using this expert again.

flag User ID: 5***56 San Francisco, United States

student rating student rating student rating student rating student rating
08 Dec 2021

Statistics

Course Work: 1 Page, Deadline: 14 hours

Great service. Quick response time. I was very satisfied with the chat responses and the work I have got

flag User ID: 8***62 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Geography

Programming: 2 Pages, Deadline: 2 days

first i want to appreciate your help, thank you so much, it was an amazing job, on time, organized, I am really satisfied with what they have done to ...

flag User ID: 8***26 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Assignment

Essay: 3 Pages, Deadline: 13 hours

perfect explanation well explained no plagiarism. i was not marked for any grammar or spelling

flag User ID: 8***81 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Database

Programming: 2 Pages, Deadline: 8 days

ho can i put this , keep been great and keep helping people cause you all really done help me out a lot of time and i am keep using you all website un ...

flag User ID: 5***08 United States

student rating student rating student rating student rating student rating
08 Dec 2021

Programing

Programming: 10 Pages, Deadline: 7 days

excellent work..great writing...on time delivery super expert...excellent work..great writing...on time delivery super expert....excellent work..great ...

flag User ID: 4***78 London, Great Britain

student rating student rating student rating student rating student rating
08 Dec 2021

Civil Engineering

Course Work: 1 Page, Deadline: 13 hours

it was very fast and convenience, i feel very confidence, quick response very expert no long wait till they assign my assignment. thank you so much.

flag User ID: 8***26 United States

5% Cashback

On APP - grab it while it lasts!

Download app now (or) Scan the QR code

*Offer eligible for first 3 orders ordered through app!

screener
ribbon
callback request mobile
Have any Query?