Question $2$: $(20\backslash \%)$ During the Covid pandemic, Canada Border Services Agency required anyone wishing to enter Canada to fill out the "ArriveCan" app, giving your $($or child's$)$ Name, Address, Passport number, Vaccination date, Date and Time of arrival, and Border crossing point. You then had to arrive within $3$ hoursof that time and present passports and vaccination certificates.

Vaccination certificates have your name, vaccine type, date, and your date of birth.

Examples:

$-$ Jensen, Lin, $64$ main, Hatley, Quebec, JENL$12345,22$ Oct $2020,6$ July $2022$ at $10$:$30,$ Stanstead

To Do:

$1.$ What are the entities involved? You will possibly arrive in a group, by road or by airplane.

$2.$ What are the relationships that matter between these entities?

$3.$ Draw an $\backslash ($ E $/$ R $\backslash )$ diagram.

$4.$ Convert your E$/$R model to a relational schema. $($See question $3$ for som related SQL$)$ Question $2$: $(20\backslash \%)$ During the Covid pandemic, Canada Border Services Agency required anyone wishing to enter Canada to fill out the "ArriveCan" app, giving your $($or child's$)$ Name, Address, Passport number, Vaccination date, Date and Time of arrival, and Border crossing point.You then had to arrive within $3$ hoursof that time and present passports and vaccination certificates.

Vaccination certificates have your name, vaccine type, date, and your date of birth.

Examples:

$-$ Jensen, Lin, $64$ main, Hatley, Quebec, JENL$12345,22$ Oct $2020,6$ July $2022$ at $10$:$30,$ Stanstead

To Do:

$1.$ What are the entities involved? You will possibly arrive in a group, by road or by airplane.

$2.$ What are the relationships that matter between these entities?

$3.$ Draw an $\backslash ($ E $/$ R $\backslash )$ diagram.

$4.$ Convert your E$/$R model to a relational schema. $($See question $3$ for som related SQL$)$

uestion $3$: $(20\backslash \%)$ Using your schema from the last question, write SQL queries for the following:

$1.$ Put yourself into the database.

$2.$ You are going to the movies in Newport, Vermont Saturday night, December $16,$ and expect to return at Stanstead after $9$ pm $.$

$3.$ How many people are expected to return that evening after $8$ pm $($Customs needs to schdule staff!$)$

$4.$ Some other query you find interesting $($say what it does.$)$