Unit Code\/s & Name\/s: ICTDBS506 – Design databases
\nCluster Name: N\/A
\nAssessment Type: \u2610 Case Study \u2610 Assignment \u2610 Project \u2612 Other (specify)<\/p>\n
Assessment Name: AT1 – Database research questions
\nAssessment Task No.: 1 of 2
\nAssessment Due Date: Week 8
\nDate Submitted: \/ \/
\nAssessor Name: [Assessor Name]<\/p>\n
Instructions to Student:
\nGeneral Instructions:
\nYou are required to answer 25 questions using your own research skills to provide the answers along with examples that illustrate your answers. You are also required to include a list of references at the end, which includes all the sources you accessed. Ensure you use an appropriate reference style. There are websites available that generate references for you, such as HarvardGenerator.<\/p>\n
Information\/Materials provided:
\n\u2022 A computer with internet access provided in the classroom.<\/p>\n
Work, Health and Safety:
\nThe environment should be assessed for safety prior to class. Special consideration should be taken regarding potential ICT-related hazards such as tripping hazards, electromagnetic radiation, ergonomics, and posture. TAFE Queensland health and safety policies and procedures should be followed at all times.<\/p>\n
Details of location:
\nTAFE will provide a simulated work environment in the classroom. All practical activities should be completed in the classroom with teacher\/tutor Helpance. However, it is possible to complete these tasks on a home computer with internet access, web browser, and office suites or similar.<\/p>\n
Time restrictions:
\nStudents can start completing this assessment from week 2 [Essay writing service – your education, our expertise: Get any assignment done with our professional essay writers before your deadlines – Zero AI, Human experts and Fast delivery.]; however, students have until week 7 to complete and submit the assessment.<\/p>\n
Level of Helpance permitted:
\nTeachers and tutors should be available in class and accessible by email for students working from home. Staff cannot directly provide students answers but can guide them to where to go to complete tasks individually.<\/p>\n
If you are unable to submit an assessment, you must notify your teacher before the assessment due date and supply a doctor\u2019s certificate and an extension approval from the team manager.<\/p>\n
Reasonable adjustments will be made for students as and when appropriate, after consultation with the Accessibility and Counselling team. You must see your teacher prior to assessment regarding this.
\nRPL (Recognition of Prior Learning) is available for this unit. Speak to your teacher\/assessor to check if you qualify for RPL.<\/p>\n
Assessment Criteria:
\nTo achieve a satisfactory result, your assessor will be looking for your ability to demonstrate the following key skills\/tasks\/knowledge to an acceptable industry standard:<\/p>\n
Relational database
\nDatabase features
\nData analysis process
\nConceptual data modelling
\nLogical model and physical model
\nEntity relationship diagram (ERD)
\nIdentifying relationship on an entity relationship diagram (ERD)
\nNormalisation, data redundancy and normal forms
\nDBMS, technical, and economic factors in choosing a DBMS.
\nPassword encryption, authentication
\nData structure, data type
\nForeign key constraint, referential integrity constraint rules
\nData definition language (DDL)
\nCase diagram
\nCheck constraints.
\nThe concepts of the object model design
\nVertical scalability and horizontal scalability
\nNumber of Attempts:
\nYou will receive up to two (2) attempts at this assessment task. Should your 1st attempt be unsatisfactory (U), your teacher will provide feedback and discuss the relevant sections\/questions with you and will arrange a due date for the submission of your 2nd attempt. If your 2nd submission is unsatisfactory (U) or you fail to submit a 2nd attempt, you will receive an overall unsatisfactory result for this assessment task. Only one re-assessment attempt may be granted for each assessment task.
\nFor more information, refer to the Student Rules.<\/p>\n
Submission details:
\nInsert your details on page 1 and sign the Student Declaration. Include this template with your submission. Your teacher will provide all the details for the submission system or network.<\/p>\n
Due Date: Week 7<\/p>\n
You are required to answer the questions in this document in the space provided under each question and save the document as [surname_student number_unit\/cluster_AssessmentNumber.zip]. For example: [surname_123456789_BSBCRT512_1.zip]
\nFor re-submissions, an “R” must be added to the file name. For example: [surname_123456789_BSBCRT512_1_R.zip]<\/p>\n
Assessment to be submitted to the allocated dropbox in Connect or to the allocated network folder.
\n\u2022 TAFE Queensland Learning Management System: Connect url: https:\/\/connect.tafeqld.edu.au\/d2l\/login
\n\u2022 Username: 9-digit student number
\n\u2022 For Password: Reset password go to https:\/\/passwordreset.tafeqld.edu.au\/default.aspx><\/p>\n
Instructions for the Assessor:
\nTo be judged competent in this assessment item, the student is required to demonstrate competence in all indicators shown in the marking guide.
\nDepending on the delivery mode and\/or timetable constraints, the Study Guide and the Study Schedule must be customized to suit the mode.<\/p>\n
Specifications of assessment:
\nThere are 25 main questions that must all be answered correctly to achieve a satisfactory result for this assessment. Students will be able to resubmit their work a second time if they are not successful on the first attempt.<\/p>\n
Equipment or material requirements:
\nA computer with internet access.<\/p>\n
Details of location:
\nTAFE will provide a simulated work environment in the classroom; however, it is possible to complete these tasks on a home virtual network using a computer with internet access.<\/p>\n
Level of Helpance permitted:
\nTeachers and tutors should be available in class and accessible by email for students working from home. Staff cannot directly provide students answers but can guide them to where to go to complete tasks individually.<\/p>\n
Interactions:
\nTeamwork skills are essential in the IT industry; therefore, students should work in teams to consult and collaborate on the practical activities. However, each student is required to complete the tasks individually.<\/p>\n
Contingencies:
\nReasonable adjustments will be made for students as and when appropriate, after consultation with the Accessibility and Counselling team. You must see your teacher prior to assessment regarding this.<\/p>\n
Work Health and Safety:
\nA work health and safety check of the assessment environment is to be conducted prior to the assessment, and any hazards addressed appropriately.<\/p>\n
Assessment Condition:
\nSkills in this unit must be demonstrated in a workplace or simulated environment where the conditions are typical of those in a working environment in this industry.
\nThis includes access to:
\n\u2022 industry-standard equipment and materials
\n\u2022 industry-standard database software
\n\u2022 network and other systems required for remote or multi-user access
\n\u2022 organizational requirements and deliverables
\n\u2022 computer-aided software engineering (CASE) or diagramming software.<\/p>\n
Note to Student:
\nAn overview of all Assessment Tasks relevant to this unit is located in the Unit Study Guide.<\/p>\n
Complete the following research questions. Remember that you cannot copy and paste from the Internet or any other source. Plagiarism will not be tolerated.<\/p>\n
In answering the questions, ensure that you:
\n\u2022 Provide a list of references at the end of the document, including all sources accessed using an appropriate referencing style such as HarvardGenerator.
\n\u2022 Provide examples to illustrate your answers. You can use your Database\/Website project ( help with nursing paper writing from experts with MSN & DNP degrees) for this unit as a source for your examples.<\/p>\n
Assessment questions:<\/p>\n
What is a relational database? (80 words) (Note: you might copy in your ERD from ICTICT523 AT2 and use this to illustrate your answer.)
\nAnswer:<\/p>\n
Describe the following nine (9) database features: (Note: you might copy in your ERD from ICTICT523 AT2 and use this to illustrate your definitions.)
\nFeature:<\/p>\n
Description:
\nExplain the data analysis process, covering the following in your answer: (Firstly consider the meeting you had with your client in ICTICT523. How would you know the data types for the various attributes in your draft ERD? EG: would a product code need to have the data type of: int, double, varchar, other? How would you determine this?)
\na) Determining the required data types. (50 words)
\nAnswer:<\/p>\n
b) Determining the required data structures. (50 words)<\/p>\n
Answer:<\/p>\n
c) Designing queries and reports. (50 words)<\/p>\n
Answer:<\/p>\n
Describe conceptual data modeling. (50 words)
\nAnswer:<\/p>\n
With reference to the conceptual model, logical model, and physical model, what are the differences between all three? (80 words)
\nAnswer:<\/p>\n
What is an entity relationship diagram (ERD)? (50 words)
\nAnswer:<\/p>\n
How do we represent an identifying relationship on an entity relationship diagram (ERD)? (50 words)
\nAnswer:<\/p>\n
a) What is normalization? How does normalization identify data redundancy? (80 words)
\nAnswer:<\/p>\n
b) Explain in detail and with examples the first three (3) normal forms (1NF, 2NF, 3NF) (number of words as required)<\/p>\n
Answer:<\/p>\n
What is a DBMS? (80 words)
\nAnswer:<\/p>\n
Explain five (5) technical, and five economic factors in choosing a DBMS. (150 – 200 words)
\nAnswer:<\/p>\n
Technical:
\n1.<\/p>\n
Economic:
\n1.<\/p>\n
Explain five (5) reasons an organization will be required to upgrade an existing DBMS. (150 – 200 words)<\/p>\n
Answer:<\/p>\n
Reasons:
\n1.<\/p>\n
What is password encryption? (50 words)<\/p>\n
Answer:<\/p>\n
What is authentication? (50 words)
\nAnswer:<\/p>\n
Why should encryption and authentication be incorporated into the database specifications? (50 words)
\nAnswer:<\/p>\n
Which form of encryption offers the best protection against brute force attacks? (50 words)
\nAnswer:<\/p>\n
What is a data structure? Provide examples of data structure in your answer. (80 words)
\nAnswer:<\/p>\n
As part of designing the physical data model, we select data types for each column. Explain which data type is best when dealing with currency in MySQL, and why? (100 words)
\nAnswer:<\/p>\n
Examine the table below. Is this database table compliant to third normal form (3NF)? Explain, in detail, why or why not. Use correct terminology when referring to database terms. (100 words)
\nAnswer:<\/p>\n
What is a foreign key constraint? In your answer, explain the referential integrity constraint rules and the three (3) possible actions. (80 words)
\nAnswer:<\/p>\n
The organization you work for, a shop selling motorbike spare parts, would like to ensure that every product name and product code stored in the database is never duplicated. Explain how you would achieve this. (50 words)
\nAnswer:<\/p>\n
Explain what the Data Definition Language (DDL) is. (50 words)
\nAnswer:<\/p>\n
Explain what an oval shape represents in a use case diagram. Illustrate your answer with an example. (Potential reference: Learner Guide, search for \u2018Use Case\u2019. Or on the Internet, search for \u2018Use Case Diagram\u2019. Don\u2019t forget to add an example.)
\nAnswer:<\/p>\n
a) What is the purpose of check constraints? Provide examples to illustrate your answer.
\nAnswer:<\/p>\n
b) Support for check constraints was introduced in MySQL 8.0.16 \u2013 older versions did not support the check feature. What other technique can you use instead of check constraints?<\/p>\n
Answer:<\/p>\n
You have been tasked to design the data structures, queries, screens, and reports of a new database. Describe the concepts of the object model design and how you would use this in your database design. (80 words)
\nAnswer:<\/p>\n
Explain the terms “vertical scalability” and “horizontal scalability”. (50 words)
\nAnswer:<\/p>\n
References:<\/p>\n
Insert references here using an appropriate referencing style such as HarvardGenerator.<\/p>\n
Assessment questions
\n1.\tWhat is a relational database? (80 words) (Note: you might copy in your ERD from ICTICT523 AT2 and use this to illustrate your answer.)<\/p>\n
2.\tDescribe the following nine (9) database features: (Note: you might copy in your ERD from ICTICT523 AT2 and use this to illustrate your definitions.)<\/p>\n
Feature\tDescription
\nField
\nTable
\nPrimary key
\nForeign key
\nConstraint
\nSuperkey
\nIndex
\nUser interface (UI)
\nReport<\/p>\n
3.\tExplain the data analysis process, covering the following in your answer: (Firstly consider the meeting you had with your client in ICTICT523. How would you know the data types for the various attributes in your draft ERD? EG: would a product code need to have the data type of: int, double, varchar, other? How would you determine this?)
\na)\tDetermining the required data types. (50 words)<\/p>\n
_____________________________A relational database is a type of database that organizes data into tables consisting of rows and columns. It is based on the relational model, which establishes relationships between tables using primary keys and foreign keys. In a relational database, data is stored in a structured manner, allowing for efficient data manipulation, Question Assignmenting, and retrieval. For example, in an ERD (Entity-Relationship Diagram) from ICTICT523 AT2, you can visually represent the tables and their relationships, demonstrating how the data is organized and connected.<\/p>\n
Database Features:<\/p>\n
Field: A field represents a specific piece of data within a table. It is the smallest unit of data storage and holds a single value, such as a customer’s name or a product price.
\nTable: A table is a collection of related data organized in rows and columns. It represents a specific entity or concept, such as customers, products, or orders.
\nPrimary key: A primary key is a unique identifier for each record in a table. It ensures that each record can be uniquely identified and serves as a reference point for establishing relationships with other tables.
\nForeign key: A foreign key is a field in a table that refers to the primary key of another table. It establishes a relationship between two tables by linking records based on common values.
\nConstraint: A constraint is a rule or condition that limits the values allowed in a field or a combination of fields. It ensures data integrity and enforces data consistency.
\nSuperkey: A superkey is a set of one or more attributes that uniquely identify a record within a table. It can be a combination of multiple fields that, when taken together, form a unique identifier.
\nIndex: An index is a data structure that improves the speed of data retrieval operations on a database table. It allows for quick access to specific data based on indexed columns.
\nUser interface (UI): The user interface refers to the visual or interactive components through which users interact with the database. It includes forms, menus, buttons, and other graphical elements that facilitate data input, manipulation, and retrieval.
\nReport: A report is a formatted presentation of data from the database. It provides a structured and organized view of specific information, often in a printed or electronic format.
\nData analysis process:
\na) Determining the required data types (50 words): In the data analysis process, determining the required data types involves understanding the nature of the data and selecting appropriate data types for each attribute. For example, a product code could be represented as a varchar or a string data type, as it typically consists of alphanumeric characters. The decision on data types can be influenced by factors such as data size, expected range of values, and specific data manipulation requirements. Consulting with the client and understanding their business needs can help in determining the appropriate data types for the attributes in the draft ERD.<\/p>\n","protected":false},"excerpt":{"rendered":"
Unit Code\/s & Name\/s: ICTDBS506 – Design databases Cluster Name: N\/A Assessment Type: \u2610 Case Study \u2610 Assignment \u2610 Project \u2612 Other (specify) Assessment Name:\u2026<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9022,8826,8770,11067,8769],"tags":[11066,11065,1402],"class_list":["post-134246","post","type-post","status-publish","format-standard","hentry","category-assessment-assignment-help","category-assessment-australia","category-assessments-help","category-computer-science-assignments","category-thesis-help","tag-at1-database-research-questions-assessment-task","tag-ictdbs506-design-databases","tag-write-a-paper"],"_links":{"self":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/134246","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/comments?post=134246"}],"version-history":[{"count":1,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/134246\/revisions"}],"predecessor-version":[{"id":134273,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/posts\/134246\/revisions\/134273"}],"wp:attachment":[{"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/media?parent=134246"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/categories?post=134246"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.studyproessays.com\/help\/wp-json\/wp\/v2\/tags?post=134246"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}