Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 EntityRelationship ER diagram to represent this section of the uni
versity's asset database
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started