Unit 4.48 Relational Database Systems Assignment

Assignment Help Other Subject

Reference no: EM133038060 , Length: word count:6000

Unit 4.48 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

Reference no: EM133038060

Questions Cloud

Conduct checks of premises : Environmental health officers (EHOs) can conduct checks of premises, compliance with building codes and adherence to safe food handling practices.

Descriptions of experiences in different treatment : Descriptions of experiences in different treatment between female and male officers in the work environment is important to present.

How much will they need to save each year : If they make annual payments into a savings plan, how much will they need to save each year? Assume the first payment comes in 1 year

What is the tax effect adjustment entry : Effective from the first day of the next financial period, the company rate of income tax was increased from 30% to 25%. What is the tax effect adjustment entry

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

Determine beta for your firm : The Tech firm has a debt-to-equity ratio of 80% and a marginal tax rate of 25%, Determine beta for your firm

What total amount of revenue should table company disclose : What total amount of revenue should Table Company disclose in the statement of comprehensive income related to its investment in Chair Company

Criminal justice policy development : How should research be used in criminal justice decisions and criminal justice policy development?

Pass the necessary adjusting entries : Pass the necessary adjusting entries - Depreciation on buildings is based on a 20-year life. The original cost of the buildings was $720,000

User Account

All Pages