Assignment: Palliative Care Job

Purpose in Summary

Verify the newly created user ID before we handed to the

employee

Input Data Flow(s)

New User send for verification

Output Data Flow(s)

Approved user ID, verification of user ID request

Data Store(s) Used

Verified / accepted user ID, user ID send request

Detailed Process

Usually connects the HR, system admin and visiting HCP.

Description

Received user id from system admin would send that user id

to HR for the verification purpose. Manager finally

approved new HCP user ID, then it given to new Visiting

HCP to the organisation.

TABLES

Name of Table: Visiting HCP

Name of Attribute 1

Employee Surname

Description

It consists of surname of visiting HCP

Data Type

Text

Length

Long (250)

Constraints

Can not contain any special character or numerical numbers

Name of Attribute 2

Employee Forename

Description

It consists of forename of visiting HCP

Data Type

Text

Length

Long (250)

Constraints

Can not contain any special character or numerical numbers

Name of Attribute 3

Date of birth

Description

It consists of date of birth of visiting HCP

Data Type

Date/time

12

Length

Date and time

Constraints

Only numerical can be filled but no alphabets

Name of Attribute 4

Occupation

Description

It consists of visiting HCP occupation

Data Type

Text

Length

Long (250 character allowed)

Constraints

Name of Attribute 5

Nursing Home user ID

Description

It is the individual identification number given to each employee

of the organisation. It is a primary key as it is unique for each

insured person.

Data Type

Auto Number

Length

Long digit

Constraints

Name of Attribute 6

Phone Number

Description

It consists of visiting HCP phone number for contacting.

Data Type

Number

Length

Long integer

Constraints

It cannot contain any alphabet.

13

Table 2: Period of Nursing Home visiting

Name of Attribute 1

Individual ID

Description

It is the individual identification number given to each

employee of the organisation. It is a primary key as it

is unique for each insured person

Data Type

Auto number

Length

Long digit

Constraints

Name of Attribute 2

Date of Joining

Description

It tells about the date of joining of the HCP into the

organization.

Data Type

Date/Time

Length

Date and time

Constraints

Date and time values only in numerals, no alphabet

allowed.

Name of Attribute 3

Date of last working day

Description

It is the date states that visiting HCP last working day

with the organisation

Data Type

Date/Time

Length

Date and time

Constraints

Date and time values only in numerical no alphabet

allowed.

14

Table 3: Resident details

Name of Attribute 1

Patient ID

Description

It is the resident’s identification number given to each

resident. It is a primary key as it is unique for every

resident in the organisation

Data Type

text

Length

Long digit

Constraints

Name of Attribute 2

Resident surname

Description

It consists of Resident surname

Data Type

Text

Length

Long (250character)

Constraints

Name of Attribute 3

Resident Forename

Description

It consists of Resident forename

Data Type

Text

Length

Long (250 characters)

Constrains

15

Table 4: Nursing Home details

Name of Attribute 1

Nursing user ID Home number

Description

This field is state about the unique number of the

Nursing Home

Data Type

Text

Length

Long (250 character)

Constraints

Name of Attribute 2

Name of the organization

Description

This field is state about name of the organization in

which visiting HCP going to visit by request.

Data Type

Text

Length

Long (250 character)

Constraints

Name of Attribute 3

Address of the Organisation

Description

It gives the address of the Nursing Home in which

visiting HCP going to visit by request.

Data Type

Text

Length

Long (250 character)

Constraints

16

17

Calculate the price of your order

550 words
We'll send you the first draft for approval by September 11, 2018 at 10:52 AM
Total price:
$26
The price is based on these factors:
Academic level
Number of pages
Urgency
Basic features
  • Free title page and bibliography
  • Unlimited revisions
  • Plagiarism-free guarantee
  • Money-back guarantee
  • 24/7 support
On-demand options
  • Writer’s samples
  • Part-by-part delivery
  • Overnight delivery
  • Copies of used sources
  • Expert Proofreading
Paper format
  • 275 words per page
  • 12 pt Arial/Times New Roman
  • Double line spacing
  • Any citation style (APA, MLA, Chicago/Turabian, Harvard)

Our guarantees

Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.

Money-back guarantee

You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.

Read more

Zero-plagiarism guarantee

Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.

Read more

Free-revision policy

Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.

Read more

Privacy policy

Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.

Read more

Fair-cooperation guarantee

By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.

Read more