John Deere wants to build a database to track all of the computer hardware assets and software assets they own. Their hardware assets include PCs, network servers, and peripheral devices. Each PC, network server, and peripheral device contains at least one software installed. They want to keep track of software assets, as well as the licenses they own for those assets. Each software asset may have one license or multiple licenses. Some software licenses are for PCs and peripheral devices. Some software licenses (i.e, network licenses) are for network servers. A single network license authorizes a specific number of users. We want to keep track of where software licenses are installed. John Deere keeps track of users’ assignments to certain PCs, network servers, and peripheral devices. Represent this situation with an E-R diagram. State assumptions if any.
John Deere wants to build a
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 1 images
