$1-$ Given the following three tables:

a$)$ For each table, identify the primary key and the foreign key$($s$).$ If a table does not have

a foreign key, write None.

b$)$ Do the tables exhibit entity integrity? Answer yes or no$,$ and then explain your answer.

c$)$ Do the tables exhibit referential integrity? Answer yes or no$,$ and then explain your

answer. Write NA $($Not Applicable$)$ if the table does not have a foreign key.

d$)$ Identify all the relationships between the tables and describe their type.

Table$1$: Mentee

$\backslash$table$[[$MenteeID$,$Mentee$\_$FNMentee$\_$LIdate$\_$joined,preferred$\_$spec,mentee$\_$status,$],[1,$John,Doe,$2022-01-01,$Software Development,Active$],[2,$Jane,Doe,$2022-02-01,$Web Design,Active$],[3,$Alice,Smith,$2022-03-01,$Data Analysis,Active$],[4,$Bob,Smith,$2022-04-01,$Project Management,Active$],[5,$Maggie,Jackson,$2022-05-01,$Graphic Design,Active$],[6,$Alex,Williams,$2022-06-01,$Marketing,Active$],[7,$Samantha,Jones,$2022-07-01,$Finance,Active$],[8,$Jessica,Davis,$2022-08-01,$Human Resources,Active$],[9,$Emily,Wilson,$2022-09-01,$Business Development,Active$],[10,$Daniel,Moore,$2022-10-01,$Accounting,Active$]]$

Table$2$: Booking

$\backslash$table$[[$SessionID$,$MenteelD$],[1,1,],[2,4,],[2,5,],[2,6,],[5,5,],[3,1,],[3,7,],[8,8,],[8,11,],[10,10,]]$

Table$3$: Session

$\backslash$table$[[$SessionID$,$Date,Duration,Sess$\_$Title,Sess$\_$Yes$\_$No$,$Sess$\_$Rating$],[1,2022-01-0110$:$00$:$00,01$:$00$:$00\mathrm{.}0000,$Introduction to Software Development,Yes,$3],[2,2022-02-0111$:$00$:$00,01$:$30$:$00\mathrm{.}0000,$Web Design Fundamentals,Yes,$4],[3.,2022-03-0112$:$00$:$00,01$:$15$:$00\mathrm{.}0000,$Introduction to Data Analysis,Yes,$5],[4,2022-04-0113$:$00$:$00,01$:$45$:$00\mathrm{.}0000,$Project Management Best Practices,No$,5],[5,2022-05-0114$:$00$:$00,02$:$00$:$00\mathrm{.}0000,$Graphic Design for Beginners,Yes,$2],[6,2022-06-0115$:$00$:$00,01$:$30$:$00\mathrm{.}0000,$Marketing Strategy $101,$Yes,$4],[7,2022-07-0116$:$00$:$00,01$:$45$:$00\mathrm{.}0000,$Finance for Non$-$Finance Professionals,Yes,$3],[8,2022-08-0117$:$00$:$00,01$:$30$:$00\mathrm{.}0000,$Introduction to Human Resources,No$,4],[9,2022-09-0118$:$00$:$00,02$:$00$:$00\mathrm{.}0000,$Business Development Techniques,Yes,$5],[10,2022-10-0119$:$00$:$00,01$:$45$:$00\mathrm{.}0000,$Accounting Basics,Yes,$4]]$