Exercise 3 - STUDENTS AND COURSES (

Exercise 3 - STUDENTS AND COURSES (Similar to Exercise 2)



Draw an entity-relationship diagram for the following scenario, stating any assumptions you find it necessary to make, and showing unknown cardinalities and optionalities using question marks on the relationship line. Show also the attributes explicitly mentioned in the scenario and underline any you consider suitable candidates for being primary keys.

It is required to keep the following information on students, courses and subcourses. Each student has a name, identification number, home address, term address, and a number of qualifications for which the subject (e.g. maths), grade (e.g. C) and level (e.g. `A' level) are recorded. Each student is registered for one course where each course has a name (e.g. Information Systems) and an identification number. Record is kept of the number of students registered for each course.

Each course is divided into subcourses where a subcourse may be part of more than one course. Information on subcourses includes the name, identification number and the number of students taking the course.

ผลลัพธ์ (อังกฤษ) 2:

Exercise 3 - STUDENTS AND COURSES (Similar to Exercise 2) Draw an Entity-Relationship diagram for the following scenario, stating any assumptions to Make You Find it necessary, and showing Unknown cardinalities and Optionalities question using Relationship Marks on the line. Show also the attributes explicitly mentioned in the scenario and underline You consider any Suitable Candidates for being primary Keys. It is required to Keep the following information on students, courses and Subcourses. Each student has a name, identification number, home address, term address, and a number of qualifications for which the subject (eg maths), grade (eg C) and level (eg `A 'level) are recorded. Each student is registered for one course where each course has a name (eg Information Systems) and an identification number. Record is kept of the Registered Number of students for each course. Each course is divided Into Subcourses where a Subcourse May be Part of more than one course. Information on subcourses includes the name, identification number and the number of students taking the course.

ผลลัพธ์ (อังกฤษ) 3:

Exercise 3 - STUDENTS AND COURSES (Similar to Exercise 2)



Draw an entity-relationship diagram for the, following scenario. Stating any assumptions you find it necessary, to make and showing unknown cardinalities and optionalities using question. Marks on the relationship line.Show also the attributes explicitly mentioned in the scenario and underline any you consider suitable candidates for being. Primary keys.

It is required to keep the following information on students courses and, subcourses. Each student has a. Name identification, address, number home, address term, a and number of qualifications for which the subject (e.g. Maths),. Grade (e.g. C) and level (e.g."A 'level) are recorded. Each student is registered for one course where each course has a name (e.g. Information Systems). And an identification number. Record is kept of the number of students registered for each course.

Each course is divided. Into subcourses where a subcourse may be part of more than one course. Information on subcourses includes, the nameIdentification number and the number of students taking the course.