Draw an er diagram from this scenario

Assignment Help Basic Computer Science

Reference no: EM131064814

Alice has a large DVD movie collection. Her friends like to borrow her DVD's, and she needs a way to keep track of who has what. She maintains a list of friends, identified by unique FID's (friend identifiers) and a list of DVD's, identified by DVDID's (DVD identifiers). With each friend is the name and the all-important telephone numbers which she can call to get the DVD back. With each DVD is the star actor name and title. Whenever a friend borrows a DVD, Alice will enter that fact into her database along with the date borrowed. Whenever the DVD gets returned, that fact, too, gets noted along with the date returned. Alice wants to keep a complete history of her friends' borrowing habits so that she can ask favors of the heavy borrowers (or perhaps refuse to make further loans to those who habitually don't return them quickly). Draw an ER diagram from this scenario.

Reference no: EM131064814

Questions Cloud

Respondents refuse to participate in the frs : It is one thing to note the number of people who do not respond to a survey, but few then go on the ask for reasons. Many people have speculated on the reasons, but one survey which routinely asks is the Family Resources Survey for the UK conducte..

Which brought nijinsky fame : Critic and theorist Michel Foucault proclaimed that humans have moved from a God-centered world, to a human-centered world, and now to a world without.

How people like anne hutchinson and george reflected : The documentary also shows how people like Anne Hutchinson and George Whitefield reflected the individual expression of religious beliefs that would become a defining characteristic of religion in America.

What is the payback period and discounted payback period : A certain project has an initial investment of $4,208 and cash inflows of $3,500 for the first year and then $2,000 in year 2 and $800 in year 3. If the discount rate is 13%, what is the NPV? What is the IRR? What is the MIRR? What is the payback..

Draw an er diagram from this scenario : Whenever the DVD gets returned, that fact, too, gets noted along with the date returned. Alice wants to keep a complete history of her friends' borrowing habits so that she can ask favors of the heavy borrowers (or perhaps refuse to make further l..

Common stock is currently trading : The Sisyphean Company's common stock is currently trading at $26.75 per share. The stock is expected to pay a $2.8 dividend at the end of the year and the Sisyphean Company's equity cost of capital is 12%. If the dividend payout rate is expected to r..

The national readership survey of newspapers and magazines : The National Readership Survey of newspapers and magazines has been conducted over many years and illustrates the changing reading patterns of the population. Their methodology and sample design have been refined and can serve as a model for other..

Standard deviation of this minimum variance portfolio : Assessment 2 aims to provide students with an opportunity to analyse various investment alternatives based on the respective risk and return so as to choose the most appropriate investment opportunity. Calculate the weights on the optimal risky portf..

Fit a polynomial curve to the noncore data and integrate : Find the total volume flow rate Q using the relationship Q = r1∫r2 2prv dr + vc Ac, Fit a polynomial curve to the noncore data and integrate and Use multiple-application Simpson's rule to integrate

User Account

All Pages