what is a real world senario i can use to complete this task. Table one has to be connnected to table $2,$ and table $2$ to table $3.$

Describe the design ideas of your tables, fields and relationships. This includes table structure descriptions$($what fields does each table have, and which field is a primary key$),$ field definitions $($for each field, describe that field name, field type and field length$),$ and relationship definition among tables$($e$.$g$.$ In table XXX$,$ XXX is the foreign key connecting to the primary key XXX in table XXX$).$

You can use a format of your choice or a table like this:

$\backslash$table$[[$#$,$Tables,Fields,Relationships$],[1,\backslash$table$[[$STUDENT$($StudentID$,],[$FirstName$,],[$MiddleName$.],[$LastName$,],[$DateOfBirth$,],[$AdvisorID$)]],\backslash$table$[[$StudentID: AutoNumber, Long$],[$Integer;$],[$FirstName: Short Text, $50$;$],[$MiddleName: Short Text, $30$;$],[$LastName: Short Text, $50$;