1.创建数据库tb_school 2. 创建数据表t_institution、t_class、t_student、t_teacher、t_course 3. 向各个表中插入对应的数据，并能够通过select * 查询表中所有数据

创建数据库`tb_school`和相应的数据表可以使用SQL语句，这里是一个基本的例子，假设我们正在使用MySQL：

1. 首先，创建数据库`tb_school`:

CREATE DATABASE tb_school;

切换到新创建的数据库：

USE tb_school;

2. 接下来，创建数据表`t_institution`, `t_class`, `t_student`, `t_teacher`, 和 `t_course`:

CREATE TABLE t_institution (
    id INT PRIMARY KEY,
    name VARCHAR(50)
);

CREATE TABLE t_class (
    id INT PRIMARY KEY,
    institution_id INT,
    class_name VARCHAR(50),
    FOREIGN KEY (institution_id) REFERENCES t_institution(id)
);

CREATE TABLE t_student (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    class_id INT,
    FOREIGN KEY (class_id) REFERENCES t_class(id)
);

CREATE TABLE t_teacher (
    id INT PRIMARY KEY,
    name VARCHAR(50),
    department VARCHAR(50)
);

CREATE TABLE t_course (
    id INT PRIMARY KEY,
    course_name VARCHAR(50),
    teacher_id INT,
    FOREIGN KEY (teacher_id) REFERENCES t_teacher(id)
);

3. 插入数据到每个表中（这里仅提供部分示例，真实情况下的数据应包含更多的详细信息）:

INSERT INTO t_institution (id, name) VALUES (1, '学校A');
INSERT INTO t_class (id, institution_id, class_name) VALUES (1, 1, '班级1');

INSERT INTO t_student (id, name, class_id) VALUES (1, '学生A', 1);
INSERT INTO t_teacher (id, name, department) VALUES (1, '老师A', '数学系');

INSERT INTO t_course (id, course_name, teacher_id) VALUES (1, '课程1', 1);

查询表中所有数据：

SELECT * FROM t_institution;
SELECT * FROM t_class;
SELECT * FROM t_student;
SELECT * FROM t_teacher;
SELECT * FROM t_course;