Law Office Database Project

Law Office Database Project

About the Project

A law firm is an office maintained by lawyers for the practice of law. It is where people with legal affairs or matters go to consult lawyers. The law firm is offices that require management; lawyers manage piles of documents, appointments, client’s record, services records, and other activities in the law firm. Conventionally, law firms are managed manually. The clerical staff and the lawyer’s sort on using printed records and physical storage which is very inefficient. Important documents may be misplaced and attorneys may face difficulties in retrieving the documents. With this, the researchers aimed to develop an automated system that will streamline the management of law firms’ daily operations and transactions. The system will let the law firms electronically record and keep important documents for sake-keeping and easy retrieval. Requesting appointments in law firms will also be easier for clients; they can register in the system and make an appointment before they visit the firm. The system will ensure that clients can have easy access to services that involve an attorney and legal processes.

Database Tables

Let’s start by making the tables and columns. For a thorough tutorial, please watch the video.

tbl_admin – this table stores the information of the admin users of the system. The table has five columns and they are the following:

• admin_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
• admin_user – the desired username of the admin user
• admin_pass – the desired password of the user combined with the username to login to the system.
• complete_name – complete name of the admin user
• email_address – the email address of the admin

Create SQL Statement – the statement below is used to create the tbl_admin, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.

CREATE TABLE `tbl_admin` (
`admin_id` int(11) NOT NULL,
`admin_user` varchar(30) NOT NULL,
`admin_pass` text NOT NULL,
`complete_name` varchar(100) NOT NULL,
`email_address` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

tbl_law_firm – the information of the registered law firms in the system are stored in this table. Eight columns are included in this table

• firm_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
• firm_name – the name of the firm
• complete_address – the complete address of the firm.
• contact_info – the contact information of the law firm preferably mobile number or telephone number.
• email_address – the email address of the law firm
• website – the name of the law firm’s website
• facebook_page – the law firm’s facebook page
• history – the history of the law firm

Create SQL Statement – the statement below is used to create the tbl_law_firm, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.

CREATE TABLE `tbl_law_firm` (
`firm_id` int(11) NOT NULL,
`firm_name` varchar(100) NOT NULL,
`complete_address` varchar(100) NOT NULL,
`contact_info` varchar(50) NOT NULL,
`email_address` varchar(50) NOT NULL,
`website` varchar(100) NOT NULL,
`facebook_page` varchar(100) NOT NULL,
`history` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

tbl_attorney – this table will store the personal information of the attorneys registered in the system and it has 14 fields.

• attorney_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
• last_name – the last name of the attorney
• first_name – the first name of the attorney
• middle_name – the middle name of the attorney
• gender – the attorney’s gender
• complete_address – the complete address of the attorney
• contact_details – the contact details of the attorney preferably mobile number.
• fax – image document of the attorney
• profile_picture – this is used to attached a profile image for the attorney
• education – educational background of the attorney
• professional_experience – professional experience of the attorney in the field of law
• username – the preferred username of the attorney combined with the username to login to the system
• password – the desired password of the attorney for his or her account
• account_status – active or inactive

Create SQL Statement – the statement below is used to create the tbl_attorney, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.

CREATE TABLE `tbl_attorney` (
`attorney_id` int(11) NOT NULL,
`last_name` varchar(30) NOT NULL,
`first_name` varchar(30) NOT NULL,
`middle_name` varchar(30) NOT NULL,
`gender` int(1) NOT NULL,
`complete_address` varchar(150) NOT NULL,
`contact_details` varchar(50) NOT NULL,
`fax` varchar(15) NOT NULL,
`profile_picture` text NOT NULL,
`education` text NOT NULL,
`professional_experience` text NOT NULL,
`username` varchar(30) NOT NULL,
`password` text NOT NULL,
`account_status` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

tbl_attorney_firm – the details of the attorney’s firm are stored in this table and it has three columns.

• record_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
• attorney_id – this is a foreign key that points out to the attorney
• firm_id – this is a foreign key that points out to the firm

Create SQL Statement – the statement below is used to create the tbl_attorney_firm, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.

CREATE TABLE `tbl_attorney_firm` (
`record_id` int(11) NOT NULL,
`attorney_id` int(11) NOT NULL,
`firm_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

tbl_firm_services -this table will store the information of the services offered by the firm. The said table contains six columns or field.

• service_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
• service_name – the name of the service
• description – information about a particular service
• firm_id – this is a foreign key that points out to the firm
• attorney_id – this is a foreign key that points out to the attorney
• rate – rate of payment for the service

Create SQL Statement – the statement below is used to create the tbl_firm_services, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.

CREATE TABLE `tbl_firm_services` (
`service_id` int(11) NOT NULL,
`service_name` varchar(30) NOT NULL,
`description` varchar(100) NOT NULL,
`firm_id` int(11) NOT NULL,
`attorney_id` int(11) NOT NULL,
`rate` float NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

tbl_client – this table will store the information of the clients in the system. Client table contains ten columns.

• client_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
• client_lastname – the client’s last name
• client_firstname – the client’s first name
• client_middlename – the client’s middle name
• contact – the contact number of the client preferably mobile number
• email_address – the email address of the client
• valid_id – the client’s valid ID
• username – the user of the client used to login to the system
• password – the password of the client used to login to the system
• account_status – active or inactive

Create SQL Statement – the statement below is used to create the tbl_client, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.

CREATE TABLE `tbl_client` (
`client_id` int(11) NOT NULL,
`client_lastname` varchar(30) NOT NULL,
`client_firstname` varchar(30) NOT NULL,
`client_middlename` varchar(30) NOT NULL,
`contact` varchar(15) NOT NULL,
`email_address` varchar(50) NOT NULL,
`valid_id` text NOT NULL,
`username` varchar(30) NOT NULL,
`password` text NOT NULL,
`account_status` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

tbl_appointment – the details of appointment of the clients are stored in this table and it has eight fields.

• appointment_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
• client_id – this Is a foreign key that points out to the client
• firm_id – this is a foreign key that points out to the firm
• attorney_id – this is a foreign key that points out to the attorney
• service_id – this is a foreign key that points out to the service
• reference_number – the unique reference number for the appointment
• remarks – additional information about the appointment
• status – pending, approved, cancelled, completed

Create SQL Statement – the statement below is used to create the tbl_appointment, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.

CREATE TABLE `tbl_appoinment` (
`appointment_id` int(11) NOT NULL,
`client_id` int(11) NOT NULL,
`firm_id` int(11) NOT NULL,
`attorney_id` int(11) NOT NULL,
`service_id` int(11) NOT NULL,
`reference_number` varchar(15) NOT NULL,
`remarks` varchar(50) NOT NULL,
`status` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

tbl_feedback – this table will store the feedback of the client about the services rendered by the firm. The feedback table has five database columns.

• feedback_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
• client_id – this is a foreign key that points out to the client
• message – message or the feedback of the client
• rate – 1 star to 5 star
• status – published, unpublished

Create SQL Statement – the statement below is used to create the tbl_feedback, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.

CREATE TABLE `tbl_feedback` (
`feedback_id` int(11) NOT NULL,
`client_id` int(11) NOT NULL,
`message` varchar(100) NOT NULL,
`rate` int(1) NOT NULL,
`status` int(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

tbl_bad_words – the bad words collected in the feedback are stored in this table and it contains two fields.

• word_id – primary key of the table. It is set usually to auto_increment (the database will automatically give this column a value starting from 1).
• bad_word – the bad word

Create SQL Statement – the statement below is used to create the tbl_bad_words, copy the sql statement and paste it in the sql manager/tab of your phpmyadmin.

CREATE TABLE `tbl_badwords` (
`word_id` int(11) NOT NULL,
`bad_word` varchar(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

FREE DOWNLOAD SQL FILE

Summary

The Law Office Database project was undertaken with the objective of developing a centralized database for a law office. The approach taken was to first gather requirements from the users of the database, which included the lawyers and staff in the office. Based on these requirements, a prototype of the database was created. This prototype was then used to create the actual database, which was designed to be user-friendly and efficient.

Readers are also interested in:

Law Office Management Information System in Bootstrap and PHP Script

IPO Model Conceptual Framework of Law Office Management Information System

85 Best Management System Project Ideas

You may visit our Facebook page for more information, inquiries, and comments. Please subscribe also to our YouTube Channel to receive free capstone projects resources and computer programming tutorials.

Hire our team to do the project.