ICTDBS506 Design Databases Assessment :
For solution: +610482078788
+61482073403
+61482072848
Declaration:
- I hereby declare that no part of this assignment or product has been copied from any other student’s work or from any other source except where due acknowledgement is made in the assignment.
- No part of the assignment/product has been written / produced for me by any other person except where collaboration has been authorised by the trainer/assessor concerned.
- I am aware that this work may be reproduced and submitted to plagiarism detection software programs etc. for the purpose of detecting possible plagiarism (which may retain a copy on its database for future plagiarism checking)
- I have read, and I clearly understand GBC assessment, course progress and intervention policies.
Student signature: ______________________________________
Note: The assessor may not mark this ICTDBS506 Design Databases Assessment if the above declaration is not ticked and signed
Instructions to Learner
Assessment instructions
Overview
Prior to commencing the ICTDBS506 Design Databases Assessment , your trainer/assessor will explain each assessment task and the terms and conditions relating to the submission of your assessment task. Please consult with your trainer/assessor if you are unsure of any questions. It is important that you understand and adhere to the terms and conditions, and address fully each assessment task. If any assessment task is not fully addressed, then your assessment task will be returned to you for resubmission. Your trainer/assessor will remain available to support you throughout the assessment process.
Assessment tasks are used to measure your understanding and underpinning skills and knowledge of the overall unit of competency. When undertaking any written assessment tasks, please ensure that you address the following criteria:
It is a condition of enrolment that you actively participate in your studies. Active participation is completing all the assessment tasks on time.
Plagiarism is taking and using someone else’s thoughts, writings or inventions and representing them as your own. Plagiarism is a serious act and may result in a learner’s exclusion from a course. When you have any doubts about including the work of other authors in your assessment, please consult your trainer/assessor. The following list outlines some of the activities for which a learner can be accused of plagiarism:
If it is identified that you have plagiarised within your assessment, then a meeting will be organised to discuss this with you, and further action may be taken accordingly.
Collusion is the presentation by a learner of an ICTDBS506 Design Databases Assessment as their own that is, in fact, the result in whole or in part of unauthorised collaboration with another person or persons. Collusion involves the cooperation of two or more learners in plagiarism or other forms of academic misconduct and, as such, both parties are subject to disciplinary action. Collusion or copying from other learners is not permitted and will result in a “0” grade and NYC.
Assessments must be typed using document software such as (or similar to) MS Office. Handwritten assessments will not be accepted (unless, prior written confirmation is provided by the trainer/assessor to confirm).
There are two outcomes of assessments: S = Satisfactory and NS = Not Satisfactory (requires more training and experience).
Once the learner has satisfactorily completed all the tasks for this module the learner will be awarded “Competent” (C) or “Not yet Competent” (NYC) for the relevant unit of competency.
If you are deemed “Not Yet Competent” you will be provided with feedback from your assessor and will be given another chance to resubmit your assessment task(s). If you are still deemed as “Not Yet Competent” you will be required to re-enrol in the unit of competency.
Additional evidence
If we, at our sole discretion, determine that we require additional or alternative information/evidence in order to determine competency, you must provide us with such information/evidence, subject to privacy and confidentiality issues. We retain this right at any time, including after submission of your ICTDBS506 Design Databases Assessment .
Confidentiality
We will treat anything, including information about your job, workplace, employer, with strict confidence, in accordance with the law. However, you are responsible for ensuring that you do not provide us with anything regarding any third party including your employer, colleagues and others, that they do not consent to the disclosure of. While we may ask you to provide information or details about aspects of your employer and workplace, you are responsible for obtaining necessary consents and ensuring that privacy rights and confidentiality obligations are not breached by you in supplying us with such information.
Assessment Task 1: Knowledge Test
Provide your response to each question in the box below.
| Q1: | Answer the following questions regarding the process of data analysis, particularly in determining data types and data structures, query and report design 1.1. Explain data analysis process? Answer using 20-40 words. 1.2. Discuss data type and the process of assigning them using 100-200 words. 1.3. What do you mean by data structure? Answer using 20-40 words. 1.4. What is a data query? Answer using an example within 30-60 words. 1.5. What steps you may take for simplifying and efficient report design. Identify five (5) steps. | Satisfactory response | |
| Yes ☐ | No ☐ | ||
| Q2: | Answer the following questions regarding the data modelling related to developing the conceptual data model 2.1. Explain conceptual data model from the three-levels of data modelling. Answer using 20-40 words. 2.2. Identify all steps for conceptual database design. | Satisfactory response | |
| Yes ☐ | No ☐ | ||
| Q3: | Answer the following questions regarding how data redundancy is identified. 3.1. What is data redundancy, explain with an example? Answer using 30-60 words. 3.2. How data redundancy can be reduced, and data integrity can be improved? Explain using 40-80 words. | Satisfactory response | |
| Yes ☐ | No ☐ | ||
| Q4: | Answer the following questions regarding database management system (DBMS) fundamentals, particularly during the design phase. 4.1. What are the three (3) main phases of database design. 4.2. Which phase of database design is also called the data modelling mapping phase? | Satisfactory response | |
| Yes ☐ | No ☐ | ||
| Q5: | Answer the following questions regarding encryption and authentication as these apply to database security features 5.1. What is encryption and authentication? Answer using 40-80 words. 5.2. When would you need a relational database security plan? Answer using 15-30 words. | Satisfactory response | |
| Yes ☐ | No ☐ | ||
| Q6: | Answer the following questions regarding the functions and features of data types, and data structures 6.1. What four (4) storage classifications are included in data types? 6.2. What is function data structure? Answer using 30-60 words. | Satisfactory response | |
| Yes ☐ | No ☐ | ||
| Q7: | Answer the following questions regarding the functions, and features, of databases 7.1. Identify three (3) features of the databases. 7.2. Mention three (3) functions of the databases. | Satisfactory response | |
| Yes ☐ | No ☐ | ||
| Q8: | Answer the following questions regarding logical design concepts, particularly those related to designing data structures, queries, screens and reports 8.1. What is the difference between conceptual and logical design? Answer using 40-80 words. 8.2. How a database report is linked to logical design concepts, particularly those related to designing data structures, queries, and screens? | Satisfactory response | |
| Yes ☐ | No ☐ | ||
| Q9: | Answer the following questions regarding the object model design concepts, particularly those related to designing data structures, queries, screens and reports 9.1. Identify two (2) objectives for a good object model design particularly those related to designing data structures, queries, screens and reports. 9.2. Explain the difference between data modelling and object modelling using 40-80 words. | Satisfactory response | |
| Yes ☐ | No ☐ | ||
| Q10: | Answer the following questions regarding the term ‘scalability’ as it applies to databases. 10.1. Explain the concept of database scalability using 20-40 words. 10.2. Why are relational databases not scalable? Answer using 20-40 words. | Satisfactory response | |
| Yes ☐ | No ☐ | ||
Assessment Task 2 – Skills Test
In thisICTDBS506 Design Databases Assessment task, you are required to design a database and complete the following activities:
Activity 1: Determine requirements for a database application
Activity 2: Develop a logical data model
Activity 3: Design the data structures
Activity 4: Design queries, screens and reports
Activity 5: Design access and security systems
Activity 6: Confirm the database design
You must complete the activities mentioned above based on the following case scenario:
Case scenario
You work for IPS computing pty. ltd. and design database applications for clients. You recently received a request to design a database application. The client has requested that the database application should be based on creating a website for a shop “Reliance products”.
You will be dealing with the following entities:
- Shops
- Customers
- Products
- Vendors
- Sales
Relationships between the entities
- Customers –> Sales; 1 customer can buy something several times
- Sales –> Customers; 1 sale is always made by 1 customer at the time
- Customers –> Products; 1 customer can buy multiple products
- Products –> Customers; 1 product can be purchased by multiple customers
- Customers –> Shops; 1 customer can purchase in multiple shops
- Shops –> Customers, 1 shop can receive multiple customers
- Shops –> Products; in 1 shop there are multiple products
- Products –> Shops; 1 product (type) can be sold in multiple shops
- Shops –> Sales; in 1 shop multiple sales can me made
- Sales –> Shops; 1 sale can only be made in 1 shop at the time
- Products –> Sales; 1 product (type) can be purchased in multiple sales
- Sales –> Products; 1 sale can exist out of multiple products
Model with relationships
Roles and responsibilities
Your trainer and assessor will play the role of the client and you will be required to interact with him/her to collect information related to the development of database application.
Activity 1: Determine requirements for a database application
In the first activity you will be meeting with the client, the role played by your trainer/assessor and conduct a user-needs analysis to determine the database functionality.
You will then be required to analyse the results of a user-needs analysis to find out the technical requirements, develop a conceptual model of the database, submit the conceptual model to the client for review and evaluate client feedback and make changes to the database application as required.
You must use the template provided to complete this assessment activity.
| Determine requirements for a database application | |
| Client’s requirements and needs Identify the requirements and needs based on the client’s inputs | |
| Analysis of the user-needs analysis to identify technical requirements Analyse the user-needs and requirements Identify the technical requirements | |
| Develop a conceptual model of the database Screenshot of the conceptual model of the database | |
| Submission of the conceptual model of the database to the client for feedback Submit the feedback of the client on the conceptual model of the database | |
| Evaluation of client feedback and changes required Evaluate the client feedback and changes required Suggest what changes you will be required. | |
| Changes made to the database application Implement the changes Provide evidence of implementation of changes | |
Activity 2: Develop a logical data model
This activity is in continuation to the previous ICTDBS506 Design Databases Assessment activity.
In this assessment activity, you are required to develop a logical data model. You must use the template provided to complete this assessment activity.
| Develop a logical data model | |
| The attributes and data types Identify attributes and data types based on client requirements and needs | |
| The normalisation of attributes Organise the columns and tables of a database Provide evidence of normalisation of attributes | |
| Develop an entity-relationship (ER) diagram in order to clarify the cardinality of relationships Develop an entity-relationship (ER) diagram You must develop the diagram by yourself | |
| Document attributes, normalised data, and the ER diagram Provide information related to attributes, normalised data and the ER diagram | |
| Forwarding the documentation to the client for confirmation Provide the documentation to the client for confirmation Provide evidence that this took place and feedback has been collected Mention the feedback in the space provided | |
Activity 3: Design the data structures
This activity is in continuation to the previous assessment activities.
In this assessment activity, you are required to design the data structures. You must use the template provided to complete this assessment activity.
| Design the data structures | |
| Confirm primary and foreign keys for tables Identify all primary keys Identify all foreign keys | |
| Review client business rules Identify and review client business rules Mention the statements that imposes some form of constraint on a specific aspect of the database, such as the elements within a field specification for a particular field or the characteristics of a given relationship | |
| Identify the referential integrity constraints Provide evidence of the association between the entity types | |
| Establish database management system constraints and incorporate into database design Establish the rules enforced on the data columns | |
| Develop the validation rules for data Provide evidence of developing the validation rules for data based on client needs and requirements | |
| Design indexes and develop the data dictionary Provide evidence of indexes and data dictionary development | |
| Document the database design Using 100-200 words explain the database design based on the work completed so far. | |
Activity 4: Design queries, screens and reports
This activity is in continuation to the previous assessment activities.
In this assessment activity, you are required to design the queries, screens and reports. You must use the template provided to complete this assessment activity.
| Design queries, screens and reports | |
| Design the user interface for database, including menus, input screens and outputs Provide screenshot of the user interface developed for the database The screenshots must include: Menus Input screens and outputs | |
| Design queries, based on requirements Provide evidence of different queries developed based on client needs and requirements | |
| Compare the physical design with the conceptual model, or user-needs analysis Provide evidence of the physical design with the conceptual model, or user-needs analysis | |
| Incorporate changes as required Submit the work to the client for feedback Analyse the feedback collected Provide evidence of implementation of the feedback | |
Activity 5: Design access and security systems
This activity is in continuation to the previous assessment activities.
In this assessment activity, you are required to design access and security systems. You must use the template provided to complete this assessment activity.
| Design access and security systems | |
| Review the business security plan as a basis for commencing the access and security design Example: Follow the guidelines provided regarding the “Business security plan” https://www.getsafeonline.org/businesses/business-security-plan/ Provide information how you would commence the access and security design | |
| Design the password and access system for the database Provide evidence of password and access system for the database | |
| Identify multiple-user requirements Provide evidence that you have identified multiple-user requirements | |
| Develop client access profiles using the client business model Provide evidence of development of client access profiles using the client business model | |
Activity 6: Confirm the database design
This activity is in continuation to the previous assessment activities.
In this assessment activity, you are required to confirm the database design. You must use the template provided to complete this assessment activity.
| Confirm the database design | |
| Identify the database backup and recovery requirements Provide evidence of identification of database backup and recovery requirements | |
| Develop and document the database backup and restore procedures Provide evidence of development and documentation of the database backup and restore procedures | |
| Submit the database, and documentation, to the client for final approval Provide evidence of database submitted to the client and client approval | |
Performance Criteria/Performance Checklist
| Your task must address the following performance criteria/ performance checklist. | |||
| To be assessed as satisfactory (S) in this assessment task the participant needs to demonstrate competency in the following critical aspects of evidence | S | N/S | Trainer/Assessor to complete (Comment and feedback to students) |
Visit:https://auspali.info/
Also visit:https://www.notesnepal.com/archives/767
For solution: +610482078788
+61482073403
+61482072848
YOUR COMMENT