Database: CapstoneManagement
1. User table: tblUsers
Field Name
Type
Validation
userID
varchar(50) (Primary Key)
Not null
fullName
nvarchar(500)
Not null
roleID
char(2)
Not null
password varchar(50)
Not null
2. Capstone table: tblCapstones
2 of 2 Paper No: 7
+ 122%
Zoom
Close