help Database design & Implementation

[maduprasad]

kauuru hari me gena hondata dannawanam mata podi help ekak denawada

 

[argan]

Ms SQL nam tikak hodata puluwan.....Oracle nam tikai puluwan....Mokakda wenna oni sahodaraya....?

 

[maduprasad]

Modelling

Ms SQL nam tikak hodata puluwan.....Oracle nam tikai puluwan....Mokakda wenna oni sahodaraya....?

mata dana ganna ona Conceptual Modelling and Logical modelling gana. Thanks for asking. but i think oya me gena nam echchara danne nethiwa athi.

 

[prageeth119lk]

bump ekak thamyi dhenna wenne

 

[argan]

mata dana ganna ona Conceptual Modelling and Logical modelling gana. Thanks for asking. but i think oya me gena nam echchara danne nethiwa athi.

Conceptual Modelling & Logical Database Design kiyanne Database designing process eke steps.....

Conceptual Modelling :- meken Wenne Requirements gather karata passe a requirements walata anuwa ER Diagram eka design karana eka....a kiyanne ape DB eka design karanna issella a database eke hadenna oni tables monada relationships monada kiyala idea1k thiyenna oni ne.....ethakota thamai apita wade lesi wenne....eka nisa mulinma concept eka gana idea 1k gannawa ERD eka andala.....Mata mathaka widiyata oka thamai Conceptual Modelling kiyanne.

 

[argan]

Logical Database Design - Mekedi wenne api kalin andapu ERD ekata anuwa Relational schema eka design karana eka....ERD eke api adunaganne Entities & Relationships & cardinalities witharai ne....mekedi apita Primary key & foreign key map wena widiya adunaganna puluwan ethakota ape DB eka hadanna ithtamat lesiyi....api project karankota Mulin adapu ER eka keepa sarayakma wenas karanna una....a mokada mehema theory walata wada karanna amarui practicaly karanna giyama......

Next step eke meken adina schema eka refine karana Normalization use karala(if Relational DB only) eta passe thamai ape Physical DB design eka karanne.....

1st year ekedi nam meeta wadiya mathaka thibba me gana....dan nadda 3rd year yanakota poddak memory lose wenawa ayi thawa thawa ewa watenawane....Onna mathaka tharamin kiwwa....anith ayath kiyai....meke innawa SLIIT parapurakma.....

 

[maduprasad]

PDF

Thanks machan
mokuth pdf ekak nedda mata kiyawanna