Database class

EXERCISE #3: E-R DESIGN - Design 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 uses a 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