Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- drop database if exists Autohaus;
- create database Autohaus;
- use Autohaus;
- create table autos(
- autokennzeichen varchar (20) not null,
- markedesAutos varchar (50) not null,
- baujahr varchar (10) not null,
- farbe varchar (20) not null,
- preis varchar (10) not null
- );
- create table kunden(
- name varchar (40) not null,
- nachname varchar (20) not null,
- telefonnummer varchar (30) not null,
- pkz varchar (30) not null,
- stadt varchar (50) not null
- );
- create table verkΓ€ufe(
- nummerdesVerkauf varchar (30) not null,
- datum varchar (20) not null,
- autokennzeichen varchar (20) not null
- autos_id int not null,
- constraint foreign key (autos_id),
- references autos (id),
- kunden_id int not null,
- constraint foreign key (kunden_id),
- references kunden (id)
- );
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement