SOLUTION AT Australian Expert Writers

Details and Submission GuidelinesTrimester T2 2020Unit Code HS2021Unit Title HS2021 Database Design and UseAssessment Type Individual AssignmentAssessment Title Database DesignPurpose of theassessment (with ULO Mapping)a) Design and implement relational database for an information system by considering business need and context of the systems.b) Retrieve and present information from cross functional areas information using SQL tools and techniques.Weight 15% of the total assessmentsTotal Marks 15Word N/ADue Date Week 08Submission Guidelines • All work must be submitted on Blackboard by the due date along with a completed Assignment Cover Page. Submissions made after the due date and time will be penalized per day late (including weekend days) according to Holmes Institute policies.• The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2 cm margins on all four sides of your page with appropriate headings.• Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using or IEEE referencing style.• The SafeAssign similarity score will be used in determining the level, if any, of plagiarism. SafeAssign will check conference web-sites, articles, the Web and your own class members’ submissions for plagiarism. You can see your SafeAssign similarity score (or match) when you submit your assignment to the appropriate drop-box. If this is a concern you will have a chance to change your assignment and resubmit. However, resubmission is only allowed prior to the submission due date and time. After the due date and time have elapsed your assignment will be graded as late. Submitted assignments that indicate a high level of plagiarism will be penalized according to the Holmes Misconduct policy, there will be no exceptions.P a g e | 2Assignment Description1. Discuss each of the following terms (3 Marks):(3 Marks)a Data (1 Mark) b Field (1 Mark)c Record (1 Mark)2. Given the following business rules, create the appropriate entity relationship diagram (ERD).(5 Marks)a A company operates many departments. b Each department employs one or more employees. c Each of the employees may or may not have one or more dependents.d Each employee may or may not have an employment history.3. Write the SQL query that will produce a list of customers who have an unpaid balance. The required output is shown in Figure 1. Note that the balances are listed in descending order.(4 Marks)Figure 1 A List of Customers with Unpaid Balances4. Suppose that you have two tables, EMPLOYEE and EMPLOYEE_1. The EMPLOYEE table contains the records for three employees: Alice Cordoza, John Cretchakov, and Anne McDonald. The EMPLOYEE_1 table contains the record for employee John Cretchakov. Given that information, what is the query output for the UNION query? (List the query output.)(3 Marks)P a g e | 3Marking criteria:Marks are allocated for each part as above:Marking Rubric for Assignment 1 Total Marks 15Excellent Very Good Good Satisfactory UnsatisfactoryQuery writingSkills/2 Evidence of accurate andwell- written queries Evidence of good query writing skills. Generally relevant. Displayed reasonable query writing skills. Demonstrated little evidence of understanding the topic.Identification/3 Demonstrated excellent ability to think critically. Demonstratedan ability to think critically. Demonstrated reasonable ability to think. Demonstrat ed some ability to think critically but not complete. Did notdemonstrateability to think critically.Analyse/2 Logic is clear and easy to follow. Consistency logical and convincing. Mostly consistent logical and convincing. Adequate cohesion and conviction. Arguments are confused and disjointed.Design/Presentation/5 All are present and very well integrated. Most of the components present and integrated. Components present and mostly well integrated. Most components present. Report lacks structure.Evaluate/justification/3Excellent outstanding effort made. Extremely good effort. Good effort made but not outstanding. Made some effort. Very little attempt. Lazy effort with inaccuracies.

Order from Australian Expert Writers
Best Australian Academic Writers