Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Computer Engineering Expert

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.

Computer Engineering, Engineering

  • Category:- Computer Engineering
  • Reference No.:- M91789199

Have any Question?


Related Questions in Computer Engineering

Restaurant management database project the restaurant

Restaurant Management Database Project : The restaurant maintains the catalog for the list of food and beverage items that it provides. Apart from providing food facility at their own premises, the restaurant takes order ...

You are required to design a circuit that takes as input a

You are required to design a circuit that takes as input a serial bit and outputs a '1' whenever there are three successive '1's, i.e., whenever the sequences 111 or 000 occur. Overlaps must be considered Also, assume th ...

In a survey of 100 people 40 were casual drinkers event d

In a survey of 100 people, 40 were casual drinkers (event D), and 60 did not drink (event D). Of the ones who drank, 6 had minor headaches. Of the non-drinkers, 9 had minor headaches. Let D represent set of surveyed peop ...

A student is applying to harvard and dartmouth if the

A student is applying to Harvard and Dartmouth. If the student is accepted at Dartmouth, the probability of being accepted at Harvard is 40%. If the student is not accepted at Dartmouth there is an 80% of non-acceptance ...

A simple repetitive song with varying verse the ants go

A simple repetitive song with varying verse, "The Ants Go Marching" provides a simple assignment for remembering the basic Control Structures - loops, switch statements, if-then-else statements, etc., that you learned in ...

Question sunshine health corporation is seeking to improve

Question : Sunshine Health Corporation is seeking to improve overall connectivity across their corporate campus near the Hawaii Kai Marina, Honolulu, Hawaii. The campus buildings have recently been updated, thus the LANs ...

There are two firms that produce large commercial airplanes

There are two firms that produce large commercial airplanes, namely, Boeing and Airbus. Boeing and Airbus have different flight control systems, with many pilots preferring one system over the other. The Airbus A380 has ...

Draw supply and demand curve to illustrate the following

Draw supply and demand curve to illustrate the following sequences of events. Show changes in one graph. Assume upward sloping for supply curves and downward sloping for demand curves 1. In year 1, the rental apartment m ...

Question after 1 year of launch ride sharing increased a

Question: After 1 year of launch, ride sharing increased a lot resulting in a lot of insertion requests to the database. Consider there is no room to further increase the size of server and changing database is not an op ...

Suppose our task is to distinguish between humans and

Suppose our task is to distinguish between humans and non-human objects in an image, which classifier would you choose and why? Decision trees, perceptrons or neural nets.

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As