Hello, if you have any need, please feel free to consult us, this is my wechat: wx91due
|
Subject Code: |
TECH1400 |
|
Subject Name: |
Database Design and Management |
|
Assessment Title: |
Case Study Design and Analysis |
|
Assessment Type: |
Individual report |
|
Assessment Length: |
1500 |
|
Words |
(+/-10%) |
|
Weighting: |
30 % |
|
Total Marks: |
30 |
|
Submission: |
Via MyKBS |
|
Due Date: |
Week 4 |
Your Task
Assessment Description
This assessment aims to achieve the following subject learning outcomes:
LO2: Construct database models.
Assessment Instructions
- 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.
- 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.
- Construct an Entity-Relationship Model (ERM) for the organisation's database based on the Crow’s Foot notation using 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.
- 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).
- 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/page/view.php?id=400053
- Your report must be submitted in MS Word format. You can access free Office 365 being a KBS Student. Click here to download Office 365. https://elearning.kbs.edu.au/mod/scorm/view.php?id=323325
- Your report must include the following sections:
- 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. You must include at least two constraints within the business rules.
- 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.
(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.
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
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.
Late submission of assignments (within the Assessment Policy)
https://www.kbs.edu.au/admissions/forms-and-policies
All assessments including draft copies must be written and submitted in English. The use of translation tools is not permitted.
Generative AI Traffic Lights
|
Traffic Light |
Amount of Generative Artificial Intelligence (GenerativeAI) usage |
Evidence Required |
This 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. |
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 content that enhances your assessment. 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 learn how 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 result in 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. |
✓ |
|
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 with your own expertise. 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 how 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 result in 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. |
|
Assessment Marking Guide
|
Marking Criteria _____| 30 marks |
F (Fail)
0 – 49%
|
P (Pass)
50 – 64%
|
C (Credit)
65 – 74%
|
D (Distinction)
75 – 84%
|
HD (High Distinction)
85 – 100%
|
|
Research of Business Rules _____| 8 marks
|
No or limited understanding of business rules demonstrated by providing no or limited evidence of research. No rules provided
|
Basic understanding of business rules demonstrated by providing evidence of basic research. Limited rules provided (3 or less)
|
Appropriate understanding of business rules demonstrated by providing evidence of advanced
research. Most rules provided (4 - 5)
|
Advanced understanding of business rules demonstrated by providing evidence of extensive research. Most rules provided (6 - 7)
|
Comprehensive understanding of business rules demonstrated by providing evidence of expert research. Most rules provided (8 or more)
|
|
Database Relationships, Keys, and Cardinalities _____| 6 marks
|
Does not demonstrate
understanding of database by not identifying any of the required components like entities, relationships, keys, and cardinalities.
|
Demonstrates basic
understanding of database by
identifying at least one of the required components like entities, attributes, relationships, keys, and cardinalities.
|
Demonstrates good understanding of database by identifying some of the required components like entities, attributes, relationships, keys, and cardinalities.
|
Demonstrates advanced understanding of database by identifying most of the required components like entities, attributes, relationships, keys, and cardinalities.
|
Demonstrates exceptional
understanding of database by identifying all the required components like entities, attributes, relationships, keys, and cardinalities.
|
|
ERM Design _____| 6 marks
|
Does not clearly present an ERM design or includes numerous errors and flaws.
|
Presents a basic ERM design with some errors and flaws.
|
Presents a good ERM design with few errors and flaws.
|
Presents an advanced ERM
design that accurately reflects the data relationships and structures of the chosen organisation's database.
|
Presents an expertly designed ERM that demonstrates exceptional understanding and accuracy.
|
|
Step-by-Step
Demonstration
_____| 6 marks
|
No steps are
demonstrated. Only
the final complete
diagram is
provided.
|
Demonstrates
some of the
required steps
(entities, attributes,
relationships, and
final diagram)
clearly with no
explanation.
|
Demonstrates
most of the
required steps
(entities, attributes,
relationships, and
final diagram)
clearly with limited
explanation of the
steps.
|
Demonstrates all the
required steps
(entities, attributes,
relationships, and
final diagram) clearly
with some
explanation of the
steps.
|
Comprehensive
demonstration of all the
required steps (entities,
attributes, relationships,
and final diagram) with
clear explanation of all
the steps.
|
|
Referencing
_____| 2 marks
|
Do not use
appropriate sources
to support
arguments and
analysis. No
references are
included.
|
Uses some
appropriate
sources to support
arguments and
analysis. At least 1
reference is
included.
|
Uses a good range
of appropriate
sources to support
arguments and
analysis. At least 2
references are
included.
|
Uses a wide range of
academic sources to
support arguments
and analysis. At least
3 references are
included.
|
Uses an exceptional
range of academic
sources to support
arguments and
analysis. At least 4
references are included.
|
|
Report Quality,
Language and
Writing
_____| 2 marks
|
Report contain
numerous errors
and flaws and does
not follow
guidelines. Uses
poor grammar and
expression that
hinder
comprehension.
|
Report contains
some errors and
flaws and follows
most guidelines.
Uses mostly clear
language and
writing that is easy
to understand.
|
Report contains
few errors and
flaws and follows
all guidelines.
Uses good
grammar and
expression that
enhances
comprehension.
|
Report is of high
quality, with clear,
well-structured
content, and follows
all guidelines. Uses
excellent grammar
and expression that
effectively enhances
comprehension.
|
Report is of exceptional
quality, with
sophisticated, well
structured content, and
follows all guidelines.
Uses outstanding
grammar and
expression that is
sophisticated and
enhances
comprehension.
|
|
Feedback and grades will be released via MyKBS |
|||||