JAVA WEB 321 Data Analysis and Design - Assignment 2 Frontsheet

When create database assignment is successfully then we use a query for customers table: Create table customers ( CustID varchar(10) primary key not null, CustName varchar(50) not null, DoB date check (DoB<getdate() and (year(getdate())-year(DoB))>14), Gender varchar(10) check (gender='Male' or gender='Female' ), [Address] xml, CustPhone varchar(11), CustEmail varchar(30) ) After executing the query for customers table then use query to insert data into table We use a query for supplier table Create table suppliers ( SupID varchar(10) primary key not null, Supname varchar(50) not null, SupAddress xml, SupPhone varchar(11), SupEmail varchar(30) ) After executing the query for supplier table then use query to input data Use a query for Items table Create table Items ( ItemID varchar(10) primary key not null, Itemname varchar(30), Unitprice int check (unitprice>0), Sup