Dreamhouse Case Essay

594 Words3 Pages
ISM 6215: Database I Instructor: Dr. Shubho Bandyopadhyay Case Study: DreamHouse DreamHouse Inc. has branch offices in various cities throughout the country. Each branch office is allocated members of staff and a manager to manage the operations of the office. The information to be held on the branch office includes a unique branch number, address (street, area, city and zip code), telephone number, fax number, and the name of the member staff (i.e. the manager) who is currently responsible for the management of the office. Additional information is held on each manager. This includes the date the manager assumed her position at the current branch office, car allowance and monthly bonus payment based on her performance. The information stored on each member of staff includes staff number, name (first and last name), address, telephone number, sex, date of birth, national insurance number (NIN), position, salary, and the date the staff member joined the company. When possible the details of the next-of-kin of staff members are stored. The information is to be stored on each next-of-kin includes name, relationship, address and telephone number. Only the details of a single next-of-kin are held for a staff member. Member of staff with the role of supervisor are responsible for day-to-day activities of an allocated group of staff. Not all staff members are assigned to a supervisor. Each branch office has property for rent. The information stored on each property includes property number, address (street, area, city, postcode), type, number of rooms, monthly rent, and the number, name and address of the property owner (whether private or business owner). The property number is unique across all branch offices. Each property for rent is assigned to a staff member who oversees the property. The details of owners of property are also stored. There are two main types of
Open Document