Types of databases (relational, NoSQL, object-oriented) in DBMS Theory - Mini Project: Build & Apply

Understanding Types of Databases

📖 Scenario: You are working as a junior data assistant in a company that uses different types of databases. Your manager wants you to create simple examples of three common types of databases: relational, NoSQL, and object-oriented. This will help the team understand how data is stored differently in each type.

🎯 Goal: Create three small database examples: one relational database table, one NoSQL document collection, and one object-oriented database class with objects. This will show how data is organized in each type.

📋 What You'll Learn

Create a relational database table named Employees with columns EmployeeID, Name, and Department.

Create a NoSQL collection named Products with at least two documents containing ProductID, Name, and Price.

Create an object-oriented database example with a class named Car having attributes make, model, and year, and create two objects.

💡 Why This Matters

🌍 Real World

Companies use different types of databases depending on their data needs. Understanding these types helps in choosing the right database for a project.

💼 Career

Database administrators and developers must know how to work with relational, NoSQL, and object-oriented databases to manage and organize data effectively.

1

Create a relational database table

Write SQL code to create a table called Employees with columns EmployeeID (integer), Name (text), and Department (text).

DBMS Theory

-- Your SQL code to create the Employees table here

Need a hint?

Use CREATE TABLE followed by the table name and define each column with its data type inside parentheses.

2

Create a NoSQL collection with documents

Write code to create a NoSQL collection named Products with two documents. Each document should have ProductID, Name, and Price fields. Use JSON format.

DBMS Theory

-- Your JSON code to create Products collection with two documents here

Need a hint?

Use an array of JSON objects to represent the collection and documents.

3

Create an object-oriented database example

Write code to define a class named Car with attributes make, model, and year. Then create two objects of this class with example values.

DBMS Theory

-- Your code to define Car class and create two objects here

Need a hint?

Use a class with a constructor to define attributes, then create objects using new.

4

Complete the database examples

Add a comment at the end of the code summarizing the three types of databases: relational, NoSQL, and object-oriented.

DBMS Theory

CREATE TABLE Employees (
    EmployeeID INT,
    Name TEXT,
    Department TEXT
);

const Products = [
    { ProductID: 101, Name: "Laptop", Price: 1200 },
    { ProductID: 102, Name: "Smartphone", Price: 800 }
];

class Car {
    constructor(make, model, year) {
        this.make = make;
        this.model = model;
        this.year = year;
    }
}

const car1 = new Car("Toyota", "Corolla", 2020);
const car2 = new Car("Honda", "Civic", 2019);

// Your comment summarizing the database types here

Need a hint?

Add a comment starting with // that briefly explains each database type.