Costumer Management

Please follow our Format Conventions

Database

Which entities do you need?

---

Adresse

• adressID NUMBER(4) PRIMARY KEY
• straße VARCHAR2(40)
• ort VARCHAR2(40)
• plz NUMBER(4)

Person

• persID NUMBER(4) PRIMARY KEY
• vorname VARCHAR2(40)
• nachname VARCHAR2(40)
• adressID NUMBER(4) FOREIGN KEY

Member

• persID NUMBER(4) PRIMARY KEY, FOREIGN
• email VARCHAR2(40)
• passwort VARCHAR2(40)

RestaurantOwner

• persID NUMBER(4) PRIMARY KEY, FOREIGN
• email VARCHAR2(40)
• passwort VARCHAR2(40)

Restaurant

• persID NUMBER(4) PRIMARY KEY, FOREIGN
• restaurantID NUMBER(4) PRIMARY KEY
• name VARCHAR2(40)
• laengengrad NUMBER(12,9)
• breitengrad NUMBER(12,9)

Newsletter

• newsletterID NUMBER(4) PRIMARY KEY
• restaurantID NUMBER(4) PRIMARY KEY, FOREIGN
• text VARCHAR(40)

Discount

• discountID NUMBER(4) PRIMARY KEY
• restaurantID NUMBER(4) PRIMARY KEY, FOREIGN
• discount NUMBER(3)

---