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

ومـما زادني شـرفـاً وتـيــهـاً
وكدت بأخمصي أطأ الـثريا
دخولي تحت قولك يا عبادي
وأن صـيَّرت أحمد لي نـبيـا
Download Telegram
Primary key can have no value .
Anonymous Quiz
3%
T
97%
F
In the primary key Value should not change over time
Anonymous Quiz
89%
T
11%
F
Primary key Can be one or more attributes.
Anonymous Quiz
72%
T
28%
F
A .......... key is composed of two or more attributes, but it must be
minimal
Anonymous Quiz
7%
Foreign
15%
Candidate
77%
composite
A property or characteristic of an entity. Often shown as an oval or circle.
Anonymous Quiz
10%
Entities
85%
Attributes
6%
Relationships
are those that consist of a hierarchy of attributes Sub-attributes spring from an attribute
Anonymous Quiz
67%
Composite attributes
4%
Simple attributes
14%
DERIVED ATTRIBUTE
10%
Multi-valued Attribute
5%
complex Attribute
More than one attribute value is denoted, such as multiple phone numbers for a person
Anonymous Quiz
8%
Composite Attribute
8%
Complex Attribute
84%
Multi-valued Attribute
Derived Attribute :Both multivalued and composite attribute
Anonymous Quiz
23%
T
77%
F
Attributed is calculated or otherwise derived from another attribute, such as age from a birthdate
Anonymous Quiz
3%
Composite Attribute
4%
Simple (Scalars) Attribute
93%
Derived Attribute
A relationship may also have attributes
Anonymous Quiz
92%
T
8%
F
between the instances of two entity types
Anonymous Quiz
6%
Unary
94%
Binary
0%
Ternary
among the instances of three entity types
Anonymous Quiz
1%
Unary
1%
Binary
97%
Ternary
between two instances of one entity type
Anonymous Quiz
8%
Ternary
9%
Binary
84%
Unary
A binary relationship set is of degree ..
Anonymous Quiz
2%
0
9%
1
86%
2
3%
3
A ternary relationship is a relationship type that involves many to many relationships between two tables
Anonymous Quiz
46%
T
54%
F
How many instances of one entity will or must be connected to a singleinstance from the other entities.
Anonymous Quiz
32%
Degree of Relationships
17%
Participation Constraint
51%
Cardinality Constraint
should be the norm in any relational database design and is found in all relational database
environments
Anonymous Quiz
23%
One-One Relationship
64%
One-Many Relationship
13%
Many-Many Relationship
المحاضره الرابعه
A computer language for storing, manipulating and retrieving data stored in a relational
Anonymous Quiz
2%
Javascript
98%
SQL
All relational database management systems use SQL as standard database language.
Anonymous Quiz
90%
T
10%
F