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