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).
The correlation coefficient, r, is 0.92227978401 which
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:
Chapters 1 thru 5 (Oracle)
Part I: Short Answer Questions
1. Which clause of a SQL query displays the results in a specific sequence?
ORDER BY clause of SELECT query let specify the sequence of rows in the final result
2. Which operator s
The word bit is a contraction for what two words?
The word bit is contraction of the words Binary Digits
Explain how the terms bit, byte, nibble, and word are related.
Here is the explanation how this four terms are related
ASSIGNMENT- 1 CHAPTER- 6 & 7
ANS-1 (A) There are 220/24 = 216 blocks in the main memory
ANS-1 (B) 20 bit addresses with 11 bits in the tag field, 5 in the block field, and 4 in the word field
ANS-1 (C) Memory reference 0DB63 will be mapped at block 2
INTODUCTION TO COMPUTER ORGANISATION AND ARCHITECTURE
a) How many milliseconds are in one second?
One second = 1000 milliseconds
one milliseconds=1/1000 of a second = 10-3 second
b) How many microseconds are in one second?
A microsecond is one milli
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
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.
If we are given n nodes, the number of the binary search tree can be made from t
HW-11 COS 506 Spring 2015
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
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
1. Show that the following decomposition of the schema R is not a lossless-join
(A, B, C)
(C, D, E)
ANS- With R1= (A, B, C), R2 = (C, D, E)
a 1 b1
a 2 b2
c 1 d1
c 1 d2
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
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
1. Describe data and process modeling, and name the main data and process modeling
Data modeling is often the first step indatabasedesign
Analog Signals: A signal in which some feature increases and decreases in the same way as the thing begin
EX. TV, Telephones, radio and tape recorder all uses the analogue signals.
Digital signals: A signal in which the or
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
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
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
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
Dhara Patel, COS 514, Fall- 2014
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
Dhara Patel, COS-514, Fall 2014
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
Dhara Patel, COS 514, Fall 2014
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
he Above classification shows the person is not qualified for the personal lone.
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(
Ans 4.1 (A)
The following data are numerical/quantitative.