# Introduction In this project, you will learn how to create a student information management system using MySQL. This system includes two tables: `student_info` and `student_score`, with a foreign key relationship between them. ## ð Preview ``` MySQL [studentSys]> DESC student_info; +-------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------+-------------+------+-----+---------+----------------+ | Id | int | NO | PRI | NULL | auto_increment | | name | varchar(10) | YES | | NULL | | +-------+-------------+------+-----+---------+----------------+ 2 rows in set (0.002 sec) MySQL [studentSys]> DESC student_score; +-------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------+------------+------+-----+---------+-------+ | Id | int | NO | PRI | NULL | | | score | varchar(4) | YES | | NULL | | | Sid | int | YES | MUL | NULL | | +-------+------------+------+-----+---------+-------+ 3 rows in set (0.001 sec) ``` ## ðŊ Tasks In this project, you will learn: - How to start the MySQL server and log into the MySQL terminal - How to create a database and tables using SQL statements - How to establish a foreign key relationship between two tables ## ð Achievements After completing this project, you will be able to: - Understand the concept of a relational database and how to create and manage tables - Implement a foreign key constraint to ensure data integrity between related tables - Apply your knowledge of SQL to build a simple student information management system
Click the virtual machine below to start practicing