PS1

  1. 1

    Hospital Patient Management System. Design an ERD for a system that tracks patients, doctors, medical appointments, treatments and hospital rooms.

    Define the entities and relationships below, then draw the conceptual ERD (professional tool, e.g. draw.io or Lucidchart) with all four entities and clear cardinalities (1:M, 1:1, M:N).

    Requirement Count asked
    Entities, each with a PK and at least 5 attributes with data types exactly 4
    One-to-Many Relationship (1:M) 2
    One-to-One Relationship (1:1) 1
    Many-to-Many Relationship (M:N) 3
    Weak Entity with an identifying relationship 1
    Associative Entity derived from an M:N relationship, with attributes 1

    Deliverable: one PDF, conceptual ERD plus the logical ERD as an extra page, drawn in a tool such as draw.io or Lucidchart.

  2. 2

    Transform your conceptual ERD into a logical ERD, using tables, primary keys (PK) and foreign keys (FK). Submit it as an additional page in the same PDF.