You have chosen to sponsor your bid up to a maximum amount of .
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.