DBMS Theoryknowledge~30 mins

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

Choose your learning style10 modes available

Learn Why Deep Visual Practice Challenge Project Recall Time

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.

Progress0 / 4 steps

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

Hint

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

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

Hint

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

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

Hint

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

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

Hint

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

Practice

(1/5)

1. Which type of database stores data in tables and uses SQL for queries?

easy

A. Object-oriented database

B. NoSQL database

C. Graph database

D. Relational database

Recommended

Ready to prove it?

Pass the test and this pattern moves unknown strong while earning +1 Grip toward your certificate.

10 questions~5 mineasy hard

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

Practice

Solution

Step 1: Understand database types

Step 2: Identify query language

Final Answer:

Quick Check:

Solution

Step 1: Recall NoSQL database features

Step 2: Eliminate incorrect options

Final Answer:

Quick Check:

Solution

Step 1: Analyze data storage style

Step 2: Match to database type

Final Answer:

Quick Check:

Solution

Step 1: Understand NoSQL query methods

Step 2: Identify the error

Final Answer:

Quick Check:

Solution

Step 1: Analyze data needs

Step 2: Choose suitable combination

Final Answer:

Quick Check:

Ready to prove it?