Question: red 4 5 SID 6/ Name 7Startdate date not null, 8DeptNo int not null, 9 constraint SALESPERSON PK primary key (SID) create table SALESPERSON( int
red 4 5 SID 6/ Name 7Startdate date not null, 8DeptNo int not null, 9 constraint SALESPERSON PK primary key (SID) create table SALESPERSON( int not null, varchar (16) not null, stion 12 create table TRIP( 13SID 14 Fromcity varchar (16) not null, int not null, 15rocity varchar (16) not null, 16 DepartureDate date not null, 17 ReturnDate date not null, 8 TripID int not null, 9 constraint TRIP_PK primary key (TripID) 20 constraint TRIP FK foreign key (SID) references SALESPERSON (SID) 21L) 23 create table EXPENSE 24 TripID int not null, 25 Amountdouble not null, 26 constraint EXPENSE PK prinary key (TripID), 27 constraint EXPENSE FK foreign key (TripID) references TRIP (TripiD 28 with the following data populated MariaDB [triprecords]> select from salesperson; ID I Name I startdate DeptNoI l 11 I Tom 2017-01-03 1 I 12 I Mary 2816-12-01 I 13 I James 1 2817-88-09I 3 rows in set (8.00 sec) MariaDB [triprecords]> select .from trip; I SID I Fro City | ToCity I DepartureDate | ReturnDate I TripID | 11 I Cape I St. Louis I 2017-12-12 2017-11-01 2017-12-14 2017-11-es 2017-12-1 I 2017-12-03 11 I St.Louis I Norfolk 12 I Houston I Suffolk 3 rows in set (e.e0 sec) MariaDB [triprecords]> select from expense I TripID I Amount I fresh, like-new experience? And by the way, welcome back
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
