[SOLVED] Cs2102 – your company, apasaja pte ltd, has been commissioned to design and implement a database application to record information about car rental operation for the pinjamobil pte ltd. the application stores and manages historical information about the customers and cars.

The application also stores and manages information about the cars. A specific car is identified by their license plate with the color of the car recorded. The current scheme for license plate starts with letter S followed by two letters, four digits, and the final checksum letter (see: Wikipedia). The brand and the model of each car are also recorded, which we call as the make of the car.
The application also tracks all passenger information of a car that are being rented. If a car is not currently being rented, there should be no passenger. For simplicity, the passenger will ride for the entire duration of the rented car. So if a car is being rented in the interval [s, e], then any passenger of this car will ride in the car for the entire interval [s, e].
References
Page 2
1. (3 points) Creating and Populating Tables with Constraints
(a) (3 points) DDL
Write the SQL Data Definition Language (DDL) code, CREATE TABLE with integrity constraints, to create the necessary table(s) for storing the data required by the application. Ensure all necessary data can be accommodated, and avoid catering for unnecessary, inconsistent, or unnecessarily redundant data. Propagate updates to maintain referential integrity. Only propagate deletions where it make sense.
(b) (0 points) DML
Other random data can be found from Mockaroo. There is a car make in Mockaroo but it is closer to brand in our terminology. Although technically the model year matters for capacity, we will simplify the problem by ignoring this information.
Use this data to write SQL Data Manipulation Language (DML) code to populate the database.
Submission
• Canvas Submission: “Assignments > Questions 1” (one file per project group)
• Files
– SQL DDL: schema.sql
Ensure that schema.sql can be executed on a fresh database.
– SQL DML: data.sql
Page 3