subject
Chemistry, 14.02.2020 21:33 charleneubah3902

MoneyMaking supermarket chain wants to build a central database for keeping track of its branches, its employees, its inventory, as well as its sales. Design an ER schema for this supermarket chain, given the following requirements. Make any additional assumptions, as you find reasonable.

There are several stores that belong to the chain. For each store, we know the city where the store is located, and the address of the store. There is only one store in any city.

There are several employees who work at the supermarket chain. For each employee, we have a unique employeeID. We also know the employee’s address, year of joining, salary and rank (manager, sales assistant I etc). Any employee works at exactly one store.

There are several products that the supermarket does business in. Each product has a unique name, also each product has a category (such as produce, canned item etc). Example of products include milk, eggs etc.

Any store has several products, also for each product, we know the quantity available at the store.

We also have a list of customers; every customer has "Advantage Card". For each customer, we know his/her unique advantage card number, and address.

We also record sales at every store. Each sale has a saleID (which is unique), and the date of the sale. Each sale happened at a particular store, and involved a particular customer. Each sale also involves one or more products, and the quantity that was bought as part of this sale

ansver
Answers: 2

Another question on Chemistry

question
Chemistry, 22.06.2019 05:30
Liv sheldon given the balanced equation for an organic reaction: c2h2 + 2cl2 → c2h2cl4 this reaction is best classified as *
Answers: 1
question
Chemistry, 22.06.2019 07:00
At 450 mm hg a gas has a volume of 760 l, what is its volume at standard pressure
Answers: 2
question
Chemistry, 22.06.2019 11:40
Which type of precipitation would most likely form when the surface air temperature is slightly below freezing and the air temperature increases as you move upward away from the ground?
Answers: 2
question
Chemistry, 22.06.2019 17:30
98 points you will be galileo perform the experiment to determine if objects with different mass fall at the same, or different, rates in the air and in a vacuum. before you conduct your experiment, you need to form a hypothesis. a hypothesis is a prediction of what you think will happen in the experiment. the hypothesis is a statement that describes “if” a certain set of circumstances are present “then” there will be a specific result that will occur. record your hypothesis here: record the results from step one of the experiment (dropping the objects in the air): first trial: second trial: third trial: record the results from step two of the experiment (dropping the objects in a vacuum): first trial: second trial: third trial: did the experiment support your hypothesis? using the data from your experiment, describe why you believe your hypothesis was either proven or disproven. what forces were acting on the objects dropped in the air? what force was acting on the objects dropped in the vacuum? part two: comparing forces choose two forces and compare and contrast these forces. you must provide two ways that they are alike and two ways that they are different. you may make a list, write in paragraph form, or make a chart. choose two forces and compare and contrast these forces. these must be different forces than used in the prior question. provide two ways that they are similar and two ways that they are different. you may make a list, write it out, or make a chart.
Answers: 3
You know the right answer?
MoneyMaking supermarket chain wants to build a central database for keeping track of its branches, i...
Questions
question
Mathematics, 16.09.2019 22:50
question
History, 16.09.2019 22:50
question
Biology, 16.09.2019 22:50
Questions on the website: 13722363