S$\_$ID

Identifier

GEN

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

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

Write definition statement for table Faculties:

a$.$ Primary key should be autogenerated.

b$.$ Faculty 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:

Select the names of faculties and the amount of students in every faculty.

Select the names of faculties without registered students.

In which faculty is the biggest amount of the male students?

In which groups the amount of students is greater than in the group $123.$

Select the list of students from group $"$II RDB $11".$

Create cube which has two dimensions: faculty and group. Count students for these two

dimensions in all possible combinations.

could you please solve the $10$ questions with explanation