Produce design documentation for a relational database

Reference no: EM133141915

Assignment - Relational Database Systems

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.

Reference no: EM133141915

Questions Cloud

Corporal punishment : What do you believe should be corporal punishment when it pertains to inmates

Review charles whitman case in appropriate resources : If Charles Whitman had faced prosecution, how would you, as a forensic psychology professional expert witness for either the prosecution or the defense

Economic and social implications of public policy : The United States has the highest reported incarceration rate in the world. Discuss the economic and social implications of this public policy.

The death penalty remains controversial issue : The death penalty remains a controversial issue in American public policy. Many argue that it is a deterrent to criminal behavior;

Produce design documentation for a relational database : Using the scenario, produce design documentation for a relational database for HoneyBee Stafford. Your design documentation should include ERD

Quantitative methods in criminal justice : What are the strengths and weaknesses of using quantitative methods in Criminal Justice? How can academicians use data analysis to inform public decisions

Corporal punishment : What do you believe should be corporal punishment when it pertains to inmates? When should it be used?

Normal safety precaution undertaken in prisons : Strip searches of prisoners are normal safety precaution undertaken in prisons.

Do you think it possible to live colorblind life : Do you think it's possible to live a colorblind life? That is, a life in which you are ignoring any and all racist ideas? Why or why not?

User Account

All Pages