Dreamhouse Case

ISM 6215: Database I Instructor: Dr. Shubho Bandyopadhyay Case Study: DreamHouse DreamHouse Inc. has assort short letters in various cities throughout the country. apiece f all(prenominal) apart office is completelyocated members of rational faculty and a passenger car to manage the operations of the office. The cultivation to be held on the branch office includes a whimsical branch rate, address (street, area, metropolis and zip code), telephone number, telecommunicate number, and the induce of the member mental faculty (i.e. the manager) who is currently responsible for the focus of the office. Additional culture is held on for distributively one manager. This includes the date the manager assumed her send at the current branch office, gondola car recompense and periodic bonus payment based on her performance. The breeding stored on each member of staff includes staff number, identify (first and last name), address, telephone number, sex, date of birth, na tional indemnification number (NIN), position, salary, and the date the staff member joined the company. When thinkable the enlarge 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 angiotensin converting enzyme next-of-kin are held for a staff member.

Member of staff with the piece of supervisor are responsible for day-to-day activities of an allocated assemblage of staff. non all staff members are assigned to a supervisor. for each one branch office has property for rent. The in formation stored on each property includes p! roperty number, address (street, area, city, postcode), type, number of rooms, monthly rent, and the number, name and address of the property owner (whether reclusive or assembly line organization 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 to a fault stored. There are two main types of owners private owners and business owners. The information stored on private owners includes owner...If you want to perplex a full essay, order it on our website: OrderCustomPaper.com

If you want to get a full essay, visit our page: write my paper