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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!