Hi sizal 🙂
The logical / physical design is about how you take the data you need to store and create a set of logical entities (customer, order), once you know that you can create a physical design with a list of tables (customer, customer_type, customer_address, order, order_item).
You can create your logical and physical design on a piece of paper with a pencil.
Once you have done that you can use any tool you like to create the actual database - SSMS has some ui's to do it or you can write T-SQL to do it.
I haven't used any in a long time but there used to be modelling tools that will let you create a logical and physical model and that would create the T-SQL to create the actual database.
I hope this helps (I know it was a while ago) 🙂