SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

create table movie (movieid varchar(6) primary key, title varchar(50))

insert into movie values('D00001', 'True Lies')
insert into movie values('D00002', 'Predator')
insert into movie values('D00003', 'Last Action Hero')
insert into movie values('D00004', 'Red Heat')
insert into movie values('D00005', 'Conan 1')
insert into movie values('D00006', 'Conan 2')
insert into movie values('D00007', 'Red Sonja')

create table store (storeid varchar(4) primary key, city varchar(20))

insert into store values('WI01', 'Chicago')
insert into store values('WI02', 'Chicago')
insert into store values('WI03', 'Chicago')
insert into store values('IL01', 'Atlanta')
insert into store values('IL02', 'Nashville')

create table movie_store (movieid varchar(6) foreign key references movie (movieid), 
    storeid varchar(4) foreign key references store (storeid),
    primary key (movieid, storeid))

insert into movie_store values('D00001', 'WI01')
insert into movie_store values('D00001', 'WI02')
insert into movie_store values('D00001', 'WI03')
insert into movie_store values('D00002', 'IL01')
insert into movie_store values('D00002', 'IL02')
insert into movie_store values('D00003', 'WI01')
insert into movie_store values('D00004', 'WI01')
insert into movie_store values('D00004', 'WI02')
insert into movie_store values('D00004', 'IL02')
insert into movie_store values('D00005', 'WI01')
insert into movie_store values('D00005', 'WI02')
insert into movie_store values('D00006', 'WI01')
insert into movie_store values('D00006', 'WI02')
insert into movie_store values('D00006', 'WI03')
insert into movie_store values('D00007', 'WI01')
insert into movie_store values('D00007', 'WI02')
insert into movie_store values('D00007', 'WI03')

select * from  Movie
select * from store
select * from movie_store

movieid	title
D00001	True Lies
D00002	Predator
D00003	Last Action Hero
D00004	Red Heat
D00005	Conan 1
D00006	Conan 2
D00007	Red Sonja

storeid	city
IL01	Atlanta
IL02	Nashville
WI01	Chicago
WI02	Chicago
WI03	Chicago

movieid	storeid
D00001	WI01
D00001	WI02
D00001	WI03
D00002	IL01
D00002	IL02
D00003	WI01
D00004	IL02
D00004	WI01
D00004	WI02
D00005	WI01
D00005	WI02
D00006	WI01
D00006	WI02
D00006	WI03
D00007	WI01
D00007	WI02
D00007	WI03

title	city
Conan 2	Chicago
Red Sonja	Chicago
True Lies	Chicago