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

ومـما زادني شـرفـاً وتـيــهـاً
وكدت بأخمصي أطأ الـثريا
دخولي تحت قولك يا عبادي
وأن صـيَّرت أحمد لي نـبيـا
Download Telegram
The primary key is indicated in the ER model by underlining the attribute
Anonymous Quiz
94%
T
6%
F
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