16. Consider the following relational schemas from a rental car database Car VIN

Question

16. Consider the following relational schemas from a rental car database Car VIN, Make. Model, Year, HomeLocation) Location LocationID, Street, City, State, Zip, Manager) Now consider the contents of the Location table: Street 123 Anywhere Fortune Cit 456 SomewhereTatnall 789 Nowhere 837 Whattowear Toughchoice City 0cationld 1010 1020 1030 1040 State OK DE IN AR Zi 65543 28779 87798 67687 Manager Smith Jones Neptune Mizrahi Based on the information given, which of the following values definitely could not appear in the HomeLocation column of the Car table? a) 1020 b) Null (the absence of a value) c) 1010 d) 103 e) All of these values are possibilities based on the information given

Explanation / Answer

Answer : (b) null

HomeLocation refers to the LocationId of Location table. So, any value in the HomeLocation column must be present in LocationId column in the Car table. As there is no null in Location table, hence, there can also be no null in HomeLocation .

Related Questions

Navigate

• Browse (All)
• Browse 1
• Subjects

---

---

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