database - Creating a server and client program like online reservation program using socket API in C -

i need in figuring out design principle program. donot expect progamming code rather design , architecture theory.

i programming in c language using socket api. want know how sql database, socket api, other language, etc needed complete it. if possible without lot of hassle, want upload on webserver. appreciate help.

thanks.

make small library has wrapper functions socket api, library sql database access, , else might use. these libraries should error handling, among other thing might do. emit diagnostics , decide whether continue or abort program, , it. build , test these libraries.

then write program, is, reading , writing database , network , else might add. link against libraries when building.

this program, understand question, going listen on port incoming connections, fork thread (or process), , keep listening. child process decide read or write , whether network or database.

i hope simple enough homework started.