model ER

Class exercise-1 ... A weak entity type can have more than one owner Model the following two different scenarios about grade records Every course has a C# (unique), name, and credit hours. Every student has a S# (unique), name, and address. We want to keep track of who got what grade in what course & semester, and their rank in the class then (e.g. top 5%, top 10%, etc.) Semesters are represented as F12, W13, Sp13, F13, etc. Scenario-1 We want to keep a record of only the latest attempt in a course. Scenario-2 We want to keep a record of all attempts in a course