can anyone explain me abt database design ?

Sorry, no one can . You need to read books for the purpose and understand the job at hand.

In few words Databased Design is the process of producting a detailed data model or a database. The process of doing database design generally consists of number of steps which will be carried out by the database designer, who ususlly must:
- determine the relatioships between the different data elements
- superimpose a logical sturctureupon the data on the basis of these relationships.

Hope it will help you somehow, but indeed you mau easely google this issue.

Best of luck!
Oz.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.