While developing database driven applications using some ORM framework, some people prefer Object first approach and others follow DB first approach. I prefer DB first approach.
So, let us start listing down all the domain entities in our JCart application domain.
- Product
- Category
- Customer
- Order
- OrderItem
- Cart
- Address
- User
- Role
- Permission
Let us create the database tables as follows:
Though we identified Cart as a domain entity, we are not creating the table for holding the Cart details. We are going to take the simple approach of storing the active cart details in HttpSession only. But in real applications it is strongly recommended to store them in some persistent storage like database.
Hi Siva
ER-diagram not getting properly.could you please check on this and
you have done great job by implementing Jcart applications.
Thank you so much.
Hi MadhavaRao,
I have updated the post to correct ER Image to show up.
What tool did you use to create this ER Diagram please?
MySQL Workbench.
Could you provide a simple sql script that create the above tables?
Could you please simple sql
Hi Siva,
I have one doubt. If we use spring data jpa, when we create entity object is enough for creating the table in DB also. Correct me if I am wrong.
thanks,
Surya.
we need to use spring.jpa.hibernate.ddl-auto in appliaction.properties
sorry, I got solution in next tutoarial
Hi Siva,
U answered the Madhav Rao that I have updated the ER diagram but you posted “JCart: Domain Modelling and Database Designing” on December,1/2015 and you answered on December,16/17/2015. So the current diagram is updated or not?