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

  Illustrate what should a memo telling staff

Illustrate what should a memo telling staff illustrate what to do when they encounter problems, with business technology comprise.

  Explain why does the poq model distinct from the eoq model

the eoq model is based on a mathematical derivation with which you would not be expected to be familiar that achieves a

  Production strategies-make-to-order manufacturing firms

Which of the following basic production strategies used for addressing the aggregate planning problem would work best with make-to-order manufacturing firms?

  What factors are likely cause errors in valuing google stock

How accurate can that justification be? What factors are likely cause errors in valuing Google stock?

  Discuss the relationship between these four features

discuss the relationship between these four features of capitalism. companies, profit motive, competition and private property.

  What extent would attraction also retention initiative

A capacity alternative has an initial cost of $50,000 also cash flow of $20,000 for each of next four years. If cost of capital is 5 percent, net present value of this investment is approximately.

  Are we losing the economic war with the whole world does

are we losing the economic war with the entire world? does globalization make it impossible to compete with nations

  Draw a state diagram for the process

A copy machine is always in one of two states, either working or broken. If it is working, there is a 70% chance that it will be working tomorrow. If it is broken, there is a 50% chance it will still be broken tomorrow. Assume that one day is a na..

  Determine the percentage of time the machine is idle

The management likes to have operators working 90% of the time. What must the assembly line arrival rate be in order for the operators to be as busy as management would like?

  Discuss several advantages of using the m/m/1 waiting line

Discuss several advantages of using the M/M/1 waiting line queuing model. Clearly explain the reasons for your choices.

  Identify the companys competitors

Use the example of the auto industry and respond to the following: Identify one company in the auto industry and describe its competitor behavior. Identify the company’s competitors.

  Evaluate the role of this knowledge area in management

According to the Project Management Body of Knowledge (PMBOK), explain one of the major knowledge areas and why it is important to project management. Evaluate the role of this knowledge area in management of a project.

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