Reference no: EM132515468
Unit 4 Relational Database Systems - ATHE Level 4 Diploma in Computing
Scenario
You have recently been appointed as database designer for HoneyBee in Stafford. HoneyBee Stafford is a sole trader, which has setup and is selling honey to customers in the local area. The business has been doing really well and until now it has recorded sales and customer information by hand. However the sales are increasing and the owner now needs to start tracking customer details, sales, bees, hives and batches of honey. The owner of HoneyBee has asked you to design a relational database that will store and record the business information.
Activity 1
The owner of HoneyBee Stafford has no experience of database management systems and you need to explain to him the different database management systems that are available and the benefits to him of using this type of system to store his data. You have agreed a date for a meeting and you wish to leave him with a guide to database management systems which includes:
• an explanation of database management systems
• an explanation of the different levels of database architecture
• a description of big data and how it can apply to the database management system
• an explanation of transaction processing within a database management system
• an evaluation of the importance of data integrity and quality control within a management system
Activity 2
Using the scenario, produce design documentation for a relational database for HoneyBee Stafford. Your design documentation should include ERD, Normalisation and data dictionaries for each of the tables you feel should be created in the database. Include security features to protect the data and include data integrity features to help users with data entry, including database administration.You must submit this work to your tutor and gain feedback.
Activity 3
The owner of HoneyBee Stafford has reviewed your design documentation and provided you with some feedback. However as he has no experience of relational databases he has asked you to write a report to him explaining the database design features you have used and how these meet the design brief. Use your design documentation to support your arguments in your report.
Produce a report to the owner of HoneyBee Stafford which explains:
• the relationships within the database
• normalisation and functional dependency within the database
• the data integrity and security controls you have designed
• integrity constraints within relational models
• how the design documents meet the design brief
In addition your report should evaluate how the database design meets the brief, following the feedback you have received from activity 2.
Attachment:- Relational Database Systems.rar