Database Design

[sunandaC]

Databases

administrator Database.

seekers Database.

employer Database.

common Database


Administrator Database contain..


admin_login (store administrator Login info)

admin_adinfo (store advertisement info)

admin_billinfo (store Billing info)

contact_info (store administrator contact info)

seeker Database contain….

seeker_contact (store contact information of Jobseekers)

seeker_edu (store educational information of Jobseekers)

seeker_exp (store experience information of Jobseekers)

seeker_expfull (store experience information of Jobseekers in Full time job)

seeker_exppart (store experience information of Jobseekers in Part time job)

seeker_jstatus (store current Job status information of Jobseekers).

seeker_login (store Login information of Jobseekers)

seeker_master (store Master information of Jobseekers)

seeker_otherinfo (store other information like language speak, write,
Passport information etc…)

seeker_seeks (Store information about what type of job seekers
wants)

seeker_skills (store information about the other skill of Jobseekers)


employer Database contain…

emp_fulljob (store information about full time job posted by Employer)

emp_info (store information about the Employer)

emp_jobtype (store information about different type of job)

emp_login ( store information about Employer login)

emp_master (store information master information of Employer)

emp_partjob (store information about part time job posted by Employer)

emp_vacancy (store information about vacancy posted by Employer)

common Database.

contact_info (store contact information for further queries.)

 

[jitendra05]

Databases

administrator Database.

seekers Database.

employer Database.

common Database


Administrator Database contain..


admin_login (store administrator Login info)

admin_adinfo (store advertisement info)

admin_billinfo (store Billing info)

contact_info (store administrator contact info)

seeker Database contain….

seeker_contact (store contact information of Jobseekers)

seeker_edu (store educational information of Jobseekers)

seeker_exp (store experience information of Jobseekers)

seeker_expfull (store experience information of Jobseekers in Full time job)

seeker_exppart (store experience information of Jobseekers in Part time job)

seeker_jstatus (store current Job status information of Jobseekers).

seeker_login (store Login information of Jobseekers)

seeker_master (store Master information of Jobseekers)

seeker_otherinfo (store other information like language speak, write,
Passport information etc…)

seeker_seeks (Store information about what type of job seekers
wants)

seeker_skills (store information about the other skill of Jobseekers)


employer Database contain…

emp_fulljob (store information about full time job posted by Employer)

emp_info (store information about the Employer)

emp_jobtype (store information about different type of job)

emp_login ( store information about Employer login)

emp_master (store information master information of Employer)

emp_partjob (store information about part time job posted by Employer)

emp_vacancy (store information about vacancy posted by Employer)

common Database.

contact_info (store contact information for further queries.)

Hey sunanda, thanks for sharing such a nice article and explaining about the database design. I am also uploading a document where you would find more detailed information on mentioned topic. Well, database design is the procedure of generating a comprehensive data model of a database.