Driver TruckID Truck Model DRIVER Region ) REGION DRIVER Driver 01234 01238 Driver Name Mark driverLicensen...

Question

Question

Answer 1

Answer #1

REGION

In REGION table, there is only 1 row which has (N, North) . So 1 row will be updated to (NO,North)

TRUCKREGION

IN TRUCKREGION, there are 2 rows where RegionID = N, So 2 rows (T5837,NO) and (T4358, NO) will be updated due to update cascade.

Do ask if any doubt.

Answer 2

Similar Homework Help Questions

Roger Rolling is a Driver Operator at the Cavalier Air Force Station in North Dakota. The Fire Department at the Cavalier Air Force base is operated by a vendor, Fiore Industries, Inc. Fiore&#39...

Roger Rolling is a Driver Operator at the Cavalier Air Force Station in North Dakota. The Fire Department at the Cavalier Air Force base is operated by a vendor, Fiore Industries, Inc. Fiore's driver trainer described him as "a very good driver" who "knows the truck [and] knows the job." Rolling has been working as a Driver Operator for Fiore and assigned to Cavalier for ten (10) years Prior to 2018, Rolling had maintained good safety and driving records, with...
Database Intro Salesmen Sheet Order_info Sheet Business_Info sheet 1.Create your own table design based on the...

Database Intro Salesmen Sheet Order_info Sheet Business_Info sheet 1.Create your own table design based on the Excel data, and include all relationships (joins). Apply referential integrity rules wherever appropriate. Import the data from Excel to Access to populate tables: 1. Use the Chen technique and illustrate the E-R diagram for the tables you created Note: It may be necessary to change the data composition due to normalization issues, if you change the composition detail how and why; (you may find...