measures to be taken for preparing Database Design

measures to be taken for preparing Database Design

  

Hi Friends,

Can Someone help me to Design Database,Please provide all the measures to be considered for designing Database from Scatch.

Appreciate your help in Advance.

Thanks

Sasidhar

Hi Sasidhar Reddy,

Given your request/requirements, this is the best I can come up with: http://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.

Solution

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.

Solution



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

Gangadhara wrote:



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

*Hope it will help you..