Union.
Set difference.
Intersection.
All of the above.
D. All of the above.
Similarity
Granularity
Dimensionality
Arity
Fields
Records
Relations
Keys
<>
<
=<
>=
It requires that an entity belongs to no more than one level entity set.
The same entity may belong to more than one level.
The database must contain an unmatched foreign key value.
An entity can be joined with another entity in the same level entity set.
an attribute
a tuple
a criteria
a relation
Aggregation
Association
Weak entity sets
Weak relationship sets
DISTINCT
UNIQUE
NULL
EXISTS
Code
Codd
Boyce Codd
Boyce
Partition constraint.
Dependency preservation.
Redundancy.
Security.
detecting view serializability.
detecting conflict serializability.
deadlock prevention
deadlock detection
4,0
0,0
4,5
8,5
Operationally, if Y is deleted, so is X
existence is dependent on Y.
Operationally, if X is deleted, so is Y.
Operationally, if X is deleted, & remains the same.
superkey
candidate key
primary key
not a key
Table
Tree like structure
Complex logical relationship
Records
disjoint
partial
overlapping
single
Atomicity
Concurrency
Isolation
Durability
IX
IS
S
SIX
Data Definition Language .
Meta Language
Procedural query Language
None of the above
Transaction management component of DBMS
Application Programmer
Concurrency control component of DBMS
Recovery management component of DBMS
Predicate calculus
Relational calculus
Relational algebra
SQL
With finer degree of granularity of locking a high degree of concurrency is possible.
Locking prevents non-serializable schedules.
Locking cannot take place at field level.
An exclusive lock on data item X is granted even if a shared lock is already held on X.
Keys
Program
Translators
Language Activity
Integrity
Availability
Confidentiality
Discretionary Security
Schema
Tuple
Domain
Relational
authorization and integrity manager
buffer manager
transaction manager
file manager
jamming
password
documentation
record lock
DFD
Flowcharts
Gantt Charts
E-R
All views are not updateable
The views may be referenced in an SQL statement whenever tables are referenced.
The views are instantiated at the time they are referenced and not when they are defined.
The definition of a view should not have GROUP BY clause in it.
Double lines
Single line
Dashed lines
Triangle
UPDATE S CITY = KANPUR WHERE SNO=S1
UPDATE S SET CITY = KANPUR FOR SNO=S1
UPDATE S SET CITY = KANPUR WHERE SNO=S1
UPDATE S RENAME CITY = KANPUR WHERE SNO=S1