Question: Need help ASAP!! Create a Relational diagram based on the following set of requirements... New York & Company is a fine clothing boutique, offering fashionable

Need help ASAP!!Need help ASAP!! Create a Relational diagram

Create a Relational diagram based on the following set of requirements... New York & Company is a fine clothing boutique, offering fashionable men's and women's clothing and accessories. It was acquired 7 years ago, after a long drawn out negotiation, by the Fashionable Group, a retail conglomerate based in Paris, France. All New York & Company items of clothing and accessories can be purchased both online on its own web site, reseller sites such as Bloomingdale's and Macy's, or in its flagship NYC store located on 5th Avenue. Luxury brands for women carried by New York & Company include Chanel, Gucci, Prada, Fendi and Bottega. For men luxury brands include Andrew Marc, Bottega, Boss, Burberry and Helmut Lang. To attract a younger market, New York & Company also offers its own brand for both women and men that is of high quality but more moderately priced. Once an item is ordered by a customer from New York & Company, the item is invoiced. The customer invoice includes the item ID, description, quantity, price, customer name or ID, date of purchase and customer address and contact information. Once invoiced, payment must be made within the time period allowed (up to 2 weeks) from date of purchase, otherwise the item is not shipped Payment is either by credit card, cash, PayPal, or Travelers Cheque. If the shipment is received in a damaged condition, it is returned by the customer and the shipping amount is reimbursed or credited to the customer's account. A new item is shipped to those customers who want a replacement for the damaged item

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!