Hi Sasidhar Reddy,

Given your request/requirements, this is the best I can come up with: https://bfy.tw/L7J7.

Please read Eduardo's guide to asking questions, and then follow its recommendations, I'm sure it will make your interactions here much more productive.

Hi Sasidhar,

Design database in outsystems is same as followed in any other DB nothing special here  .Following Needs to be taken into consideration:

1.No of entity required (Table)

2.Data type and length of the attributes (Columns)

3.Defining relation between Entities. ( Foreign Key, Unique Key, etc)

4.If there are any values that are going to be fixed/same through out your projects then create Static Entity for that.

Please go through the below links for more information.

https://success.outsystems.com/Documentation/10/Developing_an_Application/Use_Data/Data_Modeling

https://success.outsystems.com/Documentation/11/Reference/OutSystems_Language/Data/Modeling_Data

Hope this will be helpful to you.

Dear Sasidhar,

Hope you have completed the Movie Project which have provided by outsystems.

You can create the database using tables in service studio -> Got to data layer -> Database then right click then add entity then you can create entity attributes. 

Also please go through the attached outsystem document  for reference. 

https://www.outsystems.com/learn/lesson/874/modeling-data/

Hope i will help you.

Regards

Gangadhara