Kent Institute Australia Pty. Ltd. Assessment Brief XXXXXXXXXXABN XXXXXXXXXXCRICOS Code: 00161E RTO Code: 90458 Version 2: 11th October, 2019 XXXXXXXXXXPage 1 of 4 XXXXXXXXXXTEQSA Provider Number:...

1 answer below »
reflective journal


Kent Institute Australia Pty. Ltd. Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458 Version 2: 11th October, 2019 Page 1 of 4 TEQSA Provider Number: PRV12051 ASSESSMENT BRIEF COURSE: Bachelor of Business/ Bachelor of IT Unit Code: DBFN212 Unit Title: Database Fundamentals Type of Assessment: Assessment 4- Content Analysis (Reflective Journal) Length/Duration: 2500 words Unit Learning Outcomes addressed: a) Describe the key aspects and critically evaluate uses of database technology and database management. b) Apply transaction processing and concurrency in multi-user database systems. c) Be knowledgeable about issues relating to data access and retrieval, storage, ethics and privacy. Submission Date: Week 14 Assessment Task: Students are required to analyse the weekly lecture material of weeks 1 to 11 by creating concise summaries of the theoretical concepts contained in the course lecture slides and providing their own reflections over it. Total Mark: 30 Marks Weighting: 30% Students are advised that submission of an Assessment Task past the due date without a formally signed approved Assignment Extension Form (Kent Website MyKent Student Link> FORM – Assignment Extension Application Form – Student Login Required) or previously approved application for other extenuating circumstances impacting course of study, incurs a 5% penalty per calendar day, calculated by deduction from the total mark. For example. An Assessment Task marked out of 40 will incur a 2 mark penalty for each calendar day. More information, please refer to (Kent Website MyKent Student Link> POLICY – Assessment Policy & Procedures – Student Login Required) https://kentinstituteaustralia.sharepoint.com/sites/Policies%26Forms/SitePages/Home.aspx?RootFolder=%2Fsites%2FPolicies%26Forms%2FPolicies%20and%20Forms%2FStudent&FolderCTID=0x012000E6C01ECDB12ACE448B94EB84A9F93758&View=%7B148054E0%2D0936%2D4517%2D8B3E%2DD0CCDC7CD88F%7D https://kentinstituteaustralia.sharepoint.com/sites/Policies%26Forms/SitePages/Home.aspx?RootFolder=%2Fsites%2FPolicies%26Forms%2FPolicies%20and%20Forms%2FStudent&FolderCTID=0x012000E6C01ECDB12ACE448B94EB84A9F93758&View=%7B148054E0%2D0936%2D4517%2D8B3E%2DD0CCDC7CD88F%7D Kent Institute Australia Pty. Ltd. Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458 Version 2: 11th October, 2019 Page 2 of 4 TEQSA Provider Number: PRV12051 ASSESSMENT DESCRIPTION: Students are required to analyse the weekly lecture material of weeks 1 to 11 and create concise content analysis summaries of the theoretical concepts contained in the course lecture slides. Where the lab content or information contained in technical articles from the Internet or books helps to fully describe the lecture slide content, discussion of such theoretical articles or discussion of the lab material should be included in the content analysis. The document structure is as follows (2500 Words): 1. Title Page 2. Introduction and Background (85 words) 3. Content analysis (reflective journals) for each week from 1 to 11 (2365 words; 215 words per week): a. Theoretical Discussion i. Important topics covered ii. Definitions b. Reflection on the Contents i. Create a brief scenario and apply the database concept learnt on it. You can use the same scenario for every lecture or modify it if needed. (Note: For week 1, you can omit providing a scenario, instead give your interpretation of the concepts.) c. Outcome i. What was the objective of the database feature/concept learnt? ii. How the learnt concept/feature improves your understanding of the database systems. 4. Conclusion (50 words) Your report must include: • At least five references, out of which, three references must be from academic resources. • Harvard Australian referencing for any sources you use. • Refer to the Academic Learning Skills student guide on Referencing ASSESSMENT SUBMISSION: This assignment should be submitted online in Moodle through Turnitin. The assignment MUST be submitted electronically in Microsoft Word format. Other formats may not be readable by markers. Please be aware that any assessments submitted in other formats will be considered LATE and will lose marks until it is presented in Word. For assistance please speak to our Academic Learning Skills Coordinators, in Sydney ([email protected]) or in Melbourne ([email protected]) . They can help you with understanding the task, draft checking, structure, referencing and other assignment-related matters. MARKING GUIDE (RUBRIC): The assessment will be marked according to the following criteria. Marking Criteria Marks Theoretical Discussion Topics covered Content precisely presented based on references 10 marks 4 24 marks Definitions 6 Reflection 10 marks mailto:[email protected] mailto:[email protected] Kent Institute Australia Pty. Ltd. Assessment Brief ABN 49 003 577 302 CRICOS Code: 00161E RTO Code: 90458 Version 2: 11th October, 2019 Page 3 of 4 TEQSA Provider Number: PRV12051 Outcome Objective 4 marks 2 Enhancement in understanding 2 Presentation (Layout, no grammatical errors, reads well, etc.) 3 Marks Cited references 3 Marks Total marks for content analysis assignment 30 Marks GENERAL NOTES FOR ASSESSMENT TASKS Content for Assessment Task papers should incorporate a formal introduction, main points and conclusion. Appropriate academic writing and referencing are inevitable academic skills that you must develop and demonstrate in work being presented for assessment. The content of high quality work presented by a student must be fully referenced within-text citations and a Reference List at the end. Kent strongly recommends you refer to the Academic Learning Support Workshop materials available on the Kent Learning Management System (Moodle). For details please click the link http://moodle.kent.edu.au/kentmoodle/mod/folder/view.php?id=3606 and download the file titled “Harvard Referencing Workbook”. This Moodle Site is the location for Workbooks and information that are presented to Kent Students in the ALS Workshops conducted at the beginning of each
Answered 9 days AfterJun 08, 2021DBFN212

Answer To: Kent Institute Australia Pty. Ltd. Assessment Brief XXXXXXXXXXABN XXXXXXXXXXCRICOS Code: 00161E RTO...

Swati answered on Jun 11 2021
140 Votes
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, informat
ion, 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...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here