DataBase Questions: QUESTION 5 FLIGHT Observe the table FLIGHT: FLIGHT FligktID

Question

DataBase Questions:

QUESTION 5 FLIGHT Observe the table FLIGHT: FLIGHT FligktID Date OriginDestination NoOfPassen gers 100 108 115 160 1112013ChcagDever u11í112/2013 Chacago 1122013 Chcago 1222 1212013 Denver Cacago Denver Seattle Orlando L333 10/2013 This table will be used for the following questions citing table FLIGHT. Which of the following (regarding the relation FLIGHT) represents the insertion anomaly? O Inability to insert a flight without its occurrence O Inability to insert an origin without a destination Inability to insert an or O Inability to insert a destination without an origin O Inability to insert a number of passengers without a flight ID and date

Explanation / Answer

Solution:

Q5. (d)      because is passengers are there them must belong to some flight with certain name and Id

Q6. (c)      because class can exists only if there is a student belonging to that class, so student information is necessary.

Q7. (b)    because while rerieving the data only read operation is performed to get the information from the relation.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.