Extraction Transformation Load
You will become familiar with the SQL features that are used in
Objectives At end of this class you should be able to:
1Q) 4-57 Identifying Activities, Resources, and Cost Drivers in
International Plastics is a multinational, diversified organization. One of its
manufacturing divisions, Northeast Plastics, has become less profitable due
to increased competit
CS550(B)- Data Mining and Business Intelligence
Name: Rajyalakshmi gubburi Venkataramana
Student ID: 15497gr
Steps Followed and Screenshots:
1. To Install the Naive Bayes classifier,
Downloaded the Berkley Databases,
After I created Oracle Cred
Name: Lokeshwar Raju
ID: 18327 KL
Course: CS501 V
Home Work -10
Problem 1: Lookup() algorithm in binary tree.
Given a binary search tree and a "target" value, search the tree to see if it contains the
target. The basic pattern of the lookup() code occurs
TYPE EmpTab IS TABLE OF scott.emp%ROWTYPE;
v_EmpList EmpTab := EmpTab();
TYPE DeptnoTab IS TABLE OF scott.dept.deptno%TYPE;
v_DeptnoList DeptnoTab := DeptnoTab();
Test case ID
Scenario / Objective
Test Case Name
Successful login to NPU
Portal to go to user
A valid User
Windows and mac
To login N
Northwestern Polytechnic University
CS521 Software Project Management
GROUP PROJECT PROPOSAL
[Manthan Gandhi 16734gm]
Creating a website like Yahoo or Google
Provide a brief description of the project:
Write a PL/SQL program to
Dynamically create a table (e.g, t1(a number, b varchar2),
Bulk insert 100 rows into t1 using values from PL/SQL variables (For example the first
row can be (1, Row#1),
Bulk fetch the rows into another sets of PL/SQL variable
We have array A with following elements: 16,14,10,8,7,9,3,2,4,1.
(1) Write computer code to convert the array A into heap structure;
(2) Write computer code to implement heapsort algorithm to sort the array A into
(3) Please show that the h
The Master Theorem applies to recurrences of the following form:
T(n) = aT(n/b) + f(n)
where a Z 1 and b > 1 are constants and u) is an asymptotically positive function.
There are 3 cases:
1. If f(n) = 0(n1 ") for some constant e > 0, then
Please use divide-and-conquer method (merge sorting) to sort data array A into increasing order.
Array A: 14, 4, 84,71,54,15,51,72,87,25,32,75,14,34,79,80
(1) Write computer program to implement this algorithm and demo
CS501_U _HW#1_C PRAVEEN KUMAR REDDY_17844
Data array A has data series from 1,000,000 to 1 with step size 1, which is in perfect
Data array B has data series from 1 to 1,000,000, which is in random order.
Please use insert sorting method
1. What is data warehouse?
Data warehouse is the data base that is designed for query and analysis rather than for
transaction processing. It usually contains historical data derived from transaction data, but it
HOSPITAL COSTS AND PRICING
St. Vincent Hospital has an overall variable costs of 30% of total revenue and fixed
costs of $ 42 million per year.
1) Compute the break-in-point expressed in total revenue.
2) Patient-day is often used to measure the volume of
Chapter 5 Activity-Based Cost Management Systems
Chapter 6 Management Accounting Information for Activity and Process Decisions
Chapter 5- Activity Based Cost Management Systems
Traditional Manufacturing Costing Systems - (simple job and p
CS547(L)_HW1_16869_Mohmad Kaif Ahmed
1) Create table emp as select * from scott.emp;
Create table dept as select * from scott.dept;
CREATE OR REPLACE PROCEDURE salX10
(p_empno IN emp.empno%TYPE)
UPDATE emp SET sal=sal*10
What is the data warehouse (DW)?
Data warehouse is the database that is designed for query and analysis rather than for
transaction processing. It usually contains historical data derived from transaction data,
but it can include data from other sources.
Read the URL thoroughly, http:/www2.cs.uregina.ca/~dbd/cs831/notes/ml/dtrees/dt_prob1.html
Originally, the URL shows you how to construct the tree by using the column, Result, as the
Now, instead of using the "Result" column as the p
CS457 : Extra Credit Assignment 2
Answers should be either printed or hand written neatly. Submit your work at the
beginning of your class. Write your name, ID and section.
1. Use the Student database to write queries for the following questions:
Please discuss the following questions/topics in a short essay type
Is the Internet a form of public speech?
How can the different national perspectives on free speech be
managed in a global environment like the Internet?
Given that the
Name: G.Dheeraj Kumar
Home Work #3
PR Curve Program:
# Create PR Coordinates ( P precision, R recall)
# assuming the false label is 1 and negative is 0.
Cat $1 | sort t -k3,3