Help?
PLEASE MATCH YOUR ASSIGNMENT QUESTIONS ACCORDING TO YOUR SESSION
IGNOU MCSL-217 (January 2025 – July 2025) Assignment Questions
Q1: ABC is a network of Hospitals. Its having Hospitals across the World. Its possible to take appointment for any Doctor for an available slot on an available date through its website. Its having a Chatbot also. There are many specialities in each of its Hosptitals. However, not all specialities are available across all its Hospitals. Doctors may provide consultancy services in more than one hospital of its network. Its possible to make payment of consultation fee online while taking appointment or directly at hospital prior to consultation. Make assumptions, wherever necessary. Also, list them very clearly
Now, with reference to the above, answer the following:
(1) List the Entities
(2) For each Entity, list Attributes
(3) Define relationships between the Entities
(4) Finally, draw the Entity Relationship Diagram
IGNOU MCSL-217 (January 2024 – July 2024) Assignment Questions
Q1: ABC is a University which is having Learner Support Centers (LSCs) across the World. It also had Regional Centers (RCs) across the World. ABC also includes many departments which offer various programmes. However, not all LSCs offer all the Programmes. Counseling sessions normally take place during weekends. Minimum attendance of 75% is essential in Practical Counseling Sessions. Every LSC is having a Code. Every RC is having a code. Every Department is having a Code. Every Programme is having a Code. Every Course is having a Code. Any person who takes admission to any of the Programmes is also having an enrollment number. All codes and enrollment number are unique. Semester End Examinations are held at designated Examination Centers and every Examination Center is having a code. Every students is assigned to a LSC where he attends counseling sessions. A student can seek transfer from one LSC to another.
Now, with reference to the above, answer the following:
(1) List the Entities
(2) For each Entity, list Attributes
(3) Define relationships between the Entities
(4) Finally, draw the Entity Relationship Diagram
