Question: Question 1 . ER Dlagrams ( 1 5 marks ) a . Use the below business rule to develop an ERD in worthench with FTA

Question 1. ER Dlagrams (15 marks)
a. Use the below business rule to develop an ERD in worthench with FTA and Firrichy (10 emba)
Cool Feet is a company that produces bespoke shoes for their customen. They heve senral emplowes ceting for the company. Among the employees, there are the (shoemakens admin, clesiners, searith) The cosmenty have specialized lines of shoes such as formal, Casual, and Sports. The company worts with thair ciatomers to design and make unique shoes based the customer's requirements, how wer each thae groducsd will buloy a line. For example, if a customer wants a dress shos then it wil be producsd under tha Formal lias, whersit the customer wants a tennis shoe then it will be under Sports. Cool Feet choomshers are hird basd on that expertise as some of them are specialista in designing Cesusl shoes while othens specinlere in Sforts shems. Based on the company/s policy, a shoemaker can only wort on one line of thoes at a time. Thers are unilya team of several shosmakers working for a line. The company offers their custemens unicus thoes that carnet be found clsewhere. This makes the customers very happy and after their firts purchase they cumly come tha for more.
Ques
Uset
a. The dependency diegram above is party in 1 WF , complate the 1 WF and then comert tur and 3NF (5 marta),
 Question 1. ER Dlagrams (15 marks) a. Use the below business

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 General Management Questions!