Personnel Management System Database Setup

Introduction

In this project, you will learn how to create a personnel management system database using MySQL. The database will store information about employees, their work units, and residential details.

👀 Preview

MariaDB [companySys]> DESC company;
+--------------+-------------+------+-----+---------+-------+
| Field        | Type        | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| company_name | varchar(50) | NO   | PRI | NULL    |       |
| city         | varchar(10) | YES  |     | NULL    |       |
+--------------+-------------+------+-----+---------+-------+
2 rows in set (0.001 sec)

🎯 Tasks

In this project, you will learn:

• How to access MySQL using the sudo command
• How to create a database called companySys
• How to create three tables: company, work, and employ
• How to set appropriate primary key and foreign key constraints for each table
• How to insert data into the tables

🏆 Achievements

After completing this project, you will be able to:

• Understand the basics of database creation and management
• Implement CRUD (Create, Read, Update, Delete) operations on a relational database
• Establish relationships between tables using primary and foreign keys
• Manage and manipulate data in a personnel management system database