I made an ER diagram, but I'm not sure if it's correct. Please analyze and see if I have any errors.

Here's the code:

drop table apps;
create table apps (
name varchar(30) not null primary key,
desc varchar(120) not null,
price float not null,
seller varchar(30) not null,
size float not null,
release date not null,
category varchar(15) not null
);

drop table reviews;
create table reviews (
name varchar(30) not null,
review varchar(120) not null
);

drop table ratings;
create table ratings (
name varchar(30) not null,
rating float not null
);

the foreign keys that relate the tables to each other are missing