Question: Assuming you work as a database designer within the ITS department of our univer - sity, you have been tasked with modeling a particular section

Assuming you work as a database designer within the ITS department of our univer-
sity, you have been tasked with modeling a particular section of the university's asset
database, which is described as follows:
This section of the asset database pertains specifically to IT hardware equipments
installed in dedicated spaces, such as lecture theatres and seminar rooms.
Every building within the university is identified by a distinct code and is given
a name and an address. An address comprises of the street number, street name,
suburb, and city.
Each room within a building is assigned a room number. However, it's possible
for rooms in different buildings to have the same room number.
Each piece of IT hardware equipment, such as a computer or projector, is iden-
tified by a unique code and has a name and an equipment type. Each piece of
equipment can only be assigned to one room, but a single room can contain mul-
tiple pieces of equipments.
(a) Draw an Entity-Relationship (ER) diagram to represent this section of the uni-
versity's asset database
 Assuming you work as a database designer within the ITS department

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!