Đã hoàn thành

Sql developer help

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

Deliverables

Group

Create a Microsoft word report documenting the processes. The report must include 6 sections. Each of the section will be describing one of the 6 tasks. You must describe the processes in details and include all the code that you used to create the process

Individual work

You must write a one or two pages summary that describes your design for the project in your own words and details your involvement in the project. The summary must include

• A brief description of your solution to the project and why did you choose to solve it that way

• State your contribution to the project

• State the difficulties that you faced in the project

• Suggestions to improve the pet rescue operation

Kĩ năng: SQL, Oracle, MySQL, Lập trình cơ sở dữ liệu, Quản trị cơ sở dữ liệu

Xem nhiều hơn: getafreelancer message sql query help needed, sql developer mysql integration, developer help frames google image search, sql developer tutorial, is oracle sql developer free, update sql developer, oracle sql developer guide, sql developer free download for windows 10 64 bit, oracle sql developer help center, sql developer zip file download, pl sql developer 11.0 download, qtp oracle sql developer, oracle 900 sql developer option, sql statements help, php developer help modernbill, sql waiting internal operation complete, aspdotnetstorefront developer help, iphone developer help, view pdf blob sql developer, access 2007 can log sql server help pdf

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

ID dự án: #22586726

Được trao cho:

guruilya

Hello I am very much skilled in db and sql. I can start work soon and will work hard. I can design tables, sql, db procedure, indexes, etc. I have experience in mysql, oracle, mongodb, etc. With Regards, Ilya

$20 CAD trong 7 ngày
(1 Nhận xét)
1.7

3 freelancer đang chào giá trung bình $23 cho công việc này

$25 CAD trong 3 ngày
(0 Nhận xét)
0.0
rauldaniel1993

Quedo presto a ser de tu apoyo.

$25 CAD trong 2 ngày
(0 Nhận xét)
0.0