database Task 1 (P2) Use the paper records you have been given, along with your understanding of how a veterinary surgery operates, to design a relational database to support the required functions. A minimum of 5 tables are required. You must submit the following items: An Entity Relationship diagram Details of normalisation to third normal form An explanation (one page of A4) of how you arrived at your final choice of tables and attributes. This should clearly explain: how you resolved any differences between the two models Whether you attributes that weren’t in the paper record and your reasons for doing so A data dictionary for all the tables in your design A description (in structured English/pseudocode) of how any calculations will be performed in preparing the bill Task 2 (P3, M2) You must now implement your database in MS Access. You will need to provide evidence of the following: At least 5 tables that match the data dictionary (witness statement) The existence of all the required relationships with referential integrity applied (annotated screen shots) Successfully importing the data from the customer text file into a table in your database (witness statement, criteria M2) Tables populated with data. In most cases at least 10 rows of data will be required to demonstrate correct operation of the database. (witness statement) Task 3 (P4) assessed by witness statement Forms will be required to permit end users to interact with the database. The following forms will be required: An initial form showing the options available. This should include at least: A title
database Task 1 (P2) Use the paper records you have been given, along with your understanding of how a veterinary surgery operates, to design a relational database to support the required functions. A minimum of 5 tables are required. You must submit the following items: An Entity Relationship diagram Details of normalisation to third normal form An explanation (one page of A4) of how you arrived at your final choice of tables and attributes. This should clearly explain: how you resolved any differences between the two models Whether you attributes that weren’t in the paper record and your reasons for doing so A data dictionary for all the tables in your design A description (in structured English/pseudocode) of how any calculations will be performed in preparing the bill Task 2 (P3, M2) You must now implement your database in MS Access. You will need to provide evidence of the following: At least 5 tables that match the data dictionary (witness statement) The existence of all the required relationships with referential integrity applied (annotated screen shots) Successfully importing the data from the customer text file into a table in your database (witness statement, criteria M2) Tables populated with data. In most cases at least 10 rows of data will be required to demonstrate correct operation of the database. (witness statement) Task 3 (P4) assessed by witness statement Forms will be required to permit end users to interact with the database. The following forms will be required: An initial form showing the options available. This should include at least: A title