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
