MHB Modeling Relationships in a Supermarket: ER Model with Cardinalities

  • Thread starter Thread starter mathmari
  • Start date Start date
  • Tags Tags
    Model
AI Thread Summary
In a supermarket, each employee is associated with a unique employee number, name, address, and department, with each employee belonging to exactly one department. Departments have names, manage employees, and offer various items, which can be found in multiple departments. Each item has specific attributes, including description, supplier, sales price, and unique article numbers assigned by both the supplier and the supermarket. Suppliers provide items to the supermarket and have their own attributes, such as name, address, and delivery prices, with each item sourced from a single supplier but potentially at varying prices. The discussion centers on creating an ER model to represent these relationships and their cardinalities, with a focus on defining key attributes.
mathmari
Gold Member
MHB
Messages
4,984
Reaction score
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:
 
Last edited by a moderator:
Physics news on Phys.org
So far I have done the following :
1643740958824.png


Is that correct so far? :unsure:
 
Last edited by a moderator:

Thread 'Value of intuitionistic logic'

I'm taking a look at intuitionistic propositional logic (IPL). Basically it exclude Double Negation Elimination (DNE) from the set of axiom schemas replacing it with Ex falso quodlibet: ⊥ → p for any proposition p (including both atomic and composite propositions). In IPL, for instance, the Law of Excluded Middle (LEM) p ∨ ¬p is no longer a theorem. My question: aside from the logic formal perspective, is IPL supposed to model/address some specific "kind of world" ? Thanks.
View full post »

Thread 'Formal derivation of statement from Peano Arithmetic system'

I was reading a Bachelor thesis on Peano Arithmetic (PA). PA has the following axioms (not including the induction schema): $$\begin{align} & (A1) ~~~~ \forall x \neg (x + 1 = 0) \nonumber \\ & (A2) ~~~~ \forall xy (x + 1 =y + 1 \to x = y) \nonumber \\ & (A3) ~~~~ \forall x (x + 0 = x) \nonumber \\ & (A4) ~~~~ \forall xy (x + (y +1) = (x + y ) + 1) \nonumber \\ & (A5) ~~~~ \forall x (x \cdot 0 = 0) \nonumber \\ & (A6) ~~~~ \forall xy (x \cdot (y + 1) = (x \cdot y) + x) \nonumber...
View full post »

Similar threads

MHB Understanding Primary and Foreign Keys in Database Relations
Replies
7
Views
982
How Should Manage Be Represented in an ER Diagram for a Video Rental Company?
Replies
1
Views
8K
Please Review Database Tables for Advanced Database Class
Replies
2
Views
4K
Please Revise My Statement of Purpose
Replies
5
Views
11K
  • Sticky
Physics Forums Global Guidelines
Replies
2
Views
502K

Hot Threads

Recent Insights

Back
Top