Phân tích thiết kế hệ thống quản lý sinh viên - Aptech 

Phan tich thuc the se su dung trong du an:
- Giang vien -> Teacher
	- ten -> nvarchar(50)
	- id -> int -> primary key
	- sdt -> nvarchar(20) -> unique
	- email -> nvarchar(150) -> unique
	- address -> nvarchar(200)
	- gioi tinh -> nvarchar(20)
- Nhan vien -> Staff
	- ten -> nvarchar(50)
	- id -> int -> primary key
	- sdt -> nvarchar(50)
	- email -> nvarchar(150)
	- address -> nvarchar(200)
	- gioi tinh -> nvarchar(20)
- Sinh vien -> Student
	- ten -> nvarchar(50)
	- id -> int -> primary key
	- rollno -> nvarchar(20)
	- sdt -> nvarchar(20)
	- email -> nvarchar(150)
	- address -> nvarchar(200)
	- gioi tinh -> nvarchar(20)
	- ten khoa hoc -> nvarchar(50)
- Lop hoc -> Class
	- ten lop -> nvarchar(50)
	- id lop -> int -> primary key
- Quan ly lop hoc -> StudentClass
	- id sinh vien -> int
	- id lop -> int
	-> primary key (student_id, class_id)
- Ky hoc -> Semester
	- ten ky -> nvarchar(20)
	- id: int  -> primary key
- Moc hoc -> Subject
	- ten mon hoc -> nvarchar(20)
	- ma mon -> int -> primary key
	- so buoi hoc -> float
- Diem
	- diem ly thuyet -> float
	- diem thuc hanh -> float
	- ten mon hoc: subject_id -> int
	- sinh vien: student_id -> int
	- primary key (subject_id, student_id)
- Lich Hoc
	- id: int -> primary key
	- subject_id
	- teacher_id
	- staff_id
	- class_id
	- ngay bat dau
	- ngay ket thuc
	1, 1, 1, 1, 1, A, B
- Booking
	- id: int -> primary
	- id lich hoc
	- start date: datetime
	- end date: datetime
	- status
	1, 1, A1, B1, 1
	2, 1, A2, B2, 1
	3, 1, A3, B3, 0
- Diem danh
	- id: int -> primary
	- student_id -> int
	- booking_id -> ??
	- status: A, PA, P
	- note

https://dbdiagram.io/d/63650966c9abfc611170537d