Please use SQLiteStudio to showcase the work.
Requirements: 1. Select one of the cases from the pool in this document. 2. Study the business scenario and make necessary assumptions. 3. Plan for core features to be supported. 4. Design a database for the data model. 5. Prepare test data and produce test results. 6. Furnish a technical report stating: business needs database design test results assumptions and limitations conclusion . . . . Case 1 - Vehicle rental services Healthy Cycling Rental Services provides various types of bicycles for rent, especially on holidays. Customers are not required to register for memberships. On the contrary, a deposit per vehicle is to be paid by the customers. A database is to be designed to handle this based on the following Deposit Form. Healthy Cycling Rental Services Deposit Form Name David Chung Phone 9003 0288 Date 7 March Vehicle ID Vehicle Type Deposit 200 H352 R160 | Type F Type . Type K 100 Y638 100 400 Deposit Time returned Time started 11:45 1 hour Rent and Deposit Type Description A Bicycle for adult K Tricycle for kid F 4 wheels Family Size 2 hours Whole Day 40 60 Deposit 150 25 20 35 50 100 50 70 90 200 sample data for illustration only Additional information: Based on a phone number, a customer can have only one transaction per day. Each transaction can rent for one or more vehicles. Deposit has to be paid before taking the vehicles. Hours of hire are rounded up to complete hour. Rents will be computed upon returns of all the vehicles in the transaction. Balance will be settled as Deposit minus Rents. . Assumptions: The company has sufficient vehicles for rent. The condition of each vehicle is good for rent. Customers would return vehicles in proper condition on the same day. Deposit will not be refunded if customers cannot return the vehicles on the same day. Requirements: 1. Select one of the cases from the pool in this document. 2. Study the business scenario and make necessary assumptions. 3. Plan for core features to be supported. 4. Design a database for the data model. 5. Prepare test data and produce test results. 6. Furnish a technical report stating: business needs database design test results assumptions and limitations conclusion . . . . Case 1 - Vehicle rental services Healthy Cycling Rental Services provides various types of bicycles for rent, especially on holidays. Customers are not required to register for memberships. On the contrary, a deposit per vehicle is to be paid by the customers. A database is to be designed to handle this based on the following Deposit Form. Healthy Cycling Rental Services Deposit Form Name David Chung Phone 9003 0288 Date 7 March Vehicle ID Vehicle Type Deposit 200 H352 R160 | Type F Type . Type K 100 Y638 100 400 Deposit Time returned Time started 11:45 1 hour Rent and Deposit Type Description A Bicycle for adult K Tricycle for kid F 4 wheels Family Size 2 hours Whole Day 40 60 Deposit 150 25 20 35 50 100 50 70 90 200 sample data for illustration only Additional information: Based on a phone number, a customer can have only one transaction per day. Each transaction can rent for one or more vehicles. Deposit has to be paid before taking the vehicles. Hours of hire are rounded up to complete hour. Rents will be computed upon returns of all the vehicles in the transaction. Balance will be settled as Deposit minus Rents. . Assumptions: The company has sufficient vehicles for rent. The condition of each vehicle is good for rent. Customers would return vehicles in proper condition on the same day. Deposit will not be refunded if customers cannot return the vehicles on the same day
