Base De Datos De Una Empresa Que Renta Autos

Create database Rent_Car
use Rent_Car
create table autos(idauto varchar(5) primary key not null,marca varchar(10),modelo intprecio_dia_renta real,
color varchar(10),
adicionalvarchar(20),
id_plaza int
constraint fk_plaza foreign key (id_plaza) references plaza_renta)

drop table autos
use Rent_Car
create table plaza_renta(id_plaza int primary key not null,nombre_pl varchar(10))

create table cliente(rfc_Cliente varchar(10) primary key not null,
Apellidop varchar(10),
Apellidom varchar(10),
Nombre varchar(10),NoLicencia int,
idauto varchar(5)
constraint fk_auto foreign key (idauto) references autos)

insert into plaza_renta values(1,'Aragon')
insert into plaza_renta values(2,'America')insert into plaza_renta values(3,'San Juan')
insert into plaza_renta values(4,'Lindavista')
insert into plaza_renta values(5,'Reforma')

select * from plaza_renta

insert into autosvalues('Tsu01','Nissan',2008,120.00,'Blanco','4 puertas',1)
insert into autos values('Che10','Chevy',2009,223.00,'Naranja','2 puertas',5)
insert into autos values('VW001','beetle',2010,180.00,'Amarillo','4puertas',4)
insert into autos values('Che20','Zafira',2000,251.00,'Negra','5 puertas',1)
insert into autos values('VW002','VolsW',1998,100.00,'Blanco','2 puertas',3)

insert into autosvalues('VW003','VolsW',2008,100.00,'Blanco','2 puertas',3)
insert into autos values('CAP05','Nissan',2010,100.00,'Dorado','5 puertas',3)
insert into autos values('VW004','beetle',2009,100.00,'Negro','2puertas',3)
insert into autos values('FOR04','Ford',1998,100.00,'Rojo','2 puertas',3)
insert into autos values('Aud07','Audi',2009,500.00,'Negro','4 puertas',3)
insert into autosvalues('BMW01','Taurus',2010,600.00,'Rojo','5 puertas',3)
insert into autos values('VW04','Jetta',2007,200.00,'Blanco','2 puertas',3)
insert into autos values('FOR02','Mustang',1990,100.00,'Blanco','2 puertas',3)

insert...