Now a days it's very difficult to keep the record. So I
got an idea to keep our records online.
In this project R-OnLineDiary a user can signup/login. After signup/login
user can make diary and add notes in that diary.
For security purpose no other user can see other user's
diary and notes.
Below is my first screen...
From here user can signup/login...

Image 1.
After login user
will redirect to MyAccount page. From here user can make new diary or can view
his/her all diary...

Image 2.
From here user can create a new diary...

Image 3.
After creating from here user can see all diary . After
clicking on diary title it will redirect to diary detail page...

Image 4.
From here user can add new note..

Image 5
User can see all note of diary...

Image 6.
Now I am going to explain my Data Base structure...
Table 1. USER_REGISTER
(To keep user record)

Image 7.
Table 2. USER_DIARY (To Keep User Diary Information)

Image 8.
Table 3. DIARY_RECORD (To
Keep Diary Note records)
Image 9
You can download code... I copied database file and
script file inside app_data folder.

Image 10.
To run the application you can make the changes
connection string in web.config file.

Image 11.