Question: Problem statement You are required to design an Entity-Relationship Diagram (ERD) for the ZARA brand. The ERD should cover all the entities involved in the

 Problem statement You are required to design an Entity-Relationship Diagram (ERD)

Problem statement You are required to design an Entity-Relationship Diagram (ERD) for the ZARA brand. The ERD should cover all the entities involved in the supply chain and manufacturing side of ZARA, as well as those involved in the retail side of ZARA. ZARA is a multinational company with manufacturing outlets around the world, so they have many vendors for the manufacturing side. Additionally, they have several types of employees, including contract workers, manufacturing staff, and business personnel such as marketing, retail, and finance. Employees are also located around the world. Regarding customers, there are two types: those who purchase online and those who buy from physical stores located worldwide. When a person purchases something in-store, they must provide their personal information to the system for record-keeping purposes. If a person buys something online, ZARA provides the delivery service to the customer. Keeping the above scenario in mind, create an ERD diagram that clearly shows all entities, their attributes, relationships, and cardinalities. Be as creative as possible, as your level of creativity and attention to detail can result in higher marks

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!