Hi,
i have some beginner knowledge in databases and i am looking for a project that i could work on in order to develope skills in RDBMS (using Microsoft SQL Server)
ideally it would be a project where i create my own database design and do the implimentation using SQL Server ??
thanks in advance.
The classic TODO app can always be used.
You don’t need a fancy UI, just whatever your used to. The overall concept of a TODO app can also be scaled up or down depending on what kinda stuff you want to learn. The simplest is just having users each have todos to their account. You can add more features like labels, searching, filtering, sharing, etc if you want to increase the overall scope.
the TODO app might not be fancy, or cool, but it is pretty much what most other projects can boil down to without much trouble 
Good luck, keep building and keep learning
what are the requirements for this type of app ??
A TODO app usually has the core requirement that a user can keep a list of items (IE TODOs), where they can create, read, update, delete each one. (CRUD)
An example would be:
Among a bunch of others.
As I mentioned earlier, that you can add/remove features and parts of your stack to increase/decrease the scope of the project to what skills you want to show off
after doing some research i came across UML, so i try to know more about the topic and i am looking for a book to begin , i aim to learn how to use data flow diagrams, sequence diagrams, scenarios to conceptualize functional requirement ?
I wouldn’t get too hung up the entire software engineering lingo.
First thing is usually to consider the requirements of what you want to build. If your building something on your own, your the source of the requirements, and the person that will impliment them. First things first you gotta determine what you want to build.
From there you can go jump into data flow diagrams, sequence diagrams, UML, or whatever to help you break down those requirements to something you can take and go build with. Generally if your the only person working, you wont really need much of these unless your project is complex, and you need to write stuff down to keep yourself sane.
Don’t go backwards and start building diagrams/charts without understanding what you actually want to accomplish. Otherwise its very easy to just add feature after feature and make things confusing/complex/longer. This will also impact how much work you have to accomplish, so you really don’t want to give yourself more work haha.
Good luck keep building 
You don’t need a fancy UI, just whatever your used to. The overall concept of a TODO app can also be scaled up or down depending on what kinda stuff you want to learn.
speaking of the UI is there any way to connect the UI to the database without using an ORM ??