1. Define the terms i) DDL ii) DML
DDL: Data base schema is specified by a set of definitions
expressed by a special language
called a data definition language.
DML:
A data manipulation language is a
language that enables users to access or manipulate data as organized by the
appropriate data model
2. What is embedded SQL? What are
its advantages? April/May-2011
Embedded SQL is a method of
combining the computing power of a programming language and the database
manipulation capabilities of SQL. Embedded SQL statements are SQL statements
written in line with the program
source code of the host language. The embedded SQL
statements are parsed by an embedded
SQL preprocessor and replaced by host-language calls to
a code library. The output from the
preprocessor is then compiled by the host compiler. This allows programmers to
embed SQL statements in programs written in any number of languages such as:
C/C++, COBOL and Fortran
3. Write short notes on relational
model
The relational model uses a
collection of tables to represent both data and the relationships
among those data. The relational
model is an example of a record based model.
4. Define tuple and attribute
• Attributes: column headers
• Tuple : Row
5.
Define the term relation.
Relation is a subset of a Cartesian
product of list domains.
