Unit 4 Relational Database Systems Assignment

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

Reference no: EM132515468

Questions Cloud

Write literature review about conceptualizing leadership : Identify how you view leadership and explore your perceptions of different aspects of leadership - Write literature review 3 pages about conceptualizing leaders

What is covered in relation to the police innovation : Provide a brief and concise summary of what is covered in relation to the police innovation and what is the major conclusion/finding

Determine backward finite difference for first derivative : Determine the backward finite difference for the first derivative of v with step size k = 15 at mesh point i = 4. At the same point, also calculate the exact

Benefits associated with a sustainable business environment : Outline conflicting demands of stakeholders on industry, detailing 5 different stakeholders and their varying demands and identify the benefits associated

Unit 4 Relational Database Systems Assignment : Unit 4 Relational Database Systems Assignment Help and Solution, ATHE Level 4 Diploma in Computing - Assessment Writing Service

What is the size of the final payment : A loan of $28,000 is repaid by payments of $520 at the end of every month. Interest is 6.5% compounded monthly. What is the size of the final payment?

How many direct labor hours are used to manufacture : How much variable overhead cost is incurred to manufacture one unit of each of the company's five products? How many direct labor hours are used to manufacture

NX0474 Strategic Management for Competitive Advantage : NX0474 Strategic Management for Competitive Advantage Assignment Help and Solution, Northumbria university - Assessment Writing Service

Compute what financial advantage of further processing : Compute What financial advantage (disadvantage) of further processing one T-bone steak into filet mignon and New York cut steaks?

User Account

All Pages