A Relational Database Management System (RDBMS) is software designed to store, manage, and retrieve data in a structured format using tables.
student
id | Name | Age | Gender | Class |
---|---|---|---|---|
1 | John | 18 | Male | 10 |
2 | Jane | 18 | Female | 10 |
3 | Mary | 19 | Female | 10 |
4 | David | 20 | Male | 10 |
student_marks
student_id | subject | marks |
---|---|---|
1 | Maths | 80 |
1 | English | 90 |
2 | Maths | 70 |
2 | English | 80 |
3 | Maths | 90 |
3 | English | 80 |
CREATE TABLE student (
id SERIAL PRIMARY KEY,
name VARCHAR(50),
age INT,
gender VARCHAR(10),
class INT
);
create
INSERT INTO student (name, age, gender, class)
VALUES ('John', 18, 'Male', 10),
('Jane', 18, 'Female', 10),
('Mary', 19, 'Female', 10),
('David', 20, 'Male', 10);
insert
get
https://learngisonline.com/postgis/