DataBase Questions QUESTION 5 FLIGHT Observe the table FLIGH

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

Solution

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.