Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intranet And Web Databases For Dummies

Authors: Paul Litwin

1st Edition

0764502212, 9780764502217

More Books

Students also viewed these Databases questions