Answered step by step
Verified Expert Solution
Question
1 Approved Answer
PERSON: lname, fname, rname, idnum, private, linkblue lname, fname, rname are variable length strings idnum is type INT and is a key attribute private is
PERSON: lname, fname, rname, idnum, private, linkblue
lname, fname, rname are variable length strings idnum is type INT and is a key attribute private is BOOLEAN linkblue is string of 8 characters
ADVISOR: student, advisor
student is a foreign key to PERSON.idnum advisor is a foreign key to PERSON.idnum
#7 Write a DML statement for inserting an entry into the ADVISOR table using the 2 PERSON entries above.
+ - - - - - - - - - - - - - - +- - - - - - - - - - - -- - - - - - - - - - - - -- - - - - - - -- - - - - -- - - - - - - - - - - - - - -+ - - -- - - -+ 80501 SnI 1 1076u?x7 89Zz 7dy KempeoJE 'S TZS jeb01 | 95200 12 1015 4 US KY Covington 10218 Desmond Court 40256 | bill 11. + - - - - - - - + - - - - - - - - - + - - - - - - - + - - - - - 17 dz | Kiuno| les -- | idnum | person_idnum | adtype | streetaddr +- - - - - -- +- - - - - - - - - +- - - - - - - +- -- - - - - - - - - - - - - - - -- - - - - - -- - - - +Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored 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