Database Design and Development – Database Developer for Mahrud Bee – IT Assessment Answer

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

IT Assessment Answer
Task:
Scenario
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:

the bees

the queens

customers

staff

orders

payments

products

suppliers

Activity 1
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.
Activity 2
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.
Activity 3
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.
Activity 4
Now that the database has been designed, implemented and tested reflect on the process. Produce a report which:

critically evaluates the design process and documentation that was produced for Mahrud Bees database identifying improvements with the design documentation where appropriate

reviews the database implementation process and explain what was successful and what you would do differently if you were to do this again

evaluates the role of databases within Mahrud Bees. Compare this with how larger organisations use databases

explains how Mahrud Bees can connect the database to other applications that it may use within the business

recommends to Mahrud Bees a database management system they can use to maintain the database you have created

This IT Assignment has been solved by our IT experts at TVAssignmentHelp. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.
 

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services