Scribd
Upload
12 views

FUNDAMENTALS OF DATABASE Final

test question

Uploaded by

maureentabuso670
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
12 views

FUNDAMENTALS OF DATABASE Final

test question

Uploaded by

maureentabuso670
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

LA UNION COLLEGES OF SCIENCES AND TECHNOLOGY INC.

Central West, Buang La union


Diploma in Information Technology
Batch 5 (28 copies)
Second Semester
FINAL EXAMINATION

FUNDAMENTALS OF DATABASE

I.IDENTIFICATION

TEST Directions: Identify what is being asked on the following question. Caps
lock all your answers, no erasures and wrong spelling means Wrong.

1. Often used as a tool for communications between database designers and end users during
analysis phase.
2. It is entity type that is NOT existence- dependent on some other entity type.
3. A property of an entity or a relationship type.
4. It is the primary resource for which a database management system.
5. A combination of one or more attributes that make the attribute unique. It also called as multi-
key field or attribute.
6. It required participation.
7. A model suggests the existence of a relationship between entities, but the pathway does not
exist.
8. It specify how many of each entity type is allowed.
9. It is two entities have a 1 to many relationships that fan out from a third entity, but the two
entities should have a direct relationship between them to provide the necessary information.
10. It can specify the number of entity types involved.
11. A collection of entities that share common properties or characteristics Entity.
12. A single occurrence of an entity type.
13. Each entity in the relationship will have exactly one related entity.
14. Entities on both sides of the relationship can have many related entities on the other side.
15. An entity on one side of the relationship can have many related entities, but an entity on the
other side will have a maximum of one related entity.
16. It is the number of instances of one entity that can or must be associated with each instance of
another entity.
17. It is an attribute (or combination of attributes) that uniquely identifies individual instances of
an entity type.
18. It is an attribute that could be a key (satisfies the requirements for being an identifier)
II. TRUE OR FALSE

Read each statement below carefully. Write FUND if you think a statement is TRUE
and write SIGHT if you think the statement is FALSE then underlined the word to
make the statement False and put the correct answer to make the statement True.
No Erasures and Wrong Spelling Wrong.

1. A weak entity is an attribute or a combination of attributes that identify individual


entities.
2. Relationships are also known as association of entities.
3. Binary is one entity set is related to itself.
4. Optional is a participation is not required. Meaning, the entity can have a zero instance .
5. Entity type is a person, a place, an object, an event, or a concept in the user environment
about which the organization wishes to maintain data.
6. Instance is a single occurrence of an entity type.
7. Attribute is a property or characteristic of an entity or relationship type.
8. Required is an attribute that has meaningful component parts (attributes).
9. The relationship type is modeled as lines between entity types.
10. One to many is the number of instances of one entity that can or must be associated with
each instance of another entity.
11. Many-to-Many is an entity on one side of the relationship can have many related entities,
but an entity on the other side will have a maximum of one related entity.
12. Many-to-Many is an entities on both sides of the relationship can have many related
entities on the other side.
III. ESSAY

1What do you think are the possible application or real life application of the SQL? Explain?
2. What is the purpose of managing information?
3. What is entity relationship?

You might also like