Sprint

-- Create the Customer Table
CREATE TABLE Customer (
Customer_SSN_ID BIGINT PRIMARY KEY,
First_Name VARCHAR(50) NOT NULL,
Last_Name VARCHAR(50) NOT NULL,
Email VARCHAR(100) NOT NULL,
Date_Of_Birth DATE NOT NULL,
Address VARCHAR(100),
Contact_Number CHAR(10) CHECK (Contact_Number ~ '^[0-9]{10}$')
);

-- Insert 10 demo records into the Customer table with Kolkata names
INSERT INTO Customer (Customer_SSN_ID, First_Name, Last_Name, Email, Date_Of_Birth, Address, Contact_Number) VALUES
(1000000001, 'Arjun', 'Chakraborty', '[email protected]', '1985-01-15', '123 Park St, Kolkata', '9876543210'),
(1000000002, 'Ananya', 'Banerjee', '[email protected]', '1990-02-25', '456 College St, Kolkata', '8765432109'),
(1000000003, 'Subhajit', 'Das', '[email protected]', '1978-03-10', '789 Ballygunge Pl, Kolkata', '7654321098'),
(1000000004, 'Moumita', 'Sengupta', '[email protected]', '1992-04-05', '101 Elgin Rd, Kolkata', '6543210987'),
(1000000005, 'Ritwik', 'Mukherjee', '[email protected]', '1980-05-20', '202 Dhakuria, Kolkata', '5432109876'),
(1000000006, 'Priya', 'Bhattacharya', '[email protected]', '1987-06-30', '303 Salt Lake, Kolkata', '4321098765'),
(1000000007, 'Debashis', 'Roy', '[email protected]', '1995-07-15', '404 Shyambazar, Kolkata', '3210987654'),
(1000000008, 'Sanjana', 'Sen', '[email protected]', '1989-08-25', '505 New Alipore, Kolkata', '2109876543'),
(1000000009, 'Partha', 'Ghosh', '[email protected]', '1993-09-10', '606 Tollygunge, Kolkata', '1098765432'),
(1000000010, 'Riya', 'Chatterjee', '[email protected]', '1982-10-30', '707 Behala, Kolkata', '9988776655');