Database Assignment Help

Payroll Management System using Talend Database and Oracle Database – Database Assignment Help

Introduction

In this project you have to design a database for a fictional company. Your group will first decide the company and then decide the domain under which you wish to work for this project. Few examples are as follows:

  1. Employee management of your fictional company.
  2. Payroll management of your fictional company.
  3. Patient management system of fictional hospital system
  4. Account management of fictional bank
  5. Inventory management of fictional shop

Note: These are just ideas. You can work on any of the above idea or you can work on your own idea.

Once your group will finalize the idea then you have to perform given five tasks. For every task you have to prepare appropriate deliverables and compile a final project report with proper project descriptions, required screenshots and scripts. Final project submission will be in the form of project deliverables and project report. For due date visit SLATE.

Get Database Assignment Help, Database Homework Help, Do My Database Homework services and Database project ideas.

Tasks

  1. Design database schema for your company.

Number of tables required – 4 to 6

Records required – Not more than 20

  • Based on the above design create corresponding .csv files in excel for each table.
  • Integrate the data from .csv files to Talend. Create corresponding jobs to read the data in integrated table schema.
  • Integrate the generated table schemas from Talend to Oracle.
  • Select any one table from your table set and create an audit trail trigger to keep record of insert, update and delete operations performed on that table. You have to record User Name, Operation Performed, Date of Operation and Value Effected in the log table.    

Tasks Deliverables

Task#Deliverable requiredEvaluation Criteria
1Shema DesignProposed tables in the design, keys and constraints
2.csv filesEach .csv file should be properly defined as per schema designed proposed in Task#1
3Screenshots for each table schema and job description in TalendIntegrated table schemas and jobs will be evaluated
4Detailed description of tables in Oracle and associated jobs in TalendEach integrated table will be evaluated in student’s user id of Oracle.  
5PL/SQL Script for required trigger for audit trail and detailed description of log table. Operation will be performed on the table and corresponding trigger action will be mapped with logged data.
Final DeliverableCompiled Project ReportThoroughly compiled project report with proper evidences for each task performed by the group. 

Project evaluation rubrics

TaskMarks
Task#1 – Schema Design15
Task#2 – .csv files15
Task#3 – Talend table schema and jobs15
Task#4 – Oracle tables and Talend jobs15
Task#5 – PL/SQL Script15
Project Report15
Final project submission (presentation)10
Total100

Give a Comment