Skip to Content
Home └RPSC PROGRAMMER 2024 └ER Diagram

RPSC PROGRAMMER 2024

0 %

Completed

Course content

ER Diagram

10 XP
Prev Next
Fullscreen Share
Rating
0 0

There are no comments for now.

Join this Course
to be the first to leave a comment.

1. What does "ER" stand for in ER Diagram?
Entity Relationship Enhanced Routing Ethernet Redundancy Efficient Routing
2. In an ER Diagram, what does an ellipse represent?
Entity Attribute Relationship Process
3. Which of the following is not a valid relationship type in ER Diagrams?
One-to-One Many-to-Many One-to-Three Many-to-One
4. What is the purpose of a diamond shape in an ER Diagram?
Represents an Entity Indicates a Process Signifies a Relationship Denotes an Attribute
5. In an ER Diagram, what is a primary key?
An attribute that uniquely identifies an entity A relationship between two entities A process in the network A key used for encryption
6. Which cardinality notation represents "Zero or Many" in ER Diagrams?
(0,1) (0,*) (1,1) (1,*)
7. What is the purpose of a double oval in an ER Diagram?
Represents an Entity Denotes a Relationship Indicates an Attribute Signifies a Weak Entity
8. In ER modeling, what is an entity set?
A collection of related attributes A group of entities with similar characteristics A unique identifier for an entity A network protocol
9. What does a dashed oval represent in an ER Diagram?
Strong Entity Weak Entity Process Attribute
10. What is the purpose of a derived attribute in ER modeling?
It is an attribute that can be calculated from other attributes It is a mandatory attribute It represents a relationship It is a unique identifier
11. In a Crow's Foot notation, what does a straight line represent?
One-to-One relationship Many-to-One relationship One-to-Many relationship Many-to-Many relationship
12. What is the minimum cardinality of a mandatory relationship in ER Diagrams?
0 1 2 * (asterisk)
13. Which of the following is true about weak entities in ER modeling?
They have a primary key They are represented by a double rectangle They rely on another entity (owner) for identification They cannot participate in relationships
14. What is an ISA relationship in ER modeling?
It represents an "is a" relationship between entities It denotes an attribute It signifies a process It is a type of weak entity
15. Which of the following is a role indicator in ER Diagrams?
A triangle A double oval A diamond A rectangle
16. What is the purpose of a composite attribute in ER modeling?
It represents a weak entity It is a single-valued attribute It can be divided into smaller sub-parts It is a mandatory attribute