This is a database about a car dealership that sells and services cars. It stores information about customers, bills, cars, manufacturers and salesmen who work in the dealership.
DDL commands
- Making the database.
- DDL Commands for creating tables.
Entering data into tables
CRUD
- CRUD commands are here
- Tests for task 6.
Indexes for tables
Task about views
- Postgres views
2 Stored function
2 Triggers
P.S.: These observation were made after inserting additional data from bill_extra_inserts.sql. Since otherwise there is too little data.
Using python, the following data about the most expensive cars and the contribution of salesmen have been made:
- Top 10 most expensive cars (result from analysis-1.py):
- Contribution of each salesman to total revenue (result from analysis-2.py):
