NUS Hackers Wiki
NUS Hackers Wiki
  • NUS Hackers Wiki
  • Hackerschool
    • Virtual Machines and Linux
    • Beginners' Guide to the Terminal
      • Introduction to the Terminal
      • Modern Shell Tools
      • Shell Scripting
      • Real World Scripting
      • Resources
    • Self-Hosting: Three Easy Pieces
      • 1. Setting up your server
      • 2. Running Services
      • 3. Monitoring your server
    • Vim
    • Introduction to Zig
      • Language Basics
      • Error Handling
      • Memory Management
      • Working with C
      • Exploring comptime
    • CI/CD with Github Actions
      • Background
      • Basics of Github Actions
        • Target workflow
        • Running unit tests
        • Linting code
        • Deploying to Github Pages
      • Advanced use cases
        • Pollers
        • Github script
        • Executing third-party scripts
        • Reusable workflows
      • Cookbook
    • Lightning Git
      • Git Concepts
      • Getting Started with Git
      • Making your first commit
      • Branching
      • Merge Conflicts
      • Integrating remote repositories
      • Collaborative Workflows
      • Commit Manipulation and Reflog
      • Interactive rebasing
      • filter-repo
  • Orbital
    • JavaScript
      • Browser Developer Tools
      • Getting Started
      • Datatypes
      • Operators and Operations
      • Loops and Conditions
      • Functions
      • Strings
      • Arrays
      • HTML
        • Getting Started
        • Tag Attributes
        • HTML Forms
        • Browser Inspector
      • CSS
        • Selectors
        • Colors in CSS
        • Measurements in CSS
        • The Box Model
        • Adding Styles - Part 1
        • Adding Styles - Part 2
      • Working with the DOM
        • Querying the DOM - Selectors
        • Querying the DOM - Element Attributes
        • Querying the DOM - Element Styles
        • Events with JS and HTML
        • Exercise: Click Counter
        • Editing the DOM
        • Fetch Requests
        • Exercise: The NUSMods API
    • React
      • Setup
      • State
    • React Native
      • Setup
      • Intro to JSX
      • Basic Syntax
      • Handling UI
      • Props
      • State Management
    • Git
      • Setup
      • Command Glossary
      • Fundamental Concepts
        • Getting Started
        • Integrating Remote Repositories
        • Branching
        • Merge Conflicts
      • Collaborative Workflows
        • Fork and PR Workflow
        • Branch and PR Workflow
      • Advanced Concepts
        • Ignoring Files
        • Commit Message Conventions
        • Github Collaborators
        • CI/CD with Github Actions
        • Advanced Git Commands
      • FAQ
    • Telegram Bot
      • Creating a TeleBot
      • API Calls
      • Telebot Basics
      • Integrating API's
    • Relational Database
      • Database Overview
      • Database Design
      • Entity Relationship Diagram
      • SQL Basics & PostgreSQL
    • TypeScript
      • Types and Interfaces
      • Utility Types
      • Typing Component Props, Events, and Hooks
      • Why You Should Avoid Using any (and What to Do Instead)
      • TypeScript Tricks You’ll Use All the Time in React
Powered by GitBook
On this page
  • Database (DB)
  • Database Management System (DBMS)
  • Relational Database
  • Non-Relational Database
  • In Case You Are Wondering...
Edit on GitHub
Export as PDF
  1. Orbital
  2. Relational Database

Database Overview

Database (DB)

A database is a structured collection of data that is organized and stored in a way that allows for efficient retrieval, management, and manipulation of the data.

Database Management System (DBMS)

A Database Management System (DBMS) is a software that provides an interface for managing databases, either with direct user actions via its CLI/GUI, or with standardized interface used by other parts of the application.

Core functionalities of DBMS include ensuring data integrity, security, and concurrency control.

Relational Database

A relational database is a type of database that organizes data into tables, consisting of rows and columns. Structured Query Language (SQL) is used for querying and manipulating data.

It follows the relational model, which defines relationships between tables using keys.

Non-Relational Database

A non-relational database, also known as NoSQL (Not Only SQL) provides flexible schema.

Data is arranged in various formats, such as key-value pairs, documents, graphs, or wide-column stores. Non-relational databases are designed to handle large amounts of unstructured or semi-structured data efficiently.

In Case You Are Wondering...

Each RDBMS speaks a different SQL.

They are just dialects of SQL with slightly different syntax and extensions. They all adhere to the ANSI SQL standard (commonly referred but not accurate) so that under most cases, same SQL statements can be used across all RDBMS without too much modification.

Non-relational DBMS are typically very different in the way they are store data, as you see from the above examples. Hence, there isn’t a standard for NoSQL.

PreviousRelational DatabaseNextDatabase Design

Last updated 12 months ago