Question: kindly answer all quesations Assume that during system requirement determination phase, you gathered information as follows: Home-Made food A group of students want to improve
Assume that during system requirement determination phase, you gathered information as follows: Home-Made food A group of students want to improve their income by making home-made food and selling it to students in the same city. They have a page in social media where they expose their products and receive orders. They have also a delivery service. They keep data about customers for future orders. They want an is that allows to track orders, show the inventory level of each ingredient. - Each product can have different ingredients, and each ingredient can be used in many product (for example floor can be used in bread and cookies). - Customers can pay by cash, or by card. - Each customer can order many products at one time. Question 1: Create an E-R diagram for this information system. A- Identity Entities (5pts) B- Suggest Attributes (5pts) C- Identify Relationships (8 pts) D- Draw the ERD (10 pts) Question 2: Which entities are in 2NF, which ones are in 3NF? (5pts) Question 3: Transform all the entities to 3NF form, and represent them. (5pts) (E.g., Computer (computer Id, Mark, price, stock) Question 4: Draw the ERD that you will use un physical design phase. (12 pts)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
