create table members
( memberID int not null Primary Key identity,
first varchar(25) NOT NULL,
last varchar(25) NOT NULL,
 email varchar(30) NOT NULL,
 DVDCollection int);

create table DVD
( DVDID int not null Primary Key identity,
Title varchar(50) NOT NULL,
Director varchar(25) NOT NULL)

create table DVDCollection
   ( 
   memberID int NOT NULL,
    DVDID int NOT NULL,
    CONSTRAINT PK_DVDCollectionTable PRIMARY KEY
    (
        memberID,
        DVDID
    ),
    FOREIGN KEY (memberID) REFERENCES members (memberID),
    FOREIGN KEY (DVDID) REFERENCES dvd (DVDID))

select first, last, Title from dvdcollection
join members on members.memberid = dvdcollection.memberID
join DVD on dvd.dvdid = dvdcollection.DVDID