Question

KSU sells tickets to the football games. They need to track which ticket goes to which seat. The ER diagram is shown below. Map the diagram to the most efficient set of tables.

Question options:

	TICKET(TicketNo, TicketBuyerName, SeatID) SEAT(SeatID, Section, Seatcolor)
	TICKET(TicketNo, TicketBuyerName) SEAT(SeatID, Section, Seatcolor)
	TICKET(TicketNo, TicketBuyerName, SeatID, Section, Seatcolor)
	TICKET(TicketNo, TicketBuyerName, SeatID) SEAT(SeatID, Section, Seatcolor, TicketNo)
	TICKET(TicketNo, TicketBuyerName) SEAT(SeatID, Section, Seatcolor) TICKETSEAT(TicketNo, SeatID)

Question

You are given an E-R diagram with two entities, GUEST and RESERVATION, as shown, and are asked to draw the relationship between them. If a given guest can book many reservations and a given reservation can be booked by at most one guest, which of the following is the proper cardinality?

Question options:

	N:M
	1:M
	1:1
	0:1

Question

The following is an example of what type of relationship?Question 13 options:

	ID Dependent Weak
	Association
	Multi-valued Attribute
	Supertype-Subtype
	Non-ID Dependent Weak

Question

You are given an E-R diagram with two entities, PATIENT and APPOINTMENT, as shown. What does the symbol closest to the PATIENT entity indicate?

Question options:

	A cardinality of "one"
	A cardinality of "zero"
	A cardinality of "optional"
	None of the above.
	A cardinality of "required"

Question

Which of the following statements is correct for the RESTAURANT_CUSTOMER table depicted below.

Question options:

	A table cannot have two phone number attributes so CustFaxPhone and CustHomePhone must be combined into one attribute.
	CustomerID is a surrogate key so cannot be a primary key.
	This table has a composite key which must be resolved.
	Favorite Foods cannot be mapped to a table as is. It is a multi-valued attribute.

Question

Given the following scenario: Customers go to Great Day online travel agency to book flights and hotels. Once a customer provides their personal information such as their full name, address and phone number, they can book a trip. A trip includes details about flight and hotel information. Each trip is given a unique reservation number. Reservation number would be a(n):

Question options:

	Relationship cardinality
	Attribute [non identifier]
	Relationship
	Attribute [Identifier]
	Entity

Question

Given the minimal functional dependencies: ssn-> pet_id pet_id -> PetName The tables below are in (give the highest form): OWNER (ssn, Name, Address, pet_id) PET(pet_id, PetName, Breed)

Question options:

	First Normal Form
	Third Normal Form
	Second Normal Form
	They are unnormalized

Question

Today most commercial databases are based on the:

Question options:

	hierarchical model
	relational model
	comma separated lists
	link-list model

Question

Which of the following is not a basic element of the E-R Model?

Question options:

	Relationships
	Identifiers
	Entities
	Use cases
	Cardinalities

Question

Normalization is an advantage for a read-only database.

Question options:

	True
	False

TICKET TicketNo TicketBuyerName SEAT SeatlD Section Seatcolor GUEST RESERVATION GuestID ReservationID BIRD BirdID BIRD-OBSERVATION BirdID ObservationNumber BirdName Species Gender isBanded BandNumber ObservationDate Location Comments PATIENT APPOINTMENT PatientID AppointmentID OK RESTAURANT CUSTOMER CustomerID FirstName LastName CustHomePhone CustFaxPhone FavoriteFoods