Customer email address
<p>I am new to sql programming. This is for a homework assignment for my database class.  I have made all the table I need for the assignment I am just hung up one part. The line in the homework reads as follows:</p>

<blockquote>
  <p>If type is 'faculty' the email address must end up with '@xxx.edu'</p>
</blockquote>

<p>This is what the table looks like:</p>

<pre><code>create table customer
(
CID# char(10) primary key IDENTITY (1,1) NOT NULL,
F_name varchar(20),
M_name varchar(20),
L_name varchar(20),
type varchar(20),
street varchar(20),
city varchar(20),
state varchar(20),
zip char(5),
password varchar (20) NOT NULL,
email varchar(20) NOT NULL
Constraint CK_customer_type check (type in ('student', 'faculty'))
)
</code></pre>

<p>Any help someone could lend would be greatly appreciated!</p>