Management

Q: Complex________ requirements may dictate data transformations, and they may expand the number of entities and attributes within the design.a. informationb. entityc. designd. processing

Q: In organizations that generate large number of transactions,____________ are often a top priority in database design.a. relationships among entitiesb. logical design standardsc. naming conventionsd. high processing speeds

Q: If Tiny College has some departments that are classified as "research only" and do not offer courses, the COURSE entity of the college database would be ________________the DEPARTMENT entity.a. existence-dependent onb. independent ofc. mandatory ford. optional to

Q: The first step in building an entity-relationship diagram (ERD) is_________________________________ .a. developing the initial ERDb. creating a detailed narrative of the organization's description of operationsc. identifying the attributes and primary keys that adequately describe the entitiesd. identifying the business rules based on the description of operations

Q: When using the Crow's Foot notation, the associative entity is indicated by __________relationship lines between the parents and the associative entity.a. dottedb. doublec. tripled. solid

Q: The entity relationship model uses the associative entity to represent a(n)__________- relationship between two or more entities.a. M:Nb. 1:Mc. N:1d. M:1

Q: To simplify the conceptual design, most higher-order relationships are decomposed into appropriate equivalent__________relationships whenever possible.a. unaryb. binaryc. strongd. weak

Q: If an employee within an EMPLOYEE entity has a relationship with itself, that relationship is known as a______________relationship.a. selfb. self-referringc. loopingd. recursive

Q: A ___________relationship exists when three entities are associated.a. unaryb. strongc. ternaryd. weak

Q: A___________ relationship exists when an association is maintained within a single entity.a. unaryb. ternaryc. strongd. weak

Q: The Crow's foot symbol with two vertical parallel lines indicates___________ cardinality.a. (0,N)b. (1,N)c. (1,1)d. (0,1)

Q: The existence of a(n) _________entity indicates that its minimum cardinality is zero.a. ternaryb. optionalc. strongd. weak

Q: A___________ entity has a primary key that is partially or totally derived from the parent entity in the relationship.a. strongb. weakc. businessd. child

Q: If an entity can exist apart from all of its related entities, then it is existence-independent, and it is referred to as a(n)_________ entity.a. weakb. alonec. unaryd. strong

Q: An entity is said to be ______________-dependent if it can exist in the database only when it is associated with another related entity occurrence.a. existenceb. relationshipc. businessd. data

Q: Knowing the minimum and maximum number of___________ occurrences is very helpful at the application software level.a. objectb. attributec. datad. entity

Q: When the specific cardinalities are not included on the diagram in Crow's Foot notation, cardinality is implied by the use of _____.a. symbolsb. attributesc. imagesd. tables

Q: In the entity relationship diagram (ERD), cardinality is indicated using the_________ notation, where max is the maximum number of associated entities and min represents the minimum number of associated entities.a. (max, min)b. (min, max)c. [min ... max]d. {min|max}

Q: ________________expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.a. Connectivityb. Relationshipc. Dependenced. Cardinality

Q: A relationship is an association between__________ .a. objectsb. entitiesc. databasesd. fields

Q: The decision to store ___________attributes in database tables depends on the processing requirements and the constraints placed on a particular application.a. multivaluedb. derivedc. single-valuedd. composite

Q: A derived attribute is indicated in the Chen notation by a ___________that connects the attribute and an entity.a. single lineb. dashed linec. double dashed lined. double line

Q: The conceptual model can handle_________________ relationships and multivalued attributes.a. 1:1b. M:Nc. 1:Md. 1:N

Q: A____________ attribute is one that cannot be subdivided.a. compositeb. simplec. single-valuedd. multivalued

Q: A_________ attribute can be further subdivided to yield additional attributes.a. compositeb. simplec. single-valuedd. multivalued

Q: Ideally, an entity identifier is composed of ____________attribute(s).a. threeb. onec. twod. six

Q: A(n)__________ is the set of possible values for a given attribute.a. domainb. rangec. identifierd. key

Q: The _________notation of entity-relationship modelling can be used for both conceptual and implementation modelling.a. Bachmanb. UMLc. Chend. Crow's Foot

Q: The entity relationship diagram (ERD) represents the_________ database as viewed by the end user.a. condensedb. physicalc. logicald. conceptual

Q: The process of database design is a sequential process.a. Trueb. False

Q: To implement a small database, a database designer must know the "1" and the "M" sides of each relationship and whether the relationships are mandatory or optional. a. True b. False

Q: The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity. a. True b. False

Q: A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship. a. True b. False

Q: Referential integrity and participation are both bidirectional, meaning that they must be addressed in both directions along a relationship. a. True b. False

Q: Unary relationships are common in manufacturing industries. a. True b. False

Q: In a 1:M relationship, to avoid the possibility of referential integrity errors, the data of the "1" side must be loaded first.a. Trueb. False

Q: A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity. a. True b. False

Q: In implementation terms, an entity is existence-dependent if it has a mandatory primary key. a. True b. False

Q: In Chen notation, there is no way to represent cardinality. a. True b. False

Q: Connectivities and cardinalities are established by concise statements known as business rules. a. True b. False

Q: Relationships between entities always operate in one direction. a. True b. False

Q: Composite attributes make it easier to facilitate detailed queries. a. True b. False

Q: The Crow's Foot notation easily identifies multivalued attributes.a. Trueb. False

Q: A composite identifier is a primary key composed of more than one attribute. a. True b. False

Q: Software vendors have adopted the Chen representation because of its compact representation. a. True b. False

Q: In the original Chen notation, each attribute is represented by an oval with the attribute name connected to an entity rectangle with a line. a. True b. False

Q: In the Chen and Crow's Foot notations, an entity is represented with a rectangle containing the entity's name. a. True b. False

Q: In the entity relationship model, a table row corresponds to an entity instance. a. True b. False

Q: An entity in the entity relationship model corresponds to a table in the relational environment. a. True b. False

Q: The Crow's Foot notation is less implementationoriented than the Chen notation. a. True b. False

Q: The entity relationship model (ERM) is dependent on the database type.a. Trueb. False

Q: Explain recursive relationships with the help of an example.

Q: What is a ternary relationship? Provide some business rules examples that specify the need for a ternary or higher- order relationship.

Q: Explain mandatory participation in an entity relationship.

Q: What is a weak relationship? Provide an example.

Q: Explain multivalued attributes with the help of examples. How are multivalued attributes indicated in the Chen Entity Relationship model?

Q: ____________________not only helps database designers to stay on track during the design process, it also enables them to pick up the design thread when the time comes to modify the design.

Q: Identifying the attributes of entities helps in the better understanding of__________ among entities.

Q: A(n)__________ process is based on repetition of processes and procedures.

Q: A relationship____________ indicates the number of entities or participants associated with a relationship.

Q: Failure to understand the distinction between mandatory and optional________ in relationships might yield designs in which awkward (and unnecessary) temporary rows (entity instances) must be created just to accommodate the creation of required entities.

Q: In Crow's Foot notation, an optional relationship between entities is shown by drawing a(n)_______ on the side of the optional entity.

Q: Participation is_________- if one entity occurrence does not require a corresponding entity occurrence in a particular relationship.

Q: The Chen notation identifies a weak entity by using a double-walled entity______________ .

Q: A weak entity must be ____________-dependent.

Q: The Crow's Foot notation depicts the strong relationship with a(n)_________-- line between the entities.

Q: Define an index. Explain the role of indexes in a relational database.

Q: Describe the use of the INTERSECT operator.

Q: Describe the use of null values in a database.

Q: Define entity integrity. What are the two requirements to ensure entity integrity?

Q: What is a key and how is it important in a relational model?

Q: Dr. Codd's___________ rule of relational database states that every value in a table is guaranteed to be accessible through a combination of table name, primary key value, and column name.

Q: An index key can have multiple___________ (a composite index).

Q: A(n)__________ index is an index in which the index key can have only one pointer value (row) associated with it.

Q: Proper data___________ design requires carefully defined and controlled data redundancies to function properly.

Q: The proper use of ____________keys is crucial to controlling data redundancy.

1 2 3 … 1,015 Next »

Subjects