Pausework Database Model

pausework_er_diagram.JPG.JPG

pausework_normalization

Normalization for Pausework

1. Entities
-Employer_table
-Summary_leave
-Leave_type
-Approval_table


2. Identify attributes and define attribute data type
Employer_table.... user_id INT, last_name: String, first_name: String, email:String, department:String, Title: String, image: String,

summary_leave_form....id INT, user_id INT, leave_type_id INT, start_date_from: Date, end_date_to: Date, created_date: Timestamp, created_by: String, approve_status: INT, status_color: String

leave_type...id: INT, name:String, max_allowed_days: INT

approval_table....id:INT, approve_status: INT, status_color: String,approve_message: String, user_id: INT, summary_leave_form_id: INT, resume_date: DATE, off_days: INT, approve by: String


Relationship:
Employer_table - Summary_leave_form 1:M
Employer_table - leave_type 1:M
summary_leave_form -approval_table 1:1
Employer_table - approval_table 1:M