Student Information Management System 1 (Database design chapter)

1. System Overview

This is to be a student management system, after learning the database, hope that through this system to apply the knowledge to the actual project. To strengthen their proficiency level. Development background: With database, C # related knowledge reserves, master the basic HTML knowledge.
Purpose: for practice only. Through a language, the database is presented.

2. Functional Requirements Analysis

System Concept Layer Design: Function use case diagram as follows

1. Login function: For identity authentication

2. Data manipulation: Information query, data enhancement and deletion.
A) in the data operation, the administrator has all the operational privileges. Students have the ability to select classes and view them. And you can modify your personal information.
3.UI Design

3. Database design

E-r Figure 1

A total of three tables, here simply imitate the textbook data.
First, the Student table (Tb_student) is designed as follows

Column Name	Data type	is empty (default is not)	Primary KEY (default = NO)
Student_name	Nvarchar (15)
Student_num	Int	Whether	Is
Student_password	Nvarchar (30)
Student_sex	Nvarchar (5)
Student_age	smallint
Student_dept	Nvarchar (20)

Tb_course

Column Name	Data type	is empty	Primary key
Course_num	Int	Whether	Is
Course_name	Nvarchar (30)
Course_credit	smallint
Course_semester	smallint

Tb_student_course

Column Name	Data type	is empty	Primary key
sc_id	Int	Whether	Is
Student_num	Int		FOREIGN key
Course_num	Int		FOREIGN key
Grade	smallint

Tb_admin

Column Name	Data type	is empty	Primary key
admin_id	smallint	Whether	Is
Admin_name	Nvarchar (20)
Admin_password	Nvarchar (40)
Remark	Nvarcahr (10)

function code See next article

Student Information Management System 1 (Database design chapter)