what is the syntax to use foreign key in 3rd table to use first table data,suppose there is 3 table

create database muni
use muni
create table stream
(
streamname varchar(10) constraint stream_strname_pk primary key
)
select *from stream
create table branch
(
branchid int identity constraint branch_bid_pk primary key,
branchname varchar(20) not null,
streamname varchar(10) constraint stream_strname_fk foreign key references stream(streamname)
)
select *from branch
create table semistar
(
semistarid int identity constraint semistar_sid_pk primary key,
semistarname varchar(30) not null,
streamname varchar(10)constraint  stream_stname_fk foreign key references stream(stramname)
)
select *from semistar