{"id":1123,"date":"2019-09-04T13:20:43","date_gmt":"2019-09-04T06:20:43","guid":{"rendered":"http:\/\/moenawar.web.id\/?p=1123"},"modified":"2019-09-04T14:49:54","modified_gmt":"2019-09-04T07:49:54","slug":"data-base-management-system","status":"publish","type":"post","link":"http:\/\/moenawar.web.id\/?p=1123","title":{"rendered":"Data Base Management System"},"content":{"rendered":"

A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.A DBMS makes it possible for end users to create, read, update and delete data in a database. The DBMS essentially serves as an interface between the database and end users or application programs, ensuring that data is consistently organized and remains easily accessible. <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
No<\/th>\nTopic<\/th>\nLink<\/th>\n<\/tr>\n<\/thead>\n
1<\/td>\nIntro to Database Management System<\/td>\nIntro to DBMS<\/a><\/td>\n<\/tr>\n
2<\/td>\nRelational and Relational Algebra<\/td>\nRelations and Relational Algebra<\/a><\/td>\n<\/tr>\n
3<\/td>\nERD (Entity Relationship Diagram)<\/td>\nER Modelling<\/a><\/td>\n<\/tr>\n
4<\/td>\nNormalization to 3NF\n<\/td>\nNormalisation to 3NF<\/a><\/td>\n<\/tr>\n
5<\/td>\nBCNF Normalization to 5NF<\/td>\nNormalisation to BCNF<\/a>
\nContoh Normalisasi Lengkap<\/a><\/td>\n<\/tr>\n
6<\/td>\nSQL Definition<\/td>\nSQL Data Definition<\/a><\/td>\n<\/tr>\n
7<\/td>\nMore SQL Definition<\/td>\nMore SQL Data Definition<\/a><\/td>\n<\/tr>\n
8<\/td>\nSQL Select<\/td>\nSQL Select<\/a><\/td>\n<\/tr>\n
9<\/td>\nMore SQL Select<\/td>\nMore SQL Select<\/a><\/td>\n<\/tr>\n
10<\/td>\nYet More SQL Select<\/td>\nYet More SQL Select<\/a><\/td>\n<\/tr>\n
11<\/td>\nMissing Information<\/td>\nMissing Information<\/a><\/td>\n<\/tr>\n
12<\/td>\nSQL View<\/td>\nSQL View<\/a><\/td>\n<\/tr>\n
13<\/td>\nTrigger + Store Procedure<\/td>\nStore Procedure<\/a><\/td>\n<\/tr>\n
14<\/td>\nReview and Case Studies<\/td>\n<\/td>\n<\/tr>\n
15<\/td>\nAssignment<\/td>\n<\/td>\n<\/tr>\n
<\/td>\n<\/td>\n<\/td>\n<\/tr>\n
17<\/td>\nLatihan MySQL<\/td>\nLatihan Praktikum SBD MySQL<\/a><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/p>\n","protected":false},"excerpt":{"rendered":"

A database management system (DBMS) is system software for creating and managing databases. The DBMS provides users and programmers with a systematic way to create, retrieve, update and manage data.A…<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0},"categories":[17],"tags":[51],"_links":{"self":[{"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/posts\/1123"}],"collection":[{"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1123"}],"version-history":[{"count":3,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/posts\/1123\/revisions"}],"predecessor-version":[{"id":1130,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=\/wp\/v2\/posts\/1123\/revisions\/1130"}],"wp:attachment":[{"href":"http:\/\/moenawar.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1123"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1123"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/moenawar.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1123"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}