Order this Assignment Now: £159

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

Unit 4.48 Relational Database Systems

Level 4 12 Credits

Related Qualifications

ATHE Level 4 Diploma in Computing (QCF)

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 Unit 4.48 Relational Database Systems

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

LO1 assessment criteria, 1.1, 1.2, 1.3, 1.4, 1.5

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.

Assessment criteria, 3.1

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.

Assessment criteria, 2.1, 2.2, 2.3, 2.4, 3.2, 3.3

Guidelines for assessors Unit 4.48 Relational Database Systems

The assignments submitted by learners must achieve the learning outcomes and meet the standards specified by the assessment criteria for the unit. The suggested evidence described below is how learners can demonstrate that they have met the required standard. 

Activity number	Assessment criteria	Suggested evidence
1	1.1 1.2 1.3 1.4 1.5	The learner must produce a guide which meets the needs of the stated audience. The materials must demonstrate an understanding of database management systems.  Learners should investigate and explain what a database management system is and include examples of applications. Learners should explain the three level database architecture and database system and explain the transaction processing system and how it works within a database system. The learners should investigate the latest research into “big data” and they should relate this to how it applies to database management systems. The learners will consider data integrity and GIGO and what can be done to ensure data integrity and quality control within a database system.
2	3.1	The learners need to produce design documentation for HoneyBee Stafford. As a minimum they should include ERD, normalisation, data dictionaries and logical vs physical design documentation. They should consider what the business will need in terms of data requirements and the different types of data that will be required within the different tables to ensure effective data management.  Normalisation should be carried out to at least 3NF and ERD documents should be annotated correctly considering cardinality and ordinality. The learners will use these designs to support their arguments in their report in activity 3 and therefore they need to be complex enough to meet the requirements. The assessor should provide detailed feedback on the learner work, identifying strengths as well as specific areas for development. This should be documented and can form part of formative or summative assessment. Without detailed feedback the learner will find it difficult to complete parts of the next task and produce the evaluation required to meet the standards of AC 3.3.
3	2.1, 2.2, 2.3, 2.4, 3.2, 3.3	The learners will produce a comprehensive report which meets the standards set by the criteria for this task. Using the design documentation from activity 2, learners will explain their design documentation in detail throughout the report. They will use their design documentation to support their report and this can be included as screen shots or appendices. The learner will explain the relationship within the database and refer to their ERD. They will explain why they have made certain joins/relationships and the keys they have used. The learner will explain the integrity constraints they have considered throughout the design process and they will show the normalisation process from UNF to 3NF fully and correctly. The student will discuss the normalisation process they have been through and normal forms.  The learner will explain the security controls they have considered and included in their design documentation along with the database administration that would be implemented if the database is to be created. The learner will explain how their design documentation meets the owner’s requirements and they will include an evaluation of their design documentation which is directly related to the feedback.

Unit 4.48 Relational Database Systems