Homework Help is Here – Start Your Trial Now!
Engineering
Computer Science
Consider a system to manage devices (computers, printers, 1 tool kits, and equip- ment) that can be loaned to users in some institute's facility management department. Design an ER diagram to represent the following data needed by the system. ¹Checking out a printer means obtaining a permission to use. Each user has a name, a phone number (10 digits), an email address, and an account (to charge for using the devices). Each user also has a username and a password on the system for obtaining services. The usernames are unique among all users. An account keeps information of the current balance and is owned by one or more users. Asso- ciated with each account is a unique account ID (an integer), and its current balance. A device includes a name, a unique serial number (used as the device identifier), a type, the production year, an availability flag, usage unit (page count for printers, hours for computer time, days for projectors and portable devices), a unit cost, over-use penalty (for each extra page, hour, day), and maximum single use (page, hour, day limit).

Consider a system to manage devices (computers, printers, 1 tool kits, and equip- ment) that can be loaned to users in some institute's facility management department. Design an ER diagram to represent the following data needed by the system. ¹Checking out a printer means obtaining a permission to use. Each user has a name, a phone number (10 digits), an email address, and an account (to charge for using the devices). Each user also has a username and a password on the system for obtaining services. The usernames are unique among all users. An account keeps information of the current balance and is owned by one or more users. Asso- ciated with each account is a unique account ID (an integer), and its current balance. A device includes a name, a unique serial number (used as the device identifier), a type, the production year, an availability flag, usage unit (page count for printers, hours for computer time, days for projectors and portable devices), a unit cost, over-use penalty (for each extra page, hour, day), and maximum single use (page, hour, day limit).

Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
4th Edition
ISBN:9780534380588
Author:Wayne L. Winston
Publisher:Wayne L. Winston
Chapter20: Queuing Theory
Section: Chapter Questions
Problem 17RP
See similar textbooks
icon
Related questions
Question

Subject: Computer databases
please show all the work, draw the ER diagram

Consider a system to manage devices (computers, printers, 1 tool kits, and equip- ment) that can be loaned to users in some institute's facility management department. Design an ER diagram to represent the following data needed by the system. ¹Checking out a printer means obtaining a permission to use. Each user has a name, a phone number (10 digits), an email address, and an account (to charge for using the devices). Each user also has a username and a password on the system for obtaining services. The usernames are unique among all users. An account keeps information of the current balance and is owned by one or more users. Asso- ciated with each account is a unique account ID (an integer), and its current balance. A device includes a name, a unique serial number (used as the device identifier), a type, the production year, an availability flag, usage unit (page count for printers, hours for computer time, days for projectors and portable devices), a unit cost, over-use penalty (for each extra page, hour, day), and maximum single use (page, hour, day limit).
Transcribed Image Text:Consider a system to manage devices (computers, printers, 1 tool kits, and equip- ment) that can be loaned to users in some institute's facility management department. Design an ER diagram to represent the following data needed by the system. ¹Checking out a printer means obtaining a permission to use. Each user has a name, a phone number (10 digits), an email address, and an account (to charge for using the devices). Each user also has a username and a password on the system for obtaining services. The usernames are unique among all users. An account keeps information of the current balance and is owned by one or more users. Asso- ciated with each account is a unique account ID (an integer), and its current balance. A device includes a name, a unique serial number (used as the device identifier), a type, the production year, an availability flag, usage unit (page count for printers, hours for computer time, days for projectors and portable devices), a unit cost, over-use penalty (for each extra page, hour, day), and maximum single use (page, hour, day limit).
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Operations Research : Applications and Algorithms
Operations Research : Applications and Algorithms
Computer Science
ISBN:
9780534380588
Author:
Wayne L. Winston
Publisher:
Brooks Cole
Information Technology Project Management
Information Technology Project Management
Computer Science
ISBN:
9781337101356
Author:
Kathy Schwalbe
Publisher:
Cengage Learning
Principles of Information Systems (MindTap Course…
Principles of Information Systems (MindTap Course…
Computer Science
ISBN:
9781285867168
Author:
Ralph Stair, George Reynolds
Publisher:
Cengage Learning
C++ for Engineers and Scientists
C++ for Engineers and Scientists
Computer Science
ISBN:
9781133187844
Author:
Bronson, Gary J.
Publisher:
Course Technology Ptr
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:
9781337508841
Author:
Carey
Publisher:
Cengage
SEE MORE TEXTBOOKS