Quiz
Chapter 4 (True/False)
Crie uma conta grátis para terminar este quiz
Salve seu progresso e veja sua nota final.
Já tem uma conta? Inicie sessão
Perguntas do quiz (30)
11) An ERM is dependent on the database type.
- AVerdadeiro
- BFalso
22) The word “entity” in the ER model corresponds to a table.
- AVerdadeiro
- BFalso
33) The Crow’s Foot model is less implementation-oriented than the Chen model.
- AVerdadeiro
- BFalso
44) The ER diagram represents the conceptual database as viewed by the end user.
- AVerdadeiro
- BFalso
55) The ER model refers to a specific table row as an entity instance.
- AVerdadeiro
- BFalso
66) In both the Chen and Crow’s Foot models, an entity is represented with a rectangle containing the entity’s name.
- AVerdadeiro
- BFalso
77) The ER model refers to a specific table row as an entity occurrence.
- AVerdadeiro
- BFalso
88) Attributes are types of entities.
- AVerdadeiro
- BFalso
99) In the original Chen model, each attribute is represented using an oval with the
attribute name connected to the entity with a line.- AVerdadeiro
- BFalso
1010. Software vendors have adopted the Chen representation because of its compact
representation.- AVerdadeiro
- BFalso
1111) Attributes have a domain that specifies the data type of the attribute.
- AVerdadeiro
- BFalso
1212) Attributes cannot share a domain.
- AVerdadeiro
- BFalso
1313) In an ER diagram, primary keys are usually bolded.
- AVerdadeiro
- BFalso
1414. Ideally, a primary key is composed of several attributes.
- AVerdadeiro
- BFalso
1515. A composite identifier is a primary key composed of more than one attribute.
- AVerdadeiro
- BFalso
1616. All attributes are either simple or composite.
- AVerdadeiro
- BFalso
1717) All simple attributes are also single-valued.
- AVerdadeiro
- BFalso
1818) In the Chen model, a multivalued attribute is connected to the owning entity
with a double line.- AVerdadeiro
- BFalso
1919) The DBMS can easily handle multivalued attributes.
- AVerdadeiro
- BFalso
2020) Derived attributes are stored in a special database table.
- AVerdadeiro
- BFalso
2121) A relationship is identified by a name that describes the relationship.
- AVerdadeiro
- BFalso
2222) Cardinality expresses the minimum and maximum number of entity occurrences associated with one occurrence of the related entity.
- AVerdadeiro
- BFalso
2323) In Chen notation, there is no way to represent cardinality.
- AVerdadeiro
- BFalso
2424) Connectivities and cardinalities are established by business rules.
- AVerdadeiro
- BFalso
2525) A weak relationship exists if the primary key of the related entity contains at least one primary key component of the parent entity.
- AVerdadeiro
- BFalso
2626) You should always load data from the 1 side of a 1:M relationship.
- AVerdadeiro
- BFalso
2727) A weak entity has a primary key that is partially or totally derived from the parent entity in the relationship
- AVerdadeiro
- BFalso
2828. The existence of a mandatory relationship indicates that the minimum cardinality is 0 or 1 for the mandatory entity.
- AVerdadeiro
- BFalso
2929) Relationships operate only in one direction.
- AVerdadeiro
- BFalso
3030. A recursive relationship is one in which a relationship can exist between occurrences of the same entity set
- AVerdadeiro
- BFalso
Informações
- Descrição
- asdf Quiz sobre Chapter 4 (True/False), criado por . . em 08-09-2016.
- Autor
- . .
- Idioma
- English
- Visualizações
- 365
- Histórico
- Criado em 8 set 2016 · atualizado em 13 out 2016
- Etiquetas
- Avaliação
- Ainda sem avaliações Avalie este quiz