Question: Draw ER diagram ( cont'd ) A software resource center owns the license for various expensive software and loan their use remotely to software developers
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
Get step-by-step solutions from verified subject matter experts
