UCCD 2203 Database Systems - SQL Commands - Database Design & Implementation Assessment Answer

Assessment Task:

UCCD 2203 Database Systems Assessment Answer

Task

Part 1

1. Scope of Work 

Analyse requirements study (briefly explain the requirements/office/business rules in the system).

2. ER model

 You are required to design an ER diagram for the case study given, identify entities, identify relationships, identify associated attribute and determine keys. Check your ERD with the transaction requirements stated in the case.

3. Redesign and EER

 Redesign your ER diagram with the new requirements and extending the ERD to EER model, if any

4. Data Dictionary

Based on the EER diagram that you created in part 4, create a data dictionary for the solution. (Make sure the data types (Oracle) selected are appropriate)

5. Tables and records

Create all relations in ERD and insert the necessary records 

6. Script

You are required to submit the SQL schema script with proper codes. Should include Integrity and referential integrity constraints.

PART 2:

Queries

Think of 10 useful real office-like queries that will help the University to perform its operation. Indicate the operation performed and include an explanation on how the user can use the corresponding SQL commands.

Stored Procedure

Create 5 Stored Procedure that will help University to perform its operation. Indicate the operation performed and include an explanation of how the user can use the stored procedure.

Function

Create 5 Functions that will help the University to perform its operation. Indicate the operation performed and include an explanation of how the user can use the function.

This IT Assessment has been solved by our IT Assessment Experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.