1.
ER was developed by Chen in 1980
Correct Answer
B. False
Explanation
ER was developed by Chen in 1976
2.
ER was developed by Chen in 1976
Correct Answer
A. True
Explanation
The statement is true because ER (Entity-Relationship) was indeed developed by Peter Chen in 1976. ER is a conceptual modeling technique used in the field of database design to visually represent the relationships between entities and their attributes. Chen's work on ER diagrams has been widely recognized and is considered a fundamental tool in database design.
3.
ER aims to
Correct Answer
C. Facilitate database design
Explanation
ER (Entity-Relationship) aims to facilitate database design. ER is a conceptual modeling technique used to design databases by representing the entities, attributes, and relationships between them. It helps in visualizing the structure of a database system, identifying the entities and their relationships, and creating a blueprint for the database design. By using ER, database designers can easily understand and communicate the requirements of the system, ensuring a well-organized and efficient database design.
4.
The Consceptual data model is the set of concepts that
Correct Answer
B. Describe the structure of a database and the associated retrieval and update transactions
Explanation
The conceptual data model is a representation of the structure of a database and the transactions associated with it. It describes how the data is organized and the relationships between different entities. This model includes both retrieval and update transactions, which means it covers the processes of both querying and modifying the data in the database. By understanding the conceptual data model, one can gain insights into the overall structure and functionality of the database system.
5.
An ERs purpose is to support a users perception of the data and conceal the technical aspects associated with database design.
Correct Answer
A. True
Explanation
The statement is true because an Entity-Relationship (ER) diagram is a visual representation of the database schema that focuses on the entities, attributes, and relationships between them. It is designed to be user-friendly and understandable for non-technical users. The purpose of an ER diagram is to provide a clear and intuitive view of the data, hiding the complexities of the underlying database design and technical implementation. Therefore, it supports a user's perception of the data and helps them interact with the database without needing to understand the technical aspects.
6.
A high level conceptual model is dependent on the DBMS and HW platform used to implement the database
Correct Answer
B. False
Explanation
A high level conceptual model is independent of the particular DBMS and HW platform used to implement the database
7.
The basic concepts of Entity-Relationship model include:
Correct Answer(s)
A. Entity types
C. Relationship types
D. Atrtributes
Explanation
The basic concepts of the Entity-Relationship model include entity types, relationship types, and attributes. Entity types represent the different types of objects or entities in a database, such as customers or products. Relationship types define the associations or connections between these entities, such as "owns" or "purchases." Attributes describe the characteristics or properties of entities or relationships, such as the name or age of a customer. File types and storage details are not part of the basic concepts of the Entity-Relationship model.
8.
Entity type = An object or concept identified by the enterprise as having an ______________ existance
Correct Answer(s)
independent
Explanation
The Basic concept of the ER model is an Entity type, which represents a set of 'objects' in the 'real world' with the same properties.An Entity type has an independent existance and can be an object with a physical (or 'real existance') or an object with a conceptual (or 'abstract') existance
9.
A Entity is
Correct Answer
A. An instance of an Entity type that is uniquely identifiable
Explanation
Each uniquely identifiable instance of an Entity is referred to simply as an entity. Other authors may refer to an entity as an entity occurance or entity instance.
10.
Weak entity type
Correct Answer
C. An instance that is existance dependent on some other entity type
Explanation
The correct answer is "An instance that is existence dependent on some other entity type." A weak entity type is an entity that cannot exist on its own and is dependent on another entity for its existence. It means that the weak entity type cannot be uniquely identified by its own attributes and requires a relationship with another entity type to determine its identity.
11.
Strong entity type
Correct Answer
A. An entity that is not existance-dependent on some other entity type
Explanation
The correct answer is "an entity that is not existence-dependent on some other entity type". This means that a strong entity type can exist independently without relying on any other entity type. It has its own unique attributes and can be identified on its own. In contrast, an entity that is existence-dependent on some other entity type relies on the existence of another entity type to have meaning or purpose.
12.
An Atribute is a property of an entity or a relationship type
Correct Answer
A. True
Explanation
An attribute is a characteristic or property that describes an entity or a relationship type in a database. It provides additional information about the entity or relationship and helps in defining its structure and behavior. Attributes can be used to represent various types of data such as names, dates, numbers, or descriptions. Therefore, the statement "An attribute is a property of an entity or a relationship type" is true as it accurately describes the nature and purpose of attributes in a database.
13.
An Atribute
Correct Answer
B. is a property of an entity or a relationship type
Explanation
The given answer correctly states that an attribute is a property of an entity or a relationship type. Attributes are used to describe the characteristics or properties of an entity or a relationship in a database. They define the specific information that can be stored for an entity or a relationship. By stating that an attribute is a property, the answer emphasizes that it represents a specific aspect or quality of the entity or relationship.
14.
An Atribute domain
Correct Answer
A. a set of values that might be asigned to an atribute
Explanation
The given answer correctly defines an attribute domain as a set of values that can be assigned to an attribute. In other words, it represents the range of possible values that an attribute can take. This helps in defining the data type and constraints for the attribute, ensuring that only valid values are assigned to it. By specifying an attribute domain, the system can enforce data integrity and prevent the assignment of inappropriate values to the attribute.
15.
Simple atribute
Correct Answer
E. An atribute composed of a single component with an independent existance
Explanation
The correct answer is an attribute composed of a single component with an independent existence. This means that the attribute represents a single value that is not dependent on any other attribute or entity. It exists on its own and does not rely on any other attributes for its meaning or value.
16.
Composite atribute
Correct Answer
D. An atribute composed of multiple components each with individual existance
Explanation
Address atribute of the branch entity can be subdivided into street city number.....
17.
Single valued atribute
Correct Answer
C. An attribute that holds a single value for a single entity
Explanation
The majority of attributes are single-valued for a particular entity
18.
Multi- valued atribute
Correct Answer
B. An attribute that holds multiple values for a single component
Explanation
For example the branch entity may have multiple values for the entity telephone
19.
Derived atribute
Correct Answer
A. An attribute that represents a value that is derivable from a related atrribute or set of atributes, not necessarily in the same entity
Explanation
Some atributes may be related for a particular entity.ex: the age of a member of staff is derivable from the age of birth
20.
A Candidate key is an atribute or set of atributes that uniquely identifies individual occurences of an entity type
Correct Answer
A. True
Explanation
A candidate key is one or more atributes whose value unequely identifies each entity.
21.
The Primary key
Correct Answer(s)
A. Uniquely identifies each occurance of an entity type
C. Is the candidate key selected to be a primary key
Explanation
An entity typwe may have more than one candidate key. The choice of a primary key for an entity is based on considerations of atribute length the minimal nmomber of atributes requiered
22.
A Composite key is an candidate key that cosists of two or more atributes
Correct Answer
A. True
Explanation
A composite key is a candidate key that consists of two or more attributes. This means that instead of having a single attribute as the primary key, a composite key combines multiple attributes to uniquely identify a record in a database table. This is useful when a single attribute cannot uniquely identify a record, but the combination of multiple attributes can. Therefore, the statement that a composite key consists of two or more attributes is true.
23.
A relationship type is a meaningless association among entity types
Correct Answer
B. False
Explanation
A relationship type is a meaningless association among entity types. A relationship type is a set of associations between two or more participating entity types. Each relationship type is a given a name that descriebes its function. For example, the owner entity is associated with property entity through the relationship called "owns".
24.
Degree of a relationship
Correct Answer
B. The number of participating entities in a relationship
Explanation
The degree of a relationship refers to the number of participating entities in that relationship. It indicates how many entities are involved in the relationship. For example, if a relationship involves two entities, the degree of that relationship is 2. Therefore, the correct answer is "the number of participating entities in a relationship."
25.
Recursive relationship
Correct Answer
A. A relationship where the same entity participates more than once in different roles
Explanation
A recursive relationship refers to a situation where the same entity is involved multiple times in various roles within a relationship. This means that the entity plays different roles in the relationship, but it is still the same entity. For example, in a company, an employee can be both a manager and a team member at the same time, representing a recursive relationship.
26.
Relationships can't have atributes
Correct Answer
B. False
Explanation
This statement is false. Relationships can indeed have attributes. In a database, a relationship between two entities can have additional information associated with it, which is represented as attributes. These attributes provide more details about the relationship and can be used to describe the nature or characteristics of the relationship. Therefore, relationships can have attributes in a database model.
27.
Cardinality Constraints
Cardinality ratio=
Correct Answer
B. Describes the number of possible relationships for each participating entity
Explanation
The correct answer is "describes the number of possible relationships for each participating entity". Cardinality constraints in a database schema describe the number of relationships that can exist between entities. In this context, the cardinality ratio specifically refers to the number of possible relationships for each participating entity. It helps define the relationship between entities and determines how many instances of one entity can be associated with instances of another entity.
28.
Choose the ER Models problems known as connection traps
Correct Answer(s)
B. Fan traps
D. Chasm traps
Explanation
Fan traps and chasm traps are both types of ER model problems known as connection traps. A fan trap occurs when a model has a one-to-many relationship between three entities, causing ambiguity in query results. On the other hand, a chasm trap occurs when a model has a many-to-many relationship between three entities, leading to incorrect query results due to missing or misleading information. Therefore, both fan traps and chasm traps are examples of connection traps in ER models.
29.
A fan trap happens
Correct Answer
B. Where a model represents a relationshipbetween entity types, but the pathway between certain entity occurences is ambiguous
Explanation
A fan trap occurs when a model represents a relationship between entity types, but the pathway between certain entity occurrences is ambiguous. This means that there is a confusion or uncertainty in the model regarding how the entities are connected or related to each other. It can lead to incorrect or misleading interpretations of the data and can affect the accuracy of the model's predictions or analyses.
30.
A chasm trap happens
Correct Answer
A. Where a model suggests the existance of a relationship between entity types but the pathway does not exist between certain entity occurences
Explanation
A chasm trap occurs when a model implies the existence of a relationship between entity types, but there is no direct pathway connecting certain instances of those entities. This means that the model suggests a relationship that cannot be fully realized or validated due to missing connections.
31.
Choose what applies to:
FAN TRAP:
Correct Answer(s)
A. Occurs where a model represents a relationship between entity types, but the pathway between certain entity occurences is ambiguous
C. May exist where two or more 1:N relationships fan out from the same entity
D. Is usually resolved by restructuring the original ER model to represent the correct association between entities
Explanation
The answer correctly explains that a fan trap occurs when a model represents a relationship between entity types, but the pathway between certain entity occurrences is ambiguous. It also states that a fan trap may exist where two or more 1:N relationships fan out from the same entity. Additionally, it mentions that a fan trap is usually resolved by restructuring the original ER model to represent the correct association between entities. Overall, the answer provides a clear and concise explanation of the concept of a fan trap.
32.
Choose what applies to:
CHASM TRAP:
Correct Answer(s)
B. Occurs when a model suggests the relationship between entity types, but the pathway does not exist between certain entity occurrences
E. May occur where there is a relationship which forms parth of the pathway between entities that are related
Explanation
The correct answer suggests that a chasm trap occurs when a model suggests a relationship between entity types, but there is no pathway between certain entity occurrences. It also states that a chasm trap may occur when there is a relationship that forms part of the pathway between related entities. This means that the model implies a connection between entities, but in reality, there is no direct path between them. To resolve this issue, the original ER model needs to be restructured to accurately represent the association between the entities involved.
33.
EER stands for
Correct Answer
B. Enhanced Entity -Relationship Model
Explanation
The correct answer is "Enhanced Entity-Relationship Model". The EER model is an extension of the original Entity-Relationship Model, which adds additional features to represent complex relationships and constraints more accurately. It allows for the representation of subclasses, superclasses, inheritance, specialization, and generalization, making it more powerful and flexible than the traditional model.
34.
EER includes
Correct Answer(s)
A. The original concepts of EER
C. Specialization
D. Generalization
E. Categorization
Explanation
The correct answer includes the original concepts of EER, which refers to the Enhanced Entity-Relationship model. EER is an extension of the traditional Entity-Relationship model and includes additional concepts such as specialization, generalization, and categorization. These concepts allow for more complex modeling of relationships and attributes in a database design. Therefore, the correct answer encompasses both the original concepts of EER and the additional concepts that were introduced in this enhanced model.
35.
A superclass is
Correct Answer
A. An entity type that includes distinct subclasses that requiere to be represented in a data model
Explanation
A superclass is an entity type that includes distinct subclasses that require representation in a data model. This means that the superclass has subclasses that have their own specific attributes and behaviors, but are still related to the superclass. The superclass acts as a higher-level category that encompasses the subclasses, allowing for better organization and representation of the data model.
36.
A subclass is
Correct Answer
A. An entity type that includes distinct subclasses that requiere to be represented in a data model
Explanation
A subclass is an entity type that includes distinct subclasses that require to be represented in a data model. This means that a subclass is a category or subset of a larger entity type, and it contains its own unique subclasses that need to be represented separately in the data model. This allows for more specific and specialized representation of data within the overall entity type hierarchy.
37.
The relationship between a superclass and a subclass is 1:N
Correct Answer
B. False
Explanation
The relationship between a superclass and a subclass is 1:1
38.
There are two important reasons for introducing the the concepts of superclass and subclass into an ER model:
Correct Answer(s)
A. Avoid describing the same concept more than once
C. Add more semantic information into the design
Explanation
The concept of superclass and subclass in an ER model helps to avoid describing the same concept more than once. By introducing inheritance, common attributes and relationships can be defined in the superclass, which can then be inherited by the subclasses. This eliminates the need to repeat the same attributes and relationships in multiple entities, making the model more efficient and reducing redundancy. Additionally, the superclass and subclass relationship allows for adding more semantic information into the design. The subclasses can further specialize and add specific attributes and relationships, providing a more detailed and comprehensive representation of the concept being modeled.
39.
An entity and its subclass and their subclasses, and so on is called a type hierarchy
Correct Answer
A. True
Explanation
An entity and its subclass and their subclasses, and so on, form a type hierarchy. This means that there is a hierarchical relationship between different types of entities, where each subclass inherits the properties and behaviors of its superclass. This allows for classification and organization of entities based on their similarities and differences, providing a structured and organized way to represent and understand the relationships between different types of entities.
40.
Atributes can be inherited
Correct Answer
A. True
Explanation
Attributes can be inherited in object-oriented programming. Inheritance allows a subclass to inherit the attributes and behaviors of its superclass. This means that the subclass can access and use the attributes defined in the superclass without having to redefine them. Inheritance promotes code reuse and helps in creating a hierarchical structure of classes, where attributes can be shared and inherited by multiple subclasses. Therefore, the statement "Attributes can be inherited" is true.
41.
The process of maximising the differences between members of an entity by identifyiong their distinguishing characteristics is called
Correct Answer
A. Specialization
Explanation
Specialization is the correct answer because it refers to the process of maximizing the differences between members of an entity by identifying their distinguishing characteristics. This involves breaking down a general entity into more specific and specialized entities, highlighting unique features and characteristics of each member. This process helps in creating a more detailed and specific understanding of the entity by emphasizing its unique aspects.
42.
The process of minimising the differences between entities by identifyiong their common featurs is called
Correct Answer
B. Generalization
Explanation
Generalization is the process of minimizing the differences between entities by identifying their common features. It involves grouping similar entities together and creating a more general, abstract representation of them. This helps in simplifying complex information and understanding the relationships between different entities. Categorization, on the other hand, is the process of classifying entities into specific categories based on their shared characteristics. Specialization refers to the process of creating new entities by adding more specific features to an existing entity. Therefore, the correct answer is Generalization.
43.
Specialization
Correct Answer(s)
B. The process of maximising the differences between members of an entity by identifyiong their distinguishing characteristics
C. Is a top down approach
E. The set of subclasses is defined on the basiss of some distinguishing characteristics of the entities in the superclass
F. Multiple inheritance can also be used
Explanation
The correct answer states that specialization is the process of maximizing the differences between members of an entity by identifying their distinguishing characteristics. It is a top-down approach where the set of subclasses is defined based on some distinguishing characteristics of the entities in the superclass. Additionally, multiple inheritance can also be used in the process of specialization.
44.
Generalization
Correct Answer(s)
A. The process of minimising the differences between entities by identifyiong their common featurs
D. Is a bottom up approach
E. Can be viewed as the reverse of the specialization process
Explanation
Generalization is a process in which similarities or common features among entities are identified, resulting in the minimization of differences between them. It is a bottom-up approach because it starts from specific entities and then identifies their common features to create a more general entity. It can also be viewed as the reverse of the specialization process, where a more general entity is divided into more specific entities by identifying their distinguishing characteristics.
45.
Disjoint constrain = if the subclasses of a specialization are disjoint, the an entity can be a member of only one of the subclasses of the specialization.
Correct Answer
A. True
Explanation
Disjoint constrain = if the subclasses of a specialization are disjoint, the an entity can be a member of only one of the subclasses of the specialization (to represent use a d placed in the circle that connects the subclasses)
46.
Participation constraints = every entity in the superclass must be a member in a subclass in the specialization.
Correct Answer
A. True
Explanation
Participation constraints = every entity in the superclass must be a member in a subclass in the specialization (to represent it, use a double line between the superclass and the specialization circle)