+1-617-874-1011 (US)
+44-117-230-1145 (UK)
+61-7-5641-0117 (AU)

ICT50515 Diploma of Database Design and Development

Teaching Section:Information Technology
Qualification Number and Name:ICT40215 Certificate IV in Information Technology Support
ICT50515 Diploma of Database Design and Development
Units of Competency
Number and Name:
ICTPRG425 Use structured query language
ICTDBS412 Build a database
Assessment Task:Research Assignment 2


  1. This is an open book assessment. You may use online help, manuals and/or handouts to complete the tasks in this paper.
  2. Complete and sign the Assessment Cover Sheet – Out of Class. This is to be submitted with your assessment.
  3. Follow WH&S standards for safe use of computer equipment and the workstation all at times.
  4. Your response to this assessment task should be submitted as a report with appropriate response to the given task, in a Word document as well as an SQL query file. The Word document should have the Cover page, Table of contents, Introduction, responses to the Task, References and a Write-up.


To obtain a satisfactory assessment outcome, students must show evidence of the ability to:

  • write a simple, structured query language (SQL) statement to retrieve and sort data
  • write an SQL statement that selectively retrieves data
  • write SQL statements that:
    • use functions and operators
    • use aggregation and filtering
    • retrieve data from multiple tables
    • write and execute SQL sub-queries
    • create and manipulate tables to meet specific requirements
    • create and use views that satisfy information requirements
    • create and use stored procedures.


  • identify client data management and security requirements
  • produce a prototype data base
  • populate and perform tests
  • discuss results with client for approval
  • implement the data base with the client.


You are to design and develop a simple database system for a training institute. You can make valid assumptions about the entities found in such a domain. At a bare minimum, you have to have at least three entities, which are the most important ones. Essentially, you are to do the following:

  • Draw (Word or Visio) an ERD showing Entity names and their properties.
  • Identify and show the relationships between these entities.
  • Create a database with appropriate name and create relevant tables with Primary and Foreign keys.
  • Write SQL queries to perform the following operations:
    • Insertion of one row in a given table.
    • Insertion of multiple rows in a given table.
    • Update of an existing record.
    • Deletion of an existing record.
    • Reading data from one table.
    • Reading data from two tables.
    • Reading data from three tables.
ICT50515 Diploma of Database Design and Development, Database assignment Help, Database Homework Help
Simple Calculator
Scientific Calculator
EMI Calculator
Mortgage Calculator
Love Calculator
Percentage Calculator
Currency Calculator
Units Converter
Graph Calculator
Financial Lease Calculator
Temperature Converter
24 x 7 Availability.
Trained and Certified Experts.
Deadline Guaranteed.
Plagiarism Free.
Privacy Guaranteed.
Free download.
Online help for all project.

Urgenthomework helped me with finance homework problems and taught math portion of my course as well. Initially, I used a tutor that taught me math course I felt that as if I was not getting the help I needed. With the help of Urgenthomework, I got precisely where I was weak:


  Urgent HomeWork

Disclaimer: The study tools and academic assistance/guidance through online tutoring sessions provided by Urgenthomework.com is to help and enable students to compete academically. The website does not provide ghostwriting services and has ZERO TOLERANCE towards misuse of the services. In case any user is found misusing our services, the user's account will be immediately terminated.
Copyright © 2009-2022 UrgentHomework.com, All right reserved.