The following is a table of a relational database which recorded information of student consisting of name, sex, race, packing fines, dorm, student ID number, and credit card number.

Name	Sex	Race	Fines	Dorm	SID	Credit Card
Adams	M	C	45.	Holmes	501283	4501234512982045
Fein	F	B	0	West	501236	4502238938173928
· · ·	· · ·	· ·	· · ·	· · ·	· · ·	· ··

For security reason, we want to partially encrypt the table. Namely, the attributes name, packing fines, ID and credit card number should be encrypted. The other attributes are not encrypted to keep general access efficiency.

Now you are asked to design how to create a new table from the original table. For the design, you need to consider

• The new table can still provide partial statistical information.
• Use less time for encryption and decryption if possible.
• Easy to implement by software and hardware.
• Still support most SQL requests.