Pocted

tacos

Table Sfudents

Table Faculties

$\backslash$table$[[$Fity$],[$Thining$]]$

Write SQL queries for a given tables $($you can use short names of columns$)$:

Draw ER diagram, Student MTST be assigned to one Faculty. Show and connect keys.

Write definition statement for table Faculties:

a$.$ Primary key should be autogenerated.

b$.$ Faculry names are unique.

Write statement that will define relation between tables.

Two new students are entering faculty named "DITF". Write statement$($s$)$ to add this data:

$\backslash$table$[[$Sontme$,$Treges,Ceader,GR D$],[$Jofa$,sin1,$Male,$100811],[$Enty$,$Jodases,Fonded,$1120?11$