Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. M55 stocks many units of each device type. Each unit is identified by its device type id and a serial number. MSS wants to

image text in transcribed
3. M55 stocks many units of each device type. Each unit is identified by its device type id and a serial number. MSS wants to keep track of the date it received delivery for each and every unit it has in-stock. If a unit has been deployed to a room on campus (i.e. classroom, surgical theater, conference room etc), then MSS needs to record the date of its deployment. (15pts) 4. The rooms to which MSS devices are deployed need to be recorded. A given room (i.e. classroom, surgical theater etc) may contain several MSS devices. A given MSS device may be deployed, rather obviously, to only one room, and where the device is still in the M55 store room, it is deployed to no room. Rooms are identified by a building code, a room number, and a primary room function. Because there is a known and finite set of room functions, MSS would like to maintain a standard list of room functions. Each room function has a function code, a function name, and a function description. Some rooms have several functions. All rooms must have a function. Because there is a known and finite set of buildings on campus, MSS would like to maintain a standard list of buildings. Buildings are identified by building code. They are described by their street address and by their name. In addition, MSS would like to record whether or not the building is part of the Monroe Park Campus or not. Every room must be located within a building. All buildings contain multiple rooms. (20pts)

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

Strategic Management State Of The Field And Its Future

Authors: Irene M. Duhaime , Michael A. Hitt , Marjorie A. Lyles

1st Edition

0190090898, 978-0190090890

More Books

Students also viewed these General Management questions