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

|60 : 00

Click the virtual machine below to start practicing