It can be a single-user database system, which supports one user at a time, or a multiuser
database system,
database system,
Anonymous Quiz
8%
Classification Based on Data Model
87%
Classification Based on User Numbers
4%
Classification Based on Database Distribution
was introduced by C. F. Codd in 1970. Currently, it is the most widely used data model
Anonymous Quiz
31%
Entity Relationship Model
69%
Relational Model
The candidate key that is selected to identify tuples uniquely within the relation.
Anonymous Quiz
13%
Super key
6%
Candidate key
76%
Primary key
4%
Foreign key
Super key : An attribute, or set of attributes, that uniquely identifies a tuple within
a relation.
a relation.
Anonymous Quiz
87%
T
13%
F
A super key such that no proper subset is a super key within the relation.
Anonymous Quiz
11%
Super key
12%
Foreign key
77%
Candidate key
in each tuple of R, the values of K uniquely identify that tuple
Anonymous Quiz
90%
uniqueness
10%
irreducibility
Additional rules specified by the users or database administrators of a database that define or constrain some aspect of the enterprise.
Anonymous Quiz
12%
Null
14%
Referential integrity
66%
General constraints
9%
Domain Integrity
View : The dynamic result of one or more relational operations operating on the base relations to produce another relation
Anonymous Quiz
86%
T
14%
F
Represents a value for an attribute that is currently unknown or is not applicable for this tuple.
Anonymous Quiz
8%
Domain Integrity
8%
Referential integrity
84%
Null
Null Can create problems when functions such as COUNT, AVERAGE and SUM are used
Anonymous Quiz
80%
T
20%
F
Null can represent
Anonymous Quiz
8%
An unknown attribute value
2%
A known, but missing, attribute value
2%
A “not applicable” condition
89%
All of the above