Referencing Styles : Harvard Task 1 Based on the case study of FastCabs company, analyse the key issues and application of database within that organisation. AC1.1 Task 2 Critically evaluate the features and advantages of using MS-Access as a database management system for a company like FastCabs. AC1.2 Understand database design techniques (Learning Outcome 2) Task 1 Based on the requirements and the assumptions you have made of FastCabs case study, analyse the use of popular Prototyping database development methodology. AC2.1 Task 2 Create an Entity–Relationship (ER) model of the data requirements for the FastCabs case study. Also, derive Relational schema/Model from your ER model that represents the entities and relationships. Identify primary and foreign keys. To further demonstrate your knowledge of normalisation, use the technique of normalisation to validate the structure of your relational schema. Demonstrate that each of your relations is in third normal form (3NF) by displaying the functional dependencies between attributes in each relation. Note: if necessary, use the additional concepts of the Enhanced Entity–Relationship (EER) model. State any assumptions necessary to support your design. AC2.2 Be able to design, create and document databases (Learning Outcome 3) Task 1 Apply prototyping database development cycle to the FastCabs data set. The purpose of this prototype is to allow the Director to provide feedback on your proposed design. The prototype should facilitate the creation, maintenance and querying of records and where appropriate automate various tasks for the user. AC3.1 2 Task 2 Complete the design of FastCabs database and implement it using MS-Access as a target DBMS including user interface. Specifically do the following: 1. Create the tables for the FastCabs database. Where appropriate set field and table properties, including any required indexes. Ensure that referential integrity is established between related tables. 2. Create customised forms for data entry. 3. Enter some test data (approximately 5-10 rows) into each table. 4. Create and save the queries to support the examples of typical queries that the Director of FastCabs provided above from (a) to (s) 5. Create customised forms to view and enter data in tables. 6. Create reports to support at least 5 queries you created above. 7. Database security is vital to FastCabs. Set database password and create two users such that one user is admin with all exclusive rights and the other user with limited rights of using the database. AC3.2 Task 3 Now that you have developed and implemented a database for FastCabs, evaluate its effectiveness in overcoming the problems of the company and suggest ways to improve your solution further. AC3.3 Task 4 Create a user manual that describes your database solution for the FastCabs database. The user manual should introduce the database application to the users, describe the functionality of the database application and clearly demonstrate how to use the application.