Assessment Task: Using the scenario given in Appendix A, analyse the requirements and then: a) Expand upon the already given partial ERD (Appendix B) and thus produce an ERD that models a new system for Peter Darwins Estate Agency that will satisfy all the requirements detailed in the scenario given. The partial ERD may change slightly when you produce your complete ERD, depending on the assumptions you make. b) State any assumptions made during the development of your design. (The 'What' and 'Why') 으 Produce a set of minutes of team meetings that detail: ► How (and to whom) the deliverables (tasks) have been assigned. ➤ What quality control procedures took place. ➤ Discussions regarding the progression of the deliverables (tasks). ➤ Documentation of work required (and by whom) by the next meeting. Appendix A Peter Darwins Estate Agency An estate agency, Peter Darwins, has a number of branches in the Rhondda Cynon Taff area. Each branch deals with both property purchase and property rental. Each property is only dealt with at one branch and no property can be for sale and rent at the same time. Details on staff employed at each branch, together with information on the manager of that branch need to be kept. In addition, information needs to be retained re: properties, rental clients, property sellers and potential buyers. Rental Properties Each rental property is assigned to a particular member of staff. Clients are allowed to specify: The maximum length of each lease (rental period). For example: 6 months. Whether pets are allowed. Whether families with children are allowed. Details are recorded about each client and on each property they wish to rent. For example: Property code. Area. Address. No. of bedrooms. No. of bathrooms. No. of reception rooms. Whether the property has a garage. Type of property (Detached, Semi-detached, Terrace, Link). Monthly rental. Details are also kept on the customers who rent these properties (ignore the fact that usually a credit check would carried out and that two references would need to be provided before a new customer is allowed to rent a property). A record is kept of recent past rentals, future rentals in addition to the current rentals. Property code. Area. Address. No. of bedrooms. No. of bathrooms. No. of reception rooms. Whether the property has a garage. Type of property. (Detached, Semi-detached, Terrace, Link) Whether the property is freehold or leasehold. Price. Current state of property. (Unsold, Sold). Date placed 'on the market'. Details are also kept with regard to those customers who are interested in buying a property: Buyer No. Name. Address. together with a (very) simplified set of requirements: Area. Minimum no. of bedrooms. Minimum no. of bathrooms. Minimum no. of reception rooms. Garage required/not required. Maximum Price. Prospective buyers make appointments to view properties from lists of all properties that satisfy their requirements. These lists are produced by the system but DO NOT need to be an entity on your diagram. A member of staff is assigned to accompany prospective buyers to each viewing appointment. Once a buyer puts in an offer for a property, the seller is informed and if the offer is accepted, the status of the property changes to 'Sold'. Again, for simplicity, ignore the 'selling process' - simply changing the properties status to sold is adequate for this coursework. Appendix B Partial ERD for Peter Darwin's Estate Agency Potential Buyer 1..1 0... 0..* Sale Property 1..1 Viewing Appointment 0..* 1..1 Staff Member