I wouldn't say that it's completely right, but it's a nice try.

- The main problem (IMO) is the DVD table. It isn't normalized. I suggest you to create a Titles' catalog and a Categories' catalog (even a Directors' catalog).

- The Rental date should be on the Rental table not on the details.

- CatalogID should be only on the details.

- The customer name is not needed in the Rentals table (that's why you have the CustomerID)

- RentalID can't be the only column in your Rental_Details PK as it needs to have multiple rows with the same RentalID.

- StoreManager is not needed on Employee table.

- You're missing some relations which are indicated by the PKs and FKs (e.g. Store-Customer, Rental_Details-DVD)

- If you're storing address in separate columns for the stores, it would be nice to do the same for employees and customers (it would help for further analysis).

I'm sure there are more improvements that can be done, but this should give you some work to do.