Required guidance to design a database in MySQL

[iskhan]

Dear Experts

 

I need your guidance to design a database in MySQL:

SCENARIO

A big collection of official letters 90% are in the form of Hard Copy and 10% are in the form of MS-Word .doc file. Every day approx. 50 letters increases with the same ratio(i.e.90-10). Every letter have unique alphanumeric Ref. Code. Any time copy of letter is required for reference.

Letter Search By

1)Ref. Code (i.e. PCSG/2354/97/PER)

2)Subject

3)Sender/Receiver

4)Date

[ignace]

CREATE TABLE do (

  your INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,

  own VARCHAR(32) CHARACTER SET utf8 NOT NULL,

  homework TEXT CHARACTER SET utf8 NOT NULL

) ENGINE = MyISAM;