Easy SQL Project

CLOSED
Bids
25
Avg Bid (USD)
$41
Project Budget (USD)
$10 - $30

Project Description:
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 required:
MySQL, Software Architecture, SQL
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$ 30
in 2 days
$ 30
in 0 days
$ 105
in 3 days
Hire mihaibejenariu
$ 126
in 3 days
$ 45
in 1 days
$ 54
in 3 days
$ 35
in 1 days
$ 66
in 3 days
$ 40
in 1 days
$ 25
in 3 days