Database Management System Assignment 2022

Running head: SYSTEM AND DATABASE
SYSTEM AND DATABASE
Name of the Student
Name of the University
Author Note

SYSTEM AND DATABASE
1
Table of Contents
Assignment Element 2: -............................................................................................................2
1 - User requirements:............................................................................................................2
Stakeholder analysis:..........................................................................................................2
Functional Requirements:..................................................................................................3
Business rules and Assumptions:.......................................................................................5
2 - ER Model Design and Documentation:............................................................................7
ER Diagram:.......................................................................................................................7
ER Model documentation:.................................................................................................7
3 - Evidence of time management and effective group work:.............................................12
4 - Peer assessment form:.....................................................................................................13
Assignment Element 3.............................................................................................................14
1- Final ER diagram:......................................................................................................14
2- Database implementation:.........................................................................................14
Bibliography:............................................................................................................................25

SYSTEM AND DATABASE
2
Assignment Element 2: -
1 - User requirements:
Stakeholder analysis:
This section of this report discussed about the stakeholders of The Pinkton Psychiatric
Hospital Research department. The key stakeholders are:
Twins patients:
Twins are primary and internal stakeholder in this system. This system is developed to
store information of twins. Sick twin table is able to capture every detail in this system. this
database is developed for research purpose of various twins.
The Pinkton Psychiatric Hospital Research department:
This is the research department of the hospital. This department is internationally
record information of twins and search about their problems and working on their treatment.
This is the internal stakeholder of the system.
Neighbouring Hospital:
This system is also collected twin information from different neighbouring hospitals.
This is an external stakeholder for the system. Every twin detail is helpful for the research
that is the reason this system collects twin information form the different hospitals.
Researchers:
In this system, researchers are the primary stakeholder of this system. Researchers are
the guided by the Lead researchers in the hospital. A group of people can work on a particular
project.
Lead Researchers:

SYSTEM AND DATABASE
3
Every group of researchers have a lead researcher who can lead their team. They are
the primary stakeholder for this system. Every lead researcher is guided by the research
manager.
Research manager:
Research managers are the primary stakeholder of the system. research manages
supervises the lead manages and their team. Research manages to submit an update of every
research to research director.
Hospital research director:
Hospital research director is the primary and internal stakeholder of this system.
research managers monitor and manage every research and create a schedule for it.
Functional Requirements:
The database has been developed meet the below listed functional requirements:
Requirement Id #1 – Priority – High:
Every information regarding twins is stored in the sick twins and illness record table.
These tables will help to register a twin into this system. Sick twins table store contact details,
sex, age, place of birth of twins, their nationality, blood goup, every information regarding
their illness, age and nationality of mother and father at the date of birth. In order to track or
migration this table keep every record of all previous address of each twin. Every information
can be retrieved with the SQL query.
Requirement Id #2 – Priority – High:
Illness record table can store every illness record and their diagnosis date. Apart from
this information this table also records they are admitted into a new hospital or not and the
duration of their stay. These records will help researchers to get their history.

SYSTEM AND DATABASE
4
Requirement Id #3 – Priority – High:
Research projects table store every information about the research. Every information
regarding the research store in this table.
Requirement Id #4 – Priority – High:
Test table can store every information of tests. A twin can go through many tests for
diagnosis purpose. With the help of the test table this system stores every test record for the
research project.
Requirement Id #5 – Priority – medium:
This system is able to generate the complete testing record by using test and research
project table.
Requirement Id #6– Priority – medium:
Apart from the only test result, test and research table can help this system to produce
when they were tested, which test they took, for which project. By using queries, a database
administrator can retrieve this information from the database. this system also generates
various reports based on the tests.
Requirement Id #7 – Priority – high:
This system can produce a total number of researches on a particular twin patient.
With the help of this feature, researchers can avoid disturbing twin’s parents by approaching
them repeatedly to ask if they are going to participate in the project or not.
Requirement Id #8 – Priority – medium:

SYSTEM AND DATABASE
5
With the help of this database, this system can allocate a budget for a particular
research project. This budget includes the travelling expenses, hotel costs and consultancy
expenses.
Requirement Id #9 – Priority – medium:
This system is capable to set an amount of time to complete a test. Task table can help
this system to perform this task. This system can fix the time for only activate projects.
Requirement Id #10 – Priority – High:
This system allows lead researchers and their managers to see the manpower budget
remaining on a specific project.
Requirement Id #11 – Priority – High:
One of the main problems in previous system is “various researchers have lodged
complaints of ‘favoritism’ – saying that certain colleagues have been allowed to attend
conferences in exotic locations, whereas they have been restricted to conferences and events
in the UK”. To overcome this problem this system can store every budget information in the
research project table and provide the all researchers id so that hospital authority can check
every researcher get sufficient money according to their project or not.
Requirement Id #12 – Priority – High:
This system can store every information for publishing a project. This system can
monitor and store journal and publication information of every researchers. Every researchers
details, their published journals details, and publication date can be found in the database.
Business rules and Assumptions:
As the case study contains only an outline of a business scenario, few business rules
and assumptions have been made. Assume that: