• ¿Documento equivocado? Cámbialo gratis
  • Escrito por estudiantes que aprobaron
  • Inmediatamente disponible después del pago
  • Leer en línea o como PDF
Vender
¿Dónde estudias?
Tu idioma
Document preview thumbnail
Vista previa 2 fuera de 9 páginas
Examen

Database Systems

Document preview thumbnail
Vista previa 2 fuera de 9 páginas

Exam study book Database Systems of Thomas Connolly, Carolyn Begg - ISBN: 9780321601100, Edition: 5, Year of publication: - (Database Systems)

Vista previa del contenido

TEST BANK For Database Systems: Design,
Implementation, & Management 14th Edition by
Coronel & Morris




FLIGHT
Which of the following functional dependencies does not exist in the table FLIGHT?

FlightID -->NoOfPassengers

FlightID, Date -->NoOfPassengers

FlightID --> Origin

FlightID --> Destination - ANSWER: FlightID -->NoOfPassengers

A domain definition consists of the following components EXPECT:

A. Integrity Constraints
B. Format
C. Data Type
D. Logical Definition - ANSWER: Integrity Constraints

True or False
Every relation without partial functional dependencies is in 2NF - ANSWER: True

True or False
A relation is in first normal form if it has no more than one multivalued attribute -
ANSWER: False

True or False
If A, B, C, and D are columns of the table whose composite primary key is A, B while
C and D are nonkey columns, then C --> D is a transitive functional dependency. -
ANSWER: True

If a 1:M relationship is mandatory on the 1 side and optional on the M side, which of
the following is true?
A. The resulting foreign key can have null (empty) values
B. The resulting foreign key cannot have null (empty) values
C. The resulting foreign key must have null (empty) values
D. No foreign key is created as a result of mapping such a relationship - ANSWER:
The resulting foreign key cannot have null (empty) values

, ENROLLMENT
Which of the following (regarding the relation ENROLLMENT) represents the
modification anomaly?

A. If a student decides to use a longer version of his or her name, we cannot
accommodate that modification
B. If a class name changes, it may have to be changed in more than one record
C. If a student ID changes, we may have to change the class ID as well
D. If a class ID changes, we may have to change the student ID as well - ANSWER: If a
class name changes, it may have to be changed in more than one record

Tuple is a synonym for:
A. Column
B. Field
C. Row
D. Table - ANSWER: Row

An entity with two multivalued attributes will be mapped as how many relations?
A. 1
B. 2
C. 3
D. 4 - ANSWER: 3

When a regular entity type contains a multivalued attribute, one must:
A. create two new relations, one containing the multivalued attribute.
B. create two new relations, both containing the multivalued attribute.
C. create a single relation with multiple lines for each instance of the multivalued
attribute.
D. none of the above. - ANSWER: Create two new relations, one containing the
multivalued attribute.

Which of the following is NOT true? In a relational table:
A. All column names are different
B. Two rows can have the same values
C. All values in a column are from the same domain
D. Two columns can have the same values - ANSWER: Two rows can have the same
values

True or False
Foreign key column must have the same name as the primary key column it refers
to. - ANSWER: False

True or False
Every relation without transitive functional dependencies is in 3NF. - ANSWER: False
A relation without transitive functional dependencies is in 3NF only when it is also in
1NF and 2NF.

Libro relacionado
 image
Thomas Connolly, Carolyn Begg Database Systems
Editorial: Desconocido ISBN: 9780321601100 Edición: 5

Información del documento

Subido en
3 de septiembre de 2024
Número de páginas
9
Escrito en
2024/2025
Tipo
Examen
Contiene
Preguntas y respuestas
$18.49

¿Documento equivocado? Cámbialo gratis Dentro de los 14 días posteriores a la compra y antes de descargarlo, puedes elegir otro documento. Puedes gastar el importe de nuevo.
Escrito por estudiantes que aprobaron
Inmediatamente disponible después del pago
Leer en línea o como PDF

Vendido
4
Seguidores
0
Artículos
1270
Última venta
1 semana hace



Por qué los estudiantes eligen Stuvia

Creado por compañeros estudiantes, verificado por reseñas

Calidad en la que puedes confiar: escrito por estudiantes que aprobaron y evaluado por otros que han usado estos resúmenes.

¿No estás satisfecho? Elige otro documento

¡No te preocupes! Puedes elegir directamente otro documento que se ajuste mejor a lo que buscas.

Paga como quieras, empieza a estudiar al instante

Sin suscripción, sin compromisos. Paga como estés acostumbrado con tarjeta de crédito y descarga tu documento PDF inmediatamente.

Student with book image

“Comprado, descargado y aprobado. Así de fácil puede ser.”

Alisha Student

Preguntas frecuentes