Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

How to draw the Conceptual ER Model in Chens notation ? Case Study: Louis Vuitton Moet Hennessy (LVMH) LVMH (Louis Vuitton Moet Hennessy) is a

image text in transcribedimage text in transcribed

How to draw the Conceptual ER Model in Chens notation ?

Case Study: Louis Vuitton Moet Hennessy (LVMH) LVMH (Louis Vuitton Moet Hennessy) is a French multinational luxury goods conglomerate based in Paris. LVMH sells a wide range of products, including clothing, cosmetics, jewellery, wine and even luxury yachts, under a range of different brands (for example, Givenchy, Dior, Bulgari and Dom Prignon). For each brand there is a logo, website, and a brief slogan on description of the brand (for example, "ethically-minded haute couture for men and women") Within each brand there are potentially thousands of different products available for retailers to sell to consumers The LVMH conglomerate is interested in keeping track of everything it sells, specifically, each individual product item's whereabouts, pricing, sale, and other details. You have been asked to design a global shipping and inventory database that tracks every LVMH product item from its place of manufacture (e.g. a Tag Heuer watch manufactured in Switzerland) to its place of retail sale (e.g. The Hour Glass, Collins Street, Melbourne, Australia or Daimaru Department Store, downtown Tokyo, Japan) Transit The final destination for every product item is a retail store. As they make their way there, product items are transported from place to place as part of consignments. The origin city and destination city of each consignment are recorded, as well as when the consignment leaves its origin and when it arrives at its destination, and the mode of transport that was used (ship, plane, road). Each consignment has a unique tracking code assigned by LVMH A product item may be part of multiple consignments over time as it makes its way to the retail store. For example, a pair of Dior ballet pumps might be packed into a container with many other Dior goods and shipped from Dunkirk, France to Dover, UK (the ballet pumps' first consignment). From there it might be placed on a pallet and trucked to a warehouse in Manchester (its second consignment), and then be taken to a retail store in a van (its third consignment). The name and address of each retail store is recorded At any time, an employee at LVMH should be able to query the database to identify where every unsold product item is. They also need to be able to contact the person in charge of the consignment (for example, a representative of the shipping company). This person may have several phone numbers. The name of the country the person is based in also needs to be recorded

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_2

Step: 3

blur-text-image_step3

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

More Books

Students also viewed these Databases questions

Question

please dont use chat gpt 7 4 .

Answered: 1 week ago

Question

The following diagram represents the market for butter. P S D 0

Answered: 1 week ago

Question

Question Who can establish a Keogh retirement plan?

Answered: 1 week ago