Real-Time Financial Data Warehouse srs, design phase and source code

Real-Time Financial Data Warehouse srs, design phase and source code

Real-Time Financial Data Warehouse srs, design phase and source code

The Executives of ABC University wants to know the financial condition of their organization. The executives need such a repository in which most recent data is available from different departments for analysis. For this we need to develop a Real-Time DWH having most recent data for effective decision making.

A DWH collects the data from multiple operational source systems (OLTP – On-Line Transaction Processing) and stores it in a central repository, which is further used for analysis. However traditionally, the data in DWH is loaded periodically – typically in a daily, weekly or even monthly basis which means that its data is not up-to-date. The data which is saved in OLTP between those time periods (when data is loaded) is not included in reports generated for analysis from DWH.

Real-Time DWH is a solution of this problem as it provides the most recent data for analysis. When any data is entered in OLTP, It is reflected in the repository of Real-Time DWH. We have to perform ETL process at the moment of insertion of any new record in OLTP. It is done with the special techniques.
Pre-requisite:

Student should have the strong concepts of Databases and Data warehouse

Functional Requirements:
1. This is a desktop application
2. There are two users of this application, Admin and Executive.
3. Admin can add or remove any Executive.
4. Different departments in the university are using their own databases (OLTPs) to store the information according to their need.
4.1. Accounts department stores the information of revenue such as fees submitted by the students and money earned by the selling of the software products developed by its software house.
4.2. Finance department stores the information about the expenses of the university such as salaries of employees, utility bills, furniture, electrical and electronic devices.
4.3. Registration department stores the information about the student’s bio data including the degrees in which they are enrolled.
4.4. HR department stores the information about the employees of the university (Faculty & Non Faculty).

5. All the departments (above) are using SQL server DBMS.
6. The star schema in this application will have the multiple fact tables.
7. The procedure of ETL will took place at the time of insertion of any new record in OLTP. For this we will use triggers. (Student can use any other technique after getting the approval from his concerned supervisor).
8. Executive has the interface to view different reports regarding expenses and revenue.
8.1. The executive will view the reports regarding expenses. For example he will be interested to see the total expenses or a particular type of expense in a particular time period etc.
8.2. The executives will view the reports regarding revenue. For example he will be interested to view the total revenue or a particular type of revenue at the particular time period etc.
9. Reports will be generated on run time on the basis of different parameters given by the particular executive. Parameters have been discussed above in section 4.1, 4.2, 4.3 and 4.4
10. Interface must provide the facility to Drill Down and Roll UP Operations.


Tools: Microsoft.Net Framework, Java, SQL Server

Supervisor Name: Shabib Aftab

Email ID: shabib.aftab@vu.edu.pk

• Share
  • 
  • 
  • 
  • 

__________________
Vu final projects Help for Mba and Mcs
We and our Team Providing SRS,MWP,DP1,DP2 As well
project with Full Tutorial and Low Cost.
Cell no: 0313-5189209
skype: trust_aware
email: vustudent7@gmail.com
We will Surely Help you Out With Complete Documentation

important viva questions cs619 final project mcs

What is Cardinality in Databases? 
What is the difference between one-to-one and one-to-many cardinality?
What is Low, Medium and high cardinality?

Difference between Primary Key and Foreign Key?
What is primary key in a table?
What is the purpose of foreign key?
Give an example of primary and foreign key,

What is the best description of an “interface”.
What does the interfaces exhibit?

What is meant by class inheritance?
Types of Inheritance?
What are Pros and Cons of  inheritance.

what is third form of normalization?
What we achieve after 3rd normal form?
How to spot tables which are not in third normal form

what is polymorphism in oop?
Which methods are used in polymorphism?
Give a real world example of polymorphism

What is normalization in database?
Give an example of each type of normalization.
How do you achieve normalization in your project

What is an Entity Relationship Diagram (ERD)?
Show your ERD Diagram?
What do you think is there any mistake in ERD?
Why ERD is necessary? 
What are the components of ERD 

What is the difference between class diagram and database diagram?

vu final project Map My Way

Map My Way

This web application will facilitate users from any organization to define routes on Google Maps (or any other map source can be used). Once the routes are established, the other colleagues (passengers) from the same organization could use this information to ask people to drive them to home/Points of Interest (POI). The application will allow passengers to view the route, contact the person who has the same or similar route, via Email/SMS. Following are further details for this application:

Actors

Admin, Passenger, Driver (A driver can be a passenger too, and a passenger can be a driver too, so you can either treat them as two actors, or you can treat them as a single actor)

Driver/Passenger Features

1. Define multiple addresses (locations) on Map such as for Home, Office, Weekend etc.
2. Minimum information about an address will be two locations (start and end) on the route. Adding of locations will include Latitude and Longitude. In search results all the possible information from an already defined information should be accessible, such as
I. Latitude/Longitude
II. Start and End (Locations and Time for departure & arrival) of the route
III. Driver Information
IV. Vehicle Information
V. Travel Frequency Daily, Weekly, Other (mention days of the week)
3. All of the map related things will be defined on Google (or other source) maps i.e. when user will enter data about the start and end on the route, based on entered address for start and end, it will be displayed on the map that should be very similar if not the same as following:
1. Manage route information provided in point number 2 above (edit, delete etc)
2. Along with addresses, the information about departure, arrival time will also be saved.
3. Define self-owned vehicle information and License information. Define the specification of the vehicle such as: Capacity, Fuel System (Petrol/CNG/Diesel etc).
4. Search through the defined addresses (passengers can search the addresses for which they can ask someone (driver) to drop them on the way.
5. Manage circles, a user can add, update, and delete other users to their circle in 3 privacy categories (e.g. Private, Limited, Public). So that a user can define what level of detail is visible based on the privacy categories, to other users.
6. Application will display a vehicle icon (a van, car or bike etc) for the users who are drivers (having own vehicle), wherever applicable.
4. Contact driver or passenger via Email and SMS.

Admin Features

1. Admin will be responsible to manage this application for: Manage Users (Add, Update, Delete etc).
2. The information accessible to admin will be encrypted so that the admin user can’t view any user’s personal details (passwords, CNIC, Vehicle Info, License, User’s Circle information etc). So it means admin can manage users with best possible access of user’s data that allow admin enough power to operate, and still hide user’s sensitive information from admin.

Bonus Feature

1. The web site should adapt itself well in all sizes of displays (desktop, wide-screen, tablets smart phones etc). Bootstrap CSS technique or any other technique can be followed for this purpose.
(This is extra feature and any student/group will achieve bonus marks for its proper implementation)

Application Type

It will be a Web Application

Tools & Technologies

1. Any modern tool and technology set used for developing web applications/web sites, using which the required feature of the project can be implemented.
2. Google Maps API and Tools (or any other APIs, Tools or Technology for utilizing Maps)

cs619 final project LYRICSER – The Sound Mixer

“LYRICSER” The Sound Mixer

Lyricser is a desktop application which can be used to play several sound files at the same time with different volumes. Such as Sound file # 1 is playing with very low volume and sound file # 2 is playing with medium volume and so on. This software also provides us the facility to record and save the mixed sound.

1. User can select and play 5 sound files parallel (Software should be able to play following audio formats mp3, ra and rm, wma).
2. User can record and save mixed sound at his desire location on hard disk.
3. Besides 5 sound files which can be played at the same time, user can include any sound/his voice from microphone. Now there are 6 parallel sounds which can be played at the same time. (5 files selected from the hard disk and one input from the microphone).
4. Separate Volume Controller should be available for each sound file.
5. Separate Sound Graph should be available with each volume controller for each sound file.
6. There should be options for the tuning of sound effects with each volume controller for each sound file. (User would be able to optimize the bass, stereo, and other audio effects).
7. There would be one Master Sound Controller along with sound graph and tuning options, which would control the overall sound out put from the software. This master sound controller would also be used to play the recorded file.

cs619 final project Sequence Similarity and Identity Calculator

Sequence Similarity and Identity Calculator

This tool will calculate similarity and identity of each sequence in an alignment.

For reference, the following links may be visited.

http://imed.med.ucm.es/Tools/sias.html

http://imed.med.ucm.es/Tools/sias_help.html

MatGAT (Matrix Global Alignment Tool) is tool that generates  is tool that generates similarity/identity matrices for DNA or protein sequences

Task: You will develop a tool that may handle very big alignments perhaps of unlimited size.

cs619 final project Virtual Screen Splitter (VSP)

(VSP) Scope:

Mostly we perform several tasks on our systems and each task may require separate windows for execution on desktop. A lot of time is consumed switching and resizing windows and face a lot of problem to view all windows at a time.

VSP will allow main screen to be split into two or more sections. It will be helpful for the active program’s window to be resized properly to one part of the screen. Using this utility, User will be able to do a split system desktop into two or more areas so that active application would not cover up “Full” physical screen when maximized. This way user can visualize parallel windows in defined area that user has a separate monitor for working (virtually) also called “multi-monitor features of Windows”.

It allows user to position and size windows to sections/areas of monitors and helps user to efficiently manage many active windows parallel.

The image depicts virtually split of desktop screen into two sections/area:

Which tools and technologies would be better for Virtual Screen Splitter (VSP )? LMS Question

cs619 final project Mobile Hidden Object Games

Hidden object game is categorized under ‘puzzle games’. In this game, a player is required to find various items (objects) that are placed on a simple picture with a lot of objects. The required objects are embedded in the picture in such a way that they are not visible easily. This is achieved by either mixing foreground and background color combinations OR object patterns.  The player is required to touch an object which is one of the objects required at a particular level (stage). When the player touches a correct object, it is removed from the picture or it is marked. The game proceeds with increased difficulty at each stage.

Following are some sample games for you to get the basic idea:

http://www.disney.co.uk/disney-games/play/wall-e/hidden-object/

http://www.hidden4fun.com/hidden-object-games/3035/House-of-Treasures.html

http://www.mindjolt.com/egypt-hidden-objects.html

This is a single player game so only one actor i.e. Player, Following are the required features of this project:

1. It should have at least 10 stages, and each stage should offer more difficulty.

2. In start of each stage, the game will display a list of 10 objects to find (this list can be simple text i.e. names of objects, or the shapes of the objects).

3. The game application should actually have 20 to-be-required required objects at each stage, but the player is required to find 10 objects. So the game will set the required 10 objects randomly every time a stage is started.

4. When a player touches a required object, it should be removed from required list (or it should be marked). It should also be removed or marked from the picture.

5. It should be a time based game. Each stage should have a fixed time to complete, or the time can be set according to difficulty level i.e. time limit decreases a few seconds on each next level. If the player is able to find all 10 objects within the specified time, the game will move to next stage, Otherwise the game ends.

6. It should support 2 hints for each stage. When player touches hints, the application will indicate one of objects that are still not picked up by the player.

7. The application should be able to save game state when player opts to save the game.The next time game is launched, it will show options to Play New Game or Continue Last Game. On choosing continue option, player should be able to resume the game from last saved state.

Application Type	Tools & Technologies
It will be a mobile application, you can pick any modern mobile OS platform (e.g. Android, Apple, Windows Mobile etc)	Any modern tool and technology set used for developing mobile games based on the platforms discussed in Application Type.