ENTITY RELATIONSHIP DIAGRAM (ERD) TUTORIAL [TAGALOG] 2021 | ER DIAGRAM | ERD FOR DBMS

ENTITY RELATIONSHIP DIAGRAM (ERD) TUTORIAL [TAGALOG] 2021 | ER DIAGRAM | ERD FOR DBMS This video explains what is the ERD or Entity Relationship Diagram, what are the symbols and its functions and last is understanding its purpose. This ER Diagram or ERD or Entity Relationship Diagram can be use on your DBMS or Database Management Systems or Capstone Projects or any Project based research. If you like this video please don't forget to like, comment and subscribe for more educational videos. Help us reach 15,000 Subscribers! *************************************************** Please Follow Us On: YouTube ► https://bit.ly/2YdWUxU​​​​​​​​​​​​​​​ Facebook ► https://www.facebook.com/itsourcecode Website ► https://itsourcecode.com/​​​​​​​​​​​​​​​ Increase ad revenue 50-250% with Ezoic - https://bit.ly/2OIIPpD Join this channel to get access to perks: https://www.youtube.com/channel/UCg1aQxi_nEhods87BHYQTkw/join *************************************************** So first to consider, bago tayo bumuo ng ERD ay kailangang natapos mona ang Use case at Dataflow diagrams dahil essential ang mga ito sa pagbuo ng iyong ERD Bakit uunahin muna ang usecase at ang dataflow? Kilakailangan mo munang matapos ang DFD at Use Case Diagrams para magkaroon ka ng ideas sa pagbuo ng iyong ER Diagram. At para malaman mo ang mga data inputs na gagamitin at e sostore sa iyong database. Dahil ang ERD or Entity relationship diagram ay ang magsislbing blueprint ng iyong database o back end ng iyong system. OWkay? So, to start with, ang una mo munang gagawin ay ang use case diagram para malaman mo ang mga main process at ang subprocesses ng iyong capstone project. At pag nalaman mona ang mga processes nito, you will know what are the possible inputs na kakailanganin ng Capstone project mo. And that thoughts will help you in doing your dataflow diagram. Now, ano ang connection ng Use case diagram at dataflow diagram sa ERD? Well, Malaki ang connection ng mga ito sa isat isa, dahil kailangan maging synchronize ang illustrations at explanation sa tatlong diagrams. Dahil ang use case ay nag eemphasize ng mga processes, ang dfd naman ay nag eeexplain sa flow ng data at ang erd ay lalagyan ng data mismo. So kung nagkamali ka sa use case at dfd, o kung inuna moa ng erd kaysa sa dalawa, kw rin ang mahihirapan sap ag sync ng tatlong diagram. Pro kung nagawa mo sila step by step, magiging smooth ang pag gawa mo ng ERD. So pano gawin ang ERD? Simple lang, pag nakuha mona ang mga ideas sa use case at dfd, magiging knowledgeable ka na sa mga data na gagamitin sa system at ang mga data na ito ay gagawan mo lang ng lalagyan. For example, kung ang mga data na kakailangan sa system ay basic information ng isang tao, then you have to create a database for it. Gagawa ka ng table for BASIC INFORMATION which is also known as entity, then you will add the attributes depende sa kung ano ka rami ang data na kakailanganin sa basic information. Maaaring maging attribues nito ay Name, Birthdate, Address, Age, at kung ano pa na basic info. Now, matapos mong gawan ng table at attributes ang mga needed data sa iyong system, kailangan mo naman lagyan ng indication lines ang bawat entity or tables para maka create ka na ng entity relationship. (yehey) Ang relationship ng mga entities ay maaring 1 entity is connected to another entity, pwede ding 1 entity is to many at many entties to 1.. nakadepende pa rin po ang relationship sa na state mong process sa use case at data flow sa dfd. So ganun lng kadali gawin si ERD bes. Don’t worry.. And as bunos tips ko para sayo, before you start in doing your diagrams, always ask for ideas specially sa mga targeted user ng iyong capstone project. Para ma guide ka nila about sa magiging process at mga data na kakailanganin sa iyong project, So importante pa din na lagi kag nag iinquire. *************************************************** For more video like ENTITY RELATIONSHIP DIAGRAM (ERD) TUTORIAL [TAGALOG] 2021 | ER DIAGRAM | ERD FOR DBMS visit our Tips and Tricks Playlist: https://bit.ly/3AuzGEg *************************************************** Music Credits:? Song: MBB - Feel Good (Vlog No Copyright Music) Music provided by Vlog No Copyright Music. Video Link: https://youtu.be/wIDKJeLXO5Q Follow Ikson: https://youtube.com/ikson https://soundcloud.com/ikson https://www.instagram.com/iksonofficial https://www.facebook.com/iksonmusic https://twitter.com/Iksonofficial https://ikson.bandcamp.com More Ikson Music Stream on: Spotify - https://lnk.iksonmusic.com/spotify Apple Music - https://lnk.iksonmusic.com/applemusic Deezer - https://lnk.iksonmusic.com/deezer Tidal - https://lnk.iksonmusic.com/tidal Soundcloud - https://soundcloud.com/ikson #ERD #ERDiagram #EntityRelationshipDiagram