assessment
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: Task 3- Individual Project Length/Duration: N/A Unit Learning Outcomes addressed: a) Design and build relational databases b) Define views and formulate efficient queries using a query language and c) Be knowledgeable about issues relating to data access and retrieval, storage, ethics and privacy Submission Date: To be submitted in week 11 Assessment Task: The design, building, and querying of a relational database. 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: This assessment is an individual Project. An Australian owned business specialist about rental properties requires to efficiently record and track all of their listed properties, customers, staff, rental activities, and maintenance of the properties. The property managers accept entrusted rental management of the real estate from property owners. The property could be a house or apartment. Each property should be recorded with the information including property type, address, the number of bedrooms and bathrooms, listed weekly rental, as well as available date. When a customer wishes to rent a property, he/she is required to make an application which will be recorded. A customer can make many applications for different properties. However, only one application will be approved. If the application is approved, the contract start date, end date, and weekly rental must be recorded. A property is managed by one property manager and a manager could take care of multiple listed properties. From time to time the property under management may need some maintenance service or minor repair jobs (for example broken window, electrical fault, water pipe leaking etc). The company has contracted the maintenance tasks to qualified external employee who will undertake the repair job as required. The external employee could be an electrician, plumber, or handyman. Details of repair job and complete date must be entered. The people that system needs to record include property managers, the owners of property, the customers, and the contracted external employees. Their name, address, contact and phone are essential data in the database system. In addition, you should consider one or two extra attributes to describe property manager and external employer. Tasks to be completed: a. Create a complete ERD with entities and relationships using given scenario. Make sure that relationship types, participation and cardinality is shown in ERD. b. Convert the ERD to a set of relational tables in at least 3NF and draw a dependency diagram c. Create a database using MICROSOFT ACCESS- with primary keys, foreign keys, and other attributes mentioned for each entity using proper constraints. d. Create a form to input/update data e. Input some significant data in each table showing your understanding of the scenario. f. Create three queries. g. Create a report. ASSESSMENT SUBMISSION: The assignment must be submitted online in Moodle. All materials MUST be submitted electronically in Microsoft Word format. Other formats (e.g., pdf or MAC file) 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 MS Word. No paper based or hardcopy submission will be accepted. MARKING GUIDE (RUBRIC): Marking Criteria Lecturer Expectation Marks Comments ERD Right diagrammatic representation of entities, attributes, and relationships 10 Normalization Reflect understanding of dependencies and normalization. 4 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 Database, tables, keys, fields, and data Shows understanding of Microsoft Access as a relational DBMS and how it supports database design and implementation for relational databases.