Zelda 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, Zelda 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. Zelda 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

Required:
Create an ER diagram for a database to help Alice Provide appropriate names for entities, attributes, and relationships and show cardinality constraints.

Question

05-03-2021
Computers and Technology

Answered

IDNLearn.com is the perfect place to get detailed and accurate answers to your questions. Ask anything and receive prompt, well-informed answers from our community of knowledgeable experts.

Zelda 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, Zelda 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. Zelda 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

Required:
Create an ER diagram for a database to help Alice Provide appropriate names for entities, attributes, and relationships and show cardinality constraints.

Sagot :

We are delighted to have you as part of our community. Keep asking, answering, and sharing your insights. Together, we can create a valuable knowledge resource. Your questions find answers at IDNLearn.com. Thanks for visiting, and come back for more accurate and reliable solutions.

35 Which Element Reacts With Oxygen To Form Ionic Bonds?(1) Calcium (3) Chlorine (2) Hydrogen (4) Nitrogen

1. In Terms Of Technology, We Often Said To Be Living In The _____ Age.???

Which Passage Did Paul Revere Say? A. "An Ounce Of Prevention Is Worth A Pound Of Cure." B. "One If By Land, And Two If By Sea;" C. "But How Shall We The Br

During The Warring States Period In China , Trade Increased And The Kinds Of Goods Exchanged Became More Diverse. What Effect Would This Have On How The Merchan

In India, For Which Achievement Is The Gupta Golden Age Best Known? (1) Adoption Of The Printing Press (2) Invention Of The Iron Foot Stirrup (3) Use Of Gunpowd

Which Is The Most Common Cause Of Erosion In Deserts? A. Wind B. Ice C. Plants D. Liquid Water

The Seneca Falls Convention Of 1848 Was The Beginning Of An Organized Movement By Women To Reach Equality In The United States. In 1920, The Nineteenth Amendmen

What Part Of Speech Is The Underlined Word In The Sentence? Which Television Show Do You Like Best? A. adverb B. pronoun C. noun D. adjective

The Movement To Establish A Jewish Homeland In Palestine Is Best Known As (1) Zionism (3) Marxism (2) Multi-culturalism (4) Militarism

If A Train Travels 70 Miles Per Hour How Long Will It Take It To Travel 350 Miles At This Speed

IfeanyiEze8899idn IfeanyiEze8899idn · Answer 1 · 2021-03-08T08:44:59-05:00

Answer:

The ER diagram shows three tables in the DVD movie collection database namely, friends, DVD, and Borrowed. The friends and DVD tables have a one-to-many relationship to the Borrowed table.

Explanation:

The Entity-relationship diagram is a graphic representation of tables and their relationship in a database. They comprise of entities which are the tables in the database, attributes or columns of the entities or tables, and the relationship that links the tables in the database.

Sagot :

Other Questions