Đang Thực Hiện

database assgn help

1. Donation table

Every row in this table is a donation made by a donor. Below is the script that creates donation table

2. Address Table

This is an address lookup table. It has a list of all the known addresses

3. Volunteer Table

This table has information on the volunteers

Donation List

This is the list that the volunteer group leader sends to the main office. It is a comma separated text file of the following format

Master Addresses Table

The address table that the charity maintains is not updated and it often gets out of date. However, another department in the organization has an address table that they regularly update and keep current. The table is in SQLServer database and below is the connection information to the server

Tasks

Task 1 – Refresh the address table in the oracle database with the addresses in the master table. You will need to transform some data types and generate a sequential id for the address. Also note that the ids of some addresses will be used as foreign key in donation table your solution should accommodate this fact.

Task 2 – You need to create a process that loads the donations list to the central donations table: In this task you will load the file into the central repository (Oracle tables). You need to make sure that only the donations with valid addresses are inserted into the table. Donation records with erroneous addresses must be rejected. Also make sure to reject the donations that have nulls for the mandatory columns in your database (Not null columns). You must generate csv files to the volunteer group leaders with the records that were rejected in their area.

Task 3 – Create a star schema for the donations. The grain of the schema should be the combination of day, address, and volunteer

Task 4 - Create a process to Load the data to the star schema from the central donation repository

Task- 5 Create views that shows:

• The average and sum of the donation by day, month, Year

• The average and sum of the donations by address, Postal code

• The average and sum of the donations by Volunteer and volunteer group leader

Task 6 Basic Security

• Create a user named DMLUser and give the user permissions to implement all DML on address, donation, and volunteer tables

• Create a user named Dashboard and give the user read permissions on the views

• Audit DMLS on the Star schema tables

• Create a SQL statement that filters the audit table to show any DML activities on the tables

Kĩ năng: Phát triển cơ sở dữ liệu, Lập trình cơ sở dữ liệu, MySQL, SQL

Xem nhiều hơn: access database help, outsource help mysql database, help coding database users login, database management system assignment solution, database homework solutions, database assignment example, database assignment pdf, database assignment questions, pay someone to do my database homework, database assignments for students, dbms assignment questions with solutions, flat file database loads net, program create csv access database, php create csv godaddy database email, online help websites asp advantage database, populate database help, designing database help desk ticket system, plz help designing pharmacy database, database project help needed, database creation help

Về Bên Thuê:
( 1 Nhận xét ) Brampton, Canada

ID dự án: #22586623

Được trao cho:

dekinghtg

Hi, I have proficient knowledge on Oracle DBMS. Is there any more details about what are the table fields? Please give me the details. Cheers.

$100 CAD trong 2 ngày
(10 Đánh Giá)
3.8

2 freelancer chào giá trung bình$106 cho công việc này

aap31374

Hello. I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. Thêm

$111 CAD trong 2 ngày
(4 Nhận xét)
2.1