Easy SQL Project
This project received 25 bids from talented freelancers with an average bid price of $41 USD.Get free quotes for a project like this
Project Budget$10 - $30 USD
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 ) .
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.
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online