Answer To: Kent Institute Australia Pty. Ltd. Assessment Brief XXXXXXXXXXABN XXXXXXXXXXCRICOS Code: 00161E RTO...
Swati answered on Jun 11 2021
Assessment-4
Content Analysis
Database Fundamentals
Introduction and Background
Database technology seeks information and store, organize as well process it such that it is enabled by users to intuitively and easily get back for finding data (Shin et al, 2013). Database management is all about the actions taken by a business for manipulation and control of data so as to meet required conditions throughout the entire lifecycle of data. This reflective journal is about all the theoretical concepts learned in weeks 1 to 11 and would also include the application of knowledge on issues associated with technology and management of database.
Content analysis
Week 1
a. Theoretical Discussion
i. Important topics covered in this week included explanation of data, information, and database along with its several types. Importance of database for making decision, importance of database design, and evolution of modern databases from file systems is also covered (Thakar et al, 2008).
ii. Definitions covered in the content of this week included definition of data which includes facts as well as statistics collected together for purpose of analysis and information on other hand is what is being represented by specific sequence or arrangement of things.
b. Reflection on the Contents
i. My interpretation of the concepts is that these are interrelated terms wherein data is made up of small facts; information is obtained on consumption of knowledge about data which is used for making decision. And lastly database is an organized collection of related information (McHugh et al, 1997).
c. Outcome
i. The objective of the database concept learnt in this week was to give a clear understanding of the data, information, and database along with giving a glimpse about role played by these concepts. Also this week content helped to understand the flaws in the file system data management while outlines the core components of the database systems and described database management system’s main functions (Stonebraker and Kemnitz, 1991).
ii. Learnt concept improves my understanding of the database systems by giving me clear picture about the application, usage, flaws and components of database systems along with main functions of DBMS (Aken et al, 2017).
Week 2
a. Theoretical Discussion
i. Important topics covered include Data modeling, its building blocks, evolution of major data models and list of emerging alternative data models and classification by the abstraction level (Shin et al, 2013).
ii. Definitions included and studied in this week include data modeling which is the process of data model creation for storing data in the database. Another definition was of data model which is an abstract model organizing the data elements and standardizing the relation of each other to real world properties. Also, the unit included definition of the business rules which means business aspects that resolves to either true or false.
b. Reflection on the Contents
i. For a small pizza gourmet shop, the database management will require data modeling where in Products, vendors, and customers are all examples of potential entities in a data model (Aken et al, 2017). Business rules applicable on this are studied for DBMS that influences the database design.
c. Outcome
i. Objective of the database concept learnt in this week includes data modeling understanding, its importance in database management and technology. Furthermore, evolution of the major data models was clarified and made understood.
ii. The learnt concept improves my understanding of the database systems by creating a base for learning DBMS (Stonebraker and Kemnitz, 1991). Listing out of the emerging alternative data a model is being done that gives a picture and clarity about the need fulfilled by them.
Week 3
a. Theoretical Discussion
i. Important topics covered include logical structure description of relational database model, basic component identification of relational model, details of relational table such as structure and content. Also manipulation of relational table and handling of data redundancy is being discussed.
ii. Definitions studied in this concept are logical structure that means the way information in a document is organized, relational database that stores and provides access to data points that are related to one another and data redundancy which is defined as the storing of the same data in multiple locations.
b. Reflection on the Contents
i. For management of database for Pizza gourmet shop, the cloud based relational databases or databases as service are used mostly as this enables the company to outsource patching, database maintenance as well as infrastructure support requirements. Other examples of standard relational databases are Oracle dataset, My SQL, Microsoft SQL server and IBM DB2 (Aken et al, 2017). Manipulation of contents in relational table may be done using operators and data redundancy may also be well handled.
c. Outcome
i. The objective of the database concept learnt in this week is regarding giving clear understanding of the logical structure of relational database model along with identification of the basic components of the relational model and explaining the contents, structure as well as characteristics of a relational table.
ii. Learnt concept improves the understanding of the database systems as this helps to manipulate the relational table contents with the help of using relational database operators. Also, it helps in handling of data redundancy and highlights the purpose of indexing in a relational database (Aken et al, 2017).
Week 4
a. Theoretical Discussion
i. Important topics covered are entity relationship components definition, refining and incorporation into database design process. Also, the affect of ERD components on the design and implementation of database is observed and analyzed.
ii. Definitions learnt in this week included ERD which stands for Entity relationship diagram and shows the relationships of entity sets stored in a database. An entity in this context is an object, a component of data. Entity relationships model tends to describe interrelated things of interest in a specific domain of knowledge and the reconciliation which is defined as an accounting process that compares two sets of records to check that figures are correct and in agreement.
b. Reflection on the Contents
i. The three main components for the ER model of pizza gourmet house are entities, relationships and attributes. Entities in this business are customer, products and services whereas the attributes includes customer id, product code, service offered and the relationships will be many to one wherein all products, service are related with the customer.
c. Outcome
i. Objective of the database concept learnt is to help in identification of the main characteristics of the entity relationship components followed by describing the way in which relationships among the entities are defined, refined as well as incorporated into the process of database design.
ii. The learnt concept improves the understanding of the database systems as it helps to understand the affect of ERD components on the design and implementation of database is observed and analyzed. Also an understanding was developed regarding the real-world database design that requires reconciliation of the conflicting goals (Thakar et al, 2008).
Week 5
a. Theoretical Discussion
i. Important topics covered are describing the main EER model constructs along with learning the way in which they are represented in ERDs and EERDs. Then, representation of multiple entities was done with the help of using entity clusters followed by depicting the relationship in an ERD followed by describing the characteristics of good primary...