Modelado-y-SQL

Assignment for KeepCoding-Glovo Women in Tech Bootcamp. I created a database that holds information about company cars.

diagram.png

Entity-Relationship Diagram of the model

Crear-bd.sql

Script with DDL and DML to create and fill the model

Consulta-coches.sql

Query that returns a table with all of the cars, its model, brand, car group, date of purchase, license, color, total of kilometers, their insurance company, and their insurance number