Find Jobs
Hire Freelancers

Autombile Sales Database

$10-20 USD

完了済み
投稿日: 約6年前

$10-20 USD

完了時にお支払い
Application description: The application is an automobile company, such as General Motors, Ford, Toyota, or Volkswagen (or maybe a company from yesteryear like Studebaker, Hudson, Nash, or Packard). In our hypothetical company, it has been decided to redesign a major part of the database that underlies company operations. Unfortunately, the manager assigned to solicit database design proposals is not very computer literate and is unable to provide a very detailed specification at the technical level. Fortunately, you are able to do that. The company needs to keep quite a bit of data, but we shall focus on the following aspects of corporate operations. • vehicles. Each vehicle as a vehicle identification number (VIN). Lots of stuff is encoded in real VINs (they are well described on Wikipedia), but you can just make them up if you want. • brands: Each company may have several brands (for example, GM has Chevrolet, Pontiac, Buick, Cadillac, GMC, Saturn, Hummer, Saab, Daewoo, Holden, Vauxhall, and Opel and Volkswagen has Volkswagen, Audi, Lamborghini, Bentley, Bugatti, Skoda, and SEAT) • models: Each brand offers several models (for example, Buick’s models 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 body styles (4-door, wagon, etc.) • options: We’ll stick to color, and maybe engine and transmission. • dealers and customers: dealers buy vehicles from the manufacturer and sell them to customers. We’ll keep track of sales by date, brand, model, and color; and also by dealer. Note that a dealer may not sell some of the car company’s brands. Dealer’s keep some cars in inventory. Some of course, are already sold, but the dealer still keeps track of that fact. • suppliers: suppliers supply certain parts for certain models • company-owned manufacturing plants: Some plants supply certain parts for certain models; others do final assembly of actual cars. • customers: In reality, lots of demographic data are gathered. We’ll stick to name, address, phone, gender, and annual income for individual buyers. The customer may also be a company (e.g. Hertz, Avis, or other companies that maintain corporate fleets, but we’ll skip that). • We’ll skip data on corporate finance, pending bailouts, bankruptcy status etc. Not that these data are unimportant, but we need to keep the project within bounds. Queries: You should run a number of test queries to see that you have loaded your database in the way you intended. Construct and execute SQL queries for the following: • Show sales trends for various brands over the past 3 years, by year, month, week. • Find the top 2 brands by dollar-amount sold in the past year. • Find the top 2 brands by unit sales in the past year. • In what month(s) do convertibles sell best? • Find those dealers who keep a vehicle in inventory for the longest average time.
プロジェクト ID: 16329427

プロジェクトについて

4個の提案
リモートプロジェクト
アクティブ 6年前

お金を稼ぎたいですか?

Freelancerで入札する利点

予算と期間を設定してください
仕事で報酬を得る
提案をご説明ください
登録して仕事に入札するのは無料です
アワード者:
ユーザーアバター
I am expert of Database Development. I also have one I am sure you you will the ER diagram which I have related to vehicle company Feel free to contact me .....................................................................
$20 USD 10日以内
4.7 (6 レビュー)
3.4
3.4
この仕事に4人のフリーランサーが、平均$111 USDで入札しています
ユーザーアバター
The job is quite intricate and laborious. Most boring part is creating test data without which you cannot test.
$111 USD 10日以内
0.0 (0 レビュー)
0.0
0.0

クライアントについて

ALBANIAのフラグ
Tirane, Albania
5.0
1
お支払い方法確認済み
メンバー登録日:2月 19, 2018

クライアント確認

ありがとうございます!無料クレジットを受け取るリンクをメールしました。
メールを送信中に問題が発生しました。もう一度お試しください。
登録ユーザー 投稿された仕事の合計
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
プレビューを読み込み中
位置情報へのアクセスが許可されました。
あなたのログインセッションの有効期限がきれ、ログアウトされました。もう一度ログインしてください。