1.Design the relationship diagram

\( \begin{aligned} \text { SELECT } & \text { TOP (1000) [CUSTOMER_NUM] } \\ & ,[\text { LAST_NAME ] } \\ & ,[\text { FIRST_NAME] } \\ & ,[\text { ADDRESS ] } \\ & ,[\text { CITY ] } \\ & ,[\text { STATE ] } \\ & ,[\text { POSTAL_CODE ] } \\ & ,[\text { PHONE ] } \\ \text { FROM } & {[\text { COLONIAL] }][\mathrm{dbo}] \cdot[\text { CUSTOMER ] }}\end{aligned} \) \( \begin{aligned} \text { SELECT } & \text { TOP_(1000) [RESERVATION_ID] } \\ & ,[\text { TRIP_ID] } \\ & ,[\text { TRIP_DATE ] } \\ & ,[\text { NUM_PERSONS }] \\ & {[\text { TRIP_PRICE ] }} \\ & ,[\text { OTHER_FEES ] } \\ & ,[\text { CUSTOMER_NUM ] } \\ \text { FROM } & {[\text { COLONIAL] }][\mathrm{dbo}] \cdot[\text { RESERVATION }] }\end{aligned} \) \( \begin{aligned} \text { SELECT } & \text { TOP_(1000) [RESERVATION_ID] } \\ & ,[\text { TRIP_ID] } \\ & ,[\text { TRIP_DATE ] } \\ & ,[\text { NUM_PERSONS }] \\ & {[\text { TRIP_PRICE ] }} \\ & ,[\text { OTHER_FEES ] } \\ & ,[\text { CUSTOMER_NUM ] } \\ \text { FROM } & {[\text { COLONIAL] }][\mathrm{dbo}] \cdot[\text { RESERVATION }] }\end{aligned} \) \( \begin{aligned} \text { SELECT } & \text { TOP (1000) [TRIP_ID] } \\ & ,\left[G U I D E \_N U M ight] \\ & {[\text { [ASSIGN_DATE] }} \\ \text { FROM } & {[\text { COLONIAL] }[\text { dbo ] [TRIP_GUIDES ] }}\end{aligned} \) \( \begin{aligned} \text { SSELECT } & \text { TOP }(1000)[\text { TRIP_ID] } \\ & ,[\text { TRIP_NAME] } \\ & ,[\text { START_LOCATION] } \\ & ,[\text { STATE] } \\ & ,[\text { DISTANCE] } \\ & ,[\text { MAX_GRP_SIZE ] } \\ & {[\text { TYPE }] } \\ & ,[\text { SEASON] } \\ \text { FROM } & {[\text { COLONIAL] }][\text { dbo }] \cdot[\text { TRIP }] }\end{aligned} \) Results Messages Query executed successfully. \( \begin{aligned} \text { SELECT } & \text { TOP (1000) [CUSTOMER_NUM] } \\ & ,[\text { LAST_NAME ] } \\ & ,[\text { FIRST_NAME] } \\ & ,[\text { ADDRESS ] } \\ & ,[\text { CITY ] } \\ & ,[\text { STATE ] } \\ & ,[\text { POSTAL_CODE ] } \\ & ,[\text { PHONE ] } \\ \text { FROM } & {[\text { COLONIAL] }][\mathrm{dbo}] \cdot[\text { CUSTOMER ] }}\end{aligned} \) \( \begin{aligned} \text { SELECT } & \text { TOP_(1000) [RESERVATION_ID] } \\ & ,[\text { TRIP_ID] } \\ & ,[\text { TRIP_DATE ] } \\ & ,[\text { NUM_PERSONS }] \\ & {[\text { TRIP_PRICE ] }} \\ & ,[\text { OTHER_FEES ] } \\ & ,[\text { CUSTOMER_NUM ] } \\ \text { FROM } & {[\text { COLONIAL] }][\mathrm{dbo}] \cdot[\text { RESERVATION }] }\end{aligned} \) \( \begin{aligned} \text { SELECT } & \text { TOP_(1000) [RESERVATION_ID] } \\ & ,[\text { TRIP_ID] } \\ & ,[\text { TRIP_DATE ] } \\ & ,[\text { NUM_PERSONS }] \\ & {[\text { TRIP_PRICE ] }} \\ & ,[\text { OTHER_FEES ] } \\ & ,[\text { CUSTOMER_NUM ] } \\ \text { FROM } & {[\text { COLONIAL] }][\mathrm{dbo}] \cdot[\text { RESERVATION }] }\end{aligned} \) \( \begin{aligned} \text { SELECT } & \text { TOP (1000) [TRIP_ID] } \\ & ,\left[G U I D E \_N U M ight] \\ & {[\text { [ASSIGN_DATE] }} \\ \text { FROM } & {[\text { COLONIAL] }[\text { dbo ] [TRIP_GUIDES ] }}\end{aligned} \) \( \begin{aligned} \text { SSELECT } & \text { TOP }(1000)[\text { TRIP_ID] } \\ & ,[\text { TRIP_NAME] } \\ & ,[\text { START_LOCATION] } \\ & ,[\text { STATE] } \\ & ,[\text { DISTANCE] } \\ & ,[\text { MAX_GRP_SIZE ] } \\ & {[\text { TYPE }] } \\ & ,[\text { SEASON] } \\ \text { FROM } & {[\text { COLONIAL] }][\text { dbo }] \cdot[\text { TRIP }] }\end{aligned} \) Results Messages Query executed successfully