[go: up one dir, main page]
Scribd
Upload
25 views33 pages

Database Systems Group6 Problem 1.8

This document describes a mini-project to create a patient management database system. It includes: - An overview of the group members and their tasks, which include designing the ERD, database schema, and user interface. - Details of the data to be managed (patient, department, doctor, and check information) and the relationships between them. - Explanations of the functions to be implemented: showing data in tables, searching data, and updating/adding/editing records. - Notes that patients and checks cannot be deleted, but doctors and departments can under certain conditions. - Outlines of the files and code needed to build the frontend interface and backend functionality for the various functions.

Uploaded by

hienhiennguyen0106
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
25 views33 pages

Database Systems Group6 Problem 1.8

This document describes a mini-project to create a patient management database system. It includes: - An overview of the group members and their tasks, which include designing the ERD, database schema, and user interface. - Details of the data to be managed (patient, department, doctor, and check information) and the relationships between them. - Explanations of the functions to be implemented: showing data in tables, searching data, and updating/adding/editing records. - Notes that patients and checks cannot be deleted, but doctors and departments can under certain conditions. - Outlines of the files and code needed to build the frontend interface and backend functionality for the various functions.

Uploaded by

hienhiennguyen0106
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 33

MINI-PROJECT - GROUP 06

DATABASE SYSTEM MANAGEMENT


Lecturer: Tran Manh Ha

Problem 1.8: Patient Management


Group Members: Hoàng Trọng Gia Phước - MAMAIU20043

Ngô Thiện Mỹ - MAMAIU20013

Lê Nguyễn Đăng Khoa - MAMAIU19008

Task Breakdown:

● ERD & Database Design: Khoa, My, Phuoc.


● Generate Sample Database: Khoa, My, Phuoc.
● Implement Database into MySQL server on xampp folder: Phuoc
● Coding homepage.html: Khoa, My
○ <style>: My
○ <script>: My
○ Show, Search and Update function: Khoa, My
● Coding .php files: Phuoc
● Report: Khoa, My

1.Problem

A patient management system manages multiple sets of data:

● patient information contains identifiers, name, address, contact, insurance, department, doctor, etc.
● department information contains identifiers, name, building, experiment, etc.
● check information contains identifiers, patient, doctor, title, room, etc.
● doctor information contains identifiers, name, department, expertise, etc.

Several constraints need to be defined, at least patients belong to departments, doctors belong to departments,
departments possess checks and doctors perform checks on patients, patients are assigned to doctors, etc. This
system allows managers to perform multiple functions on patients, departments, checks and doctors using the
user interface.
2. ERD:
3.Database Schema

4.File Structure:
5.Homepage (including homepage.html)
This is the web page for interacting with the
user.
➢ <style>: the decoration coding:
background image, boxes, fonts, ...

➢ CSS for the menu_bar:


Source: HERE
➢ This part is used to link 3 .html files to each other

➢ Here is the homepage.html


6.Show Function:
➢ Usage:
- Show data in either one single table, or multiple tables joined together depending on the user's choice.
- User can choose what attribute to be included in the display.
➢ showdata.html
<script>: jQuery code, for simple animations on the homepage.

1.1.1. show-result.php: (continued on next page)

1.2. Result:
Below are two sample results: first one for a single table (airline), second one for multiple tables.
➢ showdata.php
Here is the working of show data function:
Here is the result:

7.Searchdata
➢ Usage:
● Search data in one single table depending on the user's choice.
● Users can choose what attribute is used for the search.

➢ searchdata.html
<script>: jQuery code, for simple animations on the homepage.
➢ searchdata.php
Here is the working of search data function:
8.Update Function:
➢ Usage:
- Add, edit or delete data in one single table depending on the user's choice.
- Users can choose any attribute for the update.
➢ updatedata.html
<script>: jQuery code, for simple animations on the web.
❖ There is no delete for the patients, as the hospital archive all the data of any person who is treated there.
❖ There is no delete for the check patient, as the hospital archive all the data of any person who is treated there.
❖ There is no delete for the department table, as the hospital wants to expand more so that they (maybe) do not want
to delete any department
➢ update_result.php
//Table patient
//Table doctor
//Table check patient
//Table department
Here is the working of update data function:

*add a new one*


*Edit*
*Delete (only doctor)

—-------------------------------------------------- Thank you ---------------------------------------------------------

You might also like