Concept Description: Characterization and Comparison
What is concept description?
Data generalization and summarization-based characterization
5.2.1 Data cube approach for data generalization
5.2.2 Attribute-oriented induction
set serveroutput on;
- a) Write a stored procedure that displays the contact details of viewing parties who haven't visited the dealership for over six months.
- For organisations, include the organisation name in the output. For international guests, in
- a) Display the name of the customer who has purchased the most cars from Archie's Luxury Motors
SELECT C.custID, C.name
FROM Customer C, SalesTransaction ST
WHERE C.custID = ST.custID
GROUP BY (C.custID, C.name)
HAVING COUNT(C.custID) = (SELECT MAX(COU
ENTERPRISE BUSINESS INTELLIGENCE
Q. Explain Decision Trees with example.
A. A Decision tree is a hierarchal tree structure which classify classes on the basis of some set
of rules about the attributes of the classes. The classes
Tutorial 3 Assignment Questions (BUS5EBI)
Q. What is an Outlier? What is its significance?
A. An outlier can be defined as the value which lies unusually far from the values in the
random sample. The significance of outlier is that i
Tutorial 4 Assignment
Q. Define r-squared in Multiple Regression.
A. The Coefficient of Multiple Determination for Multiple Regression can be defined as the
degree of variation in the response variable from the trend line. For example, for a house,
Enterprise Business Intelligence
Q. Explain Neural Networks. Is there any difference or similarity between the biological and
artificial neural networks?
A. An Artificial Neural Network (ANN) is a set of nodes linked in a network in
-CSE2/4DBF Assignment 2 - 2015
-Archie's Luxury Motors
Assignment 2 (20%)
Due date: 10.00am Wednesday, May 27th 2015
AIMS AND OBJECTIVES:
to perform queries on a relational database system using SQL;
to demonstrate an advanced knowledge of stored procedures, stored functions and triggers.
Using Dates in PostgreSQL
PostgreSQL is setup to use US date formats (mm/dd/yyyy) by default (at the time of writing).
Dates are entered as a string and PostgreSQL makes every attempt to construct a legal date
from the input string. See PostgreSQL Date/Ti
File Management System (FMS)
A traditional file system is made up of many programs accessing many files.
These are a much less ambitious concept than database systems. Many products for PCs have
the properties of FMSs and database systems.
Problems with t
Two relations are union compatible iff:
they have the same number of attributes
each domain of each attribute in either relation has a compatible domain in the other
the headings of each corresponding attribute are the same (n
Rather than use the full name of a table, table aliases can be used as an
alternative of abbreviated table name.
Table alias is specified in the FROM clause:
SELECT s.id, s.surname, s.paid
FROM student s
WHERE s.paid > 100 ;
Definition: Database Management System
This is the interface between the users (application programmers) and the database (the
It is a similar concept to an operating system.
Data: A set of information with some aspect in common
Tutorial 5 - SQL Aggregates Solutions
3. Enter commands to retrieve the following lists:
The number of instructors who inhabit each location.
select location, count(*) as numLects
group by location
The number of students
Originally, Edgar (Ted) Codd proposed eight operations, four of them based on traditional set
theory (union, intersection, difference and cartesian product) and four new relational
operations (restrict, project, join and divide).
Keywords and Identifiers
Reserved for special use. Not case sensitive. Examples: SELECT, select,
Select, WHERE, AS, from
Names given to columns, tables etc.Not case sensitive. Must begin with a
letter or underscore and be followed by
set serveroutput on
- a) A Trigger which automatically stores in a separate table called `ExcellentSale' the Sales Agent name, car model and manufacturer name,
- each time the agreed price of a SalesTransaction is more than 20% of the car's asking price.
Tutorial 6 - SQL Joins & Subqueries
/* Finish this query */
SELECT subname, surname
FROM lecturer, subject
WHERE lecturer.lectno = subject.lecturer
AND subcode IN
FROM student, enrolment
WHERE id = studid