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

kindly answer all quesations
kindly answer all quesations Assume that during system requirement determination phase, you

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!