Find Jobs
Hire Freelancers

database of an automobile company...urgent

$15-25 USD / hour

Завершено
Опублікований almost 9 years ago

$15-25 USD / hour

Project 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. client requests E-R Model • Construct an E-R diagram representing the conceptual design of the database. • Be sure to identify primary keys, relationship cardinalities, etc. 2. Relational Model • After creating an initial relational design from your E-R design, refine it based on the principles of relational design • Create the relations in database you used for earlier projects. • Create indices and constraints as appropriate. • If as you refine your design, you discover flaws in the E-R design, go back and change it (even if the earlier design passed the checkpoint.) Your final E-R design must be consistent with your relational design. 3. Populate Relations • Include enough data to make answers to your queries interesting and nontrivial for test purposes. • You may find it helpful to write a program to generate test data. 4. Queries: You should run a number of test queries to see that you have loaded your database in the way you intended. The queries listed below are those that your client (the manager from the package delivery company) wants turned in. They may provide further hints about database design, so think about them at the outset of the project. • Show sales trends for various brands over the past 3 years, by year, month, week. Then break these data out by gender of the buyer and then by income range. • Suppose that it is found that transmissions made by supplier Getrag between two given dates are defective. Find the VIN of each car containing such a transmission and the customer to which it was sold. If your design allows, suppose the defective transmissions all come from only one of Getrag’s plants. • 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. 5. Interfaces: There are several types of users who access the database. Each may need a special application • The database administrator (you) may use SQL either via the command line or SQL Developer. • The vehicle locator service needs a lookup application to check inventory both locally and at nearby dealers. This service allows a dealer to find a vehicle match the desires of a potential customer. Marketing may want to review these inquiries to do future product planning. • Online customers need an elegant Web interface to find dealers and check products, inventories, and prices. However, for this project, a command-line interface will suffice if your Web and/or GUI skills are not up to the challenge. (After all, this is a database course, not the Web Apps course, nor the User Interface course.) • The marketing department needs sales reports and may want to do special data mining and analysis. Provide them with a simple interface to generate some OLAP results. These interfaces can be built as  Web applications using Java applets or a scripting language.  A standalone Java application using Swing to create a GUI  Other GUI development tools you may know (but be sure they are platform independent, see note below) You can choose to implement any type of interfaces using any preferred programming languages. Upon completion and submission, you will get bonus points for your project.
ID проекту: 7579527

Про проект

13 пропозицій(-ї)
Дистанційний проект
Активність 9 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
Доручений:
Аватарка користувача
HI I have done Bachelors in Software Engineering and Masters in Computer Science . I assure you 100% quality work.
$17 USD за 5 дні(-в)
4,8 (2 відгуки(-ів))
1,6
1,6
13 фрілансерів(-и) готові виконати цю роботу у середньому за $22 USD/год.
Аватарка користувача
Hello Sir, I have done many similar systems. So I can build this system to you easily. I can deliver this system to you in 10 days. Also Please check my feedback. Looking forward to hear from you soon. Thanks.
$22 USD за 50 дні(-в)
5,0 (22 відгуки(-ів))
5,6
5,6
Аватарка користувача
Dear Friend, Database design expert here, I will provide you a very clear and good solution for your requirement. Kindly reply me, We will discuss more on this. Have a great day...! Thanks, Suresh
$20 USD за 25 дні(-в)
5,0 (16 відгуки(-ів))
5,1
5,1
Аватарка користувача
Hi, I am very much interested to work in your database of an automobile company. I am a php mysql,wordpress,javascript & css expert. I am ready to start with your project. we can discuss forward for this project
$22 USD за 10 дні(-в)
5,0 (12 відгуки(-ів))
4,6
4,6
Аватарка користувача
A proposal has not yet been provided
$22 USD за 3 дні(-в)
4,3 (29 відгуки(-ів))
5,4
5,4
Аватарка користувача
A proposal has not yet been provided
$29 USD за 39 дні(-в)
3,2 (69 відгуки(-ів))
7,4
7,4
Аватарка користувача
I'm Oracle Professional developer since 2000. You can contact with me at any moment to discuss your task.
$27 USD за 60 дні(-в)
5,0 (10 відгуки(-ів))
4,3
4,3
Аватарка користувача
A proposal has not yet been provided
$15 USD за 40 дні(-в)
4,1 (3 відгуки(-ів))
3,1
3,1
Аватарка користувача
I think I'm the best candidate for this project because, as I've read the details you gave, I became excited. It would be great to work on this project because I have tons of experience in database designing. Hope you pick me.
$22 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I am a database developer and DBA at finance company over 7 years. I have very good web programming skills and database experience. Thank you.
$22 USD за 8 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
La propuesta todavía no ha sido proveída
$22 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
I am a IBM DB2 certified associate, experienced programmer with MySQL database software and experienced Faculty on teaching Relational Database Management System both Computer and Mobile Devices.
$22 USD за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор UNITED STATES
hsdhsdhsh, United States
5,0
2
Спосіб оплати верифіковано
На сайті з квіт. 30, 2015

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.