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
, andemploy
- 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