We write, we don’t plagiarise! Every answer is different no matter how many orders we get for the same assignment. Your answer will be 100% plagiarism-free, custom written, unique and different from every other student.
I agree to receive phone calls from you at night in case of emergency
Please share your assignment brief and supporting material (if any) via email here at: email@example.com after completing this order process.
No Plagiarism Guarantee - 100% Custom Written
Unit 5.43 Database Design and Development
ATHE Level 5 Diploma in Computing (QCF)
You have been appointed as a database developer for Mahrud Bees. The company have recently set up a new business and it currently keeps bees. The bees produce honey, pollen and royal jelly and the bee keeper also raises “queen bees” to sell to other bee farms. Mahrud Bees produces honey to sell, alongside facial products made from the royal jelly that is produced by the bees. The owner has asked you to design and build an advanced relational database that will allow the bee keeper to record details of:
Using the information you have been provided with and some additional external research, plan and produce a design for a complex relational database based on a response to the client brief. Normalise the data to 3rd normal form.
Produce design documentation in response to the client brief ensuring this shows the design of the tables, indexes and constraints, SQL queries, forms, macro and security measures.
LO2 Assessment criteria, 2.1, 2.2, 2.3
Your designs have been approved by the owner of Mahrud Bees. Implement the database using the designs you have created in activity 1. Ensure that your database includes all the features you designed in activity one plus a suitable graphical user interface.
LO3 Assessment criteria 3.1, 3.2
Now that the database has been implemented it needs to be tested. Explain the different testing methods that could be used to test the database and produce a test plan which identifies the tests to be carried out. This should include testing of extreme data and error handling.
Use the test plan and carry out the tests. Produce screen shot evidence to show the tests that have been carried out and explain any errors that need to be resolved.
Amend the database based on the testing.
LO3 Assessment criteria 3.3
Now that the database has been designed, implemented and tested reflect on the process. Produce a report which:
LO4 Assessment criteria 4.1, 4.2
LO1 Assessment criteria 1.1, 1.2, 1.3, 1.4