Zoom
Kizspy.me
pass
Column Name
name
a.
Data Type
varchar(20)
varchar (100)
varchar(100)
Description
CCID to login Primary key [Not null]
Password to login [Not null]
Name of person [Not null]
Figure 1: Person table.
A "TrafficLaw" table with a structure as below:
Column Name
Data Type
id
int
Description
Primary key with auto-increment (IDENTITY(1,1))
name
varchar (100)
Name of the traffic law [Not null]
ccid
varchar (20)
Foreign key with Persson [Not null]
penalty
int
a punishment for traffic law.
date
varchar (10)
Penalty date
Figure 2: TrafficLaw table.
2. To demonstrate of functions, you need add some sample data into "Person" and "TrafficLaw" tables.[5 Points]
ccid く pass
✓
name
001234567
123456
Nguyen Van A
002345678
003456789
234567
345678
Tran Thi B
Le Van C
Figure 3: Samples for Person table.
id
✓
name
✓ ccid
✓ penalty
✓ date
V
1
Vuot den do
2
Khong doi mu bao hiem
001234567
002345678 500000
900000
2025-04-10
2025-04-12
3
Uong ruou bia khi lai xe
003456789 2500000
2025-04-13
4
Di sai lan duong
001234567 500000
2025-04-14
5
Khong bat den xe ban dem
003456789 150000
2025-04-15
6
Khong chap hanh hieu lenh CSGT
002345678 800000
2025-04-16
+100%
Close
