Scribd
Upload
49 views5 pages

Data Dictionary

This document contains data dictionaries for tables related to a mental health predictor and IQ test. It includes data dictionaries for registration, login, appointment, and report tables that describe the fields, data types, sizes, and examples for each. Key information captured includes patient names, contact details, demographics, test details, scores, and appointment details with doctors.

Uploaded by

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

Data Dictionary

This document contains data dictionaries for tables related to a mental health predictor and IQ test. It includes data dictionaries for registration, login, appointment, and report tables that describe the fields, data types, sizes, and examples for each. Key information captured includes patient names, contact details, demographics, test details, scores, and appointment details with doctors.

Uploaded by

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

DATA DICTIONARY

Data Dictionary for Mental Health Predictor and IQ Test.

Tables:

1) Registration Table.
2) Login Table
3) Appointment Table.
4) Report Table.

a) Data Dictionary for Registration Table.

Field name Field Data Type Description Example


size
First name 20 Text First name Ram
of the
person
Last name 20 Text Last name of Kumar
the person
Phone 20 Integer Phone 7276773501
number number of
the person
Email 40 Text, Email of the ramkumar@123
Integer, person
Special
Characters
Age 4 Integer Age of the 20
person
Qualification 30 Text, Qualification 10+2/ Bcom
Integer, of the
Special person
characters
If a Student 5 Scroll To check Yes.
whether the
person is a
student or
not.
Gender 8 Scroll To check the Male.
gender of
the person.
City 15 Scroll City of the Pune.
person
State 15 Scroll State of the Maharashtra
person
Nationality 15 Scroll To check the Indian.
nationality
of the
person

b) Data Dictionary table for login table.

Field name Field size Data type Description Example


User Id 20 Integer User Id of 9890
the person
Password 20 Text , Password of Ram@123
integer , the person’s
special account
characters
c) Data Dictionary table for Appointment table.

Field name Field Data type Description Example


size
Name 20 Text Full name Ram Kumar.
of the
person
Phone 20 Integer Phone 7276773501
number number of
the person
Email 40 Text, Email of the ramkumar@123
Integer, person
Special
Characters
Test Given 20 Text Test name Mental Test/ IQ
for which the Test.
person has
Given

Report 4Mb JPG, PNG, Copy of the Report.jpg.


Attachment PDF. person’s
report.
d) Data Dictionary table for Report table of the test.

Field name Field size Data type Description Example


User Id 20 Integer User Id of 9890
the person
Test 20 Text Test name Mental
Attempted which the Health Test
person has or IQ Test.
attempted.
Score 20 Integer Score the IQ score:
person got 15/20.
in test.

e) Data Dictionary table for Appointment table which will be stored


in Database.

Field name Field Data type Description Example


size
Name 20 Text Full name of Ram Kumar.
the person
Phone 20 Integer Phone 7276773501
number number of
the person
Email 40 Text, Email of the ramkumar@123
Integer, person
Special
Characters
Test Given 20 Text Test name Mental Test/ IQ
for which the Test.
person has
Given

Report 4Mb JPG, PNG, Copy of the Report.jpg.


Attachment PDF. person’s
report.
Doctor’s 20 Text Name of the Dr. Rajendra
name doctor for Prasad.
whom the
appointmen
t is allotted.
Specialist 20 Text Appointed Specialist in
for. doctor’s Stress
speciality. Management.
Appointment 20 Date and Date and 01/11/2022.
Date and time time of the 17:00PM(IST).
Time format appointment
allotted.

You might also like