- #1
mathmari
Gold Member
MHB
- 4,984
- 7
Hey! 
In a supermarket, there are the following relationships: For each employee (Angestellter), there are employee numbers (AngNr), last name (Name), first name (Vorname), address (Adresse) and department (Abteilung) known. Each employee works in exactly one department. Of each department knows their name (Name), their employees (Angestellte), the responsible manager (Manager) and the items (Artikel) offered.
An item can be offered in several departments. Description (Bezeichnung), supplier (Lieferant), sales price (Verkaufspreis) and an article number (Artikelnummer) assigned by the supplier as well as by the supermarket. From each supplier the name (Name), address (Adresse) and items (Artikel) delivered to the supermarket with delivery prices are known. An article is supplied by exactly one supplier, but can be supplied at different prices.
Represent these relationships in an ER model with cardinalities and define suitable ones key attributes.Does this mean that we have to make a graph with how these attributes are related ? :unsure:
Do we have the attributes employee, department, article, supplier ? :unsure:
In a supermarket, there are the following relationships: For each employee (Angestellter), there are employee numbers (AngNr), last name (Name), first name (Vorname), address (Adresse) and department (Abteilung) known. Each employee works in exactly one department. Of each department knows their name (Name), their employees (Angestellte), the responsible manager (Manager) and the items (Artikel) offered.
An item can be offered in several departments. Description (Bezeichnung), supplier (Lieferant), sales price (Verkaufspreis) and an article number (Artikelnummer) assigned by the supplier as well as by the supermarket. From each supplier the name (Name), address (Adresse) and items (Artikel) delivered to the supermarket with delivery prices are known. An article is supplied by exactly one supplier, but can be supplied at different prices.
Represent these relationships in an ER model with cardinalities and define suitable ones key attributes.Does this mean that we have to make a graph with how these attributes are related ? :unsure:
Do we have the attributes employee, department, article, supplier ? :unsure:
Last edited by a moderator:
