+ If any of the previous requirements is not respected, your mark will be 0.
From the 2nd question, you should use the database provided in the sql file which has the following database diagram. Please, run the provided script to create tables and insert data into your database.
Assessments
id
type
name
marks
od?
enrollmentid
assessmentld
mark
Departments
Code
Name
8
8
[percent]
courseld
Courses
id
code
title
credits
enrollment
enrollmentid
studentid
courseld
semesterld
8
100
birthdate
Students דייוויון
Zoom
gender
address
8
country
department
semesters
id
code
year
beginDate
endDate
+ 100%
Close