මචන්ල database assignment එකක් තියෙනවා. Help එකක් දියල්ලකො
Care pro intended to expand their services to include dental and optic care,
etc to their institute, and you are hired to redesign their current system. The
diagram below illustrates the existing processes from the medical system.
Your tasks are to prepare a complete document with an improved ER diagram to
support their extended services; your documentation should illustrate the
1) Entity-Relationship diagram pinpointing the newly added part for the services
to the system;
2) Design Note based on your design explaining your ER diagram
3) A new relational schema consisting of the definitions of the domains and
relations that represent the entity and relationship types, including primary keys,
foreign keys and any constraints.
Care pro intended to expand their services to include dental and optic care,
etc to their institute, and you are hired to redesign their current system. The
diagram below illustrates the existing processes from the medical system.
Your tasks are to prepare a complete document with an improved ER diagram to
support their extended services; your documentation should illustrate the
1) Entity-Relationship diagram pinpointing the newly added part for the services
to the system;
2) Design Note based on your design explaining your ER diagram
3) A new relational schema consisting of the definitions of the domains and
relations that represent the entity and relationship types, including primary keys,
foreign keys and any constraints.
