Software Testing Types:
Black box testing Internal system design is not considered in this type of
testing. Tests are based on requirements and functionality.
White box testing This testing is based on knowledge of the internal logic of
an applications co
HW-9 COS 506 Spring 2015
Ans-B If we have 3 distinct nodes, and assuming all are connected, we can have 5
different kind of binary search trees.
A
C
B
B
B
C
A
A
C
A
C
A
B
B
C
If we are given n nodes, the number of the binary search tree can be made from t
HW-11 COS 506 Spring 2015
ANS-4(A) (B)
ANS-10(A)
The strings of longer length have a higher priority. "Introspective" has the highest priority and
has children "intelligent and intellectual" of lesser priority. "Intelligent" has the children
"intimate" an
HW-8 COS 506 Spring 2015
ANS-1(A). A stack would be a suitable data structure for a program to evaluate
arithmetic expressions according to the specific order of operations.
ANS-1(B). A stack would not be a suitable data structure for a bank simulation of
Chapters 1 thru 5 (Oracle)
Homework 2
Part I: Short Answer Questions
1. Which clause of a SQL query displays the results in a specific sequence?
Ans:
ORDER BY clause of SELECT query let specify the sequence of rows in the final result
2. Which operator s
Chapters 1 & 2 Assignment
1. Using the STUDENT and PROFESSOR tables shown in Figure Q3.8 to illustrate the difference
between a natural join, an equijoin, and an outer join.
Natural join: The SQL NATURAL JOIN is structured in such a way that, columns with
ASSIGNMENT-4
1. Show that the following decomposition of the schema R is not a lossless-join
decomposition:
(A, B, C)
(C, D, E)
ANS- With R1= (A, B, C), R2 = (C, D, E)
R1 (r)
A B
a 1 b1
a 2 b2
would be:
C
c1
c1
R2 (r)
C D
c 1 d1
c 1 d2
would be:
E
e1
e2
R
Assignment-3 COS 515 Spring 2015
Write a SELECT statement that answers this question: Which vendors are being
paid from more than one account? Return two columns: the vendor name and
the total number of accounts that apply to that vendors invoices. Hint:
Online Order Entry Database system
Phase 0: Project Intent
Goal: This Report explains different aspects involved in designing Online Order Entry database
system. The idea behind selecting this Database was that on daily basis we go through many
online sho
ASSIGNMENT-5
Ans-2
Batch processing is usually done late in the night or after the closing of business hours. In
early days of computers, all processing was batched. The organization will accumulate a batch
transactions and then process the entire batch
Chapter8Assignment
1. Describe data and process modeling, and name the main data and process modeling
techniques.
Datamodelingisaprocessofanalysisofdataobjectsandtheirrelationshipstootherdataobjects.
Data modeling is often the first step indatabasedesign
ASSIGNMENT-3
Ans-2
Analog Signals: A signal in which some feature increases and decreases in the same way as the thing begin
transmitted.
EX. TV, Telephones, radio and tape recorder all uses the analogue signals.
Digital signals: A signal in which the or
ASSIGNMENT7
1. Define C2C E-Commerce and list some of C2C activities?
People who come together to buy, sell or trade items online take part in customer-to-customer
E-commerce environment. Two implementations of customer-to-customer markets are
auctions a
ASSIGNMENT-4
Ans-2
A data model is a way finding tool for both business and IT professionals, which uses a set of symbols
and text to precisely explain a subset of real information to improve communication within the
organization and thereby lead to a mo
Assignment-2
Ans-2
Six basic building blocks:
Input, output, memory, arithmetic/logical unit, files, and control unit.
Flows of data:
Data from input devices always go into memory; output devices always receive their
data from memory; two-way data flows
Assignment-1
Review questions
Ans-2
The reason for IT to become pervasive is that at every place especially at the work
place, need for IT is must. It is becoming rare for an employee in most industries to go
a day without interacting with some form of I
HW-10
Dhara Patel, COS 514, Fall- 2014
9.1 (A)
Rule-1 If (Open price <= 2.415) and (close price <= 1.775) Then class=0 (noncompetitive)
Rule-2 If (Open price <= 2.415) and (close price > 1.775) and (open price > 1.92) then class = 0
(noncompetitive)
Rule-
HW-9
Dhara Patel, COS-514, Fall 2014
14.1 A
The Above snip shows that the university data set too many missing values. The original data set
was of 1303 data, in that the total number of missing values were 1097, so the output Data set is of
206 data.
T
HW-8
Dhara Patel, COS 514, Fall 2014
Ans-13.3 (A)
Transaction data are usually displayed in one of two formats: a list of items purchased (each row
representing a transaction), or a binary matrix in which columns are items, rows again represents
transact
7.1(A)
T
he Above classification shows the person is not qualified for the personal lone.
7.1 (B)
Choosing k=1, we will classify in a way that is very sensitive to the local characteristics of the training data;
choosing a large value of k, such as k=20(
6.4 (A)
The above regression model shows the four most important car specification for predicting car price
should be Age_08_04, KM, HP and Quarterly Tax (Based On the least standard error).
6.4 (B)
The correlation coefficient, r, is 0.92227978401 which
Ans 4.1 (A)
The following data are numerical/quantitative.
1. calories:
calories
per serving
2. protein:
grams of
protein
3. fat:
grams of
fat
4. sodium:
milligrams
of sodium
5. fiber:
grams of
dietary
fiber
6. carbo:
grams of
complex
carbohydr
ates
7. s
ASSIGNMENT 3
Ans 3.1
(A)
(B)
With the reference to the above graph we can say that every fourth quarter there is a
decline in shipment.
(C)
The above chart shows that the shipment in 2nd and 3rd quarter is higher than the shipment
in 1st and the 4th quart
HW-10
Dhara Patel, COS 514, Fall- 2014
9.1 (A)
Rule-1 If (Open price <= 2.415) and (close price <= 1.775) Then class=0 (noncompetitive)
Rule-2 If (Open price <= 2.415) and (close price > 1.775) and (open price > 1.92) then class = 0
(noncompetitive)
Rule-
HW-9
Dhara Patel, COS-514, Fall 2014
14.1 A
The Above snip shows that the university data set too many missing values. The original data set
was of 1303 data, in that the total number of missing values were 1097, so the output Data set is of
206 data.
T