B$)$ An English Langage School give courses in online or face$-$to$-$face. Face$-$to$-$face courses organized in classrooms in

school premises. Online courses are accessed by a URL through username and password. In the language school

there are beginner, intermediate and advanced level classes. Students gets grade at the end of the course.

Based on this grade they continue to upper$-$level classes. The school make contract with the language schools

from different countries to provide education for the upper$-$level students in abroad for a specific period. Each

school has rating based on students' feedback. Each student can only attend these courses in abroad only once.

$($

a$.$ Draw ERD for above given scnerio. Show the following requests on the diagram. $($Yeni isteklere uygun

olarak ERD olussturun. $$izimde a$$agidakilere yer veria$)$

Hoving changes on entities, attribute and relationships correctly. If there are missing attributes, add

them. Definitions must satisfy normalization $($steklere uygun varlik, nitelik ve lilskileri gosterin ve eksik

nitelik varso ekdeyin. Tanumiamaiar normaizasyona uygun oimalh$)(15$ p$)$

ii$.$ Defining are structure and also convert it to supertype$/$subtype $($Yay yapisina yer veria ve usttip$-$

attlipe donustar$$n$)(15$p$)$

iil. Defining M:M relationship and resolving il$.($M:M iis $$iye yer verip cozumiemesini yapiniz$)(10$ p$)$

iv$.$ Keeping the history of contracts assuming that the contract with foreign language school is done

yearly based $(10$ p$)$

b$.$ Give mapping tables $($Tabie Instance Charts$)$ only for the enciries involved in arc and M:M relationships

$(15$ p$)$