DATABASE TABLE DESIGN EXPLAINED WITH EXAMPLES OF REAL LIFE WEB APPLICATION IN 2023.

Job Portal is an evergreen project for all country agencies. Every one needs job change . And most of people want to work for company. Are you planning to develop a Job Portal like Naukri.com ? If answer is yes then you are at right place. I am here for explaining the database tables for Job Portal Project. Now come to the point. Job Portal System may contain hundreds of tables but it's core part contains only Four tables. That means four different modules are include in this system. How a job portal system works !   An Employee comes and register.  An Employer comes in same way and register. Then employee send resume. Same way company posts jobs. Then again employee may apply for particular job . Same way company or employer may send request to employee after looking his resume. That's it !  If you are here because you are searching out database tables for  Job Portal Project then most welcome.  By clicking below download link you can get mysql tables. Me

Any kind of online booking system has it's core architecture.In which a visitor comes and book after his/her registration . He pay for service.Payment and booking information remain in below 2nd and 3rd table.If you are going to create "mini" project for online  booking then you can combine table number 1 and 2. (guest_register+booking_register) for simplify. 1. Guest_register 2. Booking_register 3. invoice_register Until we will not consider particular booking system we can not predict tables.So , here i am considering various booking system one by one. All booking system's database need atleast above three table for implementation. (1) Online Cab Booking Database design. (2) Online Movie Ticket Booking Database design. (3) Online Hotel Booking Database design. (4) Online Flight Booking Database design. Bus Booking Table in MySql:

Single table for Chat/Conversation Application:

Registration Table Structure As a programmer point of view almost each and every project start with this module i.e. registration process.  In registration process a mini or big html form is displayed on web page. A user fill that form and web script process it for further storage in database. Although a basic registration process contains email address and password from user and store it into database table.  The below image is a snapshot of registration table. Image is self explained . There are 10 columns in this table.  Although above image is self explained but for clarity of field need we have to understand one by one.  First column is table id. It is used as primary key for this table. Second one is email address of user. Third column is password . The password , generally given by user at the time of registration. But it may be auto generated. Generally banking sites uses auto generated passwords for security reasons.  Fourth one is column, name. It is simply user name.