Design an entity-relationship model based

Assignment Help Operation Management
Reference no: EM13781419

Design an entity-relationship model based on the following rules:

A Customer can have one account, and an account can be owned by one customer

A Customer can watch many Streaming movies, and a streaming movie can be watched my many Customers

A Customer can rent many DVDs, and a DVD can be rented by many customers

A movie can only have one Director, but a director can direct many movies

A movie can have one main male and one main female Star, and a Star can be in many movies

A movie can have one male co-star and one female co-star, and a co-star can be in many movies

A movie can be listed in one or more genres, and a genre can have many movies

A customer can rent zero or more DVDs, and a DVD can be rented by many customers

A customer can only have one plan type, but a plan type can be attributed to many customers

Reference no: EM13781419

Questions Cloud

Specific supply chain risk mitigation strategy : Which of the following is NOT a specific supply chain risk mitigation strategy?
Why voter turnout is so low in this country : What do you think are the reasons why voter turnout is so low in this country? State whether or not you think this is a good or bad thing and why
Analyze the features of a flow chart : Toyota Lex sedan vehicle was introduced with a problem, which made the company to recall several cars to rectify the mistake. The problem was with the carpeted place under the driver seat. A the carpet under the seat was stuck under the accelerator, ..
Impact of unemployment on the individual and society : Being unemployed and the impact of unemployment on the individual and society. Being an alcoholic and the broader impact of alcoholism on the individual and society
Design an entity-relationship model based : Design an entity-relationship model based on the following rules: A Customer can have one account, and an account can be owned by one customer. A Customer can watch many Streaming movies, and a streaming movie can be watched my many Customers. A Cust..
Discusses the current status of civil rights : find the discusses the current status of civil rights with regard to that particular minority group. You can use outside, credible resources as well
How many can buy the product based on your distribution : Your product launches typically reach 70% ACV distribution in 13 weeks. This is best in class. Of the moms that will likely buy your product, and saw your advertising, how many can buy the product based on your distribution?
Describing the sociological reasons : Write an essay (750-1,000 words) describing the sociological reasons that gender, race, and age discrimination occur in American society. Explain whether you think these forces will diminish or become more prevalent in the near future.
Benefit would using optimal order quantity yield : Garden Variety Flower Shop uses 890 clay pots a month. The pots are purchased at $3.70 each. Annual carrying costs per pot are estimated to be 50 percent of cost, and ordering costs are $30 per order. The manager has been using an order size of 1,000..

Reviews

Write a Review

Operation Management Questions & Answers

  Which one would appeal to you as an entrepreneur

Of all the advantages of franchising, which one would appeal to you as an entrepreneur? Which disadvantages would you dislike the most and why?

  Illustrate what range of volumes is proposal lesser cost

You need to increase capacity of your manufacturing operation by adding new equipment. Two vendors have presented proposals.

  Where do the raw materials come from

Where do the raw materials come from and what firms are involved in its manufacturing

  How do managers generally describe organizational authority

How do managers generally describe organizational authority?

  Use the competitive priority of flexibility

How does your cell phone provider use the competitive priority of "flexibility" to its competitive advantage? Research, then explain and provide example in a short paper.

  Old pueblo engineering contractors creates six-month

old pueblo engineering contractors creates six-month rolling schedules which are recomputed monthly. for competitive

  Is there a trek bicycle for everybody

Trek Bicycle, founded in 1976, gets a marketing boost whenever high-profile professional racers speed off on their Trek bikes or world-class cyclist’s power through dirt-bike races. Based in Waterloo, Wisconsin, Trek is North America's largest bicycl..

  How can selected organization use quantifiable elements

How can your selected organization use quantifiable elements to evaluate, monitor, and control marketing effectiveness?

  A firm is considering a latest project whose risk is more

a firm is considering a new project whose risk is greater than the risk of the firms average project based on all

  Propose two techniques that changing economic and social

Examine the extent to which the two (2) similar companies you researched have addressed the key issues you selected. Hypothesize two (2) potential positive outcomes for each company if each addresses the key issues

  What''s the differences and similarites between toyota and gm

What's the differences and similarites between Toyota and GM in operation management?

  How many earrings does raj have

Raj has a jewel chest containing Rings, Pins and Ear-rings. The chest contains 26 pieces. Raj has 2 1/2 times as many rings as pins, and the number of pairs of earrings is 4 less than the number of rings. How many earrings does Raj have?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd