1. Write SQL statements that construct four relational tables, include • domain (i.e. data type), • entity integrity (primary key) and • referential integrity (foreign key) 2. Write SQL statements that populate the datasets described below 3. Write SQL statements that delete all tuples associated with Luke

          1. Write SQL statements that construct four relational tables, include
• domain (i.e. data type),
• entity integrity (primary key) and
• referential integrity (foreign key)
2. Write SQL statements that populate the datasets described below
3. Write SQL statements that delete all tuples associated with Luke

1. Write SQL statements that construct four relational tables, include
• domain (i.e. data type),
• entity integrity (primary key) and
• referential integrity (foreign key)
2. Write SQL statements that populate the datasets described below
3. Write SQL statements that delete all tuples associated with Luke

Added by Lorraine K.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Akash M

06/20/2023

Step 1

Create the tables: CREATE TABLE `person` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB; Show more…

Show all steps

Thanks for your feedback!

1. Write SQL statements that construct four relational tables, include domain (i.e. data type), entity integrity (primary key) and referential integrity (foreign key) 2. Write SQL statements that populate the datasets described below 3. Write SQL statements that delete all tuples associated with Luke