This should get your started on the fundamental of database design:
Design the tables for a new database[
^]
The knowledge is generic and applicable to any relational database.
However, the start point is still the requirement gathering and analysis. Among other things, you have to ascertain : What kind of data are to be captured, how are they used, who use them etc.