
CREATE TABLE UserEmail_T (
	username VARCHAR(12) NOT NULL,
	email VARCHAR(30) NOT NULL,
	CONSTRAINT pk_useremail PRIMARY KEY (userName,email)
);

ALTER TABLE UserEmail_T
ADD CONSTRAINT fk_useremail FOREIGN KEY (username) REFERENCES User_T(userName);
	
INSERT INTO UserEmail_T(userName,email) VALUES 
	('user1','user1@villanova.edu');
INSERT INTO UserEmail_T(userName,email) VALUES 
	('user1','user1@gmail.com');
INSERT INTO UserEmail_T (userName,email) VALUES 
	('user2','user2@gmail.com');
	
