- The Dreamhome Case Study 16 13 Of The Textbook Create A Conceptual Data Model For The Branch User Views Of Dreamhome Do 1 (25.49 KiB) Viewed 31 times
- The Dreamhome Case Study 16 13 Of The Textbook Create A Conceptual Data Model For The Branch User Views Of Dreamhome Do 2 (97.77 KiB) Viewed 31 times
- The Dreamhome Case Study 16 13 Of The Textbook Create A Conceptual Data Model For The Branch User Views Of Dreamhome Do 3 (64.81 KiB) Viewed 31 times
This appendix describes the users' requirements specification for the Branch and Staff user views of the Dream Home database system. For each collection of user views, the "Data Requirements” section describes the data used and the “Data Transactions" section provides examples of how the data is used. A. I Branch User Views of Dream Home A.1.1 Data Requirements Branches Dream Home has branch offices in cities throughout the United Kingdom. Each branch office is allocated members of staff, including a Manager, who manages the operations of the office. The data describing a branch office includes a unique branch number, address (street, city, and postcode), telephone numbers (up to a maximum of three), and the name of the member of staff who currently manges the office. Additional data is held on each Manager, which includes the date that the Manager assumed his or her position at the current branch office, and a monthly bonus pay- ment based upon his or her performance in the property for rent market. Staff Members of staff with the role of Supervisor are responsible for the day-to-day activities of an allocated group of staff called Assistants (up to a maximum of 10, at any one time). Not all members of staff are assigned to a Supervisor. The data stored regarding each member of staff includes staff number, name, address, posi- tion, salary, name of Supervisor (where applicable), and the details of the branch office at which a member of staff is currently working. The staff number is unique across all branches of Dream Home. A-1
sendix A Csers' Requirements Specification for Dream Home Case Study Properties for rent Fach hranch ettice offers a range nt properties for rent. The data stored for each property includes properly number, address (street, city. postcode), cype, number of rooms, monthly rent, and the details of the property owner. The property mum- her is unique across all branch offices. The management of a property is assigned to a member of staff whenever it is tented out or typuiles to be rented out. A member of stall may manage a maximum of 100 properties for rent at any onc tinc. When a given property is available for rent, the property details will be displayed on the DreamHow Tveli sile and, when necessary, its advertisements in local and national newspapers. Property owners The details of property owners are also stored. There are two main types of property owner:private owners and business owners. The data stored for private owners includes a co number, name, address, telephone number.email, and password. The data stored on business owners includes name of business, type of business, address, telephone number email, password, and contact name The password will allow whers axes to parts of the DreamHume catalase using the Web Clients Dream Home refers to members of the public interested in renting property as clients. To become a client, il person must first register at a branch ottice of Dream Home. The data stored un clicals includes client nu ulice, name, lelephone number, cmail, preferred type of accommodation, and the maximum reut that the client is prepared to pay. Also stored is the name of the member of staff who processed ili registration, the date the client ind and some details on the branch oflice at which the client registered. The client number is unique across all Dream Flowe branches Leases Wher a property is retterlet, wis drawn up between the chent and the jiperty. The late listed in detail on the lease includes les member, chientrum ber, name and address, property number and address, monthly rent method of payment, an indication of whether the deposit has been paid deposit calculated as twice the monthly rent), curatim of lease, and the start and end dates of the lease period. Newspapers When required, the details of properties for rent are advertised in local and national newspapers. The data stored includes the property nunter, address, type, number of rooms, rent, the date advertised the name of the newspaper, anul the cost to advertise. The data stored on cach newspaper includes the newspaper Damc. address, telephone number and contact nunc.