A relational database for the preowned car online marketplace will be responsible for effectively storing all the data related to user information, products, advertisements, and bids.
Endlesspeed is a pre-owned car dealership located in Indonesia. Endlesspeed plans to develop a website to simplify buying and selling pre-owned cars on its platform. For this purpose, a data engineer or someone responsible focuses on creating a relational database that is well-designed and efficient. The database will be responsible for effectively storing all the data related to user information, products, advertisements, and bids.
- Providing a platform that connects members and buying and selling services
- Store user information and products
- Manage price bidding and car advertising
- Each user can offer more than one used car product.
- Before selling car products, users must provide their personal data, such as name, contact information, and location of domicile.
- Users offer their products through advertisements that will be displayed on the website.
- This advertisement contains the title, detailed product information, and the seller's contact information.
- Each user can search for cars on offer based on the seller's user location, car brand, and car body type.
- If a potential buyer is interested in a car, he can bid on the product price if the seller allows the bargaining feature.
- Purchase transactions are carried out outside the application and not within the project scope.
The following Entity-Relational Diagram is generated from the six tables that have been created.
PostgreSQL 16
Unless specified otherwise, the database and its code in this repository are licensed under the GPLv3 license. Refer to the LICENSE file for more information.