Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Draw ER diagram ( cont'd ) A software resource center owns the license for various expensive software and loan their use remotely to software developers

Draw ER diagram ( cont'd )
image text in transcribed
A software resource center owns the license for various expensive software and loan their use remotely to software developers for a period of time in return of money. The center is willing to design a database to follow its loan operations. The following information is needed to keep track of each developer: developer ID (identifier), name, and contact information. Contact information is comprising the following: mobile number, email address, and address. To be able to use the center services, a developer has to be registered for an account and may be registered in any number of accounts, For one account, one and only one developer is registered in. An account is uniquely identified by a username and is described by a password and creation date. An account loans at least one software resource and may loan several. A software resource is identified (uniquely) by a software number in addition to be defined by a software name, the manufacturer name, a loan cost, a category, and a number of accounts (i.e., representing the total number of accounts actually loaning that resource). For any software resource under a loan, the center requires to record the password to be used to access the resource as well as the loan period. Besides, a reward card, defined by a card ID identifier) is granted to exactly one developer. The reward card is also defined by a description and a set of privileges. Finally, for a better monitoring, the center requests to track account activities. For such a tracking activity is uniquely identified by a date along with the username of the corresponding account; a tracking activity saves also the time duration

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Spomenik Monument Database

Authors: Donald Niebyl, FUEL, Damon Murray, Stephen Sorrell

1st Edition

0995745536, 978-0995745537

More Books

Students also viewed these Databases questions