You are required to make use of at least two fact-finding techniques that you have been taught to investigate, gather and document business requirements (analysis) using only one of the following contexts: 1. A database system for storing details of customers, staff, products/services for a small-scaled barbershop/hairdressing salon. The database should enable you to record prices of products/services available in terms of hairstyles. 2. A database system for storing details of customers, staff (drivers and controllers), products/services for a small-scaled mini-cab office running a shift system.

The database should enable you to record details of staff allocated to shifts and charges applicable to customers per mileage. You may assume that this cab office keeps its customers on account. 3. A database system for storing details of customers, staff and products/services for a small-scaled pub. The database should enable you to record prices of at most five varieties of products/services available in the pub. You should assume that this pub keeps details of its regular customers. 4. A database system for storing details of customers, staff and products/services for a small-scaled fast-food restaurant.

The database should enable you to record prices of at most five varieties of products/services available for sale in the restaurant. You should assume that this restaurant keeps details of its regular customers. 5. A database system for storing details of suppliers, staff, products/services available for sale to customers for a small-scaled grocery store. The database should enable you to record prices of at most five varieties of products/services available for sale and the customers that purchase them. You should assume that this grocery store keeps details of its regular customers. Deliverables Analysis 1.

Evidence of the fact-finding techniques that you have adopted to investigate the business requirements of the context that you have chosen. – 10 marks Learning outcome 2 2. A well-written requirements specification developed from your investigation, detailing the business requirements, business rules and any assumptions that you have made while gathering these requirements. – 20 marks Learning outcome 2 3. Well labelled and clearly annotated conceptual prototypes of user interfaces (forms) of the database system using any prototyping or graphic tool (Access, Visual Basic, or presentation graphics) -10 marks

Learning outcome 2 4. Evidence of rough sketches/drafts of various analysis techniques used to identify the data and functional requirements of the system (placed in the appendix section of your report). Examples – rough sketches of user interface (forms), lists of entities, attributes and relationships using appropriate entity analysis techniques (top-down approach). Rough sketches of Conceptual Entity Relationship Diagram using Crow’s foot notation. Jottings or notes taken during interview or observations. – 5 marks