Relational Database Systems Assignment guide
Activity1
n this point first of all you must describe, what is a Database Management System with some real-world examples of applications to go with it. You must explain your answer mostly in a non-technical way as you have to assume that your client (HoneyBee Stafford) does not understand complex technical details.
As a second task for Activity 1, you need to explain the three-tier architecture of the database systems. To make things simpler and clearer you may include diagram as well. In addition, you need to describe, what is a Transaction Processing System and explain how it works within a database system.
 The next task in the Activity is, you need to undertake a research on Big Data, what is Big Data, and how Big Data could be applied into DBMS. Also explain the Big Data technologies with examples.

 Further, you also need to explain about what data integrity is as well as what is GIGO. In addition, you also need to describe about quality control in database systems. Also, you need to give practices carried out in the industries to maintain the data integrity and quality control within a database system.
Activity2
You need to prepare a relational database design documentation for HoneyBee Stafford, for this Activity.
 You need to include at least ERD diagram, normalisation, data dictionaries and logical vs physical designs. For this purpose,? You should take into consideration the business requirements especially the data requirements and the different types of data within the tables of the database system.
 You should perform normalisation at least up to 3NF.
Your ERD diagram should correctly depict the cardinality and ordinality.
For the conceptual model, you need to only give the relationship between the entities and the attributes with just the basic features.
 Your logical model should be quite complex than the conceptual model with additional information of the data type of each attribute and the maximum number of characters or values each data type can hold.
 In order to draw the physical model for your database system, this is more complex than the logical model. In addition to the features in the logical model, you must include the Primary keys, Foreign keys as well as the overall structure of the Database design.
Activity3
For this Activity, you need to write a comprehensive report. You must use the design you described in Activity 2. You must describe each table from the design documentation in detail as well here. In addition, you may include screenshots of your working to support your design.