Red Oak High School - Students Records

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