OWNER ( OwnerID, OwnerName, OwnerEmail, OwnerType ) PROPERTY ( PropertyID, Prope

Question

OWNER ( OwnerID, OwnerName, OwnerEmail, OwnerType )
PROPERTY ( PropertyID, PropertyName, Street, City, State, Zip, OwnerID )

Write SQL statements to insert at least three rows of data into the PROPERTY table. Assume that any surrogate key value will be supplied by the DBMS. Remember the referential integrity constraint: OwnerID in PROPERTY must exist in OwnerID in OWNER.

The data in the Owner table is shown below:

OwnerID OwnerName OwnerEmail OwnerType 1 Mary Jones MJones@somewhere.com Individual 2 DT Enterprises DTE@dte.com Corporation 3 Sam Douglas SDouglas@somewhere.com Individual 4 UNY Enterprises UNYE@unye.com Corporation 5 Doug Samuels DSamuels@somewhere.com Individual

Explanation / Answer

You can enter whatever values is required in specified value section.

Related Questions

Navigate

• Browse (All)
• Browse O
• Subjects

---

---

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