$2$uestion $1(5$ points$)$: Utilize the different concepts we discussed to design a database $($single

$R$ diagram$)$ for a new cruise line company with the following specifications:

Captains are identified by Captain$-$ID$,$ and the c$-$SSN$,$ first and last$-$name, full address,

and salary must be recorded for each captain.

Captain Profiles are identified by Profile ID$,$ and the food preferences $($one or more

values$)$ and favorite destinations $($one or more values$)$ must be recorded for each profile.

Each captain has only one profile; and if a captain is deleted, you need not keep track of

his$/$her stored profile.

Cruise ship Models are identified by Model ID$,$ and the name, capacity, and cruising$-$

range must be recorded for each ship Model.

Each captain is certified for one or more Ship$-$Model, and the date of each certification

should be recorded.

Cruises are identified by Cruise ID$,$ and the from$-$port, to$-$port, distance, departure$-$time,

and arrival time must be recorded for each cruise.

Captains can operate many cruises using different Ship$-$Models.

Tourists are identified by Tourist ID$,$ and the first and last name, budget, and age must

be recorded for each touri$$t$.$