Overview On Database SQL, DBMS, Constraint

What is a Database?

[{"selector":"#anim-7316f1a3-3002-45b8-90d5-54547a5bac31 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-20.079787052487852%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] [{"selector":"#anim-feb4cf03-9cac-4ac9-960f-34c967270360","keyframes":{"transform":["rotate(-540deg) scale(0.1)","none"],"opacity":[0,1]},"delay":0,"duration":1000,"fill":"both","iterations":1}] [{"selector":"#anim-0d31bed8-e9d8-4325-b3dc-62f40d1ec405","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-d5aa70cb-d4ad-4888-8766-e57c025682bf","keyframes":{"transform":["translate3d(0px, 220.61191%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] A database is a place where we store data in the form of tables. Data means information that is very useful.

What Is SQL (Structured Query Language)

[{"selector":"#anim-e21d504d-b381-41f5-911d-b10c1935b98b","keyframes":{"transform":["rotate(-540deg) scale(0.1)","none"],"opacity":[0,1]},"delay":0,"duration":1000,"fill":"both","iterations":1}] [{"selector":"#anim-46441f4e-a904-4776-8b2e-1bd47fab3bf2","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-21f6b20d-bf8d-4297-a4b6-0fecadbaa621","keyframes":{"transform":["translate3d(0px, 383.79630%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-cf617984-8c61-4c3c-b8ad-9b7856387c0d [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-63.70833325369134%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] The SQL language to talk to a database or to access the database. Learn more

What Is DBMS?

[{"selector":"#anim-3314a703-2da8-46d6-b4a9-b2e0a95642e6","keyframes":{"transform":["rotate(-540deg) scale(0.1)","none"],"opacity":[0,1]},"delay":0,"duration":1000,"fill":"both","iterations":1}] [{"selector":"#anim-da65f387-a2b4-4a33-8735-f8cd5ce28a21","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-5ef7e5aa-11c4-4e27-bc57-e933696738b9","keyframes":{"transform":["translate3d(0px, 290.96303%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-aa68fb7d-2a41-43d2-9c3b-8f2ce6ff88af [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-17.032284568165114%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] DBMS – Stands for Database Management System It is a database sof tware that allows storing data in the form of tables.

What Is RDBMS

[{"selector":"#anim-3e4267c3-e328-4047-a559-7c3026acc740","keyframes":{"transform":["rotate(-540deg) scale(0.1)","none"],"opacity":[0,1]},"delay":0,"duration":1000,"fill":"both","iterations":1}] [{"selector":"#anim-9ebab1ba-ea41-45e5-9cf0-0cbfc96ff3ae","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c39e552b-f9c1-4649-8c94-f5486c820eae","keyframes":{"transform":["translate3d(0px, 290.96303%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-c0143625-20e6-49a2-ad8a-eb21d7bb47f2 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-28.9125408800946%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] It is also a database software that has the facility to handle more data volume, better performance, enhanced security features, etc if compared to the DBMS.

What Are Constraints

[{"selector":"#anim-014ff9f3-41ef-4059-9cef-5966ceb88f14","keyframes":{"transform":["rotate(-540deg) scale(0.1)","none"],"opacity":[0,1]},"delay":0,"duration":1000,"fill":"both","iterations":1}] [{"selector":"#anim-eddf6a53-80bd-4cf1-ba07-950916e6d6b4","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a702124b-297b-4ee5-a067-33a9440100c3","keyframes":{"transform":["translate3d(0px, 382.84605%, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.2, 0.6, 0.0, 1)","fill":"both"}] [{"selector":"#anim-0c6a7bdf-a109-4bcc-b46d-aaa69e19f363 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(0.014810123232089425%, 0, 0) translate(25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] A constraint is a condition that restricts the invalid data inside the table. A constraint can provide for columns of a table.