ERDs

**Set-1:**
```
               +------------------+
               |      Nurse       |
               +------------------+
               | nurse_id (PK)    |
               | nurse_name       |
               | registered       |
               | department_id (FK)|
               +------------------+
                        |
                        |
                        | works in
                        |
                        v
               +------------------+
               |    Department    |
               +------------------+
               | department_id (PK)|
               | department_name  |
               +------------------+
```

**Set-2:**
```
               +------------------+
               |     Student      |
               +------------------+
               | student_id (PK)  |
               | student_name     |
               | course_id (FK)   |
               +------------------+
                        |
                        |
                        | enrolled in
                        |
                        v
               +------------------+
               |      Course      |
               +------------------+
               | course_id (PK)   |
               | course_name      |
               +------------------+
```

**Set-3:**
```
               +------------------+
               |    Physician     |
               +------------------+
               | physician_id (PK)|
               | physician_name   |
               | department_id (FK)|
               +------------------+
                        |
                        |
                        | works in
                        |
                        v
               +------------------+
               |    Department    |
               +------------------+
               | department_id (PK)|
               | department_name  |
               +------------------+
```

**Set-4:**
```
               +------------------+
               |     Supplier     |
               +------------------+
               | supplier_id (PK) |
               | supplier_name    |
               +------------------+
                        |
                        |
                        | supplies
                        |
                        v
               +------------------+
               |      Item        |
               +------------------+
               | item_id (PK)     |
               | item_name        |
               | supplier_id (FK) |
               +------------------+
```

**Set-5:**
```
               +------------------+
               |     User         |
               +------------------+
               | user_id (PK)     |
               | username         |
               +------------------+
                        |
                        |
                        | makes order
                        |
                        v
               +------------------+
               |     Order        |
               +------------------+
               | order_id (PK)    |
               | user_id (FK)     |
               +------------------+
```

**Set-6:**
```
               +------------------+
               |     Supplier     |
               +------------------+
               | supplier_id (PK) |
               | supplier_name    |
               +------------------+
                        |
                        |
                        | supplies
                        |
                        v
               +------------------+
               |      Item        |
               +------------------+
               | item_id (PK)     |
               | item_name        |
               | supplier_id (FK) |
               +------------------+
```

**Set-7:**
```
               +------------------+
               |     Student      |
               +------------------+
               | student_id (PK)  |
               | student_name     |
               | course_id (FK)   |
               +------------------+
                        |
                        |
                        | enrolled in
                        |
                        v
               +------------------+
               |      Course      |
               +------------------+
               | course_id (PK)   |
               | course_name      |
               +------------------+
```

**Set-8:**
```
               +------------------+
               |     Supplier     |
               +------------------+
               | supplier_id (PK) |
               | supplier_name    |
               +------------------+
                        |
                        |
                        | supplies
                        |
                        v
               +------------------+
               |      Item        |
               +------------------+
               | item_id (PK)     |
               | item_name        |
               | supplier_id (FK) |
               +------------------+
```

**Set-9:**
```
               +------------------+
               |     Employee     |
               +------------------+
               | emp_id (PK)      |
               | emp_name         |
               | job              |
               | hiredate         |
               | sal              |
               | comm             |
               | dept_no (FK)     |
               +------------------+
                        |
                        |
                        | works in
                        |
                        v
               +------------------+
               |    Department    |
               +------------------+
               | dept_no (PK)     |
               | dept_name        |
               | location         |
               +------------------+
```

**Set-10:**
```
               +------------------+
               |     Employee     |
               +------------------+
               | emp_no (PK)      |
               | emp_name         |
               | job              |
               | hiredate         |
               | sal              |
               | comm             |
              


/////SET-10
                                        +--------------+
                                        |   Customer   |
                                        +--------------+
                                        | customer_id (PK)
                                        | name
                                        | email
                                        | address
                                        +--------------+
                                                |
                                                |
                                    +-----------+-----------+
                                    |                       |
                        +-----------+-----------+   +-------+-------+
                        |      Makes Purchase     |   |   Manages    |
                        |    +--------------+    |   |    Payment   |
                        +----|     Order    |<---+   +-------+-------+
                             +--------------+            |    
                             | order_id (PK)             |    
                             | customer_id (FK)          |    
                             | order_date                |
                             +--------------+            |
                                                 +--------+---------+
                                                 |                  |
                                       +---------+---------+   +----v----+
                                       |     Contains     |   | Payment |
                                       +-----------------+   +---------+
                                       | order_id (FK)  |   
                                       | product_id (FK)|
                                       | quantity        |
                                       +-----------------+
                                                      
                           +-------------+             +----------------+
                           |   Product   |             |    Pharmacy    |
                           +-------------+             +----------------+
                           | product_id (PK)|         | pharmacy_id (PK)|
                           | name          |         | name           |
                           | price         |         | location       |
                           | manufacturer_id (FK)|    +----------------+
                           +-------------+    
                                   |
                                   |
                           +-------+--------+
                           |  Manufactures  |
                           +----------------+
                           | manufacturer_id (PK)|
                           | name               |
                           | country            |
                           +-------------------+