AP&P is a vegetarian food supplier chain that operates in various branches in Singapore. The vegetarian food products are processed and manufactured locally. AP&P also sells ready to eat vegetarian meal package. All food is pre-packed, and AP&P owns the licenses for their packaged food supplies which are also supplied to local supermarkets, wet markets in various part of Singapore. Pre-packed food product is also sold to retailers. Customers can also directly pre-order online and is delivered by AP&P delivery service. a) There are 3 main factories in Singapore and each factory is managed by 2 managers. b) Each FACTORY is uniquely identified by factory id and location (city). c) Each FACTORY may or may not have kitchen helpers and delivery staff. d) Each STAFF are uniquely identified by staff id, name, factory id. e) Each RETAILER is uniquely identified by retailer id, name, and location. f) There are total of 10 SUPERMARKET that carries AP&P food vegetarian supplies and each supermarket is identified with unique Supermarket code, location, and contact person. g) Some supermarkets may or may not offer all products. h) The pre-packed vegetarian MEAL is only sold at Supermarkets. Each meal is uniquely identified by meal code and meal description. i) Each ORDER record is uniquely identified by order id and retailer id, as well as customer address, email, contact number and order details. Given the above information, draw the crow’s foot ERD / EERD capturing the business requirements for AP&P. You are to identify all entities, it’s attributes, state clearly the FKs & PKs, as well as the relationships, connectivities, cardinalities and optionalities.
AP&P is a vegetarian food supplier chain that operates in various branches in
Singapore. The vegetarian food products are processed and manufactured locally.
AP&P also sells ready to eat vegetarian meal package. All food is pre-packed, and
AP&P owns the licenses for their packaged food supplies which are also supplied to
local supermarkets, wet markets in various part of Singapore. Pre-packed food
product is also sold to retailers. Customers can also directly pre-order online and is
delivered by AP&P delivery service.
a) There are 3 main factories in Singapore and each factory is managed
by 2 managers.
b) Each FACTORY is uniquely identified by factory id and location (city).
c) Each FACTORY may or may not have kitchen helpers and delivery staff.
d) Each STAFF are uniquely identified by staff id, name, factory id.
e) Each RETAILER is uniquely identified by retailer id, name, and location.
f) There are total of 10 SUPERMARKET that carries AP&P food
vegetarian supplies and each supermarket is identified with unique
Supermarket code, location, and contact person.
g) Some supermarkets may or may not offer all products.
h) The pre-packed vegetarian MEAL is only sold at Supermarkets. Each
meal is uniquely identified by meal code and meal description.
i) Each ORDER record is uniquely identified by order id and retailer id, as
well as customer address, email, contact number and order details.
Given the above information, draw the crow’s foot ERD / EERD capturing the
business requirements for AP&P. You are to identify all entities, it’s attributes, state
clearly the FKs & PKs, as well as the relationships, connectivities, cardinalities and
optionalities.
Step by step
Solved in 4 steps with 1 images
