CS304 - Assignment 02 Reg No
: 050293R
Name
: Skandhakumar Nimalaprakasan
Chapter 1 (1) 1.6 File-processing system
DBMS
Pre-written programs give access to data and
Flexible queries give access to the data and
new programs are needed for each need
quarry can be written for the need in SQL
Data redundancy, inconsistency, and isolation,
Reduces the amount of data duplication and
when multiple files are created with same data increases consistency Physical access to the data
Physical and logical access to the data
Concurrent access and Security problems
Designed to coordinate and permit multiple users to access data at the same time, and concurrency issues are handled effectively handled
(2) 1.9 ●
If a library of C or C++ functions is provided, then we wont be able to access the database from programs written in other languages directly, and database can be managed independent of the language the host program is written in.
●
A library can provide only a limited number of pre-determined functions for accessing the database, whereas in a declarative query language, the user will be able to create many number of distinct quarries with his/her imagination and thus we will be having a large spectrum of different quarries.
Chapter 2 (3) 2.5
a) ∏person_name(σ
company_name= “First Bank Corporation”
(works))
b) ∏person_name,city(σ company_name= “First Bank Corporation” (works x employee)) c) ∏person_name, street, city (σ d) ∏person_name (σ
(company_name= “First Bank Corporation” ∩ salary > 10,000)
(company.city =employee.city
(works x employee))
(σworks.person_name=employee.person_name (works x employee x
company))) e) (σ company_name = “Small Bank Corporation” (company)) ÷ ∏city (σ (company))
company_name = “Small Bank Corporation”