Question 1. 1. (TCOs 9 and 10) A relationship between different instances of the
ID: 3563504 • Letter: Q
Question
Question 1.1. (TCOs 9 and 10) A relationship between different instances of the same entity (such as an employee and his supervisor) is called a (Points : 3) ternary relationship.parent/child relationship.
many-to-many relationship.
recursive relationship.
None of the above Question 2.2. (TCOs 9 and 10) A descriptive property or characteristic of an entity is (Points : 3) a domain.
an attribute.
an entity instance.
an entity existence.
None of the above Question 3.3. (TCOs 9 and 10) Pointers to the records of a different file in a database; they are used to link records of one type to those of another type. (Points : 3) Attributes
Referential pointers
Descriptive fields
Foreign keys
None of the above
Question 4.4. (TCOs 9 and 10) During requirements analysis, what order of model development is used to arrive at the logical data model? (Points : 3) Context data model; fully attributed data model; key-based data model
Key-based data model; fully attributed data model; context data model
Context data model; key-based data model; fully attributed data model
None of the above
Question 5.5. (TCOs 9 and 10) Which of the following is NOT a guideline for creating a business coding scheme? (Points : 3) Codes should be expandable to accommodate growth.
The full code must result in redundant values for entities.
Codes should be large enough to describe distinguishing characteristics but small enough to be interpreted by a person without a computer.
Codes should be convenient.
All of the above Question 6.6. (TCOs 9 and 10) Every nonkey field is called a (Points : 3) secondary key.
foreign key.
descriptive field.
record.
None of the above
Question 7.7. (TCOs 9 and 10) The number of entities that can participate in a relationship is known as (Points : 3) the domain of the relationship.
the cardinality of the relationship.
the degree of the relationship.
the association of the relationship.
None of the above Question 8.8. (TCOs 9 and 10) A ternary relationship is (Points : 3) recursive.
reflexive.
between three entities.
not possible in data modeling.
None of the above Question 1.1. (TCOs 9 and 10) A relationship between different instances of the same entity (such as an employee and his supervisor) is called a (Points : 3) ternary relationship.
parent/child relationship.
many-to-many relationship.
recursive relationship.
None of the above
Explanation / Answer
1.1)
The appropriate answer is recursive relationship.
A relationship between different instances of the same entity (such as an employee and his supervisor) is called a recursive relationship.
A recursive relationship is a self-referencing relationship. In this only one table/entity is present and it is on both sides of the relationship.
Example: An Employees table that contains information about the supervisor of each employee. Each supervisor is also an employee and has his or her own supervisor. In this case, there is a one-to-many self-referencing relationship, as each employee has one supervisor but each supervisor may have more than one employee
---------------------------------------------------------------------------------------------
2.2)
The appropriate answer is an attribute.
A descriptive property or characteristic of an entity is an attribute.
An attribute of an entity can hold as many values as it can.
Example: Consider a Child entity. It may distinguish from the other Child entity by its child_age attribute. This attribute will be varying or it can hold different values.
-----------------------------------------------------------------------------------------------------------
3.3)
The appropriate answer is Foreign keys.
Pointers to the records of a different file in a database; they are used to link records of one type to those of another type. Those pointers are called as Foreign keys.
A primary key is a field whose values identify one and only one record in the same file. A foreign key is a pointer to the records of a different file in a database.
-----------------------------------------------------------------------------------------------------------
4.4)
The appropriate answer is
Context data model; key-based data model; fully attributed data model;
During requirements analysis, the order of model development is used to arrive at the logical data model is as shown below:
Context data model: This is a platform for storing, reporting, analysis and information delivery. It combines a distributed database, database browsing and analysis tools with a secure, web compatible, content management and delivery system.
key-based data model: This a platform for creating pointers between the different data bases and tables.
fully attributed data model: this a platform to join the different tables by using the attributes of related tables.
-----------------------------------------------------------------------------------------------------------
5.5)
The appropriate answer is the full code must result in redundant values for entity.
The full code must result in redundant values for entity is NOT a guideline for creating a business coding scheme.
-----------------------------------------------------------------------------------------------------------
6.6)
The appropriate answer is descriptive field.
Every nonkey field is called a descriptive field.
Every key field specifies the uniqueness of the rows, whereas a non-key field will only describe the name of the field.
-----------------------------------------------------------------------------------------------------------
7.7)
The appropriate answer is the degree of the relationship.
The number of entities that can participate in a relationship is known as the degree of the relationship.
When creating a relationship between the entities, one needs to specify how many entities are participating in the relationship. So, a degree of relationship only can specify the number of entities that participates the relationship. It can be one-to-one relationship, one-to-many relationship, or many-to-many relationship.
-----------------------------------------------------------------------------------------------------------
8.8)
The appropriate answer is between three entities.
A ternary relationship is between three entities.
In a ternary relationship, a relationship is defined for the three entities.
For example: Operator, Operation and Parts are three entities and they are related by performs.
The operation is performed on the certain Parts by using the operator.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.