EXERCISE #3: E-R DESIGN Desiqn a database to manage the reservation of work stat

Question

EXERCISE #3: E-R DESIGN Desiqn a database to manage the reservation of work stations in a university lab. A student is characterized by ID, name, date and place of birth, residence, and telephone. Students attend some labs. Labs contains work stations and other resources. Each work station is associated with some resources (desktop, printer, software). Some resources are made available to all students without restriction; other resources are assigned to students attending specific labs upon authorization. A student can use a work station only if s/he reserves the seat. It is imperative to keep track of all the times that a student usesa work station. Each lab has only one manager, who can only manage one lab The E-R schema must include cardinalities for relationships, and attributes (where applicable), and identifiers. 9

Explanation / Answer

Boolean

Students Student_Id primary key Name Dob Birth_place Residence or address Telephone

Related Questions

Navigate

• Browse (All)
• Browse E
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.