Closed

Easy SQL Project

I need to create a script in SQL server based on this statement :

The company " Rent a Car Crash " has hired you to design a database that will store . The company has a fleet of vehicles , each vehicle is uniquely identified by its license plate number. In addition , there is important information such as model, year , type of gear , the vehicle make and the daily rate in colones rental concept . The company keeps information about its customers, which are identified by their passport number. It is important to keep information on the name, date of birth, nationality. There are several types of policies , some of which are compulsory acquisition , other optional , a client should or can acquire when you rent a car . It is therefore necessary to have information about the policy code , description , cost and whether or not mandatory.

Every time a client requests a rental vehicle, you need to save information about that holiday with a single row , the record date of the transaction, the date on which the vehicle will be given to the client , the date returned and the customer making the reservation and the cost, which should be calculated automatically by a trigger based on the number of rental days and the cost of the rented vehicle. Each reservation you must add the ( s ) mandatory policies automatically (use a trigger for this action ) .

tasks :

5 Tables created correctly

4 Relationships created correctly

2 Triggers created correctly.

**Reserverd budget, if you go to up, I will not adjuticate the project to you.

Skills: MySQL, Software Architecture, SQL

See more: which car rental, vehicles rental, vehicle rental company, vehicle on rent, vehicle for rental, to rent a car, the rent a car, rent vehicles, rent vehicle, rent to car, rent the car, rent sql server, rent s car, rent rental car, rent rent a car, rent on car, rent of car, rent it car, rent for car, rent for a car, rent car in, rent car company, rent as car, rent a rental car, rent and car

About the Employer:
( 1 review ) -, Costa Rica

Project ID: #5216714

24 freelancers are bidding on average $42 for this job

dobreiiita

Hey, I also placed a bid on the previous project you posted.... I can get the work done. Please communicate. thanks

$30 USD in 2 days
(70 Reviews)
5.9
it2051229

Hi, I am placing my bid on your project because I have read the requirements and I am confident enough with my Database skills. I am focused mostly on doing computer science homework here in [url removed, login to view] and I would More

$30 USD in 0 days
(85 Reviews)
5.5
ielkfarna

Dear Sir, I am Professional Software Developer, I am Linux Advanced Developer, I am Database Developer and designer. I can Handle your job and do everything extremely Grate. Regards,

$105 USD in 3 days
(31 Reviews)
5.4
mihaibejenariu

• Over 15 years’ experience as Software Developer using almost all Microsoft technologies. • 12 years' experience with SQL Server including last version SS2012. • 4 years as Technical Leader. • 2 years of internatio More

$126 USD in 3 days
(82 Reviews)
5.3
manhpham

Hi there. I am senior developer from Vietnam. I have been working on this site for 2 years. I am interested in your [url removed, login to view] let's me help you. I can start now. Thank you so much

$45 USD in 1 day
(25 Reviews)
4.7
elboukharimu

Hi I'm very interested helping you doing your sql project, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is s More

$54 USD in 3 days
(21 Reviews)
4.7
rakib062

Hi, I am a graduate in CS and working as a database designer and developer for 3+ years. I have done lots of assignments both in academic courses and in freelancer.com. I assure you of clean, efficient code with p More

$35 USD in 1 day
(14 Reviews)
4.5
Reza2012

Hi I have more than 10 years experience in database design and administration. please see my profile. Thanks.

$66 USD in 3 days
(14 Reviews)
4.2
mdakteruzzaman

HI, are you there? I have been working as Database Analyst more than 9 years. Earlier I completed B.Sc. Engg and M.Sc. Engg both in computer engineering. Thanks

$40 USD in 1 day
(13 Reviews)
4.1
NourElDeen

Dear Sir, I'm interested on doing your project............................... Kind Regards, NourElDeen

$25 USD in 3 days
(17 Reviews)
3.8
VjCoder

Hi! This is very easy and i have done these Sql database creation projects many a times please see my profile for more confirmation and contact me if interested..Thanks!

$30 USD in 3 days
(5 Reviews)
3.6
truongnguyen86

Hi there, i'm expert in designing database and create trigger, package, store procedure..... Pls check my porfolio for the job i have done before. Waiting for feedback sir. P.S: I have done with similar vehicle jobs li More

$30 USD in 2 days
(8 Reviews)
3.3
zicmedia

We are exactly what you want We are a dynamic team with extensive experience in web design and PHP. See our profile. Have a good day

$55 USD in 1 day
(1 Review)
2.8
pankajgarg10

A proposal has not yet been provided

$10 USD in 3 days
(4 Reviews)
2.5
AliSafder

I have over 5 years of experience in Databases like Sql Server, Oracle, Microsoft Access and MySQL, Programming languages like .Net technologies(Asp.Net, Vb.Net / C#.net ) ,PHP, WordPress, SharePoint, VBA, C, C++ a More

$35 USD in 5 days
(4 Reviews)
2.3
TrackProgramming

yes it very simple project as you said iam database designer and development.............................................................................................

$28 USD in 4 days
(1 Review)
1.2
theneshk27

This is like a daily task which already do in my current job. I can easily tackle this peace of work.

$45 USD in 3 days
(1 Review)
0.0
maddykumar

i understood very well what r u looking for your project ..i have a very good experience with this ..u can contact me for this project ..

$30 USD in 3 days
(0 Reviews)
0.0
DNtakoulas

As you say easy for someone who knows. I can do it in 1 day, documented and 100% working. You'll get the sql scripts needed to create the database including comments for explanation. That's what you get if you choos More

$25 USD in 2 days
(0 Reviews)
0.0
SyIFwePiqjcH

Hi we are a team of freelance software developers, if you contact me at our website we can discuss the details of the project. w w w . s o l v e r . i o

$25 USD in 3 days
(0 Reviews)
0.0