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 |
YOU MUST DEMONSTRATE SATISFACTORY COMPETENCE IN EACH QUESTION OF THE ASSIGNMENT.
- This is an open book assessment. You may use online help, manuals and/or handouts to complete the tasks in this paper.
- Complete and sign the Assessment Cover Sheet – Out of Class. This is to be submitted with your assessment.
- Follow WH&S standards for safe use of computer equipment and the workstation all at times.
- 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.
ASSESSMENT CRITERIA
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.
AND
- 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.
Task
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
Calculator
Simple Calculator
Scientific Calculator
EMI Calculator
Mortgage Calculator
Love Calculator
Percentage Calculator
Currency Calculator
Units Converter
Graph Calculator
Financial Lease Calculator
Temperature Converter
Resources
24 x 7 Availability.
Trained and Certified Experts.
Deadline Guaranteed.
Plagiarism Free.
Privacy Guaranteed.
Free download.
Online help for all project.
Testimonial
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: