Download Database Design and Development: Patient Record Management System and more Study Guides, Projects, Research Database Management Systems (DBMS) in PDF only on Docsity!
Contents
- Task 1 / P1
- Task 4 / P2
- Task 6 / P3
- Task 8 / P4
- Task 11 / P5
- Bibliography
Task 1 / P Design a relational database system using an appropriate design tools and techniques, containing at least four tables, with clear statements of user and system requirements.
Introduction:
Relational Database Management System (RDBMS)
A relational database management system (RDBMS) is a collection of programs and capabilities that enable IT teams and others to create, update, administer and otherwise interact with a relational database (Rouse, n.d.). RDBMS uses SQL (Structured Query Language) for various purposes like creating and editing the data in the table. The main objective of RDBMS is to help the user to store data easily and to retrieve and manipulate it later.
SQL
SQL stands for structured query language. It is a programming language which is used to communicate with data stored in a relational database management system. The syntax of SQL is similar to the English language, which makes it relatively easy to write, read, and interpret.
In RDBMS the data are arranged in a tabular form so it can be accessed easily later. It uses a structure approach that allows the users (us) to identify and manipulate the data in the database. There are many security features in RDBMS.
In the scenario which is given, I created a database naming it Patient Record System (prms). In this task I used entity relationship diagram.
Entity Relationship Diagram (ER Diagram)
An entity-relationship diagram (ERD) is a data modeling technique that graphically illustrates an information system’s entities and the relationships between those entities. An ERD is a conceptual and representational model of data used to represent the entity framework infrastructure (Anon., n.d.). In the database an ER Diagram plays a critical role to understand the information in database. An ERD can serves as a referral point and it also helps in debugging process if the situation arises.
a. One to one relationship- In 1:1 there is only one relationship from a table A to table B.
For.eg. relationship of husband to wife
b. One to many relationship-In one to many relationship, there can be more than one relationship from table A to table B.
For e.g. a mother can have more than one children.
c. Many to many relationship In Many to many relationships there can be multiple relationship from both table A and table B. For e.g. a school can have many teachers and each teacher can teach many subjects.
The relationship diagram of address, doctor, admit, patient and ward table is as below:
An example of data dictionary is as below:
Conclusion:
Hence, in this task I have designed a relational database system using an appropriate design tools and techniques, containing at least four tables, with clear statements of user and system requirements.
Task 4 / P Develop the database system with evidence of user interface, output and data validations, and querying across multiple tables.
Introduction
Database
A database can be referred as the collection of data in a systematic way. We create database to save, edit and use the data for future purposes. In the database we save the data in an organized way so that we can use them later.
Database Management System
“ A database management system (DBMS) is system software for creating and managing databases.” The DBMS helps to mange the data in such a way so that we can easily retrieve them for future purposes. The DBMS software uses query language.
For this task, I am going to use SQL language and MySql software as a database management software.
Creating a Database
First of all, I am going to develop a database for patient record management system. I am going to name it prms for short.
Syntax is as below:
CREATE DATABASE prms;
Output
Hence, address table is created.
Creating doctor table
Syntax is:
Output
Hence, doctor table is created.
Creating Patient Table
Syntax is
Output
Hence, admit table is created.
Creating ‘ward’ table
Syntax
Output
Hence, ward table is created.
Now after that I used Join syntax to combine the tables.
Joins
e.g.
I used inner join to combine two tables named patient and address. The syntax and result is below:
Left Join
In the prms, I used Right join to combine doctor table with address table.
The screenshot is below:
Constraints
Types of constraints
