-- Tristan Sabol 
-- Due Date 10/21/24
-- My Database   
-- This program creates a datbase of what the Infotamtion of a person is 
-- This creates the database and what name it is 
Create Database customer;
--  This swicthes use into my database to put data in 
use customer;
-- This  Creates a table and then i put the field into the table 
Create table customerData (
id int primary key auto_increment,
First_Name varchar (20),
Last_Name varchar (20),
Address_ varchar (20),
City varchar (20),
State_ varchar (2),
Zip_code varchar (5),
Birth_Date date,
phone varchar (20)
);
-- it makes the First_Name become A key to make the row easy to use 
create index idx_Last_Name on customerData(Last_Name);
-- it makes the State_ become A key to make the row easy to use 
create index idx_State_ on customerData(State_);

-- This give the info to make sure that i did the table correctly
Describe customerData;
-- this insert the values into the table and saves it there
insert into customerData
(First_Name, Last_Name, Address_, City, State_, Zip_code, Birth_Date, phone)
-- This is the vaules that get inseted into the table 
value
("Stephen","Angelella","2788 Marion Stree","Bellmore","NY","11710","12/4/70","(719) 547-4746"),
("Allen","Attaway","PO Box 643","Piscataway","NJ","08855","12/4/90","(848) 800-7645"),
("Baron","Ballester","186 Lexington Avenue","Westwood","NJ","07675","11/5/70","(778) 985-6673"),
("George","Bartels","77 Allen Road","Rockville Centre","NY","11570","11/4/70","(640) 713-1323"),
("Michael","Bartolome","228 South 17th Avenue","Manville","NJ","08835","1/4/30","(464) 521-0712"),
("Hugh","Bentley","7 Holly Treee Lane","East Islip","NY","11730","1/2/2010","(911) 661-2928"),
("Robert","Bielsky","931 Peninsula Blvd","Woodmere","NY","11598","2/6/08","(684) 215-3002"),
("George","Botsch","511 Rockaway Street","West Islip","NY","11795","12/7/09","(914) 924-6320"),
("Duane","Burrell","22 Van Buskirk Rd","Teaneck","NJ","07666","6/4/70","(870) 640-2874"),
("Michael","Caldarella","108 Kemah-Mecca Lake Road","Newton","NJ","07860","5/4/70","(792) 481-4668"),
("Pephen","Belella","120 S. Rigewood Place","Chestr","PA","19013","1/4/54","(223) 285-3419"),
("Lephen","Selella","210 W. Rideod Lane","Hghtstown","NJ","08520","1/4/21","(280) 919-5145"),
("Stepeyn","Langelella","230 N. idgewood Court","Hihtstown","NJ","19013","2/2/70","(687) 560-7921"),
("Jetephen","Angel","920 E. Tidgewood Lane","Higtstown","NJ","08520","12/8/60","(701) 534-6850"),
("Stephn","Lella","990 N. Widgewood Place","Cester","PA","19013","12/12/70","(797) 797-0607"),
("Steehen","Asela","210 S. Nidgewood Ave","Hightstown","NJ","08520","12/3/12","(497) 794-0607"),
("pepen","Anlla","820 W. Cidgewood Center","Cheser","PA","19013","3/21/12","(397) 794-0647"),
("Stephen","Gelea","229 N. Pidgewood Ave","Higtstown","NJ","08520","1/22/10","(397) 194-0507"),
("Stehen","Zelella","120 S. Slidgewood Place","Cheter","PA","19013","1/3/60","(392) 794-0602"),
("Sephen","Telella","229 E. Ligewood Lane ","Hightstown","NJ","08520","11/6/20","(397) 794-2607")
;
-- This displays the text in a sql table by pull the data togather in a graph 
select * from customerData;
-- This is to Drop or delete the database from the Server 
drop database customer;