What problems do you see emerging from a proj- ect such as SBInet where the government allows the contractor to determine scope, manage all con- tractor relations, and decide how to share project status information with oversight bodies?

Tasks Task 1(4 marks) Read and analyse the following specification of a sample database domain. A database is needed to store information about the buildings owned by a university. The buildings owned by a university have the unique names and unique numbers. A building consists of offices, lecture halls, laboratory rooms, and utility rooms such as toilets, workshops, meeting rooms, kitchens, seminar rooms etc. Offices, lecture halls and laboratory rooms are identified within a building by a room number. The utility rooms do not have room numbers and their identification consists of building number, floor number and type of utility room (toilet, workshop, meeting room, kitchen, etc). To simplify the problem, assume, that there is no more than one utility room of a given type at the same floor in one building (e.g. there are no two or more male toilets at the same floor). The offices, lecture halls, laboratory and utility rooms are described by an area, number of entries/exits, number of windows, and type of floor cover. The offices have a number of facilities and equipment installed. These facilities and equipment include computer network connections, air conditioning, desk, chair, computer, small refrigerators with soft drinks (unfortunately, very rare), etc. An office may have more than one network connection and more than one chair. We would like to record in the database the names and numbers of facility and equipment units installed in each office. The employees the offices. An office is usually occupied an academic staff member and some offices are shared by many support staff members. An office may be also empty for a certain period of time. The employees are described by the first and last name, employee number, and name of department an employee belongs to. All lecture halls and laboratory rooms have a maximum seating capacity. The lecture halls and laboratory rooms are booked for lectures and laboratory classes. The database should contain information about all bookings i.e. when the facilities are booked and for what subject. A lecture hall and a laboratory room can only be booked by one subject at a time. use