¾}sS< eU/ Institution Name ¾Ê¡S”ƒ lØ`/ Document No.
KPC/OF/OBT/009
ኮምቦልቻ ፖሊቴክኒክ ኮሌጅ
KOMBOLCHA POLYTECHNIC COLLEGE
ርዕስ/Title Issue Page No.
Effective Date: 14/04/2017 Assessment Form No. Page 1 of 4
1
Web development and Database Administration Regular
students Theory Exa0m on modelling data object from
20%
I. Choose the best answer from the given alternatives (2 point for
each)
1. Multi value attributes
A) Are those that may take on more than one value for under entity
instance?
B) Can be logically grouped into supper attributes
C) Represent value that is calculated from the values of related attributes
D) Are those that may not null?
E) All except D
2. Derived value attributes
A) Are those that may take on more than one value for under entity instance?
B) Can be logically grouped into supper attributes
C) Represent value that is calculated from the values of related attributes
D) Are those that may not null?
E) All except D
Approval
Name: Robel Abebe Signature: Date:12/08/13
¾}sS< eU/ Institution Name ¾Ê¡S”ƒ lØ`/ Document No.
KPC/OF/OBT/009
ኮምቦልቻ ፖሊቴክኒክ ኮሌጅ
KOMBOLCHA POLYTECHNIC COLLEGE
ርዕስ/Title Issue Page No.
Effective Date: 14/04/2017 Assessment Form No. Page 2 of 4
1
3. An entity set that does not have sufficient attributes to form primary key is?
A) Weak entity C) Composite entity
B) Strong entity D) Recursive entity
4. Assume that there are two given tables Department and Student table under the
same database name what will be possible relationship between those tables?
A) Many to many C) One to one
B) Many to one D) One to many
5. The attribute that can be divided in to other attribute.
A) Simple attributes C) Multi value attributes
B) Compare attributes D) Composite attributes
6. Which one of the following is a data type?
A) Id C) Name
B) Age D) String
7. The numerical attributes of the relationship between two entities or entity sets is
called……….
A) Relationship C) Orders
B) Cardinality D) Sequence
8. Acandidate key which is not selected to be the primary key is
A) Primary key C) Composite key
B) Foreign key D) Alternate key
9. A collection of entity instances sharing similar properties
A) Entity set C) Entity occurrence
B) Entity type D) Relationship
Striving for Excellence, Elevating Quality.
¾}sS< eU/ Institution Name ¾Ê¡S”ƒ lØ`/ Document No.
KPC/OF/OBT/009
ኮምቦልቻ ፖሊቴክኒክ ኮሌጅ
KOMBOLCHA POLYTECHNIC COLLEGE
ርዕስ/Title Issue Page No.
Effective Date: 14/04/2017 Assessment Form No. Page 3 of 4
1
10. Which data analysis method makes predictions about future outcomes based on
current or past data?
A) Prescriptive Analysis C) Predictive Analysis
B) Text Analysis D) Diagnostics Analysis
Answer
I. Choose the best answer from the given alternatives (2 points for each)
1. A
2. C
3. A
4. D
5. D
6. D
7. B
8. D
9. A
10. C
Striving for Excellence, Elevating Quality.
¾}sS< eU/ Institution Name ¾Ê¡S”ƒ lØ`/ Document No.
KPC/OF/OBT/009
ኮምቦልቻ ፖሊቴክኒክ ኮሌጅ
KOMBOLCHA POLYTECHNIC COLLEGE
ርዕስ/Title Issue Page No.
Effective Date: 14/04/2017 Assessment Form No. Page 4 of 4
1
Striving for Excellence, Elevating Quality.
