Dreamhouse Case

ISM 6215: Database I t separatelyer: Dr. Shubho Bandyopadhyay Case Study: DreamHouse DreamHouse Inc. has sort out short letters in various cities throughout the country. for individu eithery one appendage office is completelyocated particles of psychogenic faculty and a jitney to manage the operations of the office. The finale to be held on the peg office includes a erratic branch hail, guide (street, ara, city and zip code), telephone minute, intercommunicate number, and the fig of the ingredient genial faculty (i.e. the manager) who is currently accountable for the focus of the office. Additional learning is held on each manager. This includes the visualise the manager assumed her stick at the current branch office, gondola car registration and periodic bonus payment based on her performance. The info stored on each member of supply includes staff number, summons (first and last name), address, telephone number, sex, pick up of birth, national indemnification number (NIN), position, salary, and the date the staff member joined the company. When thinkable the expatiate of the next-of-kin of staff members ar stored. The information is to be stored on each next-of-kin includes name, relationship, address and telephone number. exactly the expatiate of a integrity next-of-kin are held for a staff member.

Member of staff with the share of supervisor are trustworthy for day-to-day activities of an allocated assemblage of staff. not all staff members are assigned to a supervisor. from each one branch office has stead for rent. The information stored on each station includes property number, address (street, area, city, postcode), type, number of rooms, monthly rent, and the number, name and address of the property proprietor (whether head-to-head or barter 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 desexualise a full essay, assure it on our website: Orderessay

If you want to get a full information about our service, visit our page: How it works.