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

  Why do you assume that best buy rather than one of best buy

Why do you Assume that Best Buy, rather than one of Best Buy's big suppliers such as Sony or Panasonic, is considering eliminating rebates.

  How new system will integrated into the health organization

Once a vendor is selected, it is time for the health care organization to work with them to integrate an effective solution to the original needs.

  Illustrate what is its final kinetic energy

A proton is initially at rest at a point where potential is 501 V. Sometime later proton is at a point where potential is 218 V. If no force or than electrostatic force acts on proton, illustrate what is its final kinetic energy.

  The company''s strategic planning and tactical planning

Analyze factors that influence each of the following: the company's strategic planning, tactical planning, operational planning, and contingency planning.

  Analyzing benefits available in health care industry

Analyze the types of benefits usually available in the health care industry and determine which benefits are most important to the greatest number of health care employees.

  Elucidate what rop is appropriate if the risk is stock out

Suppose which daily usage is normal also which it has a standard deviation of 1.5 gallons per day. Elucidate what ROP is appropriate if the acceptable risk of a stock out is 2 %.

  What is the maximum revenue

A revenue function is given by R= 35x-2x2 where R is the revenue and x is the quantity. What value of x maximizes revenue? What is the Maximum Revenue and Find elasticity of demand of the function x=150-5P at (1) P=15, (2) P=20.

  Compare the outline to that of a third-party approach

Compare the outline to that of a third-party approach. Explain the importance of trusting the process.

  What changes make to the organization to position for future

What changes would you make to the organization to position it for the future. Who would be effected by this decision? What are the ethical considerations

  Making organizational and procedural changes

According to textbook, the top three challenges for CPFR implementation include all of the following except: Making organizational and procedural changes, Trust between supply chain partners, Cost

  Invested in a stock that is returning

Assume that you have $165,00 invested in stock that is returning 11.50%,$85,000 invested in a stock is returning 22.75% and $235,000 invested in a stock that is returning 10.25%

  Calculate the overall proportion of tourists

Calculate the overall proportion of "tourists" (cars with out-of-state plates). b. Calculate the LCL and UCL for these data

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