The following is a table of a relational database which recorded information of student consisting of name,
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Related Book For
Posted Date: