Scribd
Upload
3 views2 pages

Data Dictionary

The document outlines the structure of a database with various tables including Client, Department, Deduction, Salary, Employee, Address, Contact Number, Balance, and Hours. Each table includes attributes such as IDs, names, addresses, and numerical values, along with specifications for data types, required fields, and primary or foreign key designations. The document serves as a reference for the database schema and its constraints.

Uploaded by

joseph.deluna97
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
3 views2 pages

Data Dictionary

The document outlines the structure of a database with various tables including Client, Department, Deduction, Salary, Employee, Address, Contact Number, Balance, and Hours. Each table includes attributes such as IDs, names, addresses, and numerical values, along with specifications for data types, required fields, and primary or foreign key designations. The document serves as a reference for the database schema and its constraints.

Uploaded by

joseph.deluna97
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

Table Attribute Data Required?

PK or FK Fk
Name Name Description Type Formal Range (Yes/no) References
Table

Client Client ID Client’s ID varchar(6) x-xxxx 0-1000 Yes PK


number
Company Name of String(30) a-z & 0-9 Yes
Name company
Billing Address of String(20) a-z & 0-9 Yes
Address company
Fax Company’s Integer(10) xxx-xxx- 0-9 Yes
Numbers fax number xxxx

Departmen Department Department’ String(5) xx-xxxx a-z & 0-9 Yes PK


t ID s ID
Employee ID number of Integer(9) xx-xxxx- 0-9 Yes
ID employee xxx
Department Division String(15) a-z Yes
Name name

Deduction Loan Amount of varchar(6) 0-9 No


Loan
Tax Amount of Varchar 0-9 Yes
Tax
Tardiness Number of Integer(2) 0-9 No
Tardiness
Absences Number of Integer(2) 0-9 No
Absences
Holiday Number of Integer(2) 0-9 Yes
Holidays
Employee ID number of Integer(9) 0-9 Yes FK Employee
ID Employee

Salary Salary Salary Integer(5) 0-9 Yes


Amount
Work start Date when vachar(10) 0-9 Yes
date Employee
Allowance Amount of Double(4) 0-9 No
Allowance
Bonus Amount of Double(4) 0-9 No
Bonus
Work end Date when Varchar(10) 0-9 Yes
date Employee
Employee ID number of Integer(9) xx-xx 0-9 Yes FK Employee
ID Employee

Employee Employee ID number of Integer(9) xx-xxx 0-9 Yes PK


ID Employee
Full Name Full name of String(30) a-z Yes
Employee
Address Employee’s String(30) a-z&0-9 Yes
full address
Contact Employee’s Integer(11) xx-xxx- 0-9 Yes
Number Contact xxx-
Number xxxx
Balance Employee’s varchar(7) 0-9 No
current
balance
Hours Numbers of Integer(3) 0-9 Yes
worked work hours
Department Department’ String(5) xx-xxx 0-9 Yes FK Department
ID s ID number

You might also like