L.1 L.2 L.3 L.4 L.5 L.6
Chapter 1 Solutions Chapter 2 Solutions Chapter 3 Solutions Chapter 4 Solutions Chapter 5 Solutions Chapter 6 Solutions
L-2 L-7 L-20 L-30 L-46 L-52
Solutions to Case Study Exercises
Appendix L Solutions to Case Study Exerci
Classification of Physical Storage Media
Speed with which data can be accessed
Cost per unit of data
-data loss on power failure or system crash
-physical failure of the storage device
Can differentiate storage into:
Introduction to DBMS
Database Management system (DBMS):
Database is a collection of integrated data and a set of
programs to access those data.
The collection of data usually referred to as the database.
The Primary goal of DBMS i
Tuple Relational Calculus
-A nonprocedural query language, where each query is of the form
cfw_t | P (t )
-It is the set of all tuples t such that predicate P is true for t
-t is a tuple variable, t [A ] denotes the value of tuple t on attribute A
-t r d
n SQL includes a string-matching operator for comparisons on character strings.
The operator like uses patterns that are described using two special characters:
l percent (%). The % character matches any substring.
l underscore (_). The
QUERIES WITH EXAMPLES:
1) CREATE :
SYNTAX: create table tablename
( attribute1 datatype,
attribute N datatype,
EXAMPLE: If we want to create a table with name as student and variables or fields as
Domain Types in SQL:char(n). Fixed length character string, with user-specified length n.
varchar(n). Variable length character strings, with user-specified maximum
int. Integer (a finite subset of the integers that is machine-dependent).