DROP DATABASE IF EXISTS familydocmanagementdb; CREATE DATABASE IF NOT EXISTS familydocmanagementdb; USE familydocmanagementdb; DROP TABLE IF EXISTS family; -- Table Structure for 'family' Entity CREATE TABLE IF NOT EXISTS family ( FamilyID integer NOT NULL, FamilyName varchar(25) NOT NULL, FamilyType varchar(25) NOT NULL, NumOfMembers integer NOT NULL, PRIMARY KEY (FamilyID) ); DROP TABLE IF EXISTS profile; -- Table Structure for 'profile' Entity CREATE TABLE IF NOT EXISTS profile ( profileID varchar(50) UNIQUE NOT NULL, FamilyID integer NOT NULL, FirstName varchar(25) NOT NULL, LastName varchar(25) NOT NULL, DateOfBirth date NOT NULL, EmailAddress varchar(50) NOT NULL, PhoneNumber varchar(9) NOT NULL, AddressSeqNum integer NOT NULL, Dependent tinyint NOT NULL DEFAULT '0', DependentType varchar(25), PRIMARY KEY (profileID), CONSTRAINT profile_FK00 FOREIGN KEY (FamilyID) REFERENCES family(familyID) ); DROP TABLE IF EXISTS address; -- Table Structure for 'address' Entity CREATE TABLE IF NOT EXISTS address ( AddressSeqNum integer NOT NULL, DoorNo integer NOT NULL, Street varchar(25) NOT NULL, AptNo integer, City varchar(25) NOT NULL, State varchar(25) NOT NULL, Country varchar(25) NOT NULL, ZipCode integer NOT NULL, CurrentAddress tinyint NOT NULL DEFAULT '0', profileID varchar(50) NOT NULL, PRIMARY KEY (AddressSeqNum), CONSTRAINT Address_FK00 FOREIGN KEY (profileID) REFERENCES profile (profileID) ); DROP TABLE IF EXISTS document_types; -- Table Structure for 'document_sub_types' entity CREATE TABLE IF NOT EXISTS document_types ( DocumentTypeID integer UNIQUE NOT NULL, DocumentTypeName varchar(25) NOT NULL, PRIMARY KEY (DocumentTypeID) ); DROP TABLE IF EXISTS document_subtypes; -- Table Structure for 'document_types' entity CREATE TABLE IF NOT EXISTS document_subtypes ( DocumentSubTypeID integer UNIQUE NOT NULL, DocumentSubTypeName varchar(25) NOT NULL, DocumentTypeID integer NOT NULL, PRIMARY KEY (DocumentSubTypeID), CONSTRAINT DocumentSubTypes_FK00 FOREIGN KEY (DocumentTypeID) REFERENCES document_types (DocumentTypeID) ); DROP TABLE IF EXISTS job_details; -- Table Structure for 'job_details' entity CREATE TABLE IF NOT EXISTS job_details ( JobDetailID integer UNIQUE NOT NULL AUTO_INCREMENT, PositionName varchar(25) NOT NULL, CompanyName varchar(25) NOT NULL, HourlySalaryUSD integer NOT NULL, JobCity varchar(25) NOT NULL, JobState varchar(25) NOT NULL, JobStartDate date NOT NULL, JobEndDate date, CurrentJob tinyint NOT NULL DEFAULT '0', profileID varchar(50) NOT NULL, DocumentSubTypeID integer NOT NULL, PRIMARY KEY (JobDetailID), CONSTRAINT JobDetails_FK00 FOREIGN KEY (profileID) REFERENCES profile (profileID), CONSTRAINT JobDetails_FK01 FOREIGN KEY (DocumentSubTypeID) REFERENCES document_subtypes (DocumentSubTypeID) ); DROP TABLE IF EXISTS rental_property; -- Table Structure for 'rental_property' entity CREATE TABLE IF NOT EXISTS rental_property ( RentalID integer UNIQUE NOT NULL AUTO_INCREMENT, TenantID varchar(50) NOT NULL, OwnerName varchar(25) NOT NULL, RentalType varchar(25) NOT NULL, RntDoorNo integer NOT NULL, RntStreet varchar(25) NOT NULL, RntAptNo integer, RntCity varchar(25) NOT NULL, RntState varchar(25) NOT NULL, RntCountry varchar(25) NOT NULL, RntZipCode integer NOT NULL, RntMgmtPhoneCountryCode varchar(2) NOT NULL, RntMgmtPhoneNumber varchar(10) NOT NULL, RentalLeaseStart date NOT NULL, RentalLeaseEnd date NOT NULL, DocumentSubTypeID integer NOT NULL, PRIMARY KEY (RentalID), CONSTRAINT RentalProperty_FK00 FOREIGN KEY (TenantID) REFERENCES profile (profileID), CONSTRAINT RentalProperty_FK01 FOREIGN KEY (DocumentSubTypeID) REFERENCES document_subtypes (DocumentSubTypeID) ); DROP TABLE IF EXISTS family_property; -- Table Structure for 'family_property' entity CREATE TABLE IF NOT EXISTS family_property ( FamilyPropertyID integer UNIQUE NOT NULL AUTO_INCREMENT, FamilyID integer NOT NULL, OwnerID varchar(50) NOT NULL, PropertyType varchar(25) NOT NULL, FamPropDoorNo integer NOT NULL, FamPropStreet varchar(25) NOT NULL, FamPropAptNo integer, FamPropCity varchar(25) NOT NULL, FamPropState varchar(25) NOT NULL, FamPropCountry varchar(25) NOT NULL, FamPropZipCode integer NOT NULL, PropertyPurchaseDate date NOT NULL, FamPropMgmtPhoneCountryCode varchar(2) NOT NULL, FamPropMgmtPhoneNumber varchar(10) NOT NULL, DocumentSubTypeID integer NOT NULL, PRIMARY KEY (FamilyPropertyID), CONSTRAINT FamilyProperty_FK00 FOREIGN KEY (OwnerID) REFERENCES profile (profileID), CONSTRAINT FamilyProperty_FK01 FOREIGN KEY (FamilyID) REFERENCES family (FamilyID), CONSTRAINT FamilyProperty_FK02 FOREIGN KEY (DocumentSubTypeID) REFERENCES document_subtypes (DocumentSubTypeID) ); DROP TABLE IF EXISTS identification_info; -- Table Structure for 'identification_info' entity CREATE TABLE IF NOT EXISTS identification_info ( IdentificationDocID varchar(6) UNIQUE NOT NULL, FamilyID integer NOT NULL, DocumentHolderID varchar(50) NOT NULL, DocumentSubTypeID integer NOT NULL, IssuanceDate date NOT NULL, ExpirationDate date NULL, PRIMARY KEY (IdentificationDocID), CONSTRAINT IdentificationInfo_FK00 FOREIGN KEY (DocumentHolderID) REFERENCES profile (profileID), CONSTRAINT IdentificationInfo_FK01 FOREIGN KEY (FamilyID) REFERENCES family (FamilyID), CONSTRAINT IdentificationInfo_FK02 FOREIGN KEY (DocumentSubTypeID) REFERENCES document_subtypes (DocumentSubTypeID) ); DROP TABLE IF EXISTS memberships; -- Table Structure for 'memberships' entity drop table if exists memberships; CREATE TABLE IF NOT EXISTS memberships ( MembershipID int UNIQUE NOT NULL AUTO_INCREMENT, FamilyID integer NOT NULL, MembershipHolderID varchar(50) NOT NULL, DocumentSubTypeID integer NOT NULL, MembershipName varchar(30) NOT NULL, MembershipStartDate date NOT NULL, MembershipEndDate date, MembershipCost decimal(15,2), PRIMARY KEY (MembershipID), CONSTRAINT Memberships_FK00 FOREIGN KEY (MembershipHolderID) REFERENCES profile (profileID), CONSTRAINT Memberships_FK01 FOREIGN KEY (FamilyID) REFERENCES family (FamilyID), CONSTRAINT Memberships_FK02 FOREIGN KEY (DocumentSubTypeID) REFERENCES document_subtypes (DocumentSubTypeID) ); DROP TABLE IF EXISTS academic_records; -- Table Structure for 'academic_records' entity CREATE TABLE IF NOT EXISTS academic_records ( AcademicRecordID integer UNIQUE NOT NULL AUTO_INCREMENT, profileID varchar(50) NOT NULL, EducationType varchar(25) NOT NULL, CompletedEducationType tinyint NOT NULL DEFAULT '0', DocumentSubTypeID integer NOT NULL, GraduationDate date NOT NULL, PRIMARY KEY (AcademicRecordID), CONSTRAINT AcademicRecords_FK00 FOREIGN KEY (profileID) REFERENCES profile (profileID), CONSTRAINT AcademicRecords_FK01 FOREIGN KEY (DocumentSubTypeID) REFERENCES document_subtypes (DocumentSubTypeID) ); DROP TABLE IF EXISTS insurance_details; -- Table Structure for 'insurance_details' entity CREATE TABLE IF NOT EXISTS insurance_details ( InsuranceID varchar(50) UNIQUE NOT NULL, InsuranceHolderID varchar(50) NOT NULL, FamilyID integer NOT NULL, InsurancePlanName varchar(50) NOT NULL, InsuranceCompany varchar(50) NOT NULL, InsuranceStartDate date NOT NULL, InsuranceExpirationDate date NOT NULL, EmployerOffered tinyint NOT NULL DEFAULT '0', InsurancePremium decimal(9, 2), Coverage varchar(50) NOT NULL, DocumentSubTypeID integer NOT NULL, PRIMARY KEY (InsuranceID), CONSTRAINT InsuranceDetails_FK00 FOREIGN KEY (InsuranceHolderID) REFERENCES profile (profileID), CONSTRAINT InsuranceDetails_FK01 FOREIGN KEY (FamilyID) REFERENCES family (FamilyID), CONSTRAINT InsuranceDetails_FK02 FOREIGN KEY (DocumentSubTypeID) REFERENCES document_subtypes (DocumentSubTypeID) ); DROP TABLE IF EXISTS medical_records; -- Table Structure for medical_records entity CREATE TABLE IF NOT EXISTS medical_records ( MedRecID integer UNIQUE NOT NULL AUTO_INCREMENT, DateOfVisit date NOT NULL, profileID varchar(50) NOT NULL, DocumentSubTypeID int NOT NULL, TypeOfIllness varchar(50), DoctorName varchar(50), PRIMARY KEY (MedRecID), CONSTRAINT MedicalRecords_FK00 FOREIGN KEY (profileID) REFERENCES profile (profileID), CONSTRAINT MedicalRecords_FK01 FOREIGN KEY (DocumentSubTypeID) REFERENCES document_subtypes (DocumentSubTypeID) ); DROP TABLE IF EXISTS reminders; -- Table Structure for 'reminders' entity CREATE TABLE IF NOT EXISTS reminders ( EventID integer UNIQUE NOT NULL AUTO_INCREMENT, EventDate date NOT NULL, EventName varchar(50) NOT NULL, RecurringEvent tinyint NOT NULL DEFAULT '0', profileID varchar(50) NOT NULL, DocumentSubTypeID integer NOT NULL, PRIMARY KEY (EventID), CONSTRAINT Reminders_FK00 FOREIGN KEY (profileID) REFERENCES profile (profileID), CONSTRAINT Reminders_FK01 FOREIGN KEY (DocumentSubTypeID) REFERENCES document_subtypes (DocumentSubTypeID) ); CREATE TABLE IF NOT EXISTS document_locations ( DocLocationID integer UNIQUE NOT NULL, FamilyID integer NOT NULL, DocumentTypeID integer not null, DocumentTypeName varchar (25) not null, PhysicalLocation varchar(50) NOT NULL, ElectronicLocation varchar(50) NOT NULL, PRIMARY KEY (DocLocationID), CONSTRAINT DocumentLocations_FK00 FOREIGN KEY (FamilyID) REFERENCES family (FamilyID), CONSTRAINT DocumentLocations_FK01 FOREIGN KEY (DocumentTypeID) REFERENCES document_types (DocumentTypeID) ); INSERT INTO family VALUES ('123','Goswamy','nuclear','6'); INSERT INTO family VALUES ('984','Iyer','nuclear','6'); INSERT INTO family VALUES ('742','Sharma','nuclear','6'); SELECT * FROM family; INSERT INTO profile VALUES ('BhuvanG0001','123','Bhuvan','Goswamy','1948-11-29','bhuvangoswamy11@gmail.com','469100119','7676',1,'elderly'); INSERT INTO profile VALUES ('SeethaG0002','123','Seetha','Goswamy','1950-09-02','seethagoswamy11@gmail.com','469101908','7676',1,'elderly'); INSERT INTO profile VALUES ('RaviG151','123','Ravi','Goswamy','1975-09-12','goswamyravi@gmail.com','98400110','7676',0,'working adult'); INSERT INTO profile VALUES ('MeenaiG150','123','Meenai','Goswamy','1975-02-13','goswamyMeenai@gmail.com','984330090','7676',1,'working adult'); INSERT INTO profile VALUES ('AnkitG1004','123','Ankit','Goswamy','2003-02-13','agoswamy@gmail.com','984312098','7676',1,'child'); INSERT INTO profile VALUES ('NainaG1005','123','Naina','Goswamy','2006-02-13','naina_goswamyMeenai@gmail.com','984421098','7676',1,'child'); INSERT INTO profile VALUES ('SundaranI0199','984','Sundaran','Iyer','1959-01-30','sundaraniyer11@gmail.com','469108119','420',1,'elderly'); INSERT INTO profile VALUES ('KamakshiI0200','984','Kamakshi','Iyer','1962-08-02','kamakshiiyer11@gmail.com','469101907','420',1,'elderly'); INSERT INTO profile VALUES ('SureshanI1600','984','Sureshan','Iyer','1984-10-10','iyersureshan@gmail.com','98400111','420',0,'working adult'); Insert into profile VALUES ('KamalaI1590','984','Kamala','Iyer','1986-06-13','iyerki@gmail.com','984330096','420',1,'working adult'); INSERT INTO profile VALUES ('DeviI1015','984','Devi','Iyer','2009-06-19','devi_iyer@gmail.com','984312099','420',1,'child'); INSERT INTO profile VALUES ('DritiI1014','984','Driti','Iyer','2011-09-13','driti_iyer@gmail.com','984421090','420',1,'child'); INSERT INTO profile VALUES ('YogiS2349','742','Yogi','Sharma','1945-03-13','yogisharma@gmail.com','989108119','999',1,'elderly'); INSERT INTO profile VALUES ('AshaS2333','742','Asha','Sharma','1955-07-01','ashasharma@gmail.com','469101929','999',1,'elderly'); INSERT INTO profile VALUES ('PrateekSS988','742','Prateek','Sharma','1980-01-01','prateek.sha@gmail.com','98770111','999',0,'working adult'); INSERT INTO profile VALUES ('GopiS989','742','Gopi','Sharma','1980-03-13','gopi_sharma13@gmail.com','984310896','999',1,'working adult'); INSERT INTO profile VALUES ('RohanS098','742','Rohan','Sharma','2006-04-20','rosha@gmail.com','981212099','999',1,'child'); INSERT INTO profile VALUES ('RahulS100','742','Rahul','Sharma','2010-07-13','rahul_sharma@gmail.com','984432090','999',1,'child'); SELECT * FROM profile; INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7676', 101, 'Main Street', NULL, 'Dallas', 'TX', 'USA', 75201, 1, 'BhuvanG0001'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7677', 101, 'Main Street', NULL, 'Dallas', 'TX', 'USA', 75201, 1, 'SeethaG0002'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7678', 200, 'Second Street', 100, 'Dallas', 'TX', 'USA', 75201, 0, 'RaviG151'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7679', 200, 'Second Street', 100, 'Dallas', 'TX', 'USA', 75201, 0, 'MeenaiG150'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7680', 300, 'Third Street', NULL, 'Dallas', 'TX', 'USA', 75201, 1, 'AnkitG1004'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7681', 300, 'Third Street', NULL, 'Dallas', 'TX', 'USA', 75201, 1, 'NainaG1005'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7682', 101, 'Main Street', NULL, 'Houston', 'TX', 'USA', 77001, 1, 'SundaranI0199'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7683', 101, 'Main Street', NULL, 'Houston', 'TX', 'USA', 77001, 1, 'KamakshiI0200'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7684', 200, 'Second Street', 100, 'Houston', 'TX', 'USA', 77001, 0, 'SureshanI1600'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7685', 200, 'Second Street', 100, 'Houston', 'TX', 'USA', 77001, 0, 'KamalaI1590'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7686', 300, 'Third Street', NULL, 'Houston', 'TX', 'USA', 77001, 1, 'DeviI1015'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7687', 300, 'Third Street', NULL, 'Houston', 'TX', 'USA', 77001, 1, 'DritiI1014'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7688', 23, 'Ashok Nagar', 0, 'Chennai', 'Tamil Nadu', 'India', 600083, 0, 'YogiS2349'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7689', 89, 'Iyyappa Nagar', 0, 'Chennai', 'Tamil Nadu', 'India', 600106, 1, 'AshaS2333'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7690', 123, 'Ramamurthy Nagar', 0, 'Bangalore', 'Karnataka', 'India', 560016, 0, 'PrateekSS988'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7691', 75, 'Shankar Nagar', 0, 'Bangalore', 'Karnataka', 'India', 560096, 1, 'GopiS989'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7692', 45, 'MG Road', 0, 'Bangalore', 'Karnataka', 'India', 560008, 0, 'RohanS098'); INSERT INTO address (AddressSeqNum, DoorNo, Street, AptNo, City, State, Country, ZipCode, CurrentAddress, profileID) VALUES ('7693', 69, 'Hebbal', 0, 'Bangalore', 'Karnataka', 'India', 560069, 0, 'RahulS100'); select * from address; INSERT INTO document_types values('18431','Job Details'); INSERT INTO document_types values('18432','Rental Property'); INSERT INTO document_types values('18433','Family Property'); INSERT INTO document_types values('18435','Membership'); INSERT INTO document_types values('18436','Identification Info'); INSERT INTO document_types values('18437','Insurance Details'); INSERT INTO document_types values('18438','Medical Records'); INSERT INTO document_types values('18439','Reminders'); INSERT INTO document_types values('18440','Academic Records'); select * from document_types; INSERT INTO document_subtypes VALUES('25001','Intern','18431'); INSERT INTO document_subtypes VALUES('25002','Rental Lease','18432'); INSERT INTO document_subtypes VALUES('25003','Property','18433'); INSERT INTO document_subtypes VALUES('25004','SSN','18436'); INSERT INTO document_subtypes VALUES('25005','Drivers License','18436'); INSERT INTO document_subtypes VALUES('25007','Passport','18436'); INSERT INTO document_subtypes VALUES('25006','Birth Certificate','18436'); INSERT INTO document_subtypes VALUES('25008','Visas','18436'); INSERT INTO document_subtypes VALUES('25009','School ID','18436'); INSERT INTO document_subtypes VALUES('25010','Employement ID','18436'); INSERT INTO document_subtypes VALUES('25011','Costco Membership', '18435'); INSERT INTO document_subtypes VALUES('25012','Gold Gym','18435'); INSERT INTO document_subtypes VALUES('25013','Walmart Plus','18435'); INSERT INTO document_subtypes VALUES('25014','Country Club','18435'); INSERT INTO document_subtypes VALUES('25015','AMC Theatre','18435'); INSERT INTO document_subtypes VALUES('25016','Apple TV','18435'); INSERT INTO document_subtypes VALUES('25017','Apple Music','18435'); INSERT INTO document_subtypes VALUES('25018','Soccer Club','18435'); INSERT INTO document_subtypes VALUES('25019','Mileage Plan','18435'); INSERT INTO document_subtypes VALUES('25020','High School Diploma','18440'); INSERT INTO document_subtypes VALUES('25021','Undergrad','18440'); INSERT INTO document_subtypes VALUES('25022','Graduate','18440'); INSERT INTO document_subtypes VALUES('25023','Doctorate','18440'); INSERT INTO document_subtypes VALUES('25026','Degree','18440 '); INSERT INTO document_subtypes VALUES('25024','certificate Programme','18440'); INSERT INTO document_subtypes VALUES('25027','Report Cards','18440'); INSERT INTO document_subtypes VALUES('25028','Health Insurance','18437'); INSERT INTO document_subtypes VALUES('25029','Life Insurance','18437'); INSERT INTO document_subtypes VALUES('25030','Travel Insurance','18437'); INSERT INTO document_subtypes VALUES('25031','Auto Insurance','18437'); INSERT INTO document_subtypes VALUES('25034','Prescriptions','18438'); INSERT INTO document_subtypes VALUES('25035','Vaccinationcards','18438'); INSERT INTO document_subtypes VALUES('25036','MedicalHistory','18438'); INSERT INTO document_subtypes VALUES('25037','Birthday','18439'); INSERT INTO document_subtypes VALUES('25038','Anniversary','18439'); INSERT INTO document_subtypes VALUES('25040','ExtraCurriculars','18439'); INSERT INTO document_subtypes VALUES('25041','Exams','18439'); INSERT INTO document_subtypes VALUES('25042','Meetings','18439'); INSERT INTO document_subtypes VALUES('25043','Baby Shower','18439'); INSERT INTO document_subtypes VALUES('25044','Appointment','18439'); INSERT INTO document_subtypes VALUES('25045','Weddings','18439'); INSERT INTO document_subtypes VALUES('25046','Bills','18439'); INSERT INTO document_subtypes VALUES('25047','Assignment','18439'); INSERT INTO document_subtypes VALUES('25048','Dallas Yoga','18435'); INSERT INTO document_subtypes VALUES('25049','Spin Class','18435'); INSERT INTO document_subtypes VALUES('25050','Netflix','18435'); INSERT INTO document_subtypes VALUES('25051','Spotify','18435'); INSERT INTO document_subtypes VALUES('25052','HBO Max','18435'); INSERT INTO document_subtypes VALUES('25053','Dance Class','18435'); INSERT INTO document_subtypes VALUES('25054','Minor ID','18436'); INSERT INTO document_subtypes VALUES('25055','Offer Letter','18431'); select * from document_subtypes; INSERT INTO job_details VALUES ('1001', 'Developer', 'Infosys Technologies', '30', 'Bangalore', 'Karnataka', '2014-05-01', '2021-02-01', '0', 'PrateekSS988', '25055'); INSERT INTO job_details VALUES ('1002', 'Sales Manager', 'Wipro Limited', '40', 'Bangalore', 'Karnataka', '2016-05-01', '2018-05-01', '0', 'GopiS989', '25055'); INSERT INTO job_details VALUES ('1003', 'Marketing', 'Halliburton Company', '35', 'Houston', 'Texas', '2014-05-01', '2017-03-01', '0', 'KamalaI1590', '25055'); INSERT INTO job_details VALUES ('1004', 'Engineer', 'ConocoPhillips', '45', 'Houston', 'Texas', '2013-07-01', '2018-07-01', '0', 'SureshanI1600', '25055'); INSERT INTO job_details VALUES ('1005', 'Accountant', 'American Airlines', '30', 'Dallas', 'Texas', '2015-09-01', '2019-09-01', '0', 'RaviG151', '25055'); INSERT INTO job_details VALUES ('1006', 'HR Associate', 'Texas Instruments Inc', '55', 'Dallas', 'Texas', '2016-11-01', '2020-11-01', '0', 'MeenaiG150', '25055'); INSERT INTO job_details VALUES ('1007', 'Senior Developer', 'Oracle Corporation', '70', 'Atlanta', 'Georgia', '2021-05-01', NULL, '1', 'PrateekSS988', '25055'); INSERT INTO job_details VALUES ('1008', 'Sales Manager', 'Amazon.com Inc.', '75', 'Atlanta', 'Georgia', '2022-05-01', NULL, '1', 'GopiS989', '25055'); INSERT INTO job_details VALUES ('1009', 'Senior Accountant', 'AT&T Inc.', '60', 'Dallas', 'Texas', '2019-10-01', NULL, '1', 'RaviG151', '25055'); INSERT INTO job_details VALUES ('1010', 'HR Manager', 'Deloitte LLP', '80', 'Dallas', 'Texas', '2020-12-01', NULL, '1', 'MeenaiG150', '25055'); INSERT INTO job_details VALUES ('1011', 'Marketing Executive', 'Chevron Corporation', '70', 'San Francisco', 'California', '2017-05-01', NULL, '1', 'KamalaI1590', '25055'); INSERT INTO job_details VALUES ('1012', 'Senior Engineer', 'ConocoPhillips', '80', 'San Francisco', 'California', '2018-08-01', NULL, '1', 'SureshanI1600', '25055'); INSERT INTO family_property VALUES('1','123','BhuvanG0001','House','6','MGRoad',NULL,'Delhi','Delhi','INDIA','110001','1980-09-03','91','9845765555','25003'); INSERT INTO family_property VALUES('2','742','YogiS2349','House','4','Queen’sRoad',NULL,'Ahmedabad','Gujarat','INDIA','380001','1980-12-31','91','9986456185','25003'); INSERT INTO family_property VALUES('3','123','SeethaG0002','Salon','5','MGRoad','5003','Delhi','Delhi','INDIA','110001','1981-06-23','91','9912465956','25003'); INSERT INTO family_property VALUES('4','123','BhuvanG0001','Restaurant','4','MGRoad','4005','Delhi','Delhi','INDIA','110001','1982-09-18','91','9916456888','25003'); INSERT INTO family_property VALUES('5','984','SundaranI0199','House','5','HillRoad',NULL,'Hyderabad','Telangana','INDIA','500001','1992-05-15','91','9878825666','25003'); INSERT INTO family_property VALUES('6','742','AshaS2333','Bakeshop','7','Queen’sRoad','7002','Ahmedabad','Gujarat','INDIA','380001','1994-08-20','91','9945130952','25003'); INSERT INTO family_property VALUES('7','742','YogiS2349','Salon','6','Queen’sRoad','6005','Ahmedabad','Gujarat','INDIA','380001','1994-09-19','91','9812130952','25003'); INSERT INTO family_property VALUES('8','984','KamakshiI0200','Restaurant','9','HillRoad','9003','Hyderabad','Telangana','INDIA','500001','1996-02-06','91','9876123165','25003'); INSERT INTO family_property VALUES('9','742','YogiS2349','Salon','7','Queen’sRoad','1005','Ahmedabad','Gujarat','INDIA','380001','1996-04-25','91','9889825666','25003'); INSERT INTO family_property VALUES('10','984','SundaranI0199','Ranch','5','Ringroad',NULL,'Hyderabad','Telangana','INDIA','500001','2005-05-14','91','9886498952','25003'); INSERT INTO family_property VALUES('11','123','RaviG151','House','2','BealeStreet',NULL,'Dallas','Texas','USA','75080','2010-08-07','1','9728338757','25003'); INSERT INTO family_property VALUES('12','742','PrateekSS988','House','3','DuvalStreet',NULL,'Atlanta','Georgia','USA','30318','2015-06-14','1','4698019271','25003'); INSERT INTO family_property VALUES('13','742','GopiS989','Salon','1','Duval Street','1002','Atlanta','Georgia','USA','30318','2017-09-09','1','8882277394','25003'); INSERT INTO family_property VALUES('14','123','MeenaiG150','Salon','5','Beale Street','5006','Dallas','Texas','USA','75080','2019-12-24','1','4694239474','25003'); INSERT INTO family_property VALUES('15','984','SureshanI1600','House','9','Peachtree Street',NULL,'San fransisco','California','USA','90067','2022-07-18','1','4699148956','25003'); INSERT INTO family_property VALUES('16','984','KamalaI1590','Cake shop','8','Peachtree Street','8001','San fransisco','California','USA','90067','2022-12-12','1','9726456841','25003'); SELECT * FROM family_property; INSERT INTO rental_property VALUES('1','YogiS2349','Vivek Sharma','Apartment','7','Hill Palace Road','7106','Pune','Maharashtra','INDIA','411001','91','9879915777','1962-09-04','1970-09-03','25002'); INSERT INTO rental_property VALUES('2','BhuvanG0001','Balaji Kathirvaran','Apartment','1','Linking Road','1603','Mumbai','Maharashtra','INDIA','400001','91','9989123165','1963-01-01','1970-12-31','25002'); INSERT INTO rental_property VALUES('3','SeethaG0002','Srikanth Joshi','Apartment','3','Park Street','3201','Bangalore','Karnataka','INDIA','560001','91','9965498952','1964-02-14','1972-02-13','25002'); INSERT INTO rental_property VALUES('4','AshaS2333','Ankit Ghosh','Apartment','9','Pantheon Road','9004','Jaipur','Rajasthan','INDIA','302001','91','9845765555','1970-06-08','1980-06-07','25002'); INSERT INTO rental_property VALUES('5','BhuvanG0001','Raj Kumar','House','2','MG Road',NULL,'Delhi','Delhi','INDIA','110001','91','9986456185','1972-01-01','1980-12-31','25002'); INSERT INTO rental_property VALUES('6','SundaranI0199','Ramachandran Venkat','Apartment','4','Brigade Road','4101','Chennai','Tamil Nadu','INDIA','600001','91','9912465956','1976-05-16','1983-05-15','25002'); INSERT INTO rental_property VALUES('7','KamakshiI0200','Abhijith Baskar','Apartment','6','Janpath','6002','Kolkata','West Bengal','INDIA','700001','91','9916456888','1978-09-30','1983-09-29','25002'); INSERT INTO rental_property VALUES('8','YogiS2349','Deepa Rajendran','House','8','Queen’s Road',NULL,'Ahmedabad','Gujarat','INDIA','380001','91','9878825666','1979-09-04','1980-09-03','25002'); INSERT INTO rental_property VALUES('9','SundaranI0199','Diwakar Iyer','House','5','Hill Road',NULL,'Hyderabad','Telangana','INDIA','500001','91','9945130952','1983-05-16','1992-05-15','25002'); INSERT INTO rental_property VALUES('10','MeenaiG150','Aravind Swamy','Apartment','5','Brigade Road','5301','Thiruvananthapuram','Kerala','INDIA','695001','91','9812130952','1990-06-13','1992-06-12','25002'); INSERT INTO rental_property VALUES('11','RaviG151','Rakshit Ganesh','Apartment','1','Linking Road','1003','Lucknow','Uttar Pradesh','INDIA','226001','91','9876123165','1990-08-08','1992-08-07','25002'); INSERT INTO rental_property VALUES('12','MeenaiG150','Krithika Jayaram','Apartment','6','Hill Road','6303','Indore','Madhya Pradesh','INDIA','452001','91','9845456888','1992-06-13','1998-06-12','25002'); INSERT INTO rental_property VALUES('13','RaviG151','Ganesh Jaganathan','Apartment','2','MG Road,','2103','Kochi','Kerala','INDIA','682001','91','9889456185','1992-08-08','1996-08-07','25002'); INSERT INTO rental_property VALUES('14','PrateekSS988','Priyanka Rajkumar','Apartment','8','Linking Road','8203','Ahmedabad','Gujarat','INDIA','380001','91','9889825666','1995-08-08','1997-08-07','25002'); INSERT INTO rental_property VALUES('15','RaviG151','Ravi Goswamy','Apartment','3','Park Street','3203','Chandigarh','Punjab/Haryana','INDIA','160017','91','9886498952','1996-08-07','2003-08-08','25002'); INSERT INTO rental_property VALUES('16','PrateekSS988','Prateek Sharma','Apartment','9','MG Road,','9302','Jaipur','Rajasthan','INDIA','302001','91','9886765555','1997-08-08','1999-08-07','25002'); INSERT INTO rental_property VALUES('17','GopiS989','Jagadish Sodima','Apartment','4','Hill Palace Road','4006','Chennai','Tamil Nadu','INDIA','600001','91','9916456956','1997-08-19','2002-08-18','25002'); INSERT INTO rental_property VALUES('18','MeenaiG150','Ajith Kannan','Apartment','7','Janpath','7302','Visakhapatnam','Andhra Pradesh','INDIA','530001','91','9816915777','1998-06-13','2003-08-08','25002'); INSERT INTO rental_property VALUES('19','PrateekSS988','Shawn Srijith','Apartment','1','Park Street','1303','Lucknow','Uttar Pradesh','INDIA','226001','91','9865456956','1999-08-07','2004-08-08','25002'); INSERT INTO rental_property VALUES('20','GopiS989','Deepak Gowrikumar','Apartment','5','Queen’s Road','5004','Hyderabad','Telangana','INDIA','500001','91','9979498952','2002-08-19','2006-08-18','25002'); INSERT INTO rental_property VALUES('21','SureshanI1600','Madan Mohan Raj','Apartment','8','Hill Palace Road','8101','Varanasi','Uttar Pradesh','INDIA','221001','91','9879825666','2003-07-19','2005-07-18','25002'); INSERT INTO rental_property VALUES('22','RaviG151','Murali Anandharaj','House','4','Beale Street,',NULL,'Dallas','Texas','USA','75080','1','4699148956','2003-08-07','2010-08-07','25002'); INSERT INTO rental_property VALUES('23','PrateekSS988','Gowri Pradeep','Apartment','2','Brigade Road','2202','Kochi','Kerala','INDIA','682001','91','9812915952','2004-08-08','2011-06-12','25002'); INSERT INTO rental_property VALUES('24','KamalaI1590','Ravi Kumar','Apartment','4','Linking Road','4102','Chennai','Tamil Nadu','INDIA','600001','91','9879465956','2004-08-11','2005-08-10','25002'); INSERT INTO rental_property VALUES('25','SureshanI1600','Prakash Ranganathan','Apartment','9','Queen’s Road','9003','Amritsar','Punjab','INDIA','143001','91','9778765555','2005-07-19','2009-07-18','25002'); INSERT INTO rental_property VALUES('26','KamalaI1590','Gopinath Vijaykumar','Apartment','5','MG Road','5103','Hyderabad','Telangana','INDIA','500001','91','9878130952','2005-08-11','2010-08-10','25002'); INSERT INTO rental_property VALUES('27','GopiS989','Gaurav Nair','Apartment','6','Pantheon Road','6007','Kolkata','West Bengal','INDIA','700001','91','9978465888','2006-08-19','2007-08-18','25002'); INSERT INTO rental_property VALUES('28','GopiS989','Meenakshi Iyer','Apartment','7','Brigade Road','7009','Pune','Maharashtra','INDIA','411001','91','9845130777','2007-08-19','2011-06-12','25002'); INSERT INTO rental_property VALUES('29','SureshanI1600','Virat Dadlani','Apartment','1','Pantheon Road','1001','Agra','Uttar','INDIA','282001','91','9745123165','2009-07-19','2013-07-18','25002'); INSERT INTO rental_property VALUES('30','KamalaI1590','Sarojini Prakash','Apartment','6','Park Street','6103','Kolkata','West Bengal','INDIA','700001','91','9845456888','2010-08-11','2013-08-10','25002'); INSERT INTO rental_property VALUES('31','PrateekSS988','Akshath Tiwari','House','3','Duval Street',NULL,'Atlanta','Georgia','USA','30318','1','9728338757','2011-06-13','2015-06-14','25002'); INSERT INTO rental_property VALUES('32','SureshanI1600','Muthukumar Iyer','Apartment','2','Broadway','2101','New york','New york','USA','11368','1','4698019271','2013-07-19','2018-07-18','25002'); INSERT INTO rental_property VALUES('33','KamalaI1590','Rajendran Swamy','Apartment','7','Brigade Road','7301','Pune','Maharashtra','INDIA','411001','91','9876915777','2013-08-11','2018-07-18','25002'); INSERT INTO rental_property VALUES('34','SureshanI1600','Eshwaran Sharma','House','3','Peachtree Street',NULL,'San fransisco','California','USA','90067','1','8882277394','2018-07-19','2023-07-18','25002'); INSERT INTO rental_property VALUES('35','AnkitG1004','Sri Venkat','Apartment','8','Lombard Street','8003','Denver','Colorado','USA','80206','1','4694239474','2022-08-11','2023-08-10','25002'); SELECT * FROM rental_property; INSERT INTO academic_records VALUES (110011,'BhuvanG0001','School',1,25020,'1966-06-11'); INSERT INTO academic_records VALUES (110012,'BhuvanG0001','Undergrad',1,25021,'1970-07-11'); INSERT INTO academic_records VALUES (110013,'SeethaG0002','School',1,25020,'1968-06-06'); INSERT INTO academic_records VALUES (110014,'SeethaG0002','Undergrad',1,25021,'1972-08-07'); INSERT INTO academic_records VALUES (110015,'SeethaG0002','Masters',1,25022,'1981-04-07'); INSERT INTO academic_records VALUES (110016,'SeethaG0002','Doctorate',1,25023,'1972-08-07'); INSERT INTO academic_records VALUES (110017,'MeenaiG150','School',1,25020,'1993-06-10'); INSERT INTO academic_records VALUES (110018,'MeenaiG150','Undergrad',1,25021,'1996-06-03'); INSERT INTO academic_records VALUES (110019,'MeenaiG150','Masters',0,25022,'2024-05-10'); INSERT INTO academic_records VALUES (110020,'RaviG151','School',1,25020,'1993-06-10'); INSERT INTO academic_records VALUES (110021,'RaviG151','Undergrad',1,25021,'1997-07-10'); INSERT INTO academic_records VALUES (110022,'AnkitG1004','School',1,25020,'2021-06-05'); INSERT INTO academic_records VALUES (110023,'AnkitG1004','Undergrad',0,25021,'2024-07-10'); INSERT INTO academic_records VALUES (110024,'NainaG1005','School',0,25020,'2024-06-05'); INSERT INTO academic_records VALUES (110060,'SundaranI0199','School',1,25020,'1977-06-06'); INSERT INTO academic_records VALUES (110061,'SundaranI0199','Undergrad',1,25021,'1980-07-08'); INSERT INTO academic_records VALUES (110062,'SundaranI0199','Masters',1,25022,'1995-05-10'); INSERT INTO academic_records VALUES (110063,'KamakshiI0200','School',1,25020,'1980-05-09'); INSERT INTO academic_records VALUES (110064,'KamakshiI0200','Undergrad',1,25021,'1983-08-09'); INSERT INTO academic_records VALUES (110065,'SureshanI1600','School',1,25020,'2002-05-05'); INSERT INTO academic_records VALUES (110066,'SureshanI1600','Undergrad',1,25021,'2005-07-13'); INSERT INTO academic_records VALUES (110067,'KamalaI1590','School',1,25020,'2004-05-04'); INSERT INTO academic_records VALUES (110068,'KamalaI1590','Undergrad',1,25021,'2008-07-05'); INSERT INTO academic_records VALUES (110069,'KamalaI1590','Masters',1,25022,'2013-06-15'); INSERT INTO academic_records VALUES (110070,'KamalaI1590','Doctorate',0,25023,'2025-06-06'); INSERT INTO academic_records VALUES (110071,'DeviI1015','School',0,25020,'2027-05-06'); INSERT INTO academic_records VALUES (110072,'DritiI1014','School',0,25020,'2029-05-09'); INSERT INTO academic_records VALUES (110201,'YogiS2349','School',1,25020,'1963-05-09'); INSERT INTO academic_records VALUES (110202,'YogiS2349','Undergrad',1,25021,'1966-06-10'); INSERT INTO academic_records VALUES (110203,'AshaS2333','School',1,25020,'1973-05-10'); INSERT INTO academic_records VALUES (110204,'AshaS2333','Undergrad',1,25021,'1977-08-11'); INSERT INTO academic_records VALUES (110205,'AshaS2333','Masters',1,25022,'1987-06-08'); INSERT INTO academic_records VALUES (110206,'PrateekSS988','School',1,25020,'1998-05-05'); INSERT INTO academic_records VALUES (110207,'PrateekSS988','Undergrad',1,25021,'2001-06-06'); INSERT INTO academic_records VALUES (110208,'GopiS989','School',1,25020,'1998-05-07'); INSERT INTO academic_records VALUES (110209,'GopiS989','Undergrad',1,25021,'2001-06-06'); INSERT INTO academic_records VALUES (110210,'RohanS098','School',0,25020,'2024-05-05'); INSERT INTO academic_records VALUES (110211,'RahulS100','School',0,25020,'2028-05-05'); select * from academic_records; INSERT INTO identification_info VALUES (880081,'123','BhuvanG0001',25006,'1948-11-29',NULL); INSERT INTO identification_info VALUES (880082,'123','SeethaG0002',25006,'1950-09-02',NULL); INSERT INTO identification_info VALUES (880083,'123','MeenaiG150',25006,'1975-02-13',NULL); INSERT INTO identification_info VALUES (880086,'123','RaviG151',25006,'1975-09-12',NULL); INSERT INTO identification_info VALUES (880084,'123','AnkitG1004',25006,'2003-02-13',NULL); INSERT INTO identification_info VALUES (880085,'123','NainaG1005',25006,'2006-02-13',NULL); INSERT INTO identification_info VALUES (880186,'984','SundaranI0199',25006,'1959-01-30',NULL); INSERT INTO identification_info VALUES (880187,'984','KamakshiI0200',25006,'1962-08-02',NULL); INSERT INTO identification_info VALUES (880188,'984','SureshanI1600',25006,'1984-10-10',NULL); INSERT INTO identification_info VALUES (880189,'984','KamalaI1590',25006,'1986-06-13',NULL); INSERT INTO identification_info VALUES (880190,'984','DeviI1015',25006,'2009-06-19',NULL); INSERT INTO identification_info VALUES (880191,'984','DritiI1014',25006,'2011-09-13',NULL); INSERT INTO identification_info VALUES (880001,'742','YogiS2349',25006,'1945-03-13',NULL); INSERT INTO identification_info VALUES (880002,'742','AshaS2333',25006,'1955-07-01',NULL); INSERT INTO identification_info VALUES (880003,'742','PrateekSS988',25006,'1980-01-01',NULL); INSERT INTO identification_info VALUES (880004,'742','GopiS989',25006,'1980-03-13',NULL); INSERT INTO identification_info VALUES (880005,'742','RohanS098',25006,'2006-04-20',NULL); INSERT INTO identification_info VALUES (880006,'742','RahulS100',25006,'2010-07-13',NULL); -- Inserting values for SSN Documentation INSERT INTO identification_info VALUES (100081,'123','BhuvanG0001',25004,'1948-11-29',NULL); INSERT INTO identification_info VALUES (100082,'123','SeethaG0002',25004,'1950-09-02',NULL); INSERT INTO identification_info VALUES (100083,'123','MeenaiG150',25004,'1975-02-13',NULL); INSERT INTO identification_info VALUES (100086,'123','RaviG151',25004,'1975-09-12',NULL); INSERT INTO identification_info VALUES (100084,'123','AnkitG1004',25004,'2003-02-13',NULL); INSERT INTO identification_info VALUES (100085,'123','NainaG1005',25004,'2006-02-13',NULL); INSERT INTO identification_info VALUES (100186,'984','SundaranI0199',25004,'1959-01-30',NULL); INSERT INTO identification_info VALUES (100187,'984','KamakshiI0200',25004,'1962-08-02',NULL); INSERT INTO identification_info VALUES (100188,'984','SureshanI1600',25004,'1984-10-10',NULL); INSERT INTO identification_info VALUES (100189,'984','KamalaI1590',25004,'1986-06-13',NULL); INSERT INTO identification_info VALUES (100190,'984','DeviI1015',25004,'2009-06-19',NULL); INSERT INTO identification_info VALUES (100191,'984','DritiI1014',25004,'2011-09-13',NULL); INSERT INTO identification_info VALUES (100001,'742','YogiS2349',25004,'1945-03-13',NULL); INSERT INTO identification_info VALUES (100002,'742','AshaS2333',25004,'1955-07-01',NULL); INSERT INTO identification_info VALUES (100003,'742','PrateekSS988',25004,'1980-01-01',NULL); INSERT INTO identification_info VALUES (100004,'742','GopiS989',25004,'1980-03-13',NULL); INSERT INTO identification_info VALUES (100005,'742','RohanS098',25004,'2006-04-20',NULL); INSERT INTO identification_info VALUES (100006,'742','RahulS100',25004,'2010-07-13',NULL); -- Inserting values for Driver's Licenses INSERT INTO identification_info VALUES (200081,'123','BhuvanG0001',25005,'2022-10-09','2026-10-08'); INSERT INTO identification_info VALUES (200082,'123','SeethaG0002',25005,'2022-10-09','2026-10-08'); INSERT INTO identification_info VALUES (200083,'123','MeenaiG150',25005,'2020-12-15','2024-12-14'); INSERT INTO identification_info VALUES (200086,'123','RaviG151',25005,'2021-09-23','2025-09-22'); INSERT INTO identification_info VALUES (200084,'123','AnkitG1004',25005,'2020-06-10','2024-06-09'); INSERT INTO identification_info VALUES (200085,'123','NainaG1005',25005,'2023-09-13','2027-09-12'); INSERT INTO identification_info VALUES (200186,'984','SundaranI0199',25005,'2023-01-31','2027-01-30'); INSERT INTO identification_info VALUES (200187,'984','KamakshiI0200',25005,'2022-05-02','2026-05-01'); INSERT INTO identification_info VALUES (200188,'984','SureshanI1600',25005,'2023-03-11','2027-03-12'); INSERT INTO identification_info VALUES (200189,'984','KamalaI1590',25005,'2022-06-15','2026-06-14'); INSERT INTO identification_info VALUES (200001,'742','YogiS2349',25005,'2017-09-09','2017-09-08'); INSERT INTO identification_info VALUES (200002,'742','AshaS2333',25005,'2022-04-09','2026-04-08'); INSERT INTO identification_info VALUES (200003,'742','PrateekSS988',25005,'2022-04-09','2026-04-08'); INSERT INTO identification_info VALUES (200004,'742','GopiS989',25005,'2021-09-15','2025-09-14'); INSERT INTO identification_info VALUES (200005,'742','RohanS098',25005,'2023-01-11','2027-01-10'); -- Inserting values for Passports INSERT INTO identification_info VALUES (210081,'123','BhuvanG0001',25007,'2015-11-19','2025-11-18'); INSERT INTO identification_info VALUES (210082,'123','SeethaG0002',25007,'2015-11-19','2025-11-18'); INSERT INTO identification_info VALUES (210083,'123','MeenaiG150',25007,'2018-10-10','2028-10-09'); INSERT INTO identification_info VALUES (210086,'123','RaviG151',25007,'2017-09-16','2027-09-15'); INSERT INTO identification_info VALUES (210084,'123','AnkitG1004',25007,'2021-02-02','2031-02-01'); INSERT INTO identification_info VALUES (210085,'123','NainaG1005',25007,'2021-02-02','2031-02-01'); INSERT INTO identification_info VALUES (210186,'984','SundaranI0199',25007,'2014-11-01','2024-10-30'); INSERT INTO identification_info VALUES (210187,'984','KamakshiI0200',25007,'2020-09-22','2030-09-21'); INSERT INTO identification_info VALUES (210188,'984','SureshanI1600',25007,'2016-12-20','2026-12-19'); INSERT INTO identification_info VALUES (210189,'984','KamalaI1590',25007,'2022-07-14','2032-07-13'); INSERT INTO identification_info VALUES (210190,'984','DeviI1015',25007,'2020-05-01','2025-04-30'); INSERT INTO identification_info VALUES (210191,'984','DritiI1014',25007, '2020-05-02','2025-05-01'); INSERT INTO identification_info VALUES (210001,'742','YogiS2349',25007,'2021-08-08','2031-08-07'); INSERT INTO identification_info VALUES (210002,'742','AshaS2333',25007,'2022-09-09','2032-09-08'); INSERT INTO identification_info VALUES (210003,'742','PrateekSS988',25007,'2014-11-09','2024-11-08'); INSERT INTO identification_info VALUES (210004,'742','GopiS989',25007,'2016-09-23','2026-09-24'); INSERT INTO identification_info VALUES (210005,'742','RohanS098',25007,'2022-05-24','2027-06-25'); INSERT INTO identification_info VALUES (210006,'742','RahulS100',25007,'2023-02-16','2028-02-15'); -- Inserting values for VISA Documentation INSERT INTO identification_info VALUES (750081,'123','BhuvanG0001',25008,'2016-12-19','2026-12-18'); INSERT INTO identification_info VALUES (750082,'123','SeethaG0002',25008,'2016-12-19','2026-12-18'); INSERT INTO identification_info VALUES (750083,'123','MeenaiG150',25008,'2016-10-10','2026-10-09'); INSERT INTO identification_info VALUES (750086,'123','RaviG151',25008,'2016-10-16','2026-10-15'); INSERT INTO identification_info VALUES (750084,'123','AnkitG1004',25008,'2016-10-02','2026-10-01'); INSERT INTO identification_info VALUES (750085,'123','NainaG1005',25008,'2016-10-02','2026-10-01'); INSERT INTO identification_info VALUES (750186,'984','SundaranI0199',25008,'2013-11-04','2023-11-03'); INSERT INTO identification_info VALUES (750187,'984','KamakshiI0200',25008,'2013-04-02','2023-04-01'); INSERT INTO identification_info VALUES (750188,'984','SureshanI1600',25008,'2014-04-11','2024-04-12'); INSERT INTO identification_info VALUES (750189,'984','KamalaI1590',25008,'2014-07-19','2024-07-18'); INSERT INTO identification_info VALUES (750190,'984','DeviI1015',25008,'2014-07-19','2024-07-18'); INSERT INTO identification_info VALUES (750191,'984','DritiI1014',25008,'2014-07-19','2024-07-18'); INSERT INTO identification_info VALUES (750001,'742','YogiS2349',25008,'2014-02-19','2024-02-18'); INSERT INTO identification_info VALUES (750002,'742','AshaS2333',25008,'2013-03-11','2023-03-10'); INSERT INTO identification_info VALUES (750003,'742','PrateekSS988',25008,'2019-02-09','2029-02-08'); INSERT INTO identification_info VALUES (750004,'742','GopiS989',25008,'2020-09-15','2030-09-14'); INSERT INTO identification_info VALUES (750005,'742','RohanS098',25008,'2020-02-16','2030-02-15'); INSERT INTO identification_info VALUES (750006,'742','RahulS100',25008,'2020-02-16','2030-03-15'); -- Inserting values for School IDs INSERT INTO identification_info VALUES (050084,'123','AnkitG1004',25009,'2021-08-02','2025-05-08'); INSERT INTO identification_info VALUES (050085,'123','NainaG1005',25009,'2019-08-02','2024-05-14'); INSERT INTO identification_info VALUES (050190,'984','DeviI1015',25009,'2018-08-01','2023-05-09'); INSERT INTO identification_info VALUES (050191,'984','DritiI1014',25009,'2021-08-01','2025-05-18'); INSERT INTO identification_info VALUES (050005,'742','RohanS098',25009,'2021-08-06','2024-05-05'); INSERT INTO identification_info VALUES (050006,'742','RahulS100',25009,'2020-08-16','2024-05-15'); -- Inserting values for Employment IDs INSERT INTO identification_info VALUES (700083,'123','MeenaiG150',25010,'2015-10-10',NULL); INSERT INTO identification_info VALUES (700086,'123','RaviG151',25010,'2017-10-16',NULL); INSERT INTO identification_info VALUES (700188,'984','SureshanI1600',25010,'2019-04-11',NULL); INSERT INTO identification_info VALUES (700189,'984','KamalaI1590',25010,'2019-07-19',NULL); INSERT INTO identification_info VALUES (700003,'742','PrateekSS988',25010,'20-02-09',NULL); INSERT INTO identification_info VALUES (700004,'742','GopiS989',25010,'2020-09-15',NULL); -- Inserting values for Minor ID Cards INSERT INTO identification_info VALUES (910190,'984','DeviI1015',25054,'2022-01-03','2027-06-19'); INSERT INTO identification_info VALUES (910191,'984','DritiI1014',25054,'2023-03-16','2029-09-12'); INSERT INTO identification_info VALUES (910006,'742','RahulS100',25054,'2022-04-05','2010-07-12'); select * from identification_info; -- Inserting values for Memberships INSERT INTO memberships VALUES (null, '123', 'MeenaiG150', '25011', 'Costco', '2022-03-01', '2024-02-28', '10'); INSERT INTO memberships VALUES (null, '984', 'KamalaI1590', '25011', 'Costco', '2022-03-01', '2024-02-28', '10'); INSERT INTO memberships VALUES (null, '123', 'MeenaiG150', '25012', 'Gold\'s Gym', '2021-12-01', '2023-12-30', '40'); INSERT INTO memberships VALUES (null, '123', 'RaviG151', '25012', 'Gold\'s Gym', '2021-12-01', '2023-12-30', '40'); INSERT INTO memberships VALUES (null, '742', 'PrateekSS988', '25012', 'Gold\'s Gym', '2021-03-25', '2025-12-18', '40'); INSERT INTO memberships VALUES (null, '742', 'PrateekSS988', '25013', 'Walmart Plus', '2019-04-01', '2024-01-02', '12.95'); INSERT INTO memberships VALUES (null, '123', 'BhuvanG0001', '25014', 'Country Club', '2000-05-01', '2028-04-30', '500'); INSERT INTO memberships VALUES (null, '742', 'YogiS2349', '25014', 'Country Club', '2014-10-04', '2024-09-13', '500'); INSERT INTO memberships VALUES (null, '984', 'SureshanI1600', '25014', 'Country Club', '2000-05-01', '2028-04-30', '500'); INSERT INTO memberships VALUES (null, '123', 'RaviG151', '25015', 'AMC Theatre', '2018-06-12', '2024-02-28', '14.99'); INSERT INTO memberships VALUES (null, '742', 'GopiS989', '25015', 'AMC Theatre', '2021-06-07', '2026-03-07', '8.99'); INSERT INTO memberships VALUES (null, '984', 'SureshanI1600', '25015', 'AMC Theatre', '2021-11-12', '2024-08-07', '8.99'); INSERT INTO memberships VALUES (null, '123', 'MeenaiG150', '25016', 'Apple Tv', '2022-12-31', '2023-12-31', '4.99'); INSERT INTO memberships VALUES (null, '123', 'BhuvanG0001', '25017', 'Apple Music', '2020-05-15', '2025-05-14', '14.99'); INSERT INTO memberships VALUES (null, '123', 'AnkitG1004', '25018', 'Soccer Club', '2022-10-10', '2024-02-20', '80'); INSERT INTO memberships VALUES (null, '123', 'BhuvanG0001', '25019', 'Mileage Plan', '2021-03-31', '2027-06-17', '108.25'); INSERT INTO memberships VALUES (null, '742', 'PrateekSS988', '25019', 'Mileage Plan', '2018-02-08', '2025-02-14', '108.25'); INSERT INTO memberships VALUES (null, '984', 'KamalaI1590', '25019', 'Mileage Plan', '2016-06-06', '2025-09-03', '108.25'); INSERT INTO memberships VALUES (null, '742', 'GopiS989', '25048', 'Dallas Yoga', '2021-05-02', '2023-08-29', '60'); INSERT INTO memberships VALUES (null, '984', 'KamalaI1590', '25048', 'Dallas Yoga', '2021-05-02', '2023-08-29', '60'); INSERT INTO memberships VALUES (null, '742', 'GopiS989', '25050', 'Netflix', '2018-08-01', '2025-11-25', '17.99'); INSERT INTO memberships VALUES (null, '984', 'KamalaI1590', '25050', 'Netflix', '2018-02-14', '2026-12-22', '17.99'); INSERT INTO memberships VALUES (null, '742', 'PrateekSS988', '25051', 'Spotify', '2020-09-07', '2023-07-09', '14.99'); INSERT INTO memberships VALUES (null, '984', 'KamalaI1590', '25051', 'Spotify', '2019-09-30', '2023-05-18', '14.99'); INSERT INTO memberships VALUES (null, '742', 'GopiS989', '25052', 'HBO Max', '2021-04-09', '2024-10-31', '14.99'); INSERT INTO memberships VALUES (null, '984', 'SureshanI1600', '25052', 'HBO Max', '2023-03-25', '2027-01-29', '14.99'); INSERT INTO memberships VALUES (null, '984', 'SureshanI1600', '25049', 'Spin Class', '2022-12-31', '2023-12-31', '14'); INSERT INTO memberships VALUES (null, '984', 'DeviI1015', '25053', 'Dance Class', '2022-06-10', '2024-02-20', '100'); -- Inserting values for Health Insurance INSERT INTO insurance_details VALUES ('1301','bhuvanG0001','123','PPO','Aetna','2018-06-04','2023-06-04','0','1200','8000','25028'); INSERT INTO insurance_details VALUES ('1302','SeethaG0002','123','POS','Aetna','2019-02-21','2024-02-21','0','1100','4000','25028'); INSERT INTO insurance_details VALUES ('1303','RaviG151','123','HMO','cigna','2020-01-25','2025-01-25','1','1600','9000','25028'); INSERT INTO insurance_details VALUES ('1304','MeenaiG150','123','HSA','AIG','2020-05-20','2025-05-20-','1','1700','9000','25028'); INSERT INTO insurance_details VALUES ('1305','AnkitG1004','123','HMO','WPA','2022-09-30','2027-09-30','0','1800','8000','25028'); INSERT INTO insurance_details VALUES ('1306','NainaG1005','123','HSA','WPA','2022-10-04','2027-10-04','0','1200','6000','25028'); INSERT INTO insurance_details VALUES ('1307','SundaranI0199','984','PPO','Blueshield','2017-04-03','2023-04-03','0','1800','10000','25028'); INSERT INTO insurance_details VALUES ('1308','KamakshiI0200','984','HDHP','BUPA','2020-02-14','2025-02-14','0','1400','1000','25028'); INSERT INTO insurance_details VALUES ('1309','SureshanI1600','984','HMO','Aetna','2021-06-30','2026-06-30','1','1900','10000','25028'); INSERT INTO insurance_details VALUES ('1310','KamalaI1590','984','HSA','MetLife','2023-11-11','2027-11-11-','1','1200','6000','25028'); INSERT INTO insurance_details VALUES ('1311','DeviI1015','984','HMO','Generali','2021-12-12','2026-12-30','0','2000','12000','25028'); INSERT INTO insurance_details VALUES ('1312','DritiI1014','984','HSA','WPA','2021-10-10','2026-10-10','0','1200','4000','25028'); INSERT INTO insurance_details VALUES ('1313','YogiS2349','742','POS','zurich','2015-11-25','2020-11-25','0','2000','10000','25028'); INSERT INTO insurance_details VALUES ('1314','AshaS2333','742','PPO','Generali','2020-08-11','2025-08-11','0','1900','8000','25028'); INSERT INTO insurance_details VALUES ('1315','PrateekSS988','742','POS','United','2021-05-24','2026-05-24','1','2100','15000','25028'); INSERT INTO insurance_details VALUES ('1316','GopiS989','742','HDHP','MetLife','2021-03-24','2026-03-24','1','2400','16000','25028'); INSERT INTO insurance_details VALUES ('1317','RohanS098','742','HMO','Cigna','2023-08-22','2026-08-22','0','2800','18000','25028'); INSERT INTO insurance_details VALUES ('1318','RahulS100','742','POS','WPA','2022-02-13','2027-02-13','0','2500','10000','25028'); -- Inserting values for Life Insurance INSERT INTO insurance_details VALUES ('1401','bhuvanG0001','123','Fulllife','Metlife','2018-03-04','2023-03-04','0','3000','100000','25029'); INSERT INTO insurance_details VALUES ('1402','SeethaG0002','123','wholelife','Universal','2019-06-28','2024-06-28','0','2000','90000','25029'); INSERT INTO insurance_details VALUES ('1403','RaviG151','123','Termlife','Newyork Life','2020-09-25','2025-09-25','1','4000','90000','25029'); INSERT INTO insurance_details VALUES ('1404','MeenaiG150','123','Variablelife','Prudential','2020-01-20','2025-01-20-','1','1700','40000','25029'); INSERT INTO insurance_details VALUES ('1405','AnkitG1004','123','Fixedlife','Massmutual','2022-08-30','2027-08-30','0','1000','80000','25029'); INSERT INTO insurance_details VALUES ('1406','SundaranI0199','984','variable','Universal','2022-04-03','2027-04-03','0','3000','100000','25029'); INSERT INTO insurance_details VALUES ('1407','KamakshiI0200','984','Indexted','Gecio','2020-08-16','2025-08-16','0','4000','150000','25029'); INSERT INTO insurance_details VALUES ('1408','SureshanI1600','984','Fulllife','Statefarm','2020-4-09','2025-4-09','1','2000','10000','25029'); INSERT INTO insurance_details VALUES ('1409','KamalaI1590','984','Termlife','Traverlers','2023-10-11','2027-10-11-','1','1200','60000','25029'); INSERT INTO insurance_details VALUES ('1410','DeviI1015','984','Fulllife','Statefarm','2021-12-14','2026-12-14','0','2000','120000','25029'); INSERT INTO insurance_details VALUES ('1411','DritiI1014','984','Wholelife','Transamerica','2021-04-04','2026-04-04','0','1200','40000','25029'); INSERT INTO insurance_details VALUES ('1412','YogiS2349','742','Indexed','Mutuallife','2021-06-25','2026-06-25','0','5000','100000','25029'); INSERT INTO insurance_details VALUES ('1413','AshaS2333','742','Finalexpense','Metlife','2020-02-11','2025-02-11','0','4000','80000','25029'); INSERT INTO insurance_details VALUES ('1414','PrateekSS988','742','Indexed','Mutuallife','2022-05-24','2028-05-24','1','3000','140000','25029'); INSERT INTO insurance_details VALUES ('1415','GopiS989','742','Fixedlife','Nationwide','2023-07-24','2027-07-24','1','3400','1200000','25029'); INSERT INTO insurance_details VALUES ('1416','RohanS098','742','Variablelife','Allstate','2020-02-13','2025-02-13','0','4500','1000000','25029'); INSERT INTO insurance_details VALUES ('1418','RahulS100','742','Finalexpense','Metlife','2022-02-13','2027-02-13','0','2500','10000','25029'); -- travel insurance INSERT INTO insurance_details VALUES ('1501','bhuvanG0001','123','Tripcancellation','Allianz','2021-03-04','2023-03-04','0','3000','6000','25030'); INSERT INTO insurance_details VALUES ('1502','SeethaG0002','123','Insurebuy','Medical','2022-01-28','2022-01-28','0','2000','9000','25030'); INSERT INTO insurance_details VALUES ('1503','RaviG151','123','Travelguard','Emergencymedical','2023-09-25','2024-09-25','1','4000','2000','25030'); INSERT INTO insurance_details VALUES ('1504','MeenaiG150','123','Travelex','Baggageandpersonal','2022-01-20','2023-01-20-','1','1700','4000','25030'); INSERT INTO insurance_details VALUES ('1505','SundaranI0199','984','AIG','Medical','2022-03-03','2024-03-03','0','3000','100000','25030'); INSERT INTO insurance_details VALUES ('1506','KamakshiI0200','984','Sevencorners','Flight','2020-12-16','2023-12-16','0','4000','150000','25030'); INSERT INTO insurance_details VALUES ('1507','SureshanI1600','984','Beikshire','Carinsurance','2021-11-09','2023-11-09','1','2000','10000','25030'); INSERT INTO insurance_details VALUES ('1508','KamalaI1590','984','Tripcancellation','Adeventuresports','2022-10-11','2024-10-11-','1','1200','60000','25030'); INSERT INTO insurance_details VALUES ('1509','YogiS2349','742','Travelex','Grouptravel','2022-09-25','2024-09-25','0','5000','1000','25030'); INSERT INTO insurance_details VALUES ('1510','AshaS2333','742','Beikshire','Trip','2023-04-11','2025-04-11','0','4000','8000','25030'); INSERT INTO insurance_details VALUES ('1511','PrateekSS988','742','Worldnomads','Baggageandpersonal','2021-05-24','2025-05-24','1','3000','14000','25030'); INSERT INTO insurance_details VALUES ('1512','GopiS989','742','Travelex','Allianz','2023-05-24','2024-05-24','1','3000','14000','25030'); -- auto insurance INSERT INTO insurance_details VALUES ('1601','bhuvanG0001','123','Liabilitycoverage','Statefarm','2023-04-28','2025-04-28','0','7000','15000','25031'); INSERT INTO insurance_details VALUES ('1602','SeethaG0002','123','Collisioncoverage','FaremersInsurance','2021-03-26','2022-01-26','0','4000','19000','25031'); INSERT INTO insurance_details VALUES ('1603','RaviG151','123','Personalinjury','Geico','2024-05-25','2026-05-25','1','5000','12000','25031'); INSERT INTO insurance_details VALUES ('1604','MeenaiG150','123','Uninsured','Progressive','2022-01-20','2025-01-20-','1','1700','14000','25031'); INSERT INTO insurance_details VALUES ('1605','SundaranI0199','984','Roadsideassitance','Allstate','2021-02-03','2021-02-03','0','4000','10000','25031'); INSERT INTO insurance_details VALUES ('1606','KamakshiI0200','984','personalinjury','Nationwide','2024-12-16','2024-12-16','0','7000','15000','25031'); INSERT INTO insurance_details VALUES ('1607','SureshanI1600','984','Liability','Geico','2021-10-09','2022-10-09','1','5000','10000','25031'); INSERT INTO insurance_details VALUES ('1608','KamalaI1590','984','undersured','Liberty','2022-09-11','2024-09-11-','1','4000','60000','25031'); INSERT INTO insurance_details VALUES ('1609','YogiS2349','742','Comprehensive','Geico','2023-09-25','2025-09-25','0','5000','1000','25031'); INSERT INTO insurance_details VALUES ('1610','AshaS2333','742','Personalinjury','Progressive','2023-04-11','2024-04-11','0','4000','8000','25031'); INSERT INTO insurance_details VALUES ('1611','PrateekSS988','742','Collisioncoverage','Geico','2023-09-24','2025-09-24','1','3000','14000','25031'); INSERT INTO insurance_details VALUES ('1612','GopiS989','742','Collisioncoverage','Geico','2023-03-24','2024-03-24','1','3000','14000','25031'); select * from insurance_details; INSERT INTO medical_records VALUES ('1011','1999-12-12','BhuvanG0001','25036','viralfever','james'); INSERT INTO medical_records VALUES ('1012','2002-11-12','SeethaG0002','25036','stomachinfection','sudha'); INSERT INTO medical_records VALUES ('1013','2004-09-04','RaviG151','25036','fever','sudha'); INSERT INTO medical_records VALUES ('1014','2005-04-04','MeenaiG150','25036','skinrash','gowri'); INSERT INTO medical_records VALUES ('1015','2008-01-12','AnkitG1004','25036','fever','james'); INSERT INTO medical_records VALUES ('1016','2021-03-27','NainaG1005','25036','fever','keshav'); INSERT INTO medical_records VALUES ('1017','1998-04-12','SundaranI0199','25036','generalcheckup','gokul'); INSERT INTO medical_records VALUES ('1018','2011-06-29','KamakshiI0200','25036','viralfever','gokul'); INSERT INTO medical_records VALUES ('1019','2000-04-04','SureshanI1600','25036','followup','jayaprada'); INSERT INTO medical_records VALUES ('1020','2018-01-01','KamalaI1590','25036','followup','jayaprada'); INSERT INTO medical_records VALUES ('1021','2020-11-10','DeviI1015','25036','rashes','sujatha'); INSERT INTO medical_records VALUES ('1022','2021-06-10','DritiI1014','25036','pimples','gowri'); INSERT INTO medical_records VALUES ('1023','2022-08-09','YogiS2349','25036','pimples','gowri'); INSERT INTO medical_records VALUES ('1024','2023-02-02','AshaS2333','25036','heartcheckup','teja'); INSERT INTO medical_records VALUES ('1025','2020-03-03','PrateekSS988','25036','kidneystones','teja'); INSERT INTO medical_records VALUES ('1026','2020-04-04','GopiS989','25036','viralfever','john'); INSERT INTO medical_records VALUES ('1027','1999-05-05','RohanS098','25036','viralfever','john'); INSERT INTO medical_records VALUES ('1028','2023-06-06','RahulS100','25036','throatinfection','smith'); -- Inserting values for Reminders INSERT INTO reminders VALUES ('10201', '2023-06-19', 'Devi Birthday', '1', 'DeviI1015', '25037'); INSERT INTO reminders VALUES ('10202', '2023-09-13', 'Druti Birthday', '1', 'DritiI1014', '25037'); INSERT INTO reminders VALUES ('10203', '2023-08-02', 'Kamakshi Birthday', '1', 'KamakshiI0200', '25037'); INSERT INTO reminders VALUES ('10204', '2023-06-13', 'Kamala Birthday', '1', 'KamalaI1590', '25037'); INSERT INTO reminders VALUES ('10205', '2023-01-20', 'Sundaran Birthday', '1', 'SundaranI0199', '25037'); INSERT INTO reminders VALUES ('10206', '2023-10-10', 'Sureshan Birthday', '1', 'SureshanI1600', '25037'); INSERT INTO reminders VALUES ('10207', '2023-07-01', 'Asha Birthday', '1', 'AshaS2333', '25037'); INSERT INTO reminders VALUES ('10208', '2023-03-13', 'Gopi Birthday', '1', 'GopiS989', '25037'); INSERT INTO reminders VALUES ('10209', '2023-01-01', 'Prateek Birthday', '1', 'PrateekSS988', '25037'); INSERT INTO reminders VALUES ('10210', '2023-07-13', 'Rahul Birthday', '1', 'RahulS100', '25037'); INSERT INTO reminders VALUES ('10211', '2023-04-20', 'Rohan Birthday', '1', 'RohanS098', '25037'); INSERT INTO reminders VALUES ('10212', '2023-03-13', 'Yogi Birthday', '1', 'YogiS2349', '25037'); INSERT INTO reminders VALUES ('10213', '2023-02-13', 'Ankit Birthday', '1', 'AnkitG1004', '25037'); INSERT INTO reminders VALUES ('10214', '2023-11-29', 'Bhuvan Birthday', '1', 'BhuvanG0001', '25037'); INSERT INTO reminders VALUES ('10215', '2023-02-13', 'Mennai Birthday', '1', 'MeenaiG150', '25037'); INSERT INTO reminders VALUES ('10216', '2023-02-13', 'Naina Birthday', '1', 'NainaG1005', '25037'); INSERT INTO reminders VALUES ('10217', '2023-09-12', 'Ravi. Birthday', '1', 'RaviG151', '25037'); INSERT INTO reminders VALUES ('10218', '2023-09-02', 'Seetha Birthday', '1', 'SeethaG0002', '25037'); INSERT INTO reminders VALUES ('10219', '2023-02-17', 'Prateek Anniversary', '1', 'PrateekSS988', '25038'); INSERT INTO reminders VALUES ('10220', '2023-02-18', 'Gopi Anniversary', '1', 'GopiS989', '25038'); INSERT INTO reminders VALUES ('10221', '2023-05-12', 'kamala Anniversary', '1', 'KamalaI1590', '25038'); INSERT INTO reminders VALUES ('10222', '2023-05-13', 'Sureshan Anniversary', '1', 'SureshanI1600', '25038'); INSERT INTO reminders VALUES ('10223', '2023-12-05', 'Ravi Anniversary', '1', 'RaviG151', '25038'); INSERT INTO reminders VALUES ('10224', '2023-12-06', 'Meenai Anniversary', '1', 'MeenaiG150', '25038'); INSERT INTO reminders VALUES ('10225', '2023-11-28', 'Asha Anniversary', '1', 'AshaS2333', '25038'); INSERT INTO reminders VALUES ('10226', '2023-11-29', 'Yogi Anniversary', '1', 'YogiS2349', '25038'); INSERT INTO reminders VALUES ('10227', '2023-03-12', 'Kamakshi Anniversary', '1', 'KamakshiI0200', '25038'); INSERT INTO reminders VALUES ('10228', '2023-03-13', 'Sundaran Anniversary', '1', 'SundaranI0199', '25038'); INSERT INTO reminders VALUES ('10229', '2023-05-14', 'Seetha Anniversary', '1', 'SeethaG0002', '25038'); INSERT INTO reminders VALUES ('10230', '2023-05-15', 'Bhuvan Anniversary', '1', 'BhuvanG0001', '25038'); INSERT INTO reminders VALUES ('10231', '2023-04-10', 'Ankit Soccer Practice', '0', 'AnkitG1004', '25018'); INSERT INTO reminders VALUES ('10232', '2023-04-11', 'Devi Dance Class', '0', 'DeviI1015', '25053'); INSERT INTO reminders VALUES ('10233', '2023-03-08', 'Ankit Midterm', '0', 'AnkitG1004', '25041'); INSERT INTO reminders VALUES ('10234', '2023-05-05', 'Ankit Finals', '0', 'AnkitG1004', '25041'); INSERT INTO reminders VALUES ('10235', '2023-04-12', 'Rahul Art Class', '0', 'RahulS100', '25040'); INSERT INTO reminders VALUES ('10236', '2023-04-13', 'Rohan Drama Club', '0', 'RohanS098', '25040'); INSERT INTO reminders VALUES ('10237', '2023-04-14', 'Driti Assignment', '0', 'DritiI1014', '25047'); INSERT INTO reminders VALUES ('10238', '2023-04-13', 'Naina Drama Club', '0', 'NainaG1005', '25040'); INSERT INTO reminders VALUES ('10239', '2023-03-08', 'Devi Midterm', '0', 'DeviI1015', '25041'); INSERT INTO reminders VALUES ('10240', '2023-03-07', 'Rahul Midterm', '0', 'RahulS100', '25041'); INSERT INTO reminders VALUES ('10241', '2023-03-08', 'Rohan Midterm', '0', 'RohanS098', '25041'); INSERT INTO reminders VALUES ('10242', '2023-03-06', 'Driti Midterm', '0', 'DritiI1014', '25041'); INSERT INTO reminders VALUES ('10243', '2023-03-07', 'Naina Midterm', '0', 'NainaG1005', '25041'); INSERT INTO reminders VALUES ('10244', '2023-05-05', 'Devi Finals', '0', 'DeviI1015', '25041'); INSERT INTO reminders VALUES ('10245', '2023-05-06', 'Rahul Finals', '0', 'RahulS100', '25041'); INSERT INTO reminders VALUES ('10246', '2023-05-10', 'Rohan Finals', '0', 'RohanS098', '25041'); INSERT INTO reminders VALUES ('10247', '2023-05-12', 'Driti Finals', '0', 'DritiI1014', '25041'); INSERT INTO reminders VALUES ('10248', '2023-05-09', 'Naina Finals', '0', 'NainaG1005', '25041'); INSERT INTO reminders VALUES ('10249', '2023-04-12', 'Gopi Office Meeting', '0', 'GopiS989', '25042'); INSERT INTO reminders VALUES ('10250', '2023-04-13', 'Kamala Office Meeting', '0', 'KamalaI1590', '25042'); INSERT INTO reminders VALUES ('10251', '2023-04-14', 'Meenai Office Meeting', '0', 'MeenaiG150', '25042'); INSERT INTO reminders VALUES ('10252', '2023-04-17', 'Prateek Office Meeting', '0', 'PrateekSS988', '25042'); INSERT INTO reminders VALUES ('10253', '2023-04-18', 'Ravi Office Meeting', '0', 'RaviG151', '25042'); INSERT INTO reminders VALUES ('10254', '2023-04-19', 'Sureshan Office Meeting', '0', 'SureshanI1600', '25042'); INSERT INTO reminders VALUES ('10255', '2023-04-16', 'Rekha Baby Shower', '0', 'RaviG151', '25043'); INSERT INTO reminders VALUES ('10256', '2023-04-20', 'Asha MRI Scan', '0', 'AshaS2333', '25044'); INSERT INTO reminders VALUES ('10257', '2023-04-21', 'Meenai Salon', '0', 'MeenaiG150', '25044'); INSERT INTO reminders VALUES ('10259', '2023-04-25', 'Driti Eye CheckUp', '0', 'DritiI1014', '25044'); INSERT INTO reminders VALUES ('10260', '2023-04-26', 'Rohan Salon', '0', 'RohanS098', '25044'); INSERT INTO reminders VALUES ('10261', '2023-04-27', 'Yogi Bank', '0', 'YogiS2349', '25044'); INSERT INTO reminders VALUES ('10262', '2023-06-03', 'Kusha and Rohan Wedding', '0', 'GopiS989', '25045'); INSERT INTO reminders VALUES ('10263', '2023-05-25', 'Harshit and Priya Wedding', '0', 'MeenaiG150', '25045'); INSERT INTO reminders VALUES ('10264', '2023-05-01', 'Sharma Water', '1', 'PrateekSS988', '25046'); INSERT INTO reminders VALUES ('10265', '2023-05-02', 'Iyer Water', '1', 'SureshanI1600', '25046'); INSERT INTO reminders VALUES ('10266', '2023-05-03', 'Goswamy Water', '1', 'RaviG151', '25046'); INSERT INTO reminders VALUES ('10267', '2023-05-01', 'Sharma Elecrtricity', '1', 'PrateekSS988', '25046'); INSERT INTO reminders VALUES ('10268', '2023-05-02', 'Iyer Elecrtricity', '1', 'SureshanI1600', '25046'); INSERT INTO reminders VALUES ('10269', '2023-05-03', 'Goswamy Elecrtricity', '1', 'RaviG151', '25046'); INSERT INTO reminders VALUES ('10270', '2023-04-10', 'Asha Phone', '1', 'AshaS2333', '25046'); INSERT INTO reminders VALUES ('10271', '2023-04-15', 'Bhuvan Phone', '1', 'BhuvanG0001', '25046'); INSERT INTO reminders VALUES ('10272', '2023-04-10', 'Gopi Phone', '1', 'GopiS989', '25046'); INSERT INTO reminders VALUES ('10273', '2023-04-30', 'Kamakshi Phone', '1', 'KamakshiI0200', '25046'); INSERT INTO reminders VALUES ('10274', '2023-04-30', 'Kamala Phone', '1', 'KamalaI1590', '25046'); INSERT INTO reminders VALUES ('10275', '2023-04-15', 'Meenai Phone', '1', 'MeenaiG150', '25046'); INSERT INTO reminders VALUES ('10276', '2023-04-10', 'Prateek Phone', '1', 'PrateekSS988', '25046'); INSERT INTO reminders VALUES ('10277', '2023-04-15', 'Ravi Phone', '1', 'RaviG151', '25046'); INSERT INTO reminders VALUES ('10278', '2023-04-15', 'Seetha Phone', '1', 'SeethaG0002', '25046'); INSERT INTO reminders VALUES ('10279', '2023-04-30', 'Sundaran Phone', '1', 'SundaranI0199', '25046'); INSERT INTO reminders VALUES ('10280', '2023-04-30', 'SureshanPhone', '1', 'SureshanI1600', '25046'); INSERT INTO reminders VALUES ('10281', '2023-04-10', 'Yogi Phone', '1', 'YogiS2349', '25046'); INSERT INTO reminders VALUES ('10282', '2023-04-21', 'Kkamakshi Medical Bill', '1', 'KamakshiI0200', '25046'); INSERT INTO reminders VALUES ('10283', '2023-04-24', 'SundaranMedical Bill', '1', 'SundaranI0199', '25046'); INSERT INTO reminders VALUES ('10284', '2023-04-25', 'Meenai Medical Bill', '1', 'MeenaiG150', '25046'); INSERT INTO reminders VALUES ('10285', '2023-04-15', 'Gopi Wifi', '1', 'GopiS989', '25046'); INSERT INTO reminders VALUES ('10286', '2023-04-10', 'Kamala Wifi', '1', 'KamalaI1590', '25046'); INSERT INTO reminders VALUES ('10287', '2023-04-30', 'Meenai Wifi', '1', 'MeenaiG150', '25046'); INSERT INTO reminders VALUES ('10288', '2023-04-20', 'Ankit Assignment', '0', 'AnkitG1004', '25047'); INSERT INTO reminders VALUES ('10289', '2023-04-21', 'Devi Assignment', '0', 'DeviI1015', '25047'); INSERT INTO reminders VALUES ('10290', '2023-04-24', 'Driti Assignment', '0', 'DritiI1014', '25047'); INSERT INTO reminders VALUES ('10291', '2023-04-25', 'naina Assignment', '0', 'NainaG1005', '25047'); INSERT INTO reminders VALUES ('10292', '2023-04-26', 'Rahul Assignment', '0', 'RahulS100', '25047'); INSERT INTO reminders VALUES ('10293', '2023-04-27', 'Rohan Assignment', '0', 'RohanS098', '25047'); INSERT INTO reminders VALUES ('10294', '2023-04-20', 'Gopi Yoga Class', '0', 'GopiS989', '25048'); INSERT INTO reminders VALUES ('10295', '2023-04-20', 'Kamala Yoga Class', '0', 'KamalaI1590', '25048'); INSERT INTO reminders VALUES ('10296', '2023-04-19', 'Meenai Gym', '0', 'MeenaiG150', '25012'); INSERT INTO reminders VALUES ('10297', '2023-04-18', 'Prateek Gym', '0', 'PrateekSS988', '25012'); INSERT INTO reminders VALUES ('10298', '2023-04-19', 'Ravi Gym', '0', 'RaviG151', '25012'); INSERT INTO reminders VALUES ('10299', '2023-04-18', 'Sureshan Spin Class', '0', 'SureshanI1600', '25049'); INSERT INTO reminders VALUES ('10300', '2023-04-21', 'Bhuvan Church Meeting', '0', 'BhuvanG0001', '25042'); INSERT INTO reminders VALUES ('10301', '2023-04-24', 'Kamakshi Church Meeting', '0', 'KamakshiI0200', '25042'); INSERT INTO reminders VALUES ('10302', '2023-04-25', 'Seetha Church Meeting', '0', 'SeethaG0002', '25042'); INSERT INTO reminders VALUES ('10303', '2024-02-12', 'Costco Expiration', '1', 'MeenaiG150', '25011'); INSERT INTO reminders VALUES ('10304', '2023-12-12', 'Gold\'s Gym Expiration', '1', 'MeenaiG150', '25012'); INSERT INTO reminders VALUES ('10305', '2023-12-30', 'Gold\'s Gym Expiration', '1', 'RaviG151', '25012'); INSERT INTO reminders VALUES ('10306', '2028-04-30', 'Country Club Expiration', '1', 'BhuvanG0001', '25014'); INSERT INTO reminders VALUES ('10307', '2024-02-28', 'AMC Theatre Expiration', '1', 'RaviG151', '25015'); INSERT INTO reminders VALUES ('10308', '2023-12-31', 'Apple Tv Expiration', '1', 'MeenaiG150', '25016'); INSERT INTO reminders VALUES ('10309', '2025-05-14', 'Apple Music Expiration', '1', 'BhuvanG0001', '25017'); INSERT INTO reminders VALUES ('10310', '2024-02-20', 'Soccer Club Expiration', '1', 'AnkitG1004', '25018'); INSERT INTO reminders VALUES ('10311', '2027-06-17', 'Mileage Plan Expiration', '1', 'BhuvanG0001', '25019'); INSERT INTO reminders VALUES ('10312', '2024-01-02', 'Walmart Plus Expiration', '1', 'PrateekSS988', '25013'); INSERT INTO reminders VALUES ('10313', '2023-08-29', 'Dallas Yoga Expiration', '1', 'GopiS989', '25048'); INSERT INTO reminders VALUES ('10314', '2025-12-18', 'Gold\'s Gym Expiration', '1', 'PrateekSS988', '25012'); INSERT INTO reminders VALUES ('10315', '2024-09-13', 'Country Club Expiration', '1', 'YogiS2349', '25014'); INSERT INTO reminders VALUES ('10316', '2026-03-07', 'AMC Theatre Expiration', '1', 'GopiS989', '25015'); INSERT INTO reminders VALUES ('10317', '2025-11-25', 'Netflix Expiration', '1', 'GopiS989', '25050'); INSERT INTO reminders VALUES ('10318', '2023-07-09', 'Spotify Expiration', '1', 'PrateekSS988', '25051'); INSERT INTO reminders VALUES ('10319', '2025-02-14', 'Mileage Plan Expiration', '1', 'PrateekSS988', '25019'); INSERT INTO reminders VALUES ('10320', '2024-10-31', 'HBO Max Expiration', '1', 'GopiS989', '25052'); INSERT INTO reminders VALUES ('10321', '2024-02-29', 'Costco Expiration', '1', 'KamalaI1590', '25011'); INSERT INTO reminders VALUES ('10322', '2023-12-31', 'Spin Class Expiration', '1', 'SureshanI1600', '25049'); INSERT INTO reminders VALUES ('10323', '2023-08-29', 'Dallas Yoga Expiration', '1', 'KamalaI1590', '25048'); INSERT INTO reminders VALUES ('10324', '2028-04-30', 'Country Club Expiration', '1', 'SureshanI1600', '25014'); INSERT INTO reminders VALUES ('10325', '2024-08-07', 'AMC Theatre Expiration', '1', 'SureshanI1600', '25015'); INSERT INTO reminders VALUES ('10326', '2026-12-22', 'Netflix Expiration', '1', 'KamalaI1590', '25050'); INSERT INTO reminders VALUES ('10327', '2023-05-18', 'Spotify Expiration', '1', 'KamalaI1590', '25051'); INSERT INTO reminders VALUES ('10328', '2025-09-03', 'Mileage Plan Expiration', '1', 'KamalaI1590', '25019'); INSERT INTO reminders VALUES ('10329', '2027-01-29', 'HBO Max Expiration', '1', 'SureshanI1600', '25052'); INSERT INTO reminders VALUES ('10330', '2024-02-20', 'Dance Class Expiration', '1', 'DeviI1015', '25053'); INSERT INTO reminders VALUES ('10331', '2017-09-08', 'Drivers License Expiration', '0', 'YogiS2349', '25005'); INSERT INTO reminders VALUES ('10332', '2026-04-08', 'Drivers License Expiration', '0', 'AshaS2333', '25005'); INSERT INTO reminders VALUES ('10333', '2026-04-08', 'Drivers License Expiration', '0', 'PrateekSS988', '25005'); INSERT INTO reminders VALUES ('10334', '2025-09-14', 'Drivers License Expiration', '0', 'GopiS989', '25005'); INSERT INTO reminders VALUES ('10335', '2027-01-10', 'Drivers License Expiration', '0', 'RohanS098', '25005'); INSERT INTO reminders VALUES ('10336', '2026-10-08', 'Drivers License Expiration', '0', 'BhuvanG0001', '25005'); INSERT INTO reminders VALUES ('10337', '2026-10-08', 'Drivers License Expiration', '0', 'SeethaG0002', '25005'); INSERT INTO reminders VALUES ('10338', '2024-12-14', 'Drivers License Expiration', '0', 'MeenaiG150', '25005'); INSERT INTO reminders VALUES ('10339', '2024-06-09', 'Drivers License Expiration', '0', 'AnkitG1004', '25005'); INSERT INTO reminders VALUES ('10340', '2027-09-12', 'Drivers License Expiration', '0', 'NainaG1005', '25005'); INSERT INTO reminders VALUES ('10341', '2025-09-22', 'Drivers License Expiration', '0', 'RaviG151', '25005'); INSERT INTO reminders VALUES ('10342', '2027-01-30', 'Drivers License Expiration', '0', 'SundaranI0199', '25005'); INSERT INTO reminders VALUES ('10343', '2026-05-01', 'Drivers License Expiration', '0', 'KamakshiI0200', '25005'); INSERT INTO reminders VALUES ('10344', '2027-03-12', 'Drivers License Expiration', '0', 'SureshanI1600', '25005'); INSERT INTO reminders VALUES ('10345', '2026-06-14', 'Drivers License Expiration', '0', 'KamalaI1590', '25005'); INSERT INTO reminders VALUES ('10346', '2031-08-07', 'Passport Expiration', '0', 'YogiS2349', '25007'); INSERT INTO reminders VALUES ('10347', '2032-09-08', 'Passport Expiration', '0', 'AshaS2333', '25007'); INSERT INTO reminders VALUES ('10348', '2024-11-08', 'Passport Expiration', '0', 'PrateekSS988', '25007'); INSERT INTO reminders VALUES ('10349', '2026-09-24', 'Passport Expiration', '0', 'GopiS989', '25007'); INSERT INTO reminders VALUES ('10350', '2027-06-25', 'Passport Expiration', '0', 'RohanS098', '25007'); INSERT INTO reminders VALUES ('10351', '2028-02-15', 'Passport Expiration', '0', 'RahulS100', '25007'); INSERT INTO reminders VALUES ('10352', '2025-11-18', 'Passport Expiration', '0', 'BhuvanG0001', '25007'); INSERT INTO reminders VALUES ('10353', '2025-11-18', 'Passport Expiration', '0', 'SeethaG0002', '25007'); INSERT INTO reminders VALUES ('10354', '2028-10-09', 'Passport Expiration', '0', 'MeenaiG150', '25007'); INSERT INTO reminders VALUES ('10355', '2031-02-01', 'Passport Expiration', '0', 'AnkitG1004', '25007'); INSERT INTO reminders VALUES ('10356', '2031-02-01', 'Passport Expiration', '0', 'NainaG1005', '25007'); INSERT INTO reminders VALUES ('10357', '2027-09-15', 'Passport Expiration', '0', 'RaviG151', '25007'); INSERT INTO reminders VALUES ('10358', '2024-10-30', 'Passport Expiration', '0', 'SundaranI0199', '25007'); INSERT INTO reminders VALUES ('10359', '2030-09-21', 'Passport Expiration', '0', 'KamakshiI0200', '25007'); INSERT INTO reminders VALUES ('10360', '2026-12-19', 'Passport Expiration', '0', 'SureshanI1600', '25007'); INSERT INTO reminders VALUES ('10361', '2032-07-13', 'Passport Expiration', '0', 'KamalaI1590', '25007'); INSERT INTO reminders VALUES ('10362', '2025-04-30', 'Passport Expiration', '0', 'DeviI1015', '25007'); INSERT INTO reminders VALUES ('10363', '2025-05-01', 'Passport Expiration', '0', 'DritiI1014', '25007'); INSERT INTO reminders VALUES ('10364', '2024-05-05', 'School ID Expiration', '0', 'RohanS098', '25009'); INSERT INTO reminders VALUES ('10365', '2024-05-15', 'School ID Expiration', '0', 'RahulS100', '25009'); INSERT INTO reminders VALUES ('10366', '2025-05-08', 'School ID Expiration', '0', 'AnkitG1004', '25009'); INSERT INTO reminders VALUES ('10367', '2024-05-14', 'School ID Expiration', '0', 'NainaG1005', '25009'); INSERT INTO reminders VALUES ('10368', '2023-05-09', 'School ID Expiration', '0', 'DeviI1015', '25009'); INSERT INTO reminders VALUES ('10369', '2025-05-18', 'School ID Expiration', '0', 'DritiI1014', '25009'); INSERT INTO reminders VALUES ('10370', '2024-02-18', 'Visa Expiration', '0', 'YogiS2349', '25008'); INSERT INTO reminders VALUES ('10371', '2023-03-10', 'Visa Expiration', '0', 'AshaS2333', '25008'); INSERT INTO reminders VALUES ('10372', '2029-02-08', 'Visa Expiration', '0', 'PrateekSS988', '25008'); INSERT INTO reminders VALUES ('10373', '2030-09-14', 'Visa Expiration', '0', 'GopiS989', '25008'); INSERT INTO reminders VALUES ('10374', '2030-02-15', 'Visa Expiration', '0', 'RohanS098', '25008'); INSERT INTO reminders VALUES ('10375', '2030-03-15', 'Visa Expiration', '0', 'RahulS100', '25008'); INSERT INTO reminders VALUES ('10376', '2026-12-18', 'Visa Expiration', '0', 'BhuvanG0001', '25008'); INSERT INTO reminders VALUES ('10377', '2026-12-18', 'Visa Expiration', '0', 'SeethaG0002', '25008'); INSERT INTO reminders VALUES ('10378', '2026-10-09', 'Visa Expiration', '0', 'MeenaiG150', '25008'); INSERT INTO reminders VALUES ('10379', '2026-10-01', 'Visa Expiration', '0', 'AnkitG1004', '25008'); INSERT INTO reminders VALUES ('10380', '2026-10-01', 'Visa Expiration', '0', 'NainaG1005', '25008'); INSERT INTO reminders VALUES ('10381', '2026-10-15', 'Visa Expiration', '0', 'RaviG151', '25008'); INSERT INTO reminders VALUES ('10382', '2023-11-03', 'Visa Expiration', '0', 'SundaranI0199', '25008'); INSERT INTO reminders VALUES ('10383', '2023-04-01', 'Visa Expiration', '0', 'KamakshiI0200', '25008'); INSERT INTO reminders VALUES ('10384', '2024-04-12', 'Visa Expiration', '0', 'SureshanI1600', '25008'); INSERT INTO reminders VALUES ('10385', '2024-07-18', 'Visa Expiration', '0', 'KamalaI1590', '25008'); INSERT INTO reminders VALUES ('10386', '2024-07-18', 'Visa Expiration', '0', 'DeviI1015', '25008'); INSERT INTO reminders VALUES ('10387', '2024-07-18', 'Visa Expiration', '0', 'DritiI1014', '25008'); INSERT INTO reminders VALUES ('10388', '2023-06-04', 'Insurance Expiration', '0', 'BhuvanG0001', '25028'); INSERT INTO reminders VALUES ('10389', '2024-02-21', 'Insurance Expiration', '0', 'SeethaG0002', '25028'); INSERT INTO reminders VALUES ('10390', '2025-01-25', 'Insurance Expiration', '0', 'RaviG151', '25028'); INSERT INTO reminders VALUES ('10391', '2025-05-20', 'Insurance Expiration', '0', 'MeenaiG150', '25028'); INSERT INTO reminders VALUES ('10392', '2027-09-30', 'Insurance Expiration', '0', 'AnkitG1004', '25028'); INSERT INTO reminders VALUES ('10393', '2027-10-04', 'Insurance Expiration', '0', 'NainaG1005', '25028'); INSERT INTO reminders VALUES ('10394', '2023-04-03', 'Insurance Expiration', '0', 'SundaranI0199', '25028'); INSERT INTO reminders VALUES ('10395', '2025-02-14', 'Insurance Expiration', '0', 'KamakshiI0200', '25028'); INSERT INTO reminders VALUES ('10396', '2026-06-30', 'Insurance Expiration', '0', 'SureshanI1600', '25028'); INSERT INTO reminders VALUES ('10397', '2027-11-11', 'Insurance Expiration', '0', 'KamalaI1590', '25028'); INSERT INTO reminders VALUES ('10398', '2026-12-30', 'Insurance Expiration', '0', 'DeviI1015', '25028'); INSERT INTO reminders VALUES ('10399', '2026-10-10', 'Insurance Expiration', '0', 'DritiI1014', '25028'); INSERT INTO reminders VALUES ('10400', '2020-11-25', 'Insurance Expiration', '0', 'YogiS2349', '25028'); INSERT INTO reminders VALUES ('10401', '2025-08-11', 'Insurance Expiration', '0', 'AshaS2333', '25028'); INSERT INTO reminders VALUES ('10402', '2026-05-24', 'Insurance Expiration', '0', 'PrateekSS988', '25028'); INSERT INTO reminders VALUES ('10403', '2026-03-24', 'Insurance Expiration', '0', 'GopiS989', '25028'); INSERT INTO reminders VALUES ('10404', '2026-08-22', 'Insurance Expiration', '0', 'RohanS098', '25028'); INSERT INTO reminders VALUES ('10405', '2027-02-13', 'Insurance Expiration', '0', 'RahulS100', '25028'); INSERT INTO reminders VALUES ('10406', '2023-03-04', 'Insurance Expiration', '0', 'bhuvanG0001', '25029'); INSERT INTO reminders VALUES ('10407', '2024-06-28', 'Insurance Expiration', '0', 'SeethaG0002', '25029'); INSERT INTO reminders VALUES ('10408', '2025-09-25', 'Insurance Expiration', '0', 'RaviG151', '25029'); INSERT INTO reminders VALUES ('10409', '2025-01-20', 'Insurance Expiration', '0', 'MeenaiG150', '25029'); INSERT INTO reminders VALUES ('10410', '2027-08-30', 'Insurance Expiration', '0', 'AnkitG1004', '25029'); INSERT INTO reminders VALUES ('10411', '2027-04-03', 'Insurance Expiration', '0', 'SundaranI0199', '25029'); INSERT INTO reminders VALUES ('10412', '2025-08-16', 'Insurance Expiration', '0', 'KamakshiI0200', '25029'); INSERT INTO reminders VALUES ('10413', '2025-09-14', 'Insurance Expiration', '0', 'SureshanI1600', '25029'); INSERT INTO reminders VALUES ('10414', '2027-10-11', 'Insurance Expiration', '0', 'KamalaI1590', '25029'); INSERT INTO reminders VALUES ('10415', '2026-12-14', 'Insurance Expiration', '0', 'DeviI1015', '25029'); INSERT INTO reminders VALUES ('10416', '2026-04-04', 'Insurance Expiration', '0', 'DritiI1014', '25029'); INSERT INTO reminders VALUES ('10417', '2026-06-25', 'Insurance Expiration', '0', 'YogiS2349', '25029'); INSERT INTO reminders VALUES ('10418', '2025-02-11', 'Insurance Expiration', '0', 'AshaS2333', '25029'); INSERT INTO reminders VALUES ('10419', '2028-05-24', 'Insurance Expiration', '0', 'PrateekSS988', '25029'); INSERT INTO reminders VALUES ('10420', '2027-07-24', 'Insurance Expiration', '0', 'GopiS989', '25029'); INSERT INTO reminders VALUES ('10421', '2025-02-13', 'Insurance Expiration', '0', 'RohanS098', '25029'); INSERT INTO reminders VALUES ('10422', '2027-02-13', 'Insurance Expiration', '0', 'RahulS100', '25029'); INSERT INTO reminders VALUES ('10423', '2023-03-04', 'Insurance Expiration', '0', 'bhuvanG0001', '25030'); INSERT INTO reminders VALUES ('10424', '2022-01-28', 'Insurance Expiration', '0', 'SeethaG0002', '25030'); INSERT INTO reminders VALUES ('10425', '2024-09-25', 'Insurance Expiration', '0', 'RaviG151', '25030'); INSERT INTO reminders VALUES ('10426', '2023-01-20', 'Insurance Expiration', '0', 'MeenaiG150', '25030'); INSERT INTO reminders VALUES ('10427', '2024-03-03', 'Insurance Expiration', '0', 'SundaranI0199', '25030'); INSERT INTO reminders VALUES ('10428', '2023-12-16', 'Insurance Expiration', '0', 'KamakshiI0200', '25030'); INSERT INTO reminders VALUES ('10429', '2023-11-09', 'Insurance Expiration', '0', 'SureshanI1600', '25030'); INSERT INTO reminders VALUES ('10430', '2024-10-11', 'Insurance Expiration', '0', 'KamalaI1590', '25030'); INSERT INTO reminders VALUES ('10431', '2024-09-25', 'Insurance Expiration', '0', 'YogiS2349', '25030'); INSERT INTO reminders VALUES ('10432', '2025-04-11', 'Insurance Expiration', '0', 'AshaS2333', '25030'); INSERT INTO reminders VALUES ('10433', '2025-05-24', 'Insurance Expiration', '0', 'PrateekSS988', '25030'); INSERT INTO reminders VALUES ('10434', '2024-05-24', 'Insurance Expiration', '0', 'GopiS989', '25030'); INSERT INTO reminders VALUES ('10435', '2025-04-28', 'Insurance Expiration', '0', 'bhuvanG0001', '25031'); INSERT INTO reminders VALUES ('10436', '2022-01-26', 'Insurance Expiration', '0', 'SeethaG0002', '25031'); INSERT INTO reminders VALUES ('10437', '2026-05-25', 'Insurance Expiration', '0', 'RaviG151', '25031'); INSERT INTO reminders VALUES ('10438', '2025-01-20', 'Insurance Expiration', '0', 'MeenaiG150', '25031'); INSERT INTO reminders VALUES ('10439', '2021-02-03', 'Insurance Expiration', '0', 'SundaranI0199', '25031'); INSERT INTO reminders VALUES ('10440', '2024-12-16', 'Insurance Expiration', '0', 'KamakshiI0200', '25031'); INSERT INTO reminders VALUES ('10441', '2022-10-09', 'Insurance Expiration', '0', 'SureshanI1600', '25031'); INSERT INTO reminders VALUES ('10442', '2024-09-11', 'Insurance Expiration', '0', 'KamalaI1590', '25031'); INSERT INTO reminders VALUES ('10443', '2025-09-25', 'Insurance Expiration', '0', 'YogiS2349', '25031'); INSERT INTO reminders VALUES ('10444', '2024-04-11', 'Insurance Expiration', '0', 'AshaS2333', '25031'); INSERT INTO reminders VALUES ('10445', '2025-09-24', 'Insurance Expiration', '0', 'PrateekSS988', '25031'); INSERT INTO reminders VALUES ('10446', '2024-03-24', 'Insurance Expiration', '0', 'GopiS989', '25031'); INSERT INTO reminders VALUES ('10447', '2023-07-18', 'Lease End', '0', 'SureshanI1600', '25002'); INSERT INTO reminders VALUES ('10448', '2023-08-10', 'Lease End', '0', 'AnkitG1004', '25002'); select * from reminders; INSERT INTO document_locations VALUES('123001', '123', '18431', 'Job Details', 'Goswamy Family Filing Cabinet', 'Goswamy Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('123002', '123', '18432', 'Rental Property', 'Goswamy Family Filing Cabinet', 'Goswamy Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('123003', '123', '18433', 'Family Property', 'Goswamy Family Filing Cabinet', 'Goswamy Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('123004', '123', '18435', 'Membership', 'Goswamy Family Filing Cabinet', 'Goswamy Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('123005', '123', '18436', 'Identification Info', 'Goswamy Family Filing Cabinet', 'Goswamy Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('123006', '123', '18437', 'Insurance Details', 'Goswamy Family Filing Cabinet', 'Goswamy Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('123007', '123', '18438', 'Medical Records', 'Goswamy Family Filing Cabinet', 'Goswamy Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('123008', '123', '18439', 'Reminders', 'Goswamy Family Filing Cabinet', 'Goswamy Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('123009', '123', '18440', 'Academic Records', 'Goswamy Family Filing Cabinet', 'Goswamy Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('742001', '742', '18431', 'Job Details', 'Sharma Family Bookshelf', 'Sharma Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('742002', '742', '18432', 'Rental Property', 'Sharma Family Bookshelf', 'Sharma Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('742003', '742', '18433', 'Family Property', 'Sharma Family Bookshelf', 'Sharma Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('742004', '742', '18435', 'Membership', 'Sharma Family Bookshelf', 'Sharma Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('742005', '742', '18436', 'Identification Info', 'Sharma Family Bookshelf', 'Sharma Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('742006', '742', '18437', 'Insurance Details', 'Sharma Family Bookshelf', 'Sharma Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('742007', '742', '18438', 'Medical Records', 'Sharma Family Bookshelf', 'Sharma Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('742008', '742', '18439', 'Reminders', 'Sharma Family Bookshelf', 'Sharma Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('742009', '742', '18440', 'Academic Records', 'Sharma Family Bookshelf', 'Sharma Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('984001', '984', '18431', 'Job Details', 'Iyer Family Bookshelf', 'Iyer Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('984002', '984', '18432', 'Rental Property', 'Iyer Family Bookshelf', 'Iyer Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('984003', '984', '18433', 'Family Property', 'Iyer Family Bookshelf', 'Iyer Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('984004', '984', '18435', 'Membership', 'Iyer Family Bookshelf', 'Iyer Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('984005', '984', '18436', 'Identification Info', 'Iyer Family Bookshelf', 'Iyer Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('984006', '984', '18437', 'Insurance Details', 'Iyer Family Bookshelf', 'Iyer Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('984007', '984', '18438', 'Medical Records', 'Iyer Family Bookshelf', 'Iyer Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('984008', '984', '18439', 'Reminders', 'Iyer Family Bookshelf', 'Iyer Office Room Desktop File Explorer'); INSERT INTO document_locations VALUES('984009', '984', '18440', 'Academic Records', 'Iyer Family Bookshelf', 'Iyer Office Room Desktop File Explorer'); -- QUERIES -- Query to retrieve the insurance details of user BhuvanG001. SELECT * FROM insurance_details WHERE InsuranceHolderID = 'BhuvanG0001'; -- Query to retrieve the number of insurances policies that each family has. SELECT f.FamilyName, COUNT(i.InsuranceID) AS NumberOfPolicies FROM family f JOIN insurance_details i ON f.FamilyID = i.FamilyID GROUP BY f.FamilyID; -- Query to retrieve info of membership holder and the start and end dates of the memberships that have a start date on or after January 1st, 2020 and an end date on or before December 31st, 2030. SELECT p.FirstName, f.FamilyName, m.MembershipName, m.MembershipStartDate, m.MembershipEndDate FROM memberships m JOIN profile p ON m.MembershipHolderID = p.profileID JOIN family f ON p.FamilyID = f.FamilyID JOIN document_subtypes dst ON m.DocumentSubTypeID = dst.DocumentSubTypeID WHERE m.MembershipStartDate >= '2020-01-01' AND m.MembershipEndDate <= '2030-12-31' ORDER BY p.LastName, p.FirstName; -- Query retrives information of individuals whose passport isn't expired . The ID 25007 is used as a filter for the DocumentSubTypeID, which represents passport. Ordered the results by the FamilyName SELECT ii.DocumentHolderID, p.FirstName, f.FamilyName, ii.ExpirationDate FROM identification_info ii JOIN profile p ON ii.DocumentHolderID = p.profileID JOIN family f ON p.FamilyID = f.FamilyID WHERE ii.DocumentSubTypeID = '25007' AND ii.ExpirationDate > CURDATE() AND (p.FirstName LIKE '%Bhuvan%' OR p.LastName LIKE '%Iyer%') ORDER BY f.FamilyName, p.LastName, p.FirstName; -- Query to return a list of all who have joined a new job in the last 2 years. SELECT * FROM job_details WHERE JobStartDate BETWEEN '2021-05-02' AND '2023-05-02' ORDER BY JobStartDate; -- Query to retrieve for all profiles who will graduate after 2021, ordered by last name and first name. SELECT p.FirstName, p.LastName, a.EducationType, a.GraduationDate FROM academic_records a INNER JOIN profile p ON a.profileID = p.ProfileID LEFT JOIN document_locations d ON a.AcademicRecordID = d.DocumentTypeID AND d.DocumentTypeName = 'Transcript' WHERE a.GraduationDate > '2021-01-01' AND a.CompletedEducationType = 0 ORDER BY p.LastName, p.FirstName; -- Query to retrieve the data of each family that meets the following criteria: -- 1.The property purchase date is between January 1, 2010, and December 31, 2019. -- 2.The family has at least one document location associated with it. SELECT f.FamilyName, f.FamilyType, fp.PropertyType, fp.PropertyPurchaseDate, (SELECT COUNT(*) FROM family_property WHERE FamilyID = f.FamilyID) AS NumOfProperties, (SELECT COUNT(*) FROM family_property WHERE FamilyID = f.FamilyID AND PropertyType = 'Apartment') AS NumOfApartments, (CASE WHEN fp.PropertyType = 'House' THEN (SELECT COUNT(*) FROM family_property WHERE FamilyID = f.FamilyID AND PropertyType = 'House' AND PropertyPurchaseDate < fp.PropertyPurchaseDate) ELSE NULL END) AS NumOfHousesPurchasedBefore FROM family f INNER JOIN family_property fp ON f.FamilyID = fp.FamilyID WHERE fp.PropertyPurchaseDate BETWEEN '2010-01-01' AND '2019-12-31' AND (SELECT COUNT(*) FROM document_locations WHERE FamilyID = f.FamilyID) > 0; -- Query retrieves memberships that started after 2019, have no end date or end before 2031, and where the hourly salary is greater than $30 or null SELECT m.MembershipID, m.MembershipName, p.FirstName, f.FamilyName, j.HourlySalaryUSD FROM memberships m INNER JOIN profile p ON m.MembershipHolderID = p.ProfileID INNER JOIN family f ON p.FamilyID = f.FamilyID LEFT JOIN job_details j ON p.ProfileID = j.ProfileID WHERE m.MembershipStartDate >= '2020-01-01' AND (j.CurrentJob = 1) AND (m.MembershipEndDate IS NULL OR m.MembershipEndDate < '2031-01-01') AND (j.HourlySalaryUSD > 30 OR j.HourlySalaryUSD IS NULL) ORDER BY p.LastName, p.FirstName; -- Query to check the medical appointment including health insurance. SELECT p.FirstName, p.LastName, md.DateOfVisit, md.TypeOfIllness, md.DoctorName, i.InsurancePlanName, i.InsuranceCompany FROM profile p JOIN medical_records md ON p.profileID = md.profileID JOIN insurance_details i ON p.profileID = i.InsuranceHolderID WHERE p.FamilyID = 123; -- Query to get a complete view of health and medical insurances. SELECT * FROM insurance_details INNER JOIN medical_records ON insurance_details.InsuranceHolderID = medical_records.profileID; -- FUNCTIONS -- Function to calculate the total insurance premium paid by family. DELIMITER // CREATE FUNCTION calculateTotalPremiumPaidByFamily (familyId integer) RETURNS decimal(9, 2) DETERMINISTIC BEGIN DECLARE totalPremiumPaid decimal(9, 2); SELECT SUM(InsurancePremium) INTO totalPremiumPaid FROM insurance_details WHERE insurance_details.FamilyID = familyId; RETURN totalPremiumPaid; END// DELIMITER ; -- Query to call function SELECT calculateTotalPremiumPaidByFamily(742) AS 'Total Premium Paid'; -- Function to get a count of how many identification information documents a user has. DELIMITER // CREATE FUNCTION get_document_count_by_holder_id(holder_id_param varchar(50)) RETURNS INT DETERMINISTIC BEGIN DECLARE document_count INT; SELECT COUNT(*) INTO document_count FROM identification_info WHERE DocumentHolderID = holder_id_param; RETURN document_count; END// DELIMITER ; -- Query to call function SELECT get_document_count_by_holder_id('RahulS100') AS 'Total Document Count of User: RahulS100'; -- Function to get the total membership costs for a given user. DELIMITER // CREATE FUNCTION get_total_membership_cost_by_profile_id(profile_id_param VARCHAR(50)) RETURNS DECIMAL(15,2) DETERMINISTIC BEGIN DECLARE total_cost DECIMAL(15,2); SELECT SUM(MembershipCost) INTO total_cost FROM memberships WHERE MembershipHolderID = profile_id_param; IF total_cost IS NULL THEN SET total_cost = 0; END IF; RETURN total_cost; END// DELIMITER ; -- Query to call the function SELECT get_total_membership_cost_by_profile_id('BhuvanG0001') AS 'Total Memberships Cost for BhuvanG0001'; -- TRIGGERS -- -- Trigger Audit Tables -- REMINDER INSERT AUDIT TABLE ----- drop table if exists reminders_insert_audit; CREATE TABLE if not exists reminders_insert_audit( id int UNIQUE NOT NULL AUTO_INCREMENT, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, MembershipHolderID varchar(50), MembershipName varchar(30), MembershipEndDate date NOT NULL, DocumentSubTypeID int not null ); -- Trigger to insert Expiration Date into Reminders after purchasing a new membership Delimiter \\ CREATE TRIGGER insert_reminder AFTER INSERT ON memberships FOR EACH ROW BEGIN INSERT INTO reminders (EventName, EventDate, RecurringEvent, profileID, DocumentSubTypeID) VALUES (CONCAT(NEW.MembershipName, ' ', ' Expiration'), NEW.MembershipEndDate, '1', NEW.MembershipHolderID, NEW.DocumentSubTypeID); INSERT INTO reminders_insert_audit(created_at,MembershipHolderID, MembershipName, MembershipEndDate, DocumentSubTypeID) VALUES(now(),NEW.MembershipHolderID,NEW.MembershipName,NEW.MembershipEndDate,NEW.DocumentSubTypeID); END\\ -- Statement to execute trigger INSERT INTO memberships VALUES (null, '984', 'BhuvanG0001', '25050', 'Netflix', '2022-08-10', '2024-06-20', '100'); SELECT * FROM reminders_insert_audit; -- REMINDER UPDATE AUDIT TABLE ----- drop table if exists reminders_update_audit; CREATE TABLE if not exists reminders_update_audit( ident int UNIQUE NOT NULL AUTO_INCREMENT, profileID varchar(50), DocumentSubTypeID int not null, EventDate date NOT NULL, created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ); -- Trigger to Update New Expiration date of an Identification Document after getting it Renewed drop trigger if exists after_update_reminder; Delimiter \\ CREATE TRIGGER after_update_reminder AFTER UPDATE ON identification_info FOR EACH ROW BEGIN UPDATE reminders SET EventDate = NEW.ExpirationDate WHERE DocumentSubTypeID = OLD.DocumentSubTypeID AND profileID = OLD.DocumentHolderID; INSERT INTO reminders_update_audit(profileID, DocumentSubTypeID, EventDate, created_at) VALUES (OLD.DocumentHolderID, OLD.DocumentSubTypeID, NEW.ExpirationDate, now()); END\\ -- Statement to execute trigger UPDATE identification_info SET ExpirationDate = '2027-05-31' WHERE DocumentHolderID = 'YogiS2349' AND DocumentSubTypeID = 25005; SELECT * FROM reminders_update_audit; -- MEMBERSHIP DELETE AUDIT TABLE ----- drop table if exists membership_delete_audit; Delimiter \\ CREATE TABLE if not exists membership_delete_audit( id int UNIQUE NOT NULL AUTO_INCREMENT PRIMARY KEY, EventName char(30), DocumentSubTypeID int not null, MembershipHolderID varchar(50), deleted_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ); \\ -- Trigger to delete membership expiration date reminder when deleting membership of a specific profile drop trigger after_delete_memberships; Delimiter \\ CREATE TRIGGER after_delete_memberships AFTER DELETE ON memberships FOR EACH ROW BEGIN DELETE FROM Reminders WHERE profileID = OLD.MembershipHolderID; INSERT INTO membership_delete_audit(EventName, DocumentSubTypeID, MembershipHolderID, deleted_at) VALUES (CONCAT(OLD.MembershipName, ' ', 'Expiration'), OLD.DocumentSubTypeID, OLD.MembershipHolderID, now()); END\\ -- Statement to execute the trigger DELETE FROM memberships WHERE MembershipHolderID = 'GopiS989' AND DocumentSubTypeID = 25015; SELECT * FROM membership_delete_audit; DELIMITER ; -- VIEWS -- View to see where the documents are located both physically and electronically in each household. CREATE VIEW docs_physicalloc AS SELECT d.DocumentTypeName, d.PhysicalLocation, d.ElectronicLocation FROM document_locations d ORDER BY d.DocumentTypeName; SELECT * FROM docs_physicalloc; -- View to see how many document types each family has in each location where documents are stored. CREATE VIEW total_documents_by_location AS SELECT 'Physical' AS LocationType, PhysicalLocation AS Location, COUNT(*) AS DocumentCount FROM document_locations GROUP BY PhysicalLocation UNION ALL SELECT 'Electronic' AS LocationType, ElectronicLocation AS Location, COUNT(*) AS DocumentCount FROM document_locations GROUP BY ElectronicLocation; SELECT * FROM total_documents_by_location; -- View to see who lived at each rental property that a family stayed in. CREATE VIEW FamilyProperties1 AS SELECT f.FamilyName, COUNT(rp.RentalID) AS NumProperties, GROUP_CONCAT(p.FirstName, ' ', p.LastName SEPARATOR ', ') as PeopleStaying FROM family f LEFT JOIN profile p ON f.FamilyID = p.FamilyID LEFT JOIN rental_property rp ON p.ProfileID = rp.TenantID GROUP BY f.FamilyID; SELECT * FROM FamilyProperties1; -- store procedures -- store procedures for adding a new job DELIMITER // CREATE PROCEDURE AddJob( IN JobDetailID int, IN PositionName VARCHAR(25), IN CompanyName VARCHAR(25), IN HourlySalaryUSD INT, IN JobCity VARCHAR(25), IN JobState VARCHAR(25), IN JobStartDate DATE, IN JobEndDate DATE, IN CurrentJob TINYINT, IN ProfileID VARCHAR(50), IN DocumentSubTypeID int ) BEGIN INSERT INTO job_details (JobDetailID, PositionName, CompanyName, HourlySalaryUSD, JobCity, JobState, JobStartDate, JobEndDate, CurrentJob, profileID, DocumentSubTypeID) VALUES (JobDetailID, PositionName, CompanyName, HourlySalaryUSD, JobCity, JobState, JobStartDate, JobEndDate, CurrentJob, ProfileID, DocumentSubTypeID); END// DELIMITER ; CALL AddJob(1013, 'Professor', 'UTD', 60, 'Dallas', 'Texas', '2023-05-01', NULL, 1, 'GopiS989', 25055); select * from job_details; -- store procedure for adding a new member DELIMITER // CREATE PROCEDURE AddNewMember( IN FamilyID INT, IN FirstName VARCHAR(25), IN LastName VARCHAR(25), IN DateOfBirth DATE, IN EmailAddress VARCHAR(50), IN PhoneNumber VARCHAR(9), IN AddressSeqNum INT, IN Dependent Tinyint, IN DependentType VARCHAR(25) ) BEGIN DECLARE ProfileID VARCHAR(50); SET ProfileID = CONCAT('TaraS2233', (SELECT COUNT(*)+1 FROM profile WHERE FamilyID = FamilyID)); INSERT INTO profile (ProfileID, FamilyID, FirstName, LastName, DateOfBirth, EmailAddress, PhoneNumber, AddressSeqNum, Dependent, DependentType) VALUES (ProfileID, FamilyID, FirstName, LastName, DateOfBirth, EmailAddress, PhoneNumber, AddressSeqNum, Dependent, DependentType); UPDATE family SET NumOfMembers = NumOfMembers + 1 WHERE FamilyID = FamilyID; END // DELIMITER ; CALL AddNewMember(742, 'Tara', 'Sharma', '2023-04-28', 'gopi_sharma13@gmail.com', '984310896', 999, 1,'Child'); select * from profile; -- store procedures for adding new ID- birthceritificate DELIMITER // CREATE PROCEDURE AddIdentificationNewMember( IN IdentificationDocID VARCHAR(6), IN FamilyID INT, IN DocumentHolderID VARCHAR(50), IN DocumentSubTypeID INT, IN IssuanceDate DATE, IN ExpirationDate DATE ) BEGIN INSERT INTO identification_info (IdentificationDocID, FamilyID, DocumentHolderID, DocumentSubTypeID, IssuanceDate, ExpirationDate) VALUES (IdentificationDocID, FamilyID, DocumentHolderID, DocumentSubTypeID, IssuanceDate, ExpirationDate); END // DELIMITER ; CALL AddIdentificationNewMember('880009', 742, 'TaraS223319', 25006, '2023-04-28', NULL); select * from identification_info;