Derived Channel
1.54K subscribers
252 photos
4 videos
374 files
68 links
القناة الأساسية
@stepbystep001

ومـما زادني شـرفـاً وتـيــهـاً
وكدت بأخمصي أطأ الـثريا
دخولي تحت قولك يا عبادي
وأن صـيَّرت أحمد لي نـبيـا
Download Telegram
It can be a single-user database system, which supports one user at a time, or a multiuser
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 order of attributes has significance
Anonymous Quiz
38%
T
62%
F
Each attribute has … name;
Anonymous Quiz
8%
multiple
93%
distinct
Each tuple is distinct; there are no duplicate tuples;
Anonymous Quiz
86%
T
14%
F
The order of tuples has significance, theoretically
Anonymous Quiz
61%
F
39%
T
Each cell of the relation contains exactly one atomic (single) value;
Anonymous Quiz
97%
T
3%
F
The values of an attribute are all from the same domain;
Anonymous Quiz
91%
T
9%
F
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
Candidate key: when a key consists of more than one attribute
Anonymous Quiz
41%
T
59%
F
Super key : An attribute, or set of attributes, that uniquely identifies a tuple within
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
Forwarded from Notes
Forwarded from Notes
المحاضره التالته