TECH1400 Database Design and Management Assignment Help

1. TECH1400 Database Design and Management Assignment Help TECH1400 Database Design and Management Assignment Assessment 1 Information Subject Code:TECH1400Subject Name:Database Designand ManagementAssessment Title:Case Study Design andAnalysisAssessment Type:Individual reportAssessment Length:1500Words(+/- 10%)Weighting:30 %Total

2. Marks:30Submission:Via MyKBSDue Date:Week 4 Your Task For this assessment, you will construct an Entity Relationship Model (ERM) for a real-world case study of an organisation and outline the business rules governing its operations and data management. Additionally, this assessment will allow you to demonstrate the concepts of database relationships, keys, and cardinalities covered in the first three weeks of the subject. Assessment Description This assessment evaluates your ability to construct an Entity Relationship Model (ERM) for a real- world organisation that uses a relational database based on Crow’s Foot notationusing MySQL Workbench. Also, it evaluates your understanding

3. of database relationships, keys, cardinalities, and the application of business rules in database design. This assessment aims to achieve the following subject learning outcomes: LO1:Investigate the use of Relational Database Management Systems in organisations.LO2:Construct database models. Assessment Instructions You are required to complete the following tasks: 1.Choose a real-world organisation that uses a relational database as part of its operations. This could be a business, government agency, non- profit organisation, or other type of entity.

4. 2.Research and identify the business rules that govern the organisation’s operations and data management. Additionally, Identify the types of data that are stored in the database, the relationships between the different data sets, and any key terminology or concepts that are relevant to the organisation’s use of the database. 3.Construct an Entity-Relationship Model (ERM) for the organisation’s database based on the Crow’s Foot notationusing MySQL Workbench. The Entity-Relationship Model Diagram (ERM) must be fully labelled and implementable by including all necessary components, such as entities, relationships, cardinalities, and constraints. Each entity should have essential attributes, including primary keys (PKs), foreign keys (FKs), and other necessary attributes.

5. 4.Provide a detailed, step-by-step explanation of the process you followed to create the ERM diagram, including the screenshot of the diagram during the four major construction steps (listed as the construction steps in item 7 below). 5.Your report should follow a professional report format. You can refer to resources in the MyKBS academic success centre regarding a professional report format. Click here to learn more about the professional format for this assessment. https://elearning.kbs.edu.au/mod/p age/view.php?id=400053 6.Your report must be submitted in MS Word format. You can access free Office 360 being a KBS Student. Click here to download Office 360. https://elearning.kbs.edu.au/mod/scorm/vi ew.php?id=323325 7.Your report must include the following sections:

6. Introduction: Provide a brief overview of the chosen organisation, its operations, and its use of a relational database. Business Rules: Identify and provide a detailed description of the business rules. You need to identify (at least 8) of the necessary business rules for your case study that govern the organisation’s operations and data management. Entity Relationship Model Design: Present your ERM design, using appropriate notation and symbols to represent the data relationships and structures. Explain the design choices you made and how they relate to the key concepts of database relationships, keys, and cardinalities. Construction steps: Provide step-by-step details of the ERM construction process and necessary explanation of the steps.

7. 1.Entities: Initial diagram with entities and descriptions 2.Attributes: Updated diagram with attributes 3.Relationships: Updated diagram that shows added relationships. 4.Final ERM: The complete final ERM diagram. 5.Your report should include at least 4 academic sources to support your arguments. Your ERM should demonstrate your understanding of the key concepts of database relationships, keys, and cardinalities covered in the first three weeks of the course. Please refer to the assessment marking guide to assist you in covering all the assessment criteria. Important Study Information

8. Academic Integrity and Conduct Policy https://www.kbs.edu.au/admissions/forms-and- policies KBS values academic integrity. All students must understand the meaning and consequences of cheating, plagiarism and other academic offences under the Academic Integrity and Conduct Policy. Please read the policy to learn the answers to these questions: What is academic integrity and misconduct? What are the penalties for academic misconduct? How can I appeal my grade? Late submission of assignments (within the Assessment Policy)

9. https://www.kbs.edu.au/admissions/forms-and- policies Length Limits for Assessments Penalties may be applied for assessment submissions that exceed prescribed limits. Study Assistance Students may seek study assistance from their local Academic Learning Advisor or refer to the resources on the MyKBS Academic Success Centre page. Further details can be accessed at https://elearning.kbs.edu.au/course/view.php?id =1481

10. Looking For: TECH8000 IT Capstone Assignment Help Generative AI Traffic Lights Please see the level of Generative AI that this assessment has been designed to accept: Traffic LightAmount of Generative Artificial Intelligence (GenerativeAI) usageEvidence RequiredThis assessment (✓) Level 1 Prohibited: No GenerativeAI allowed This assessment showcases your individual knowledge, skills and/or personal experiences in the absence of Generative AI support.

11. The use of generative AI is prohibited for this assessment and may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment. Level 2 Optional: You may use GenerativeAI for research and content generation that is appropriately referenced. See assessment instructions for details This assessment allows you to engage with Generative AI as a means of expanding your understanding, creativity, and idea generation in the research phase of your assessment and to produce contentthat enhances yourassessment.

12. I.e., images. You do not have to use it. The use of GenAI is optional for this assessment. Your collaboration with GenerativeAI must be clearly referenced just as you would reference any other resource type used. Click on the link below to learnhow to reference GenerativeAI. https://library.kaplan.edu.au/referencing- other-sources/referencing-other-sources- generative-ai In addition, you must include an appendix that documents your GenerativeAI collaboration including all prompts and responses used for the assessment. Unapproved use of generative AI as per assessment details during the content generation parts of your assessment may potentially resultin penalties for

13. academic misconduct, including but not limited to a mark of zero for the assessment. Ensure you follow the specific assessment instructions in the section above. ✓ Level 3 Compulsory: You must use GenerativeAI to complete your assessment See assessment instruction for details This assessment fully integrates Generative AI, allowing you to harness the technology’s full potential in collaboration withyour own expertise.

14. Always check your assessment instructions carefully as there may still be limitations on what constitutes acceptable use, and these may be specific to each assessment. You will be taught how to use generative AI and assessed on its use. Your collaboration with GenerativeAI must be clearly referenced just as you would reference any other resource type used. Click on the link below to learn howto reference GenerativeAI. https://library.kaplan.edu.au/referencing- other-sources/referencing-other-sources- generative-ai In addition, you must include an appendix that documents your GenerativeAI collaboration including all prompts and responses used for the assessment.

15. Unapproved use of generative AI as per assessment details during the content generation parts of your assessment may potentially resultin penalties for academic misconduct, including but not limited to a mark of zero for the assessment. Ensure you follow the specific assessment instructions in the section above.