Sure, here is an example of creating a simple relational database schema for a blog website using SQL:
```
CREATE TABLE users (
id INT PRIMARY KEY,
username VARCHAR(50) NOT NULL,
email VARCHAR(100) NOT NULL,
password VARCHAR(100) NOT NULL
);
CREATE TABLE posts (
id INT PRIMARY KEY,
title VARCHAR(255) NOT NULL,
content TEXT NOT NULL,
author_id INT NOT NULL,
FOREIGN KEY (author_id) REFERENCES users(id)
);
CREATE TABLE comments (
id INT PRIMARY KEY,
content TEXT NOT NULL,
post_id INT NOT NULL,
author_id INT NOT NULL,
FOREIGN KEY (post_id) REFERENCES posts(id),
FOREIGN KEY (author_id) REFERENCES users(id)
);
```
In this example, we have three tables: "users", "posts", and "comments". The "users" table stores information about registered users, including their username, email, and password. The "posts" table stores information about blog posts, including the title, content, and the ID of the user who wrote the post. The "comments" table stores information about comments on blog posts, including the content of the comment, the ID of the post it refers to, and the ID of the user who wrote the comment.
Note that we have also included foreign key constraints in the "posts" and "comments" tables, which ensure that the "author_id", "post_id", and "author_id" fields reference valid IDs in the "users" and "posts" tables, respectively.