2. Consider the following two tables and answer the questions below. AGENT 501 7
ID: 3601944 • Letter: 2
Question
2. Consider the following two tables and answer the questions below. AGENT 501 713 %2615 503 615 225-1249 882-1244 138967 127093 45 CUSTOMER CLUS FNAME CUS NTIAL CUS RENEW DATE AGENT COOE 502 CUS 10010 Ranes 10011 Durne 10012 Smth 10013 Clowski Pau 10014 OrlandoMyron 0015 O'BrianAmy 10016 Brown 05-Apr-2014 16-Jun-2014 29-Jan-2015 14-0ct-2014 28-Dec-2014 22-Sep-2014 25-Mar-2015 17- 2014 03-Dec-2014 14-Mar-2015 501 Leana Kathy 501 503 James 10017 s George 503 0018 Fariss 501 10019 Smith a) How many tuples are in the CUSTOMER table? b) In the AGENT table, the AGENT CODE column is ....Key c) In the CUSTOMER table, the AGENT CODE column is d) Considering the CUSTOMER table: Key. i. The first integrity rule means that . .. . . . . . . . . . .. . . .. . . . . . . . . . ii. The second integrity rule means that . . .Explanation / Answer
Answer :
(a). There are 10 tuples in CUSTOMER table .
(b). In AGENT table , AGENT_CODE column is Primary key.
(c). In CUSTOMER table, AGENT_CODE column is Foreign Key.
(d). Considering the CUSTOMER table :
Related Questions
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.