Posted: April 4th, 2019

ICTDBS506

Analysis and Design Report

Design Databases

Can I See Writer Credentials?

You can view anonymized writer profiles, highlighting their degrees and expertise, to feel confident in who’s handling your paper. Each profile gives you a clear picture of their background, so you know they’re qualified for the job. Our team ensures every writer meets high academic standards. This transparency helps students make informed choices and find the best academic writing help online.

Created by

UPTOWN IT

For

<>

What If I Need Last-Minute Changes?

No problem! Request revisions anytime within 7 days, and we’ll tweak your paper quickly to meet your needs, free of charge. Our flexible process keeps your paper on track. Just update your order details in your account. Fast and responsive revision services are key for students managing tight deadlines.

YOUR NAME:
YOUR STUDENT NUMBER:

PROJECT REFERENCE:
DATE:

Contents

Task 1 – Meeting with client 2
Task 2 – Technical requirements 2
Task 3 – Conceptual model 2
Task 4 – Logical data model 4
Task 5 – Business rules and constraints 5
Task 6 – User interface 7
Task 7a – Physical design 8
Task 7b and 8 – Access and security 9
Task 9 – Client receipt 10

Can I Request Revisions to My Completed Essay?

Absolutely, our essay writing service offers free, unlimited revisions within 14 or 30 days, depending on your order, to meet your expectations. Simply contact your writer or our 24/7 support team to request adjustments, ensuring your paper aligns perfectly with your needs. We’re dedicated to your satisfaction, refining your essay until it’s just right. Trust us for exceptional, customizable academic assistance! Students often rely on our revision policy to achieve polished and professional academic results.

Remove all blue text once your report is completed. The blue text is intended at giving you some pointers for the report content.

Please ensure that you re-submit your ICTICT523 AT2 document with this assignment.

Task 1 – Meeting with client

NOTE: Already completed in ICTICT523 – Gather data to identify business requirements

a) This part consists of group work. Group size will depend on class numbers. Around four (4) people per group is an appropriate number. As a group, review the given scenario and collaboratively create a list of around 60 questions. Questions should be categorised as follow:
 Hardware
 Software
 Data requirements
 People – roles, access, etc.
 Processes/business activities
 Business rules
 Security
b) Provide evidence of communication between the student group/developer and the client/teacher. Send an email to the client/teacher requesting a mutually suitable time for a meeting. In a second email, once the meeting time has been agreed to, send the meeting agenda prior to the meeting.

How Do You Define Originality?

Originality means crafting every paper from scratch, with unique content and proper citations, verified by plagiarism checks for 95%+ uniqueness. You’ll receive a free originality report with every order. We guarantee your paper is one-of-a-kind. Academic integrity is our priority, ensuring your work is plagiarism-free and trustworthy.

c) Each group will have a meeting with the teacher/facilitator who will be playing the role of the client – a non-technical business executive. The meeting will either be recorded or documented as an observation checklist (by the teacher) as evidence to demonstrate that you have:
 met with the client to conduct the user-needs analysis
 negotiated and understood the client’s requirements for the functionality of the website
 used active listening, communicating in plain English, and summarising the client’s key points to understand their requirements.

 A meeting is a good way of identifying user needs. List and explain other four (4) methods that can be used to identify user needs. Superior Paper Help – Outline the advantages and disadvantages of each method.

Task 2 – Technical requirements

NOTE: Already completed in ICTICT523 – Gather data to identify business requirements

Based on the answers received as a result of the client meeting, recommend specific technical requirements for the database/website project.
You will also be required to research the technical requirements, and include references to where you sourced your information from.
Document the technical requirements (500-800 words). The document must include:
• technical requirements negotiated with the client/teacher during the meeting
• referenced sources of technical information you have obtained in preparing the technical requirements.

Can You Follow My Professor’s Unique Guidelines?

Absolutely! Share your professor’s rubric or specific instructions, and we’ll tailor the paper to meet every detail, no matter how unique. Even complex formatting or niche topics are no problem for our team. Our writers thrive on precision and customization. Upload your guidelines in the order form for best results. Following strict academic rubrics helps us deliver exactly what professors expect, boosting your grades.

Task 3 – Conceptual model

NOTE: Already completed in ICTICT523 – Gather data to identify business requirements

Design a conceptual model using Visual Paradigm (or similar). The conceptual model will take the form of an entity relationship diagram (ERD).
The conceptual model submitted with your evidence must include:
• the completed conceptual model for the database – first draft ERD
• feedback from the client, incorporated as amendments in the model – provide evidence of communication between you and the client/teacher (exchange of e-mails)
• content written in plain English language which a non-technical client would understand.

Task 4 – Logical data model

a) Perform normalisation process to at least third normal form (3NF) showing the results for each step. (Hint: Normalisation to be completed on each of the forms provided for the scenario. Reference: 03a_SomeBackgroundOnNormalisation.doc.)
b) Update the ERD after normalisation. Ensure that the cardinality ratio is displayed. (Hint: Based on your initial version prepared in ICTICT523 – updated as required.)
c) Develop a data dictionary that clearly indicates the data types and precision parameters for each field (size, range and nullability), primary and foreign keys for tables, data validation and business constraints (checks or triggers). Template provided. (Hint: Export a data dictionary from Visual Paradigm (or equivalent))

Can You Provide Sample Papers?

Yes, we offer sample papers upon request to showcase our quality and style, helping you decide before placing an order. These samples reflect our commitment to excellence. Contact support to view samples relevant to your needs. Reviewing samples lets you see how our writers handle academic research and formatting at a professional level.

NOTE: The logical data model submitted with your evidence must include:
• normalisation documentation (step-by-step)
• final ERD
• data dictionary
• approval of the logical data model to the client (exchange of e-mails).

To: Client
From: Me…
CC:
BCC:
Date: 19/07/2023
Subject: Logical database model

————————————————————-

Hi ,

How Do I Specify My Requirements?

Use our order form to detail your topic, style, and any specific instructions, or upload files for your writer to follow precisely. Clear instructions ensure a perfect paper every time. Our support team can guide you if needed. Detailed requirements give us the roadmap to craft academic writing that fully meets your expectations.

…

Regards,

———————————————-

SystemsAnalyst@UptownIT.com.au
———————————————–

Task 5 – Business rules and constraints

Are Your Writers Native English Speakers?

Many are native speakers, and all are fluent, passing strict language tests to ensure clear, professional writing for your papers. Every writer is evaluated for grammar, tone, and flow to match academic standards. You can request a native speaker if preferred. This ensures your paper maintains a natural flow and academic credibility.

a) Create a database – Create a database in-line with your ERD and normalisation within Microsoft Access, LibreOffice Base, Microsoft SQL Server or MySQL. Add the required tables and relationships within this database.
b) Add Sample Data – Add at least 2 records of sample data to each table of your database.
c) Database Data Dictionary – Generate a data dictionary (or equivalent) from your database. (- – Note: this is a second data dictionary, in addition to the one you have generated from your ERD.)

d) Business rules – Identify a minimum of five (5) business rules that apply to the database/website project. (Hint: These would be based on requirements noted by your client in your initial project requirements meeting for ICTICT523.)
e) Integrity constraints – Primary and foreign keys have been identified. Also identified in the data dictionary. (Hint: As per your updated ERD and Data Dictionary in Task4, and noted in the table below.)
f) Referential integrity constraints – Identify and set all referential integrity constraints. Use the table below to document the referential integrity constraints by indicating the rules and actions that apply to each foreign key. (Hint: As per your updated ERD and Data Dictionary in Task4, and noted in the table below.)

TABLE and FOREIGN KEY (FK) TABLE & PRIMARY KEY it REFEENCES (PK) REFERENTIAL INTEGRITY CONSTRAINTS REFERENTIAL ACTIONS
RULE 1
FK has the same declaration (data type and domain) that the PK it references RULE 2
FK value is equal to value in PK or NULL
Table_name
(FK)_Col_name Referenced_tbl_name
(PK)Col_name Yes Yes ON DELETE CASCADE,
ON UPDATE CASCADE
Add lines as required

g) Semantic and other constraints – These can take the form of validation rules, check constraints and triggers. These need to have been included in the data dictionary. Review and update this section the data dictionary until you are sure that all semantic constraints have been identified. (Hint: These would be based on requests from the client from your initial project requirements meeting for ICTICT523. Examples of these might include: phone numbers or email addresses having a correct format, a product code having the correct number of numbers and characters, a customer name having being entered, a date being in an appropriate date range, a quantity ordered having been entered, and being in an appropriate value range, etc.)
h) Indexes – Identify which table column will benefit from indexing and create the indexes. You can use the table below to record the indexing. (Hint: While many RDBMS add their own indices, additional indices might be added to improve search efficiency. For instance, indices could be added to customer names, or product codes and/or product names, etc, where searching would be more based on words rather than just IDs.)

Can You Help with Literature Reviews?

Definitely! Our writers craft comprehensive literature reviews, synthesizing sources to support your research with clarity and depth. We ensure every source is relevant and properly cited. Just provide your topic or sources to get started. Literature reviews are essential for dissertations, theses, and research projects, and our experts can guide you with precision.

INDEX NAME COLUMN NAME TABLE INDEX TYPE
(e.g. HASH or B-Tree) SEARCH BENEFITS

Add rows as required

i) Provide an estimation of the approximate size of the completed database. Explain how you have reached the estimate. (Hint: See sample spreadsheet provided)

Task 6 – User interface

What Payment Methods Do You Accept?

We accept major credit cards, PayPal, and secure bank transfers, all processed through encrypted systems for your safety. Your financial security is our priority. Choose the method that works best for you at checkout. Flexible payment options make our academic services accessible to students worldwide.

Using inVision , MockFlow or similar program (Prototyper, Microsoft Visual Studio, etc) design a user interface for the required database/website project including menus, input forms, and reports. The number of screens and reports depends on the case study or scenario used for the project.

The queries necessary to display the required reports will be completed in Task 7.

Task 7a – Physical design

Create a database prototype following the blueprint or structure outlined in the data dictionary created in Task 4. Export or dump the database structure as an SQL file and/or data dictionary file. Submit the database or SQL file, and your exported data dictionary as evidence of database implementation. Apply the constraints identified in Task 5 to the database and provide evidence of the implementation of these.

How Do You Handle Group Projects?

We can write sections for group projects, ensuring consistency with your team’s style and integrating seamlessly with other parts. Whether you are working with three people or ten, we make sure the tone and structure stay unified. Our writers collaborate to match your group’s vision. Upload any shared guidelines to keep everything aligned. With our support, group assignments become smoother and more cohesive.

a) Compare conceptual model and technical requirement with the actual database created and list and explain the differences. Make sure to make changes to the database, as necessary, while performing this review.
b) Populate the database with appropriate testing data – sufficient to run the queries.
c) Create and run the necessary queries to display the reports outlined in the case study or scenario project requirements. Provide screenshots of your queries and results. Remember that these queries are run on the database prototype and their purpose is to ascertain that the database structure is sufficient to produce the desired results.

Task 7b and 8 – Access and security

Superior Paper Help – Outline a plan to backup and restore the database remembering that at this stage it is just a prototype.

Review the business security requirements for the case study/scenario. The points below may help you clarify these requirements.
• How the users will gain access.
• How the password will be stored securely.
• Who will be authorised to access the database.
• What permissions will be given
• The different permission levels.

At this stage, you are ready to document the access and security requirements (500-800 words). The document must ensure that:
• Security design meets the requirements of the business security requirements.
• The password access system for the database including encryption/hashing details.
• The different user groups and their access requirements and privileges. (Role-Based Access Control, RBAC)
• User access assessment task profiles.

Can You Assist with Grant Proposals?

Yes, our writers have experience crafting compelling grant proposals, tailored to meet funding requirements with persuasive arguments. We help you make a strong case for funding. Provide your guidelines, and we’ll deliver a winning proposal. Strong proposals can secure critical funding and boost your academic or professional projects.

Task 9 – Client receipt
a) Create a checklist to seek feedback from the client/teacher, change according to given feedback.
b) Write an email to the client/teacher to obtain sign off via communicating your intention to submit the completed database design documentation. Include this email with your submission with sign off sheet.
c) Upload your completed database portfolio (zipped folder) to Connect which include:
• Assessment document (this word file)
• Database and any associated SQL files of your database
• UI Design documents and Report samples– if separate from this report
• Excel file with data dictionary
• Any other additional files prepared for this assessment that have not been included in this dot-point list.

Example Sign-off:

DATABASE DESIGN REPORT SIGNOFF
Signing off on this document signifies that the Analysis Report complies with the Client Business requirements.

Project Manager
Signature:
Date:
Systems Analyst
Signature:
Date:

————————

What’s Your Turnaround for Editing?

Editing typically takes 24-48 hours, depending on paper length, with rush options available for faster delivery. We polish your work to perfection quickly. Upload your draft to start the process today. Our professional editing enhances clarity, grammar, and structure for stronger academic writing.

__________________________________________________
Student Name Student Number
Unit Code/s & Name/s ICTDBS506 – Design databases
Cluster Name
If applicable N/A
Assessment Name AT2 – Database/website design project portfolio Assessment Task No. 2 of 2
Assessment Due Date Week 11 Date submitted / /
Assessor Name
Student Declaration: I declare that this assessment is my own work. Any ideas and comments made by other people have been acknowledged as references. I understand that if this statement is found to be false, it will be regarded as misconduct and will be subject to disciplinary action as outlined in the TAFE Queensland Student Rules. I understand that by emailing or submitting this assessment electronically, I agree to this Declaration in lieu of a written signature.
Student Signature Date / /

Instructions to Student Using the scenario provided, you are required to complete nine (9) tasks. Task 1 involves working in a group but the other eight (8) tasks you will be working alone or as directed by your teacher. These tasks are:
1. Meeting with a client
2. Technical requirements
3. Conceptual model
4. Logical data model
5. Business rules and constraints
6. User interface
7. Physical design
8. Access and security
9. Client receipt, feedback checklist, sign off sheet
The project involves the creation of a front-end website supported by a back-end database to implement the solution required. The website must be responsive to different screen sizes. Initial details of the client’s background, data requirements are supplied below.
Materials to be supplied:
• Case Assessment Help – – Scenario
• Excel file for data dictionary
• Access to a computer with:
o Internet access
o Web browser
o Microsoft office
o Database provider(MySQL/PhpMyAdmin/Microsoft SQL Server)
• Suggested applications are:
o inVision
o MockFlow or similar

Work, Health and Safety:
The environment should be assessed for safety prior to class. Special considering 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.

Details of location –
TAFE will provide simulated work environment in the classroom all practical activities should be completed in the classroom with teacher/tutor assistance; however, it is possible to complete these tasks on a home computer with internet access, web browser and office suits or similar.
Time restrictions – this is a portfolio assessment designed to take place over 8 weeks. The student is expected to attend in class for 7 hours per week (this includes theory sessions) and should be able to commit up to 3 hours per week in their own time.
Level of assistance permitted:
Teachers and tutors should be available in class, and accessible by email for students working from home. Staff cannot directly show students answers but guide them to where to go to complete tasks individually. Students with disability will receiver reasonable adjustments.
If you are unable to attend assessment you must notify your teacher before the assessment and supply a doctor’s certificate and approval from the team manager for extension. Reasonable adjustments will be made for students as and when appropriate, after consultation with the Disability and Counselling team. Extra time may be given for Language literacy and numeracy (LLN) or extenuating circumstances – you must see your teacher prior to assessment regarding this.
RPL (Recognition of Prior Learning) is available for this unit. Speak to your teacher/assessor to check if you qualify for RPL.
Assessment Criteria:
To 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:
1. Meeting with a client
2. Technical requirements
3. Conceptual model
4. Logical data model
5. Business rules and constraints
6. User interface
7. Physical design
8. Access and security
9. Client receipt
Submission details
(if relevant) Insert your details on page 1 and sign the Student Declaration. Include this form with your submission.
Due Date:
Week 8
You need to submit three files in a zipped folder:
• Assessment document (this word file)
• SQL file of your database
• Excel file with data dictionary
Your assignment must be saved with your
surname_student number_unit/cluster_AssessmentNumber.zip.
For example:
surname_123456789_ICTDBS506_2.zip
For re-submissions, an “R” must be added to the file name. For example:
surname_123456789_ICTDBS506_2_R.zip
Submit your assessment to the allocated dropbox in Connect or to the allocated network folder. Your teacher will provide all the details for the submission system or network.
Connect details:
• TAFE Queensland Learning Management System: Connect url: https://connect.tafeqld.edu.au/d2l/login
• Username; 9 digit student number
• For Password: Reset password go to https://passwordreset.tafeqld.edu.au/default.aspx>

Can You Write for Non-Academic Purposes?

Sure! We handle professional documents like reports or personal statements, customized to your goals and audience. Our versatile writers adapt to any context. Just specify your needs in the order form. From resumes to cover letters, our team ensures your documents stand out and make an impact.

Instructions to Assessor Specifications of assessment – To be judged competent in this assessment item the student is required to demonstrate competence in all indicators shown in the marking guide.
Depending on the delivery mode and/or timetable constraints, the Study Human Written Academic Papers – Guide and the Study Schedule must be customised to suit the mode.
Select project scenario or case study from the resources folder.
Information / Materials provided:
• Case Assessment Help – – Scenario
• Excel file for data dictionary
• Access to a computer with:
o Internet access
o Web browser
o Microsoft office
o Database provider(MySQL/PhpMyAdmin/Microsoft SQL Server)
• Specialisation specific project requirements
• Suggested applications are inVision , MockFlow or similar
Assessment location:
Computer lab that simulates an ICT workplace environment.
Time restrictions – this is a portfolio assessment designed to take place over 8 weeks. The student is expected to attend in class for 3 hours per week (this includes theory sessions), and also should be able to commit up to 3 hours per week in their own time.
Level of assistance permitted – teachers and tutors should be available in class, and accessible by email for students working from home. Staff cannot directly show students answers but guide them to where to go to complete tasks individually. Students with disability will receive reasonable adjustments.
Work Health and Safety:
The environment should be assessed for safety prior to class. Special considering 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.

Interactions – teamwork skills are essential in the IT industry therefore you should work in teams to consult and collaborate on the practical activities. Students need to perform Task 1 in group, and other tasks individually and will be required to show their work (unless indicated).
Contingencies – reasonable adjustments can be made for students who require variations to assessment conditions.
If Microsoft Word is not available; other word processing software may be used, given that the items produced can still be exported to a format accepted by Microsoft Word.
Students can use MySQL, PhpMyAdmin or similar Database provider.
inVision , MockFlow or similar program may be used, given that it supports and same features and functionality as the suggested programs.
Assessment Conditions:
Skills 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.
This includes access to:
• industry standard equipment and materials
• industry standard database software
• network and other systems required for remote or multi-user access
• organisational requirements and deliverables
• computer-aided software engineering (CASE) or diagramming software.
– – Note to Student An overview of all Assessment Tasks relevant to this unit is located in the Unit Study Human Written Academic Papers – Guide.

Project Assessment Help – – Scenario

You are employed by Uptown IT’s Software Solutions Department as a Systems Analyst. You have been assigned to a new project and your task is to initiate contact with the client, attend a client meeting, gather project requirements, and document the findings by producing an Analysis Report. The Client for this project is Caroline’s Classroom Robots.
Your teacher/assessor will take on the role of the Project Manager assigned to this project by Uptown IT.

DETAILS:
Caroline is looking to get your support in programming one or more robots to assist her with classroom administration and supporting student activity.

Can You Write My Paper in Any Citation Style?

Our skilled writers are proficient in all major citation styles, including APA, MLA, Harvard, Chicago, and more, ensuring your paper meets specific guidelines. Simply specify your required style in the order form, and we’ll format every reference perfectly. Our team’s expertise guarantees a polished, professionally formatted essay tailored to your needs. Get a perfectly cited paper with our trusted writing service! Proper citations strengthen your academic credibility and prevent plagiarism concerns.

Specifically, Caroline would like the robot(s) to assist her with:
• Welcoming students to the class and tracking their attendance.
• Interacting with students in the delivery of a range of tutorial exercises.
• Tracking the activities and results of students throughout each lesson.
• Store a record of these various details for review, reporting and statistical reporting purposes; and for planning future class exercises, activities and preparation.

Caroline would like screens and reports accessible via her computer tablet to review these various details on a day to day basis, and for reviewing periodic reports.

Caroline is seeking a meeting with your team so that she might provide more specific details.

Some Suggested Reports:
Some of the anticipated reports for this project include:
• Attendance of students in class on a given day
• Attendance, grouped by students between two dates
• Exercise results for a given student by Exercise Type (eg: Reading, Writing, and Mathematics), and by Exercise Homework Help – Topic within that (eg: Arithmetic Level 1, Arithmetic Level 2), between two dates
• Average of results grouped by Exercise Type and within that by Homework Help – Topic. Eg:

Type Homework Help – Topic Average (/10)
Reading Homework Help – Topic R1 8.2
Homework Help – Topic R2 7.6
Writing Homework Help – Topic W1 6.8
Homework Help – Topic W2 9.0

SECURITY REQUIREMENTS
The following security requirements must be met:
• Authentication
• Password encryption/hashing
• Multi-user access control
• Backup and restore strategy.

Assessment task
Task 1 – Meeting with client
a) This part consists of group work. Group size will depend on class numbers. Around four (4) people per group is an appropriate number. As a group, review the given scenario and collaboratively create a list of around 60 questions. Questions should be categorised as follow:
 Hardware
 Software
 Data requirements
 People – roles, access, etc.
 Processes/business activities
 Business rules
 Security
b) Provide evidence of communication between the student group/developer and the client/teacher. Send an email to the client/teacher requesting a mutually suitable time for a meeting. In a second email, once the meeting time has been agreed to, send the meeting agenda prior to the meeting.

Can I Request Unlimited Revisions?

We offer free revisions within 7 days; additional revisions are available at a small cost if needed beyond that period. Your satisfaction is our goal. Contact support to discuss any extra changes you need. Revision flexibility ensures your paper fully meets your professor’s expectations.

c) Each group will have a meeting with the teacher/facilitator who will be playing the role of the client – a non-technical business executive. The meeting will either be recorded or documented as an observation checklist (by the teacher) as evidence to demonstrate that you have:
 met with the client to conduct the user-needs analysis
 negotiated and understood the client’s requirements for the functionality of the website
 used active listening, communicating in plain English, and summarising the client’s key points to understand their requirements.

d) A meeting is a good way of identifying user needs. List and explain other four (4) methods that can be used to identify user needs. Superior Paper Help – Outline the advantages and disadvantages of each method.

Task 2 – Technical requirements
Based on the answers received as a result of the client meeting, recommend specific technical requirements for the database/website project.
You will also be required to research the technical requirements, and include references to where you sourced your information from.
Document the technical requirements (500-800 words). The document must include:
• technical requirements negotiated with the client/teacher during the meeting
• referenced sources of technical information you have obtained in preparing the technical requirements.

Task 3 – Conceptual model
Design a conceptual model using Visual Paradigm (or similar). The conceptual model will take the form of an entity relationship diagram (ERD).
The conceptual model submitted with your evidence must include:
• the completed conceptual model for the database – first draft ERD
• feedback from the client, incorporated as amendments in the model – provide evidence of communication between you and the client/teacher (exchange of e-mails)
• content written in plain English language which a non-technical client would understand.

Task 4 – Logical data model
a) Perform normalisation process to at least third normal form (3NF) showing the results for each step.
b) Update the ERD after normalisation. Ensure that the cardinality ratio is displayed.
c) Develop a data dictionary that clearly indicates the data types and precision parameters for each field (size, range and nullability), primary and foreign keys for tables, data validation and business constraints (checks or triggers). Template provided.
The logical data model submitted with your evidence must include:
• normalisation documentation (step-by-step)
• final ERD
• data dictionary
• approval of the logical data model to the client (exchange of e-mails).

Task 5 – Business rules and constraints
a) Business rules – Identify a minimum of five (5) business rules that apply to the database/website project.
b) Integrity constraints – Primary and foreign keys have been identified. Also identified in the data dictionary.
c) Referential integrity constraints – Identify and set all referential integrity constraints. Use the table below to document the referential integrity constraints by indicating the rules and actions that apply to each foreign key.

What’s Included in Your Outlines?

Our outlines detail structure, key points, and sources, giving you a clear roadmap for your paper before writing begins. They’re designed to keep your project focused and on track. Request an outline with your order for added clarity. Outlines are especially useful for research papers and dissertations, saving you time and effort.

TABLE and FOREIGN KEY (FK) TABLE & PRIMARY KEY it REFEENCES (PK) REFERENTIAL INTEGRITY COSTRAINTS REFERENTIAL ACTIONS
RULE 1
FK has the same declaration (data type and domain) that the PK it references RULE 2
FK value is equal to value in PK or NULL
Table_name
(FK)_Col_name Referenced_tbl_name
(PK)Col_name Yes Yes ON DELETE CASCADE,
ON UPDATE CASCADE
Add lines as required

d) Semantic and other constraints – These can take the form of validation rules, check constraints and triggers. Keep in mind that MySQL does not support check constraints and triggers must be created to implement some checks. These have been included in the data dictionary. Review and update this section the data dictionary until you are sure that all semantic constraints have been identified.
e) Indexes – Identify which table column will benefit from indexing and create the indexes. You can use the table below to record the indexing.

INDEX NAME COLUMN NAME TABLE INDEX TYPE
(e.g. HASH or B-Tree) SEARCH BENEFITS

Add rows as required

f) Provide an estimation of the approximate size of the completed database. Explain how you have reached the estimate.

Task 6 – User interface
Using inVision , MockFlow or similar program, design a user interface for the required database/website project including menus, input forms, and reports. The number of screens and reports depends on the case study or scenario used for the project.
The queries necessary to display the required reports will be completed in Task 7.

Task 7 – Physical design
a) Create a database prototype following the blueprint or structure outlined in the data dictionary created in Task 4. Export or dump the database structure. Submit the SQL file as evidence of database implementation. Apply the constraints identified in Task 5 to the database and document which constraints were applied.
b) Compare conceptual model and technical requirement with the actual database created and list and explain the differences. Make sure to make changes to the database, as necessary, while performing this review.
c) Populate the database with appropriate testing data – sufficient to run the queries.
d) Create and run the necessary queries to display the reports outlined in the case study or scenario project requirements. Provide screenshots of your queries and results. Remember that these queries are run on the database prototype and their purpose is to ascertain that the database structure is sufficient to produce the desired results.
e) Superior Paper Help – Outline a plan to backup and restore the database remembering that at this stage it is just a prototype.

Task 8 – Access and security
Review the business security requirements for the case study/scenario. The points below may help you clarify these requirements.
• How the users will gain access.
• How the password will be stored securely.
• Who will be authorised to access the database.
• What permissions will be given
• The different permission levels.

Can You Handle Technical Writing?

Yes, our writers excel in technical fields like engineering or IT, producing precise, well-documented papers for specialized topics. We ensure accuracy and clarity in every technical detail. Many have industry backgrounds, so they understand both the theory and real-world application. Share your requirements for a tailored result. Technical academic writing requires both subject expertise and strong communication, which our team delivers.

At this stage, you are ready to document the access and security requirements (500-800 words). The document must ensure that:
• Security design meets the requirements of the business security requirements.
• The password access system for the database including encryption/hashing details.
• The different user groups and their access requirements and privileges.
• User access assessment task profiles.

Task 9 – Client receipt
Create a checklist to seek feedback from the client/teacher, change according to given feedback.
Write and email to the client/teacher to obtain sign off via communicating your intention to submit the completed database design documentation. Include this email with your submission with sign off sheet.

Upload your completed database portfolio (zipped folder) to Connect which include:
• Assessment document (this word file)
• SQL file of your database
• Excel file with data dictionary
.

End of assessment
________________________________________________

DATABASE DESIGN REPORT NOT APPROVED

Please provide feedback on the changes needed.

______________________________________________________________________-

Assignment Assessment Help – – Scenario: Caroline’s Classroom Robots

You are employed by Uptown IT’s Software Solutions Department as a Systems Analyst. You have been assigned to a new project and your task is to initiate contact with the client, attend a client meeting, gather project requirements, and document the findings by producing an Analysis Report. The Client for this project is Caroline’s Classroom Robots.
Your teacher/assessor will take on the role of the Project Manager assigned to this project by Uptown IT.

DETAILS:

How Do You Support ESL Students?

We tailor papers to match your language proficiency, ensuring clarity and academic quality while supporting non-native English speakers. Our writers make complex ideas accessible. Let us know your needs for a perfect fit. This service helps ESL students gain confidence and excel academically in English-speaking institutions.

Caroline is looking to get your support in programming one or more robots to assist her with classroom administration and supporting student activity.

Specifically, Caroline would like the robot(s) to assist her with:
• Welcoming students to the class and tracking their attendance.
• Interacting with students in the delivery of a range of tutorial exercises.
• Tracking the activities and results of students throughout each lesson.
• Store a record of these various details for review, reporting and statistical reporting purposes; and for planning future class exercises, activities and preparation.

Caroline would like screens and reports accessible via her computer tablet to review these various details on a day to day basis, and for reviewing periodic reports.

Caroline is seeking a meeting with your team so that she might provide more specific details.

Some Suggested Reports:
Some of the anticipated reports for this project include:
• Attendance of students in class on a given day
• Attendance, grouped by students between two dates
• Exercise results for a given student by Exercise Type (eg: Reading, Writing, and Mathematics), and by Exercise Homework Help – Topic within that (eg: Arithmetic Level 1, Arithmetic Level 2), between two dates
• Average of results grouped by Exercise Type and within that by Homework Help – Topic. Eg:

Can You Meet Tight Formatting Rules?

Absolutely! We adhere to any formatting guidelines, from margin sizes to heading styles, ensuring your paper meets all requirements. Precision is our promise. Upload your formatting guide to get it right. Strict formatting compliance saves students time and ensures papers are professor-ready.

Type Homework Help – Topic Average (/10)
Reading Homework Help – Topic R1 8.2
Homework Help – Topic R2 7.6
Writing Homework Help – Topic W1 6.8
Homework Help – Topic W2 9.0

_____________
Student Name Student Number
Unit Code/s & Name/s ICTDBS506 – Design databases
Cluster Name
If applicable N/A
Assessment Type ☐ Assignment ☐ Project ☐ Case Study ☒ Portfolio
☐ Third Party Report (Workplace) ☐ Third Party Report (Peer) ☐ Other

Assessment Name AT2 – Database/website design project portfolio Assessment Task No. 2 of 2
Assessment Due Date Week 11 Date Submitted / /
Assessor Feedback:

Attempt 1 Satisfactory ☐
Unsatisfactory ☐
Date / /
Assessor Name Assessor Signature
☐ Student provided with feedback and reassessment arrangements (check box when completed) Date scheduled for reassessment / /
Attempt 2 Satisfactory ☐
Unsatisfactory ☐
Date / /
Assessor Name Assessor Signature
– – Note to Assessor: Please record below any reasonable adjustment that has occurred during this assessment e.g. written assessment given orally.

Assessment Criteria / Benchmarks
The evidence submitted demonstrates that the student has satisfactorily:
Attempt 1 Attempt 2
Date
__/__/__ Date
__/__/__
Y N Y N
Task 1: meeting with client
1. Prepared an email to client to organise a meeting to conduct user needs analysis. ☐
☐
☐
☐

What Happens If I’m Not Satisfied?

If you’re not happy, we offer free revisions within 7 days or a refund review to ensure you’re fully satisfied with the outcome. Your peace of mind matters to us. Reach out to our support team to resolve any issues. This satisfaction guarantee gives students confidence to order without risk.

2. Supplied second email to client/teacher with meeting agenda ☐
☐
☐
☐

3. Prepared a list of around 60 questions for the meeting. ☐
☐
☐
☐

4. Attended a meeting with client/teacher and asked appropriate questions to clarify client requirements. This was shown by:
Video/audio recording of meeting submitted
OR
Observation checklist: ☐
☐
☐
☐

 Systems Analyst /Student appropriately dressed/prepared ☐
☐
☐
☐

Can You Help with Annotated Bibliographies?

Yes, we create detailed annotated bibliographies, summarizing sources and aligning with your citation style for academic precision. Each entry is concise and relevant. Provide your sources or let us find them for you. Annotated bibliographies are essential for research-based assignments and dissertations.

 Agenda prepared and presented ☐
☐
☐
☐

 Appropriate introduction ☐
☐
☐
☐

 Purpose and length of meeting clarified ☐
☐
☐
☐

 Each section of meeting appropriately signposted ☐
☐
☐
☐

 Client responses/feedback noted as appropriate ☐
☐
☐
☐

 Clarification sought where there are uncertainties ☐
☐
☐
☐

What’s the Shortest Deadline You Offer?

We can deliver quality papers in as little as 3 hours for urgent needs, with dedicated writers ensuring no drop in quality. Perfect for last-minute assignments. Even when you are pressed for time, we are here to help you meet the deadline. Chat with support to confirm timing for your task. Fast academic help makes sure you never miss important submission dates.

 Reflective listening used ☐
☐
☐
☐

 Actions against agenda items identified/noted. ☐
☐
☐
☐

 Meeting closed appropriately with next meeting / relevant actions summarised. ☐
☐
☐
☐

5. Listed and explained four (4) methods for identifying user needs ☐
☐
☐
☐

6. Superior Paper Help – Outlined advantages and disadvantage of each method. ☐
☐
☐
☐

Do You Handle Interdisciplinary Topics?

Yes, our writers with diverse expertise can blend fields like psychology and sociology, delivering cohesive papers for complex assignments. We ensure every angle is covered with precision. Share your topic details for a tailored approach. Interdisciplinary writing is one of our strengths, helping students tackle modern, cross-field academic challenges.

Task 2: Technical requirements
7. Negotiated technical requirements with the client/teacher during the meeting ☐
☐
☐
☐

 Referenced sources of technical information obtained in preparing the technical requirements. ☐
☐
☐
☐

 Complied with specified length of document (500-800 words) ☐
☐
☐
☐

Task 3: Conceptual model
8. Completed the first draft ERD of the conceptual model for the database. ☐
☐
☐
☐

 Incorporated feedback from the client as amendments in the model and included evidence of communication between them and the client/teacher (exchange of e-mails). ☐
☐
☐
☐

How Do You Ensure Writer Expertise?

Our writers are vetted for degrees and expertise, with ongoing evaluations to maintain high standards across all subjects. This ensures your paper is handled by a true professional. Trust us to match you with the right expert. With advanced qualifications, our writers consistently deliver reliable academic excellence.

 Wrote content written in plain English language which a non-technical client would understand. ☐
☐
☐
☐

Task 4: Logical data model
9. Presented the normalisation documentation to at least the third normal form (3NF) showing step-by-step process. ☐
☐
☐
☐

10. Entity relationship Diagram (ERD):
 Presented the updated E R diagram (after normalisation). ☐
☐
☐
☐

 Identified the cardinality ratio between entities in the ERD. ☐
☐
☐
☐

11. Submitted a data dictionary which includes:
 tables ☐
☐
☐
☐

 attributes ☐
☐
☐
☐

 primary keys ☐
☐
☐
☐

 foreign keys ☐
☐
☐
☐

 data types ☐
☐
☐
☐

 precision parameters for each field (size, range and nullability), ☐
☐
☐
☐

 data validation (checks or triggers) ☐
☐
☐
☐

 business constraints (checks or triggers) ☐
☐
☐
☐

12. Provided proof of approval of the logical data model to the client (exchange of emails) ☐
☐
☐
☐

Task 5: Business rules and constraints
13. Identified a minimum of five (5) business rules. ☐
☐
☐
☐

14. Identified integrity constraints and included them in data dictionary. ☐
☐
☐
☐

15. Completed the referential integrity constraints table. ☐
☐
☐
☐

16. Identified semantic and other constraints in the data dictionary. ☐
☐
☐
☐

17. Completed Indexes table for all tables. ☐
☐
☐
☐

18. Provided an estimation of approximate database size. ☐
☐
☐
☐

Task 6 – User interface
19. Completed design layouts of User interface Screens and Reports – as directed by your teacher. ☐
☐
☐
☐

Task 7: Physical design
20. Created database prototype from data dictionary information. ☐
☐
☐
☐

21. Submitted SQL export or dump ☐
☐
☐
☐

22. Completed comparison of the conceptual model and the technical requirements ☐
☐
☐
☐

23. Updated, if necessary, database prototype as per comparison results. ☐
☐
☐
☐

24. Populated the database prototype with sufficient testing data. ☐
☐
☐
☐

25. Created and ran all queries necessary to run the reports required in the selected case study or scenario. ☐
☐
☐
☐

26. Provided screenshots of queries and results – as directed by your teacher. ☐
☐
☐
☐

27. Provided backup and restore plan for database prototype. ☐
☐
☐
☐

Task 8: Access and security
28. Provided a review and explanation of security requirements. ☐
☐
☐
☐

29. Documented security requirements and addressed the following:
 Security design meets the client requirements ☐
☐
☐
☐

 Password encryption/hashing ☐
☐
☐
☐

 Multi-user access control ☐
☐
☐
☐

 User access assessment task profiles ☐
☐
☐
☐

Task 9: Client receipt
30. Checklist created to seek feedback from the client/teacher and responded to the feedback. ☐
☐
☐
☐

31. Included the email to the client/teacher communicating their intention to submit the completed database/website design project with sign off sheet ☐
☐
☐
☐

32. Submitted the final documentation for the project. ☐
☐
☐
☐

____________________________________________________________________

Order|Paper Discounts