Build a API backend using Python and Flask (Flask can be changed)
Budget: $30 – $250 USD
We have all the excel files with the data to be imported into a MSSQL SERVER express database
Then you need to create an erd diagram
and code the api
The price field in the diagram needs to call another free currency converter to convert from dollars to the 7 countries used in the project (Not live just when we run a call to the endpoint)
The project is to build a backend API for a car dealership , its a studies project and doesn't have to be perfect
No frontend is required
Any fake data can be used , we have sheets with excel data
It can run on our local host pc
It needs a Authentication and Authorization part also
7 Coutries
49 Branches related to 7 countries
Customer who buys the car
Employee who works at branch
Modification if you want to install parts on your car
Modification inventory 1 per country to store parts and delivers to branch of same country
Modification supplier 1 per country that makes the parts and delivers it to inventory
Motor plan which can be added to a vehicle
Vehicle which are vehicles on the branch floor displayed
Vehcile inventory which stores the cars and send it to the branch as per order
Vehcile supplier which sends the vehicle to the inventory in the same country
Order to order a car for purchase
Order to order modification parts
Order to order a motor plan for a car
Explanation of the Car delarship
There are 7 countries each country has multiple branches 49 Branches in total Shown in the Branch Table
Each Country has multiple banks
Each Branch has multiple vehicles
Multiple Braches from the same country can order a car from One ineventoy in the same country
Each branch has Multiple Employees
Multiple Customer belongs to one Branch (For simplicty)
One Vehicle can have multiple Modication parts
One modifcation part can only belong to one Modification inventory
One Country has one inventory with multiple modification parts
One motor plan can only belong to one Vehicle
One Vehcile has only one customer
One vehicle was sold by only one Employee
One customer can purchase multiple vehicles
One vehicle id has only one customer
Each country has one inventory
One Customer fills in order one order form for Vehicle purchase thats the Order vehicle Table
One Customer fills in one order modification form thats the Modification Order table
Multiple branches can order from one Inventoy ony thats in their country
Then you need to create an erd diagram
and code the api
The price field in the diagram needs to call another free currency converter to convert from dollars to the 7 countries used in the project (Not live just when we run a call to the endpoint)
The project is to build a backend API for a car dealership , its a studies project and doesn't have to be perfect
No frontend is required
Any fake data can be used , we have sheets with excel data
It can run on our local host pc
It needs a Authentication and Authorization part also
7 Coutries
49 Branches related to 7 countries
Customer who buys the car
Employee who works at branch
Modification if you want to install parts on your car
Modification inventory 1 per country to store parts and delivers to branch of same country
Modification supplier 1 per country that makes the parts and delivers it to inventory
Motor plan which can be added to a vehicle
Vehicle which are vehicles on the branch floor displayed
Vehcile inventory which stores the cars and send it to the branch as per order
Vehcile supplier which sends the vehicle to the inventory in the same country
Order to order a car for purchase
Order to order modification parts
Order to order a motor plan for a car
Explanation of the Car delarship
There are 7 countries each country has multiple branches 49 Branches in total Shown in the Branch Table
Each Country has multiple banks
Each Branch has multiple vehicles
Multiple Braches from the same country can order a car from One ineventoy in the same country
Each branch has Multiple Employees
Multiple Customer belongs to one Branch (For simplicty)
One Vehicle can have multiple Modication parts
One modifcation part can only belong to one Modification inventory
One Country has one inventory with multiple modification parts
One motor plan can only belong to one Vehicle
One Vehcile has only one customer
One vehicle was sold by only one Employee
One customer can purchase multiple vehicles
One vehicle id has only one customer
Each country has one inventory
One Customer fills in order one order form for Vehicle purchase thats the Order vehicle Table
One Customer fills in one order modification form thats the Modification Order table
Multiple branches can order from one Inventoy ony thats in their country