The CEO of Flex Works is interested in adopting a flexible working space for his company. His idea is to allow his emplo

[answerhappygod]

The Ceo Of Flex Works Is Interested In Adopting A Flexible Working Space For His Company His Idea Is To Allow His Emplo 1 (134.08 KiB) Viewed 20 times

The CEO of Flex Works is interested in adopting a flexible working space for his company. His idea is to allow his employees to book desk-spaces, as per their needs and preferences. By giving users the option to select their own desks allows for team collaboration, reduction of human resources and an increase in efficiency, as all bookings and schedules can be operated directly by the users (via their online credentials). You have been asked to design a Desk-space Booking System (DBS) for FlexWorks, which will initially allow two types of users i.e. employees and interns. Additional user types may be introduced later. For each user we know their first and last names, but their email and phone numbers may be unknown. Each employee has a grade and designation while each intern is assigned a supervisor, who is one of the employees. Booking requests from interns must be approved by their supervisors. The system should cater to company office spread over multiple zones, where each zone is on a different floor and comprises of multiple rooms. Each room is uniquely identifiable within the company office and has multiple desk spaces. For each room, we know its capacity, the approximate noise-level and desk space type (private or shared). Each desk space is identified by a desk-id, which is unique within a given room. Each desk space has different features like availability of power sockets, window facing (for ventilation & sunlight), and availability of extra monitor screen. Each user can select any of the above features in his/her preferences, and these will be taken into account while making desk space bookings. For instance, if a user selects power sockets in his/her preferences, then the booking system will not allocate a desk space without power sockets. Each booking should record the booking date, start and end times and whether the desk space was actually used i.e. through an RFID card scanner installed on each desk space. (a) Design an Entity-Relationship model for the Desk-space Booking System (DBS). Explain the key design decisions made in your choice of entities, relationships and any other (ownership or hierarchical) aspects. [9 marks] Annotate it with multiplicities and hierarchy annotations. [4 marks] (b) Carry out logical design for the model, representing the design with relational schemas for tables. Annotate the schemas with primary keys and the possibility of null attributes. [7 marks]