1461844139_90060432.jpg

ER Diagram of car insurance Company


ER diagramI am working on a tiny uni database task, I wish to determine if my ER design is good enough for me to move to further steps.

Additional steps involve: Translating ER to Relational diagram, and essentially apply it as a database for a database application, in which individual can search and browse stuff through a program.

Discover the project information:

The application form is a vehicle business, such as for example General Motors, Ford, Toyota, or Volkswagen (or possibly an organization from yesteryear like Studebaker, Hudson, Nash, or Packard). Within hypothetical business, it's been made a decision to redesign a major the main database that underlies business businesses. Unfortunately, the supervisor assigned to solicit database design proposals is not very computer literate and is not able to offer a tremendously detail by detail requirements at technical degree. Thankfully, you certainly can do that. The business needs to hold a substantial amount of data, but we shall concentrate on the following areas of business businesses.

  • Cars: each vehicle as a vehicle recognition number (VIN). Plenty of material is encoded in real VINs (these are generally well described on Wikipedia), you could simply cause them to up if you need.
  • Brands: each organization might have several companies (for instance, GM has actually Chevrolet, Pontiac, Buick, Cadillac, GMC, Saturn, Hummer, Saab, Daewoo, Holden, Vauxhall, and Opel and Volkswagen has actually Volkswagen, Audi, Lamborghini, Bentley, Bugatti, Skoda, and CHAIR)
  • Models: each brand offers several models (for instance, Buick’s designs are the Enclave, LaCrosse, and Lucerne, and Mercury’s models are the Mariner, Milan, Sable, and Grand Marquis). Each model may come in a variety of human anatomy styles (4-door, wagon, etc.)
  • Options: we’ll stick to color, and possibly engine and transmission.
  • Dealers and clients: dealers purchase cars from producer and sell them to customers. We’ll keep track of product sales by time, brand name, model, and shade; and in addition by supplier. Note that a dealer might not offer any of the car company’s companies. Dealer’s keep some vehicles in inventory. Some, naturally, are already sold, although dealer still monitors that fact.
  • Vendors: vendors supply specific parts for several designs.
  • Company-owned manufacturing flowers: some plants supply specific parts for several models; other people do final set up of real vehicles.
  • Clients: in reality, a lot of demographic data are gathered. We’ll adhere to name, target, phone, gender, and annual earnings for individual purchasers. The customer may also be a business (e.g. Hertz, Avis, or any other companies that maintain business fleets, but we’ll skip that).


Share this article




FAQ


avatar
Where can I get the Cheapest Car Insurance Quotes at Online? | Yahoo Answers

How can I find the cheapest car insurance for me? I just got my first car and I know I will prolly pay a lot for insurance but how can I check for deals? I am on a really tight budget but at the same time, I only have a second-hand car so I gotta make sure I get insurance that will pay out if I need to make a claim. Where can I get the cheapest car insurance for my car at, and how reliable is it if I need to claim??

How can I find the cheapest car insurance for me? I just got my first car and I know I will prolly pay a lot for insurance but how can I check for deals? I am on a really tight budget but at the same time, I only have a second-hand car so I gotta make sure I get insurance that will pay out if I need to make a...

avatar
What are the best ways to bring your car insurance down? - Quora

How can I find the cheapest car insurance for me? I just got my first car and I know I will prolly pay a lot for insurance but how can I check for deals? I am on a really tight budget but at the same time, I only have a second-hand car so I gotta make sure I get insurance that will pay out if I need to make a claim. Where can I get the cheapest car insurance for my car at, and how reliable is it if I need to claim??
Follow




Related Posts


Average cost of car insurance
Average cost of car insurance

Latest Posts
Credit cards that offer rental car insurance
Credit cards…
Many travel rewards credit cards provide…
Cheap Liability car insurance
Cheap Liability…
Find the most affordable automobile insurance…
Be Wiser car insurance reviews
Be Wiser car…
Okay guys, it’s time for you to get all…
List of insurance companies in Florida
List of insurance…
Nassau County, FL Listed: 01/28/2002…
Best Florida insurance companies
Best Florida…
Jill S. Schwartz & Associates…
Search
Featured posts
  • Average cost of car insurance
  • Average cost of car insurance by state
  • Classic car Insurance company
  • Average cost of car insurance in Florida
  • Country Company car insurance
  • Continental car Insurance Company
  • Company car Insurance Coverage
  • Best rated car Insurance Company
  • Rental car Insurance Coverage
Copyright © 2018 l www.floridainsurquotes.com. All rights reserved.