USE master;
GO

CREATE DATABASE rosh;
GO

USE rosh;
GO

CREATE SCHEMA Registration;
GO

/* One of the problems I used to have with the Students table of this
   database was that, every year or every 2-4 years, I had to change
   the dates of birth of the records to make them more realistic, to 
   get appropriate students ages. I have finally found a solution in the
   following function. Instead of entering the ages of students when the
   table is created, this function takes the current date, subtracts a 
   certain number of days, which corresponds to an age, and assigns it 
   to the student record.
*/
CREATE FUNCTION Registration.SetDateOfBirth(@days int)
RETURNS Date
AS
BEGIN
	RETURN DATEADD(d, @days, SYSDATETIME());
END
GO

CREATE TABLE Registration.Students
(
	StudentNumber nchar(16),
	FirstName nvarchar(22),
	MI nchar(3),
	LastName nvarchar(22),
	DateOfBirth date,
	Gender nvarchar(20),
	[Address] nvarchar(50),
	City nvarchar(40),
	[State] nvarchar(40),
	ZIPCode nvarchar(20),
	HomePhone nvarchar(20),
	EmailAddress nvarchar(50),
	ParentsNames nvarchar(50),
	SingleParentHome bit,
	EmergencyName nvarchar(50),
	EmergencyPhone nvarchar(20)
);
GO

INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('888-849-402', 'Sebastien', 'B', 'Porter', Registration.SetDateOfBirth(-6542),'Male', '4442 Shane Ave', 'Silver Spring',
       'MD', '20902', '(301) 591-6236', 'porters@rosh.md.us',
       'John and Christine Porter',0,'John Porter', '(202) 662-4825'),
       ('286-022-404', 'Suzie', 'D', 'Hoak', '10/5/1997', 'Female', '1866 Old Conference Rd. #1412',
       'Hyattsville', 'MD', '20782', '(301) 736-0002', 'hoaks@rosh.md.us',
       'Christianne Hoak',0,'Christianne Hoak', '(301) 364-0221');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('138-248-300', 'Antoinette', 'Clark', Registration.SetDateOfBirth(-6485),'Female', '282 Centerway st.', 'Rockville',
       'MD', '20875', '(301) 598-9292', 'clarcka@rosh.md.us', 'Daniel and Henriette Clarck',0,
       'Henriette Clarck', '(301) 598-9292');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName)
VALUES('247-900-002', 'Koko', 'P', 'Domba', 'Male', '8782 South Waterfront Blvd #14D2', 'Alexandria',
       'VA', '20212', '(703) 363-1066', 'dombak@rosh.md.us', 'Dr. Julie and Mr. Jeremiah Domba',0,'Jeremiah Domba');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, EmailAddress)
VALUES('174-302-802', 'Janet', 'O', 'West',  Registration.SetDateOfBirth(-6432), 'Female', '980 Washington Blvd.',
       'Bethesda', 'MD', '20872', 'westj@rosh.md.us');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  EmailAddress, ParentsNames, EmergencyPhone)
VALUES('395-484-228', 'Catherine', 'L', 'Chang',  Registration.SetDateOfBirth(-6057),'Female', 'changc@rosh.md.us',
       'Julie Best and Dr. Peter Chang', '(202) 215-6663');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome)
VALUES('206-022-274', 'Nehemiah', 'Dean',  Registration.SetDateOfBirth(-6249), 'Male', '442 Lakefront Ave.', 'Silver Spring',
       'MD', '20910', '(301) 938-2763', 'deann@rosh.md.us', 'Marie Rodnat', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, EmailAddress,
                                  ParentsNames, EmergencyName, EmergencyPhone)
VALUES('285-902-004', 'Sherryl', 'B',  Registration.SetDateOfBirth(-6305), 'Female', '1771 N. Frederick Rd.', 'Chevy Chase',
       'MD', '20870', 'ashburns@rosh.md.us', 'Shelia and Patrick Ashburn', 'Shelia Ashburn', '(703) 292-8340');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, EmailAddress)
VALUES('444-736-466', 'Santos', 'M', 'Pacheco',  Registration.SetDateOfBirth(-6095), 'pachecos@rosh.md.us');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, EmergencyName, EmergencyPhone)
VALUES('512-882-805', 'Mohamed', 'D', 'Husseini', 'Male', '888 Democracy Rd. #D8', 'Washington',
       'DC', '20008', '(202) 556-4766', 'husseinim@rosh.md.us', 'Drs. Phyllis and Ezra Husseini',
       'Dr. Phyllis Husseini', '(202) 631-8855');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName)
VALUES('903-627-414', 'Dean', 'F', 'Chen',  Registration.SetDateOfBirth(-6098), 'Male', '4608 St. Leonard St.', 'Vienna',
       'VA', '20204', '(703) 518-3372', 'chend@rosh.md.us', 'Alexandra Chen', 1, 'Alexandra Chen');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  City, [State], ZIPCode, EmailAddress,
                                  ParentsNames, EmergencyName, EmergencyPhone)
VALUES('728-599-277', 'Ruby', 'W', 'DeGaram',  Registration.SetDateOfBirth(-5571), 'Female', 'Silver Spring', 'MD', 20906,
       'degaramr@rosh.md.us', 'Lynn and Anthony DeGaram', 'Anthony DeGaram', '(301) 938-1220');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('802-948-008', 'Carole', 'Chance',  Registration.SetDateOfBirth(-4829), 'Female', '445 Farmers Av.', 'Rockville',
       'MD', '20875', 'chancec@rosh.md.us', 'Carole and Andy Chance', 0, 'Andy Chance', '(301) 422-1001');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyPhone)
VALUES('240-048-427', 'Justin', 'G', 'Vittas', 'Male', 'Bethesda', 'MD', 20815,
       '(301) 549-4004', 'vittasj@rosh.md.us', 'Clarice Vittas', 1, '(301) 549-0020');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('110-472-462', 'Ismael', 'T', 'Zara',  Registration.SetDateOfBirth(-5344), 'Male', '9009 Kentland St', 'Laurel',
       'MD', '20707', 'zarai@rosh.md.us', 'Melinda and Robert Zara', 0, 'Robert Zara', '(202) 978-6642');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  [Address], City, [State], HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('831-822-852', 'Anselme', 'T', 'Waters',  Registration.SetDateOfBirth(-4920), '1872 Hunters Dr.', 'Washington',
       'DC', '(202) 525-0160', 'watersa@rosh.md.us', 'Claudette and Dr. Celestin Waters', 1,
       'Celestin Waters', '(703) 894-6624');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyPhone)
VALUES('382-866-277', 'Brenda', 'P', 'Lobo',  Registration.SetDateOfBirth(-5942), 'Female', '2490 Chanting Rd.',
       'Alexandria', 'VA', '20214', '(703) 894-2888', 'lobob@rosh.md.us',
       'Priscilla and Michel Lobo', 0, '(703) 894-2888');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  HomePhone, EmailAddress, ParentsNames, EmergencyPhone)
VALUES('666-265-905', 'Suzanna', 'Verde',  Registration.SetDateOfBirth(-6149), 'Female',
       '(301) 831-2420', 'verdes@rosh.md.us', 'Suzanne and Thommy Verder', 'Thommy Verde');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, EmergencyName, EmergencyPhone)
VALUES('402-022-060', 'Danilo', 'R', 'Chico', 'Male', '291 Nixon Av.', 'Chevy Chase', 'MD',
       '20872', '(301) 364-9212', 'chicod@rosh.md.us', 'Michelle and Stephen Chico',
       'Stephen Chico', '(202) 299-7001');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('704-807-720', 'Mincy', 'R', 'Franse',  Registration.SetDateOfBirth(-4843), 'Female',
       '1788 Old Montgomery Av.', 'Laurel', 'MD', '20707', 'fransem@rosh.md.us', 
       'Dr. Melanie and Cleve Franse', 0, 'Melanie Franse', '(301) 986-4445');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  City, [State], ZIPCode, HomePhone, EmailAddress,
                                  SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('357-382-035', 'Arlene', 'G', 'Andriamirano', Registration.SetDateOfBirth(-5809),
       'Arlington', 'VA', '20212', '(703) 593-2820', 'Andriam@rosh.md.us', 1,
       'Christianne Andriamirano', '(703) 593-2820');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, EmailAddress)
VALUES('588-333-228', 'Gabrielle', 'A', 'Ledoux',  Registration.SetDateOfBirth(-5681),
       'Female', '752 West Farm Blvd.', 'Hyattsville', 'MD', '20782', 'ledouxg@rosh.md.us');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('925-268-822', 'Koko', 'Lobila', 'Female', '2888 Wolf Terrace', 'Washington', 'DC', '20002',
       '(202) 538-2008', 'lobilak@rosh.md.us', 'Aquilla and Dr. Diallo Lobila', 0,
       'Aquilla Lobila', '(301) 752-0002');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('284-888-255', 'Paul', 'O', 'Farms',  Registration.SetDateOfBirth(-6465), 'Male',
       '4490 Presidents Square', 'Silver Spring', 'MD', '20902', '(301) 695-7727',
       'farmsp@rosh.md.us', 'Rebecca and Peter Farms', 0, 'Rebecca Farms', '(301) 696-8281');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  EmailAddress, ParentsNames, EmergencyName, EmergencyPhone)
VALUES('310-295-075', 'Lester', 'D', 'Bell',  Registration.SetDateOfBirth(-6245), 'Male', 'belll@rosh.md.us',
       'Bernadette and Paulin Bell', 'Bernadette Bell', '(301) 979-0032');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, EmergencyName, EmergencyPhone)
VALUES('822-280-271', 'Christian', 'M', 'Liss',  Registration.SetDateOfBirth(-5574), 'Male', '902 Continental Rd',
       'Washington', 'DC', '20020', '(202) 389-7487', 'lissc@rosh.md.us',
       'Sandra and Paul Liss', 'Sandra Liss', '(703) 797-9762');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome)
VALUES('579-767-006', 'Arlette', 'Duma', 'Female', 'Bethesda', 'MD', '20850',
       '(301) 206-8623', 'dumat@rosh.md.us', 'Ursula Duma', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('602-708-295', 'Harriette', 'D', 'Sans',  Registration.SetDateOfBirth(-6371), 'Female', '402 Dublin Rd',
       'Alexandria', 'VA', '22032', '(703) 684-1500', 'sansh@rosh.md.us', 'Thomas Sans', 0,
       'Thomas Sans', '(703) 684-1500');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName)
VALUES('700-422-384', 'Clint', 'Fuller',  Registration.SetDateOfBirth(-6476), 'Male', '6812 Thousand Way',
       'Silver Spring', 'MD', '20904', 'clintf@rosh.md.us', 'Shelley and Dr. Oregon Fuller',
       0, 'Shelley Fuller');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, EmergencyName, EmergencyPhone)
VALUES('805-420-937', 'Thomas', 'Moore',  Registration.SetDateOfBirth(-6108), 'Male', 'Columbia', 'MD', '21102',
       '(410) 730-8100', 'mooret@rosh.md.us', 'Deborah Moore', 'Deborah Moore', '(410) 730-8100');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('447-708-090', 'Bernadette', 'L', 'Howerson', 'Female', '4440 Public Sq', 'Silver Spring',
       'MD', '20910', '(301) 899-1800', 'howb@rosh.md.us', 'Caron and Rick Howerson',
       0, 'Caron Howerson', '(301) 899-1800');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName)
VALUES('882-708-492', 'Tim', 'M', 'Amorros',  Registration.SetDateOfBirth(-5810), 'Male', 
       '125 Eutah Rd', 'Rockville', 'MD', '20854', '(301) 262-1717', 'amorrost@rosh.md.us',
       'Eduardo Amoros', 0, 'Helena');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  EmailAddress, ParentsNames, SingleParentHome,
                                  EmergencyName, EmergencyPhone)
VALUES('228-230-044', 'Judith', 'Steinberg',  Registration.SetDateOfBirth(-5802),
       'Female', 'steinbergj@rosh.md.us', 'Jim', 0, 'Jim', '(301) 322-7130');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('407-220-037', 'Ella', 'Napolis', 'Female', '820 Chisom Rd', 'Silver Spring', 'MD',
       '20906', '(301) 925-7041', 'napolise@rosh.md.us', 'Sandra and Pedro Napolis',
       0, 'Sandra Napolis', '(301) 925-7041');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  City, [State], ZIPCode, HomePhone, EmailAddress,
                                  EmergencyPhone)
VALUES('616-736-003', 'Maurice', 'Walken',  Registration.SetDateOfBirth(-4843), 'Male',
       'Washington', 'DC', '20010', '(202) 583-4228', 'walkenm@rosh.md.us', '(202) 583-4228');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  [Address], City, [State], HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('688-724-050', 'Charles', 'P', 'Edelman', Registration.SetDateOfBirth(-5860),
       '54 Sommerset Rd', 'Hyattsville', 'MD', '(301) 656-4441', 'edelmane@rosh.md.us',
       'Jasmine Bealieu', 1, 'Jasmine Bealieu', '(301) 656-4441');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  City, [State], ZIPCode, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('247-564-115', 'Arthur', 'W', 'Milley', Registration.SetDateOfBirth(-6464), 'Silver Spring', 'MD', '20906',
       'milleya@rosh.md.us', 'Jeffrey Milley', 0, 'Jeffrey Milley', '(301) 229-1600');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender, 
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress)
VALUES('148-147-229', 'Martin', 'P', 'Davis', 'Male', '856 Worry Lane', 'Bethesda', 'MD',
       '20860', '(703) 836-1100', 'davism@rosh.md.us');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  SingleParentHome, EmergencyPhone)
VALUES('842-124-135', 'Ann', 'Miller', Registration.SetDateOfBirth(-6048), 'Female',
       '1948 Hagers St', 'Rockville', 'MD', '20855', '(301) 571-0400', 'millern@rosh.md.us',
       0, '(301) 571-0400');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  EmailAddress)
VALUES('530-245-168', 'Millicent', 'O', 'Broadskey', Registration.SetDateOfBirth(-5236),
       'Female', 'broadskeym@rosh.md.us');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('803-808-205', 'Victoria', 'Milchen', Registration.SetDateOfBirth(-6112),
       'Female', '105 Military Rd', 'MD', '20905', '(301) 540-2300', 'milchenv@rosh.md.us',
       'Paul Milchen', 1, 'Paul Milchen', '(301) 540-2300');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  EmailAddress, ParentsNames, SingleParentHome, EmergencyPhone)
VALUES('468-288-708', 'Arthur', 'Junger', Registration.SetDateOfBirth(-4904), 'Male', 'jungera@rosh.md.us',
       'Heleine Pitts', 1, '(301) 656-4060');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  SingleParentHome, EmergencyName)
VALUES('804-827-004', 'Martine', 'Quarles', Registration.SetDateOfBirth(-6550),
       'Female', '808 Patuxent Rd', 'Washington',
       'DC', '20004', '(202) 833-4167', 'quarlesm@rosh.md.us', 0, 'Carole Zarra');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [Address], [State], EmailAddress)
VALUES('515-790-282', 'Julie', 'D', 'Laurens', 'Female', '4012 Sunset Rd',
       'MD', 'laurensj@rosh.md.us');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], [State], ZIPCode, EmailAddress,
                                  SingleParentHome, EmergencyPhone)
VALUES('442-585-060', 'Martha', 'T', 'Bastens', Registration.SetDateOfBirth(-6542),
       'Female', '506 Smallwall Circle',
       'MD', '20840', 'bastensm@rosh.md.us', 0, '(301) 780-4424');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress)
VALUES('752-484-481', 'Jeannette', 'R', 'Hutchins', Registration.SetDateOfBirth(-6106), '704 Summit Ave',
       'Silver Spring', 'MD', '20910', '(301) 662-0013', 'hutchinsj@rosh.md.us');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  HomePhone, EmailAddress, ParentsNames, SingleParentHome,
                                  EmergencyName, EmergencyPhone)
VALUES('152-680-295', 'Paul', 'Marlly', Registration.SetDateOfBirth(-4831), 'Female', '(301) 661-5050',
       'marllyp@rosh.md.us', 'Arlette Hutchins', 1, 'Arlette Hutchins', '(301) 661-5050');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('901-927-008', 'Donnie', 'Mart', 'Female', '3002 Magnuson Ave', 'Rockville', 'MD',
       '20854', '(301) 276-6068', 'martd@rosh.md.us', 'Alan Marly', 1, 'Alan Marly', '(301) 276-6068');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome)
VALUES('258-809-284', 'George', 'Orion', Registration.SetDateOfBirth(-6229), 'Male', '12004 Shepherd Way', 'Bethesda',
       'MD', '20850', '(301) 805-2233', 'oriong@rosh.md.us', 'Jennifer Freemont', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  EmailAddress, ParentsNames, SingleParentHome, EmergencyPhone)
VALUES('248-470-847', 'Albert', 'Linken', Registration.SetDateOfBirth(-6086), 'Male', 'linkena@rosh.md.us',
       'Sandra Kallahan', 1, '(301) 530-0540');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  SingleParentHome)
VALUES('902-750-068', 'Ralph', 'Hagers', Registration.SetDateOfBirth(-5368),
       'Male', '312 Friendship Ave', 'Chevy Chase',
       'MD', '20845', '(301) 805-6008', 'hagersr@rosh.md.us', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('661-706-084', 'Charles', 'C', 'Laurel', Registration.SetDateOfBirth(-4892),
       'Male', '4422 Davison Rd #1205',
       'College Park', 'MD', '20747', 'laurelc@rosh.md.us', 'Stephen Laurel', 0,
       'Terry Fralin', '(301) 628-3200');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], [State], HomePhone, SingleParentHome)
VALUES('806-304-664', 'Seraphin', 'Lamis', Registration.SetDateOfBirth(-6469), 'Male', '12 Market Rd',
       'MD', '(301) 314-2255', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [State], HomePhone, SingleParentHome, EmergencyName)
VALUES('608-737-004', 'Travis', 'D', 'Waters', 'Male', 'MD', '(301) 588-8186', 0, 'Jacqueline Um');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], [State], HomePhone)
VALUES('824-836-807', 'Elaine', 'Van Roden', Registration.SetDateOfBirth(-6029),
       'Female', '4412 Unite Rd', 'MD', '(301) 562-5361');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [State], EmergencyName, EmergencyPhone)
VALUES('508-358-728', 'Raymond', 'D', 'Ho', Registration.SetDateOfBirth(-4782),
       'MD', 0, 'Jacqueline Cendrowsky', '(301) 834-6380');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender, [State], HomePhone,
                                  ParentsNames, SingleParentHome, EmergencyPhone)
VALUES('703-740-506', 'Fame', 'H', 'Lunden', 'Female', 'MD', '(301) 499-8603',
       'Christianne & Bill Burton', 0, '(301) 262-1717');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], [State], HomePhone)
VALUES('802-350-855', 'Yelena', 'Vasco', Registration.SetDateOfBirth(-6432),
       'Female', '1490 Trauma Rd', 'MD', '(301) 217-6434');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [State], ZIPCode, HomePhone, SingleParentHome, EmergencyPhone)
VALUES('368-127-288', 'Orlando', 'N', 'Tysons', Registration.SetDateOfBirth(-5566), 'Male', 'MD', '20910',
       '(301) 677-1437', 0, '(301) 677-1437');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], HomePhone, ParentsNames,
                                  SingleParentHome, EmergencyName)
VALUES('446-660-974', 'Elisa', 'N', 'Sunderland', Registration.SetDateOfBirth(-5387),
       'Female', '2778 Rain Rd #D12',
       'Greenbelt', 'MD', '(301) 320-5101', 'Gregory Lawrence', 0, 'Sandrine Lotts');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  City, [State])
VALUES('881-652-606', 'Bouba', 'A', 'Rahmani', 'Male', 'Silver Spring', 'MD');
GO
INSERT INTO Registration.Students(StudentNumber, LastName, DateOfBirth, Gender,
                                  [Address], [State], HomePhone, SingleParentHome, EmergencyPhone)
VALUES('600-520-384', 'Millers', Registration.SetDateOfBirth(-6442), 'Male', '1205 Sunrise Rd', 'DC',
       '(202) 434-2277', 0, '(202) 998-0274');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [State], ZIPCode, HomePhone, ParentsNames,
                                  SingleParentHome, EmergencyPhone)
VALUES('775-730-046', 'Frank', 'T', 'Chambers', Registration.SetDateOfBirth(-5094), 'Male', 'DC', '20002',
       '(202) 554-3501', 'Jane and Alexander Lehmann', 0, '(202) 554-3501');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  City, ZIPCode)
VALUES('825-750-484', 'Justine', 'H', 'Grates', Registration.SetDateOfBirth(-6093), 'Female', 'Chevy Chase', '20850');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [State], HomePhone, SingleParentHome,
                                  EmergencyName)
VALUES('702-708-485', 'Caroline', 'G', 'Oxley', Registration.SetDateOfBirth(-6352), 'Female', 'MD', 
       '(301) 970-5401', 0, 'Ernestine Mobe');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [State], HomePhone, SingleParentHome, EmergencyPhone)
VALUES('882-365-882', 'Patrick', 'T', 'Gallagher', 'Male', 'MD', '(301) 360-2000', 1, '(301) 368-0244');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], [State])
VALUES('275-708-462', 'Clayton', 'T', 'Channey', Registration.SetDateOfBirth(-5943), 'Male', '4444 Charity Lane', 'MD');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], [State], EmergencyPhone)
VALUES('528-750-848', 'Yannick', 'T', 'Earley', Registration.SetDateOfBirth(-4902), 'Male', '3734 Bond St',
       'MD', '301-791-3030');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [State], ZIPCode, HomePhone, ParentsNames,
                                  SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('491-808-449', 'Alain', 'Sanders', Registration.SetDateOfBirth(-6122), 'Male', 'MD', '20854', '301-499-3600',
       'Sandrine & Joshua Roberts', 1, 'Sandrine Roberts', '(301) 499-3600')
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  [State], ZIPCode, SingleParentHome, EmergencyPhone)
VALUES('725-694-680', 'Christopher', 'N', 'Johnson', Registration.SetDateOfBirth(-6433),
       'MD', '20774', 0, '(301) 294-2643');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  [Address], HomePhone, SingleParentHome)
VALUES('704-694-644', 'Joseph', 'H', 'Grants', Registration.SetDateOfBirth(-6364),
       '11312 Crane Drive #12', '(301) 696-9766', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone,
                                  SingleParentHome, EmergencyPhone)
VALUES('609-697-080', 'Ralph', 'F', 'Chapman', 'Male', '12881 Northpoint Blvd. #1410',
       'Bethesda', 'MD', '20815', '(301) 784-7000', 0, '(301) 222-6061');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [State], SingleParentHome)
VALUES('900-790-582', 'Dennis', 'Eisenberg', Registration.SetDateOfBirth(-6066), 'Male', 'MD', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [State], HomePhone)
VALUES('309-770-282', 'Joseph', 'Greens', Registration.SetDateOfBirth(-4845), 'Male', 'DC', '(202) 475-3770');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [State], HomePhone, ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('664-405-164', 'Karl', 'H', 'Bartlinsky', Registration.SetDateOfBirth(-6405), 'Male', 'MD', '301-855-9660',
       'Caroline Nguyen', 1, 'Caroline Nguyen', '(301) 855-9660');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth,
                                  Gender, [Address], City, [State], ZIPCode)
VALUES('426-203-840', 'Jerry', 'Chang', Registration.SetDateOfBirth(-5516), 'Male', 
       '2186 Holm St. N.E.', 'Washington', 'DC', '20010');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  Gender, [Address], [State], EmergencyPhone)
VALUES('282-273-044', 'Mark', 'M', 'Gray', Registration.SetDateOfBirth(-4889), 'Male',
       '8782 South Wells St.', 'MD', '301-694-1920');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName,
                                  DateOfBirth, Gender, [State], ParentsNames)
VALUES('442-304-506', 'Jeff', 'M', 'Eisler', Registration.SetDateOfBirth(-6496), 'Male',
       'MD', 'Brenda and Patrick Fasten');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [State], HomePhone, ParentsNames,
                                  SingleParentHome, EmergencyPhone)
VALUES('228-740-570', 'Calvin', 'U', 'Jackson', 'Male', 'MD', '(301) 791-3100',
       'Dr. Julia Santana', 0, '(301) 490-6390');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, ZIPCode, HomePhone,
                                  SingleParentHome, EmergencyPhone)
VALUES('992-708-051', 'Marck', 'T', 'Colon', Registration.SetDateOfBirth(-5917), 'Male', '2900 Cooke Rd',
       'Silver Spring', '20905', '(301) 279-1580', 0, '(202) 938-7772');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  [Address], [State], EmergencyPhone)
VALUES('773-708-595', 'Eric', 'M', 'Bartlett', Registration.SetDateOfBirth(-5715),
       '10008 Paloma Drive #1204', 'MD', '301-650-6760');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [State], SingleParentHome)
VALUES('630-708-293', 'Sandrine', 'Egert', Registration.SetDateOfBirth(-6362), 'Female', 'VA', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender, [State])
VALUES('882-708-059', 'Graham', 'F', 'Jones', Registration.SetDateOfBirth(-4844), 'Male', 'MD');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('770-708-495', 'Bonnie', 'P', 'Greenberg', Registration.SetDateOfBirth(-6076),
       'Female', '8044 Defensive Circle', 'Chevy Chase', 'MD', '20815', '301-855-9021',
       'greenbb@rosh.md.us', 'Paul Greenberg', 0, 'Jenn Greenberg', '(301) 855-9021');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('848-490-807', 'Eldridge', 'Kahle', Registration.SetDateOfBirth(-6401),
       'Female', '72 Southern Land Rd', 'Silver Spring', 'MD', '20910', '(301) 705-1994',
       'kahlee@rosh.md.us', 'Anne and Johnny Kahle', 0, 'Anne Patricia Kahle', '(301) 705-1994')
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender, [State])
VALUES('558-597-008', 'Jerome', 'N', 'Linten', 'Male', 'MD');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [State], HomePhone, ParentsNames, SingleParentHome)
VALUES('160-860-644', 'Carlton', 'T', 'Lippold', Registration.SetDateOfBirth(-4852),
       'Male', 'MD', '(301) 791-3103', 'Arnold Linten', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('808-645-388', 'Rente', 'A', 'Kahntroff', Registration.SetDateOfBirth(-5681),
       '1204 Shame Street', 'College Park', 'MD', '20747', '(301) 870-4014',
       'kahnr@rosh.md.us', 'Sherry Yost', 1, 'Sherry Yost', '(301) 870-4014');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender)
VALUES('814-640-579', 'Joan', 'T', 'Gallant', Registration.SetDateOfBirth(-5945), 'Female');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('704-708-006', 'Helene', 'Lunner', Registration.SetDateOfBirth(-5004), 'Female',
       '904 District Rd', 'Laurel', 'MD', '20707', '(301)777-2400', 'hunner@rosh.md.us',
       'Monique and Carl Lunner', 0, 'Monique Lunner', '(301) 777-2400');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('804-706-947', 'Denise', 'Eagles', Registration.SetDateOfBirth(-5510),
       'Female', '1204 Jefferson Str #D4', 'College Park', 'MD', '20727',
       'eaglesd@rosh.md.us', 'Jerry Eagles', 0, 'Suzy Eagles', '(301) 478-2930');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('624-857-090', 'Jeanne', 'Gate', 'Female', '10440 Richmond Hwy', 'Rockville',
       'MD', '20850', '(301) 463-2244', 'gatej@rosh.md.us', 'Aline Mancini',
       1, 'Aline Mancini', '(301) 463-2244');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  [State], SingleParentHome)
VALUES('604-706-807', 'Brian', 'A', 'Joneson', Registration.SetDateOfBirth(-6452), 'MD', 0);
GO
INSERT INTO Registration.Students(StudentNumber, LastName, DateOfBirth, Gender,
                                  [Address], City, ZIPCode, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('551-708-296', 'Bassler', Registration.SetDateOfBirth(-6452), 'Female', '727 Columbia Ave', 'Hyattsville',
       '20707', 'basslerm@rosh.md.us', 'Jeanne Bassler', 1, 'Jeanne Bassler', '(301) 359-9190');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [State], ParentsNames, SingleParentHome)
VALUES('116-405-020', 'Jenniffer', 'F', 'Eifler', Registration.SetDateOfBirth(-4846), 'Female', 'MD', 'Arnd Eifler', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [State], HomePhone, ParentsNames, SingleParentHome)
VALUES('606-942-030', 'Catherine', 'B', 'Watson', Registration.SetDateOfBirth(-6237), 'Female', 'MD',
       '301-791-3202', 'Daniel Petrocelli', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  [State], SingleParentHome)
VALUES('825-755-500', 'Terrie', 'M', 'Edwards', Registration.SetDateOfBirth(-5984), 'MD', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [Address], [State], SingleParentHome, EmergencyPhone)
VALUES('804-504-695', 'Rachel', 'D', 'Gray', Registration.SetDateOfBirth(-4961), 'Female', 
       '7200 St Francis Ave #16', 'MD', 0, '(301) 724-3822');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [State], HomePhone, SingleParentHome)
VALUES('528-607-839', 'Jack', 'D', 'Barton', 'Male', 'MD', '(301) 475-8048', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [State], ZIPCode, HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome, EmergencyName)
VALUES('420-793-50', 'Linette', 'Bland', Registration.SetDateOfBirth(-6150), 'Female', 'DC', '20012', 
       '(202) 442-2869', 'lbland1960@hotmail.com', 'Joey Bland', 0, 'Joey Bland');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('224-273-603', 'Beatrice', 'O', 'Thomason', Registration.SetDateOfBirth(-6412),
      'Female', 1, 'Nicole Fousche', '(410) 788-1800')
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  Gender, [Address], City, [State], SingleParentHome)
VALUES('791-452-003', 'Arsene', 'H', 'Huse', Registration.SetDateOfBirth(-6104),
       'Male', '2800 Freight Way', 'Silver Spring', 'MD', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  Gender, HomePhone)
VALUES('335-346-220', 'Benedict', 'T', 'Powel', Registration.SetDateOfBirth(-5913),
       'Male', '(301) 656-4060');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], [State], SingleParentHome)
VALUES('318-070-860', 'Hermine', 'Sidgemore', Registration.SetDateOfBirth(-6218),
       'Female', '11124 Old Tribute Av. #12E2', 'MD', 1);
GO
INSERT INTO Registration.Students(StudentNumber, LastName, Gender, [State], HomePhone,
                                  ParentsNames, SingleParentHome, EmergencyName)
VALUES('209-708-097', 'Pallas', 'Female', 'MD', '(301) 515-2831', 
       'Kirsten Farmer', 1, 'Kirsten Farmer');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  HomePhone, EmailAddress, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('300-839-839', 'Norrelle', 'Lafflin', Registration.SetDateOfBirth(-6139), 'Female', '(301) 478-2930',
       'nlafflin@rosh.md.us', 1, 'Dona Mehdy', '(301) 907-8201');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  SingleParentHome)
VALUES('500-530-488', 'Michael', 'Lurrine', Registration.SetDateOfBirth(-6103), 'Male', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [State], HomePhone, SingleParentHome)
VALUES('206-304-852', 'Evelyne', 'Perry', Registration.SetDateOfBirth(-6451),
       'Female', 'MD', '(301) 777-2131', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], City, [State], ZIPCode, SingleParentHome,
                                  EmergencyPhone)
VALUES('900-994-050', 'Robert', 'Emery', Registration.SetDateOfBirth(-5837), 'Male',
       '9 Alberton Circle #D', 'Takoma Park', 'MD', '20910', 0, '(301) 780-4424');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  HomePhone, SingleParentHome)
VALUES('116-374-225', 'Barthelemy', 'Allen', 'Male', '(301) 356-1826', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, DateOfBirth, Gender,
                                  [State], ParentsNames, SingleParentHome)
VALUES('804-748-708', 'Tom', Registration.SetDateOfBirth(-5421), 'Male', 'VA', 'Jeannette Wollman', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  SingleParentHome, EmergencyName)
VALUES('602-568-355', 'Robert', 'Hodge', Registration.SetDateOfBirth(-4806), 'Male', 0, 'Ben Ostead');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  HomePhone, SingleParentHome, EmergencyName)
VALUES('700-750-685', 'Peter', 'Rattner', Registration.SetDateOfBirth(-6459),
       'Male', '(301) 799-1112', 0, 'Cheryl Gurman');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  HomePhone, SingleParentHome)
VALUES('414-548-005', 'Jennifer', 'Gleason', Registration.SetDateOfBirth(-5106),
       'Female', '(301) 791-3100', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  City, [State])
VALUES('204-270-622', 'Dominique', 'DeSalvo', Registration.SetDateOfBirth(-6112), 'Male', 'McLean', 'VA');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender)
VALUES('424-470-284', 'Jason', 'Savio', Registration.SetDateOfBirth(-6170), 'Male');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  [State], HomePhone, SingleParentHome)
VALUES('470-708-470', 'Kenneth', 'Nolan', 'Male', 'DC', '(301) 879-4567', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth,
                                  City, [State], ParentsNames,
                                  SingleParentHome, EmergencyPhone)
VALUES('558-600-085', 'Beth', 'Shaw', Registration.SetDateOfBirth(-6510), 'College Park', 'MD',
       'Nadine & Michael Josephson', 0, '(301) 206-8623');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth,
                                  Gender, HomePhone, ParentsNames)
VALUES('202-570-829', 'Stephen', 'Tamko', Registration.SetDateOfBirth(-6581), 'Male',
       '(301) 490-6390', 'Christopher & Anita Tamko');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [State], HomePhone, SingleParentHome)
VALUES('669-957-008', 'Bill', 'Jachym', Registration.SetDateOfBirth(-6204),
       'Male', 'MD', '301-725-8211', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  ParentsNames, SingleParentHome, EmergencyName)
VALUES('400-849-072', 'Carolyn', 'Parade', Registration.SetDateOfBirth(-6491),
       'Female', 'Bethanie Pedreira', 0, 'Bethanie Pedreira');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, DateOfBirth,
                                  [Address], City, [State], ZIPCode, 
                                  ParentsNames, SingleParentHome, EmergencyPhone)
VALUES('205-845-066', 'Eric', Registration.SetDateOfBirth(-5483), '14277 Grand Misty Dr.',
       'Arlington', 'VA', '20202', 'David Decarlo', 1, '(703) 652-4412');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  [State], HomePhone, ParentsNames,
                                  SingleParentHome, EmergencyName)
VALUES('114-708-706', 'Barry', 'Traill', 'Male', 'MD', '(301) 359-9190',
       'Andrew Donovan', 0, 'Alicia Donovan');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [State], HomePhone, ParentsNames, SingleParentHome, EmergencyPhone)
VALUES('460-680-494', 'Ken', 'Donston', Registration.SetDateOfBirth(-6537), 'Male', 'MD',
       '(301) 942-7210', 'Eva Donston', 0, '(301) 724-1810');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  City, [State], HomePhone, SingleParentHome)
VALUES('225-763-042', 'Sloan', 'Ricketts', Registration.SetDateOfBirth(-5351),
       'Male', 'Hyattsville', 'MD', '(301) 229-1600', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [State], ParentsNames, SingleParentHome, EmergencyPhone)
VALUES('300-405-072', 'Carlos', 'Williams', Registration.SetDateOfBirth(-6334),
       'Male', 'MD', 'Jeannette Flynn', 0, '(301) 334-1947');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender, ParentsNames)
VALUES('500-524-706', 'Christine', 'Strang', 'Female', 'Betty Schwartz');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  ZIPCode, SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('422-635-004', 'Jasmine', 'Young', Registration.SetDateOfBirth(-5575), 'Female', '21206',
       0, 'Susan Edelmann', '(443) 895-5669');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender)
VALUES('828-4763-44', 'Henry', 'Taschek', Registration.SetDateOfBirth(-4771), 'Male');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  City, [State], HomePhone, SingleParentHome, EmergencyPhone)
VALUES('925-666-006', 'Leslyn', 'F', 'Gibson', Registration.SetDateOfBirth(-5846), 'Female',
       'Laurel', 'MD', '(301) 372-1993', 0, '(240) 420-2100');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [Address], [State], SingleParentHome)
VALUES('802-271-222', 'Austie', 'Walter', Registration.SetDateOfBirth(-5086),
       'Female', '5909 Freemont Ave', 'MD', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  ParentsNames, SingleParentHome, EmergencyName)
VALUES('800-374-500', 'Daniel', 'Drummond', Registration.SetDateOfBirth(-5086),
       'Male', 'Leah Drummond', 1, 'Leah Drummond');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  ParentsNames, EmergencyPhone)
VALUES('200-860-597', 'Brenda', 'P', 'Martin', 'Female',
       'Evelyne Martins', '(301) 952-2580');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  City, [State], ZIPCode, HomePhone, SingleParentHome)
VALUES('800-278-492', 'Raul', 'A', 'Martinez', Registration.SetDateOfBirth(-6429),
       'Male', 'Chevy Chase', 'MD', '20845', '(301) 618-3867', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  [State], EmergencyPhone)
VALUES('315-203-744', 'Gilbert', 'Wallace', Registration.SetDateOfBirth(-5453),
       'Male', 'MD', '(301) 478-2491');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender,
                                  [State], ParentsNames, SingleParentHome)
VALUES('200-963-716', 'Maud', 'M', 'Medford', 'Female', 'MD', 'Johnny & Janet Medford', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
								  Gender, EmergencyPhone)
VALUES('992-890-502', 'Maurizio', 'G', 'Cordero', Registration.SetDateOfBirth(-4893),
       'Male', '(301) 870-6754');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, Gender,
                                  [Address], City, [State], HomePhone, SingleParentHome)
VALUES('660-896-379', 'Pamela', 'F', 'Female', '3022 Connecticut Ave',
       'Chevy Chase', 'MD', '(301) 322-7130', 0);
GO
INSERT INTO Registration.Students(StudentNumber, LastName, DateOfBirth, SingleParentHome)
VALUES('284-965-082', 'Jensen', Registration.SetDateOfBirth(-6209), 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  City, ZIPCode, HomePhone, ParentsNames, SingleParentHome, EmergencyName)
VALUES('400-562-031', 'Patrick', 'D', 'Gravesen', Registration.SetDateOfBirth(-6050), 'Male',
       'Baltimore', '21205', '(301) 984 5792', 'David & Annie Gravesen', 0, 'Annie Gravesen');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth,Gender)
VALUES('680-485-336', 'Ashton', 'Sand', Registration.SetDateOfBirth(-6062), 'Male');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  [State], SingleParentHome, EmergencyName)
VALUES('420-629-702', 'Hugh', 'E', 'Poulsen', Registration.SetDateOfBirth(-5352),
       'Male', 'DC', 0, 'Terry Mulneck');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, Gender)
VALUES('905-737-060', 'Christie', 'N', 'Madsen', 'Female');
GO
INSERT INTO Registration.Students(StudentNumber, LastName, DateOfBirth, Gender,
                                  ParentsNames, SingleParentHome, EmergencyName)
VALUES('490-708-637', 'Lester', Registration.SetDateOfBirth(-5956),
       'Male', 'Donald Jenkins', 0, 'Donald Jenkins');
GO
INSERT INTO Registration.Students(StudentNumber, LastName, DateOfBirth,
                                  [Address], HomePhone, ParentsNames, EmergencyPhone)
VALUES('149-576-304', 'Nicolas', Registration.SetDateOfBirth(-6216), '4202 Birsten Street',
       '(301) 430-7712', 'Margareth & Kenneth Nicholas', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, 
								  Gender, EmergencyName)
VALUES('826-308-066', 'Juanita', 'D', 'Gomez', 'Female', 'Larry Brooks');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth,
								  Gender, [Address], HomePhone, SingleParentHome)
VALUES('194-379-630', 'Lark', 'Edison', Registration.SetDateOfBirth(-5519),
       'Female', '3702 Lottsford Rd', '(301) 841-3346', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  City, [State], ParentsNames, SingleParentHome)
VALUES('135-405-006', 'Annie', 'T', 'Nielsen', Registration.SetDateOfBirth(-5455),
       'Female', 'Washington', 'DC', 'Benjamin Roberts', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender, SingleParentHome)
VALUES('316-058-580', 'Graene', 'Gravesen', 'Female', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  HomePhone, SingleParentHome, EmergencyName)
VALUES('207-908-074', 'Fannie', 'G', 'Morgan', Registration.SetDateOfBirth(-6424),
       'Female', '(301) 628-3200', 0, 'Alexander Graven');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  [State], SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('317-802-906', 'Martin', 'Graham', 'Male', 'MD', 0, 'Randy Goldberg', '(240) 764-5272');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
								  Gender, City, [State], ZIPCode)
VALUES('600-739-404', 'Perry', 'E', 'Vassel', Registration.SetDateOfBirth(-5934),
       'Male', 'Beltsville', 'MD', '20910');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, SingleParentHome)
VALUES('500-080-296', 'Paulette', 'Lee', Registration.SetDateOfBirth(-5502), 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  City, HomePhone, ParentsNames, SingleParentHome, EmergencyName)
VALUES('904-756-882', 'Jane', 'S', 'Michaels', Registration.SetDateOfBirth(-4923),
       'Female', 'Greenbelt', '(301) 736-8747', 'Sarah Larson', 0, 'Steve Michaels');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  [Address], City, [State], ZIPCode, HomePhone)
VALUES('480-706-038', 'Michael', 'Hwang', 'Female', '2882 April Av. #D4',
       'Silver Spring', 'MD', '20906', '(301) 979-0032');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
								  Gender, City, ParentsNames, SingleParentHome)
VALUES('903-739-061', 'Bryan', 'L', 'Larsen', Registration.SetDateOfBirth(-6365), 'Male',
       'Germantown', 'Albert & Michelle Church', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  [State], ParentsNames, SingleParentHome)
VALUES('429-385-648', 'Juan', 'Rodriguez', 'Male', 'MD', 'Jennifer & Linette Winston', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender,
                                  City, [State], ZIPCode, HomePhone, ParentsNames, SingleParentHome)
VALUES('319-470-063', 'Hermine', 'H', 'Lawson', Registration.SetDateOfBirth(-5001),
       'Female', 'Damascus', 'MD', '20904', '301-925-9660', 'James Schneider', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth,
                                  Gender, SingleParentHome)
VALUES('208-683-014', 'Gaston', 'Thomason', Registration.SetDateOfBirth(-4903), 'Male', 1);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  HomePhone, SingleParentHome)
VALUES('428-757-006', 'Jerry', 'Santana', 'Male', '(301) 530-0540', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth,
                                  City, [State], SingleParentHome, EmergencyName, EmergencyPhone)
VALUES('991-652-631', 'Donnie', 'F', 'Aberdeen', Registration.SetDateOfBirth(-5011),
       'Falls Church', 'VA', 0, 'Marie Rodnat', '(703) 434-8756');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  HomePhone, SingleParentHome)
VALUES('250-568-202', 'Roland', 'West', 'Male', '(301) 596-3190', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  EmailAddress, SingleParentHome)
VALUES('740-342-777', 'Vaughn', 'Browns', Registration.SetDateOfBirth(-5683),
       'Male', 'vbrowns@rosh.md.us', 0);
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth, Gender,
                                  City, [State], ParentsNames, SingleParentHome, EmergencyName)
VALUES('482-568-905', 'Alfred', 'Cole', Registration.SetDateOfBirth(-6315),
       'Male', 'Washington', 'DC', 'Vincent and Jacqueline Valerio', 0, 'Vince Valerio');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth,
                                  [Address], HomePhone, ParentsNames,
                                  SingleParentHome, EmergencyName)
VALUES('927-002-957', 'Alfred', 'Muelle', Registration.SetDateOfBirth(-5355), '114 Mandan Street',
       '(301) 834-6380', 'Claire and Leon Muelle', 0, 'Claire Muelle');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, Gender,
                                  [Address], HomePhone, EmailAddress,
                                  ParentsNames, SingleParentHome,
                                  EmergencyName, EmergencyPhone)
VALUES('248-428-605', 'Michelle', 'Gantz', 'Female', '9027 Hillside Rd', '(301) 649-6900',
       'mgantz@rosh.md.us', 'Jason and Kimberly Goldman', 0, 'Kim Goldman', '(301) 386-2882');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, MI, LastName, DateOfBirth, Gender)
VALUES('837-284-825', 'Francine', 'D', 'Lenney', Registration.SetDateOfBirth(-5491), 'Female');
GO
INSERT INTO Registration.Students(StudentNumber, [Address], City, [State], ZIPCode, 
								 SingleParentHome, EmergencyPhone)
VALUES('394-286-002', '3844 John McGill St.', 'Silver Spring', 'MD', '20904', 0, '(301) 567-3236');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, DateOfBirth, Gender,
                                  [Address], ZIPCode, HomePhone,
                                  ParentsNames, SingleParentHome, EmergencyName)
VALUES('284-188-266', 'Mauricette', Registration.SetDateOfBirth(-4966), 'Female', 
       '902 Gothic Lane', '20010', '(202) 434-0034', 'Annette Boyd', 0, 'Annie Boyd');
GO
INSERT INTO Registration.Students(StudentNumber, FirstName, LastName, DateOfBirth,
                                  [Address], [State], ParentsNames, SingleParentHome)
VALUES('822-380-286', '', 'Cleaveland', Registration.SetDateOfBirth(-5147),
       '5205 Varnum Rd', 'MD', 'Charles Easton', 0);
GO