reate an ER diagram that correctly describes the database for exams at Campus in Bäcksvängen in accordance with the following description: (Own assumptions must be clearly described.) Staff for various functions are involved in the exams. All staff have a full name and a unique staff code. Some people are examiners on one or more courses. A course has one name and one unique ladok code. For a course, you can add up its points based on the associated elements. One part is part of a course (for example an exam, a laboratory or project). A course can have several different parts. An element has a name, a description, a torque code, one point and two or more grades (eg: U, G, VG). An element can only belong to one course. Since the database is to process the exams, it is obvious that a part like described as an examination has an examination opportunity that is identified, among other things, by the date, start time, end time and that it is possible to calculate total writing time. A student has a complete name, a regular social security number. One or more students can register for an exam for one or more courses. All premises that can be used for an examination must be in the database. A room has a code and often a name. When a student participates in an exam, it takes place in a specific room. In order for everything to take place according to the rule book, there is one in each room and for each exam or several persons as guard s.
Create an ER diagram that correctly describes the
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 1 images
