Write some Software

Introduction This Assignment, which is a Data Warehousing Design and Development assignment. Every Dimensional Model will have a Time Dimension. For this assignment you are required to design a Time Dimension, Write the code in PL/SQL that will populate the Time Dimension, and provide test plans for the code.

Required Tasks

Design a Date Dimensions table Oracle SQL Developer Data Modeller Produce the DDL script using Oracle SQL Developer Data Modeller Run the DDL script in your Oracle schema. Design a PL/SQL program that will populate the Time Dimension table, with one record per day.

The PL/SQL program will accept 2 input parameters - Start Date and End Date

Use the PL/SQL program to populate the Time Dimension table for a range of dates. For example, use your PL./SQL program to populate your Time Dimension table using the following set of input parameters:

Input Parameters 1 : Start Date = 01/01/2005 End Date = 31/12/2020

Input Parameters 2 : Start Date = 01/01/2010 End Date = 14/02/2018

Input Parameters 3 : Start Date = 01/02/2015 End Date = 31/12/2025

HINT: Use the Date format mask of DD/YY/RRRR Your PL/SQL Program should have error checking. Assume all dates will be entered using the above format of DD/MM/YYYY

Your PL/SQL Program should be re-runable and should not require any manual intervention, apart from entering the dates.


HINT: Keep it simple!

Habilidades: SQL

Veja mais: sql pl sql pdf, sql oracle pl sql, sql in pl sql, sql code pdf, sql code oracle, sql and pl sql pdf, schema design, pl sql software, pl sql oracle pdf, pl sql manual oracle, pl sql in oracle, pl/sql format, pl sql format, pl/sql example code, pl sql example code, pl sql developer format sql, pl sql and oracle, pl sql and, pdf pl sql, pdf oracle pl sql

Acerca do Empregador:
( 9 comentários ) Cork, Ireland

ID do Projeto: #8850334

Concedido a:


We are SQL professional and we will deliver you in less time with quality for sure. We have EXPERTs. Please let us know if we can help. thanks

€88 EUR em 2 dias
(1 Comentário)

2 freelancers estão ofertando em média €80 para esse trabalho


Đề xuất vẫn chưa được gửi

€72 EUR in 3 dias
(0 Comentários)