Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Database Systems With Internet And Java Applications

Authors: Greg Riccardi

1st Edition

020161247X, 978-0201612479

More Books

Students also viewed these Databases questions

Question

List the different categories of international employees. page 642

Answered: 1 week ago

Question

Explain the legal environments impact on labor relations. page 590

Answered: 1 week ago