Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Subject: Intro to relational database Question 11 Not yet answered Points out of 10.00 FLIGHT Observe the table FLIGHT FLIGHT Flag question EliD Date Origin
Subject: Intro to relational database
Question 11 Not yet answered Points out of 10.00 FLIGHT Observe the table FLIGHT FLIGHT Flag question EliD Date Origin Destination NoofPassen gers 11/2013Chcag Denver Chcago Derver Seattle L1333 1112013Clacag Orlando 100 108 215 160 112/2013 Clacag U222 1112013 This table will be used for the following questions citing table FLIGHT Normalizing table FLIGHT to 3NF will result in Select one 0 a. Three separate tables O b. Four separate tables O c. No changes (table FLIGHT remains as is, no additional tables) O d. Two separate tables Question 12 Answer saved Points out of 5.00 P Flag question STUDENT Observe the table STUDENT STUDENT StudentIDSSN 0111 D222 D333 0444 D555 Name Class 11-11-1111 Cnnor Fresma 222-22-2222 Trevor 333-33-3333 Cnor Sophomore 444-44-4444Parkr Sophomore 555-55-5555 Cnmor Sophomore Fresa This table will be used for the following questions citing table STUDENT Full key functional dependency exists in the table STUDENT Select one O True O False Question 13 Not yet answered Points out of 10.00 P Flag questionUD FLIGHT Observe the table FLIGHT Date Origin Destination NoOjPassengers uIII 1112013 Clecago Dever u 112/2013Chcg Dever 1222 1/2013 Demver L1333 1112013Ccag Orlando 100 108 115 160 Seattle This table will be used for the following questions citing table FLIGHT Which of the following (regarding the relation FLIGHT) represents the insertion anomaly? Select one 0 a. Inability to insert a number of passengers without a flight ID and date O b. Inability to insert a destination without an origin O c. Inability to insert a flight without its occurrence O d. inability to insert an origin without a destinationStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started