Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

UNITEN needs to keep details of its students and staff, the courses that it offers and the performance of the students who study its courses.

image text in transcribed

UNITEN needs to keep details of its students and staff, the courses that it offers and the performance of the students who study its courses. UNITEN is administered in two geographical regions: Putrajaya and Muadzam. Information about each student should be initially recorded during registration. This includes the student's identification number issued at the time, name, year of registration and the region in which the student is located. A student is not required to enroll in any courses during registration; enrollment in a course can happen at a later time. Information recorded for UNITEN staff must include the staff number, name and region in which he or she is located. Each staff member may act as a counselor to one or more students, and may act as a tutor to one or more students on one or more courses. It may be the case that, at any particular point in time, a member of staff may not be allocated any students to tutor or counsel. Each student has one counselor assigned during registration who supports the student throughout his or her study at UNITEN. A student is assigned to a separate tutor for each course in which he or she is enrolled. A staff member may only counsel or tutor a student who is resident in the same region as that staff member. Each course that is available for study must have a course code, a title and a value in terms of credit points. A course is either two credit or three credit. A course may have a quota for the number of students enrolled in it at any one semester. A course need not have any students enrolled in it (such as a course that has just been listed and offered for study). Students are constrained in the number of courses they can be enrolled in at any one time. They are not allowed to take more courses if their combined credit points total exceeds 21. Draw an entity relationship diagram (ERD) for the given scenario above. You need to include all attributes, primary keys, relationships and cardinalities mentioned. [15 marks]

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

What are the other economic side effects of accidents?

Answered: 1 week ago

Question

8. Provide recommendations for how to manage knowledge.

Answered: 1 week ago