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.
24 freelancers are bidding on average $42 for this job
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,
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
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
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!
yes it very simple project as you said iam database designer and development.............................................................................................