{"id":105115,"date":"2022-06-06T00:00:00","date_gmt":"2022-06-06T00:00:00","guid":{"rendered":"https:\/\/nursingstudybay.com\/2022\/06\/06\/assessment-task-ifn554-databases-orm\/"},"modified":"2022-06-06T00:00:00","modified_gmt":"2022-06-06T00:00:00","slug":"assessment-task-ifn554-databases-orm","status":"publish","type":"post","link":"https:\/\/www.studyproessays.com\/help\/assessment-task-ifn554-databases-orm\/","title":{"rendered":"Assessment Task IFN554 Databases ORM"},"content":{"rendered":"

Assessment Task 1 – ORM
\nAssessment Task
\nIFN554 Databases
\nSemester 1A 2022
\nName \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.. Assessment 1 – ORM
\nDue \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026. Tuesday 19th April 2022 11:59pm
\nFormative Feedback \u2026\u2026 Tuesday 29th March 2022 11:59pm
\nWeight \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026 50%
\nType \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026 Group with individual
\nSubmit \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026 PDF Document via Blackboard
\nRationale and Description
\nFoundational to addressing business concerns is an understanding of core concepts, principles and skills required for understanding, designing, and managing databases. This implies understanding the kinds of techniques that are used to model data, and an ability to develop a concise conceptual model that represents a given universe of discourse.
\nThis assessment will involve creating a conceptual schema design for a given universe of discourse and the generation of a relational mapping.
\nYou will use your knowledge from the lectures and the techniques practised in the tutorial sessions and apply both to a set of tasks that refer to some business concern. You will not only perform the necessary steps to solve the tasks, but also provide an explanation of your approach.
\nLearning Outcomes
\nA successful completion of this task will demonstrate:
\n1. Knowledge of conceptual data modelling principles to understand, capture and analyse an abstraction of the complex data aspect of business domains.
\n2. Develop rigorous database design underpinned by a conceptual data model
\nInstructions
\nThis assessment will have a Group task with Individual components. You will have to solve two tasks:
\n1. Apply the Conceptual Schema Design Process (steps 1 \u2013 6) to a given business concern (group task)
\n2. Map a conceptual schema design to a relational database schema (individual task)
\nFor task 1, you can use any modelling tool (including MS PowerPoint, LucidChart, or even handwriting) to draw your models. Make sure the diagrams are readable. Assignment submissions are to be made via IFN554 Blackboard (including submission for formative feedback).
\nGroups should be of 2 members (exceptions can be made with the approval of the teaching team). Group members should belong to the same tutorial group.
\nAssignment submissions MUST be a single PDF file properly identified (student name and number).
\nFeedback
\nFeedback will be provided on specific questions related to the assessment during the drop-in session times, and via MS Teams. Please note that the teaching team will NOT respond to general \u201cis this good enough\u201d style questions or requests to pre-assess your work.
\nSubmission of assessment
\nAll assessment will be submitted via standard QUT electronic submission methods (e.g. Blackboard, Turnitin), and you will need to submit your assessment in the format specified in the assessment task sheet. Assessment will not be accepted by any other method or in any other format. Please note that all assessment is due on a Tuesday 19th April 11:59pm. You should submit early to avoid delays from technical issues. The most recent assessment prior to the due date will be used for marking. Please ensure that you are aware of QUT\u2019s policy on late assignments:
\nLate Submission \u2013 requesting an extension
\nNo member of the teaching team, including the unit coordinator, can grant you an extension for an assignment. If you need one, you must apply through HiQ:
\nhttp:\/\/external-apps.qut.edu.au\/studentservices\/concession\/
\nYou now have two options for assignment extension. There is one assignment extension online form with options for Longer extension and an Automatically approved 48-hour extension. You must select unit, assignment and extension type. More information and extension form: qut.to\/late-assessment
\nIf you don’t have an approved extension, you should submit the work you have done by the due date, and it will be marked against the assessment criteria. Assignments submitted without an approved extension will not be marked and will receive a grade of 1 or 0%.
\nReviews
\nWe cannot remark assessments. All assessments will be returned with feedback explaining the reasons for the marks allocated. If you require additional feedback or clarification, discuss it with your tutor. If you believe that there is a component that has not been marked in accordance with the criteria sheet, you must identify it in writing to your tutor.
\nAcademic Honesty
\nAny action or practice on your part which would defeat the purposes of assessment is regarded as academic dishonesty. The penalties for academic dishonesty are provided in the Student Rules. For more information, consult the QUT Library resources for avoiding plagiarism.
\nResources
\nThe following resources may Help with the completion of this task:
\n\u2022 Refer to tutorial materials, Microsoft Teams, and any lecture videos.
\n\u2022 Refer to the recommended book.
\nQuestions
\nQuestions related to the assessment should be directed to the teaching team during the workshops or drop-in sessions and also via MS Teams.
\nThe teaching team will not be available to answer questions outside business hours, nor in the hours immediately before the assessment is due.
\nAssessment Tasks
\nTask 1 [25 marks] \u2013 Group
\nProjectsRus maintains information about their project ( help with nursing paper writing from experts with MSN & DNP degrees) team staff members and the project ( help with nursing paper writing from experts with MSN & DNP degrees)s for clients. Perform CSDP step 1 ~ 6 and submit your final ORM diagram (not required to submit the results of the
\ninterim steps only the final diagram) for the following business concern.
\nProjectsRus business concern
\nA business called ProjectsRus hires project ( help with nursing paper writing from experts with MSN & DNP degrees) teams to develop and implement technology for a client. The project ( help with nursing paper writing from experts with MSN & DNP degrees) team is suitably qualified staff who fulfil the project ( help with nursing paper writing from experts with MSN & DNP degrees) roles of project ( help with nursing paper writing from experts with MSN & DNP degrees) manager (PM), software developer(SD), system analyst(SA), database developer(DD), user interface developer(UID), and tester(T). Other project ( help with nursing paper writing from experts with MSN & DNP degrees) roles are possible, and a staff member can have a different role in different project ( help with nursing paper writing from experts with MSN & DNP degrees)s. For example, you are the system analyst in one project ( help with nursing paper writing from experts with MSN & DNP degrees), and in another project ( help with nursing paper writing from experts with MSN & DNP degrees), you are a project ( help with nursing paper writing from experts with MSN & DNP degrees) manager. ProjectsRus maintains information about their project ( help with nursing paper writing from experts with MSN & DNP degrees) team staff members and the project ( help with nursing paper writing from experts with MSN & DNP degrees)s performed for clients. The following table shows the list of project ( help with nursing paper writing from experts with MSN & DNP degrees) team staff members details including their employment start and finish dates.
\nStaff ID Staff name Staff phone Employment
\nStart date End date
\nS100 Charlie 4663451 15\/03\/1990
\nS101 Isabella 4663452 01\/01\/2010 31\/12\/2015
\n01\/01\/2017
\nS102 Jacob 4663453 15\/03\/2001
\nS103 Damian 4663454 02\/06\/2015 31\/12\/2015
\n01\/03\/2017 05\/09\/2018
\nS104 Harry 4663455 01\/02\/2003
\nS105 James 4663456 15\/03\/2017 14\/12\/2018
\nS106 Michelle 4663457 12\/07\/2016
\nS107 Kyle 01\/11\/2019
\nS108 Amelia 4663459 15\/12\/2017
\nS109 Tom 4663460 01\/02\/2020
\nA client project ( help with nursing paper writing from experts with MSN & DNP degrees) is reported in a form of project ( help with nursing paper writing from experts with MSN & DNP degrees) charter which describes some important information about the project ( help with nursing paper writing from experts with MSN & DNP degrees) (e.g., the project ( help with nursing paper writing from experts with MSN & DNP degrees) name, period, scope, members, etc.) as shown in the following. A project ( help with nursing paper writing from experts with MSN & DNP degrees) team staff member has only one role in the project ( help with nursing paper writing from experts with MSN & DNP degrees). As shown in the examples, the full names of the roles are not used in a project ( help with nursing paper writing from experts with MSN & DNP degrees) charter.
\nProject Charter (1)
\nProject ID PRJ_515
\nProject Name Mobile Application to manage electronic scripts for doctor prescribed medicines
\nProject Sponsor Acme Chemist
\nDate of Approval 01\/02\/2020 Last Revision 03\/02\/2020
\nProject Description Mobile application so that patients with an electronic script for medicines can place an order and make payment for the medicines with their chemist of choice for pickup or delivery.
\nProject Period (year) 2
\nScope Identify system functionality from sample groups.
\nMobile App will function all mobile devices
\nIdentifies nearby chemists for immediate fulfilment, or a preferred chemist
\nOrder can be placed for pickup or delivery.
\nPayment options to be included. \u2026.
\nCompatibility with Government E-health systems. Compatibility with existing formats of electronic scripts and associated security\u2026.
\n\u2026 The scope goes on to explain further requirements included in the project ( help with nursing paper writing from experts with MSN & DNP degrees).
\n\u2026..
\nProject Members Role Name
\nPM
\nSA
\nSD
\nDD
\nUID
\nT Charlie (S100)
\nJacob (S102)
\nHarry (S104)
\nMichelle (S106)
\nKyle (S107)
\nAmelia (S108)
\nTotal Number 6
\nProject Charter (2)
\nProject ID PRJ_517
\nProject Name Application to interface dispensing machine to SCM IS.
\nProject Sponsor ChemistRus franchise.
\nDate of Approval 15\/05\/2017 Last Revision 20\/05\/2017
\nProject Description A standalone dispensing machine can load onto shelves and dispense prescription medicines (like a vending machine). The standalone dispensing machine needs to be interfaced to the existing supply chain management (SCM) information system
\n(IS). An application is required to interface between the existing SCM IS and the dispensing machine. The SCM IS lists incoming medicines from suppliers for loading onto the shelves of the
\ndispensing machine. The SCM IS will also list order information for dispensing medicines to customers.
\nProject Period (year) 1
\nScope Develop and implement an application to interface between the existing SCM IS and the existing dispensing machine. The interface application will need to transmit information to the dispensing machine so that a supplier\u2019s delivery of medicines is automatically loaded onto the correct shelves in the dispensing machine. The interface application will need to transmit information to the dispensing machine so that a customer\u2019s order is automatically dispensed. All transmissions to the dispensing machine will need to be confirmed by reply message. The dispensing machine will transmit and display any error or fault codes.
\n\u2026..
\nProject Members Role Name
\nPM
\nSA
\nSD
\nT Damian (S103)
\nIsabella (S101)
\nJames (S105)
\nMichelle (S106)
\nTotal Number 4
\nCriteria Sheet – Task 1 [25 marks]
\nCriteria
\nHigh Distinction
\n[20 \u2013 16 marks]
\nDistinction \/ Credit [20 \u2013 16 marks] Credit \/ Pass [15 \u2013 11 marks] Pass \/ Borderline [5 \u2013 10 marks] Fail [4 \u2013 0 marks]
\nSyntactic
\nCorrectness
\n[7 marks] The model is complete and fully syntactically correct The model is complete and mostly syntactically correct The model is mostly complete and\/or reasonably syntactically correct The model is partially complete and\/or mainly syntactically incorrect The model is mostly incomplete and\/or syntactically incorrect
\nSemantic
\nCorrectness
\n[15 marks] The model fully and correctly reflects every aspect of the facts described in the scenario The model fully and correctly reflects most aspects of the facts described in the scenario The model correctly reflects many aspects of the facts described in the scenario, or reflects most aspects but is somewhat incorrect or inefficient in structure The model reflects a few aspects of the facts described in the scenario and\/or has an incorrect or inefficient structure The model
\nincorrectly reflects the facts described in the scenario
\nPragmatic
\nCorrectness
\n[3 marks] The model has a clear structure designed for maximal
\nunderstandability by stakeholders (layout, labels, annotations, etc) The model has a mostly clear structure and\/or is designed for high understandability by stakeholders (layout, labels, annotations, etc) The model has a mainly clear structure and\/or is designed for reasonable understandability by stakeholders (layout, labels, annotations, etc) The model has a somewhat messy structure and\/or does not reflect that it has been designed with consideration for stakeholder understandability The model has an unclear structure
\nand\/or most would
\nfind it difficult to
\nunderstand
\nTask 2 [25 marks] \u2013 Individual
\nFollowing is an ORM model for employee. Map the schema to a relational database schema. Any possible constraints need to be included (e.g., primary key, foreign key).
\nCriteria Sheet – Task 2
\nMarks will be awarded for the following:
\n\u2022 Full marks will be awarded if all relations are correctly mapped with the schema including correct primary\/foreign keys.
\n\u2022 Any incorrect\/missing relations will be deducted: – penalty for missing relation
\n3 marks
\n– penalty for missing table and penalise for each missing key
\n5 marks if a table is missing
\n1.5 marks for missing primary key or missing foreign key
\n0.5 mark for minor errors
\nASSESSMENT CRITERIA
\n2022
\nFIRST SIT
\nCOURSE(S): BA (Hons) Business & Management Pathways \/ BA
\n(Hons) Business Studies \/ Franchises
\nMODULE TITLE: Leading Innovation & Change (CRN 12184)
\nFORM AND TITLE OF ASSESSMENT: Essay
\nLEVEL: H6
\nASSESSORS: Module Leader & Module Tutors (tbc)
\nESSAY QUESTION:
\n\u201cInnovation & change are central to value creation.\u201d Discuss
\nSubmission Deadline Full Time Campus Based & Franchise Cohorts:
\n12:00hrs noon Friday 6th May 2022 online submission by Turnitin on Moodle
\nAssessment Rationale
\nOn successful completion of this module students will be able to:
\nLearning Outcome 1 Evaluate the significance and importance of innovation and change in relation to business enterprises and notfor-profit organisations of all kinds.
\nLearning Outcome 2 Apply theories, tools and techniques appropriate to the management of innovation and change.
\nLearning Outcome 3 Manage and lead innovation and change to sustain business development.
\nLearning Outcome 4 Analyse the political, socio-economic and cultural factors promoting (or inhibiting) innovation and change with special reference to the role of networks (national regional and global) and National Innovation Systems (NIS).
\nThe module will be assessed through a 1 component assessment essay. The essay will carry 100% of the assessment marks. The assessment will cover Learning Outcomes 1,2,3&4.
\nAnswer Guide
\nThe question is designed to assess the candidates\u2019 breadth and depth of knowledge and understanding of the module learning outcomes. It provides candidates with the opportunity to demonstrate their knowledge and understanding of the module theory and their ability to contextualise this within the prescribed parameters of the set question.
\nThe question focuses on people and their role, responsibilities, impact etc. on innovation and change. It invites a discussion around the contribution and potential Dissertation Help UK<\/a> contribution made by people to innovation and change. A strong appreciation of complexities within the set context is expected. It further invites consideration and discussion of the wider interpretation of \u2018people\u2019 within the set context both from an internal and external perspective.
\nAs such the question provides scope for candidates to clearly demonstrate their knowledge and understanding across the full set of learning outcomes. The question requires candidates to find and express their academic voices through the construction, delivery and support of their arguments. Weak answers will remain superficial, under-developed and descriptive. Stronger answers will demonstrate greater levels and degrees of depth, breadth, complexity and sophistication of knowledge and understanding.
\nAssessment Criteria
\nSee grid below:
\nCourse Title(s): BA (Hons) Business & Management Pathways \/ BA (Hons) Business Studies \/ Franchises
\nModule Title: Leading Innovation & Change Level: H6
\nAssessment Title: \u201cInnovation & change are central to value creation.\u201d Discuss
\nWeighting: 100% (Essay)
\nCriteria and Weighting 100-70 69-60 59-50 49-40 39-30 Less than 29
\nKnowledge of relevant module theory (10%) Level of knowledge demonstrated is exemplary.
\nCritical, analytical and reflective throughout. Very good level of knowledge demonstrated. Discussion contains critical analysis and reflection. A reasonable to good level of knowledge demonstrated. Predominantly descriptive. Basic (narrow \/ limited) relevant knowledge demonstrated. To pass this knowledge must be linked to set question. Highly descriptive. Insufficient knowledge of relevant theory. Little to no knowledge of relevant theory.
\nUnderstanding of relevant module theory
\n(40%) Level of understanding is exemplary.
\nCritical, analytical and reflective throughout. Very good level of understanding demonstrated. Discussion contains critical analysis and reflection. A reasonable to good level of understanding demonstrated. Predominantly descriptive. Basic (narrow \/ limited) relevant understanding demonstrated. To pass this understanding must be linked to set question. Highly descriptive. Insufficient understanding of relevant theory. Little to no understanding of relevant theory.
\nPage 5 of 6
\nCriteria and Weighting 100-70 69-60 59-50 49-40 39-30 Less than 29
\nConstruction of thesis
\nstatement, presentation, development of relevant arguments. Extent to which full extent of set question has been addressed. (50%) Exemplary argument construction, presentation and development. All levels of the question (explicit and implicit) addressed in
\ndetail. Critical, analytical and reflective throughout. Very good level of argument construction, presentation, development. Most levels of the question (explicit and implicit) addresses. Discussion contains critical analysis and reflection. A reasonable to
\ngood level of argument construction, presentation, development. Predominantly descriptive. Basic (underdeveloped) weak
\nstructure. Little to no development of arguments. To pass content must be relevant and relate to the set question. Insufficient construction, presentation and development of arguments. Fails of address set question. Little to no attempt to address set question.
\nPage 6 of 6<\/p>\n","protected":false},"excerpt":{"rendered":"

Assessment Task 1 – ORM Assessment Task IFN554 Databases Semester 1A 2022 Name \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026.. Assessment 1 – ORM Due \u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026\u2026. Tuesday 19th April 2022 11:59pm\u2026<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[7643,7642,7645,7644],"tags":[7678,8989,8988,7387,633,8991,630,8987,8994,8467,15,8990,7656,7571,8993,66,8992],"class_list":["post-105115","post","type-post","status-publish","format-standard","hentry","category-custom-same-day-essays","category-custom-writings-writers","category-do-my-essay-mla-format","category-write-my-paper-hub-writers","tag-best-custom-paper-writing-service","tag-best-online-paper-writing-service","tag-best-paper-writing-service","tag-best-research-paper-writing-services","tag-cheap-research-paper-writing-service","tag-cheapest-paper-writing-service","tag-college-paper-writing-service","tag-free-paper-writing-service","tag-free-term-paper-writing-service","tag-paper-writing-service","tag-paper-writing-service-reddit","tag-professional-paper-writing-service","tag-someone-to-write-my-paper","tag-websites-that-write-papers-for-you","tag-what-is-the-best-paper-writing-service","tag-write-my-paper","tag-write-my-paper-for-me-free"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/105115","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=105115"}],"version-history":[{"count":0,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/105115\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=105115"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=105115"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=105115"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}