BookStoreDb.sql

INSERT INTO Publishers (Name)
VALUES ('Badar Publishers');

INSERT INTO Categories (Name)
VALUES ('Programming');

INSERT INTO Books (Title, ISBN, Price, Stock, CategoryId, PublisherId)
VALUES ('Clean Code', '9780132350884', 29.99, 10, 1, 1);

INSERT INTO Customers (Name, Email)
VALUES 
('Ali Khan', 'ali.khan@example.com'),
('Sara Ahmed', 'sara.ahmed@example.com'),
('John Smith', 'john.smith@example.com'),
('Emily Johnson', 'emily.johnson@example.com'),
('Omar Farooq', 'omar.farooq@example.com'),
('Ayesha Malik', 'ayesha.malik@example.com'),
('Hassan Raza', 'hassan.raza@example.com'),
('Fatima Noor', 'fatima.noor@example.com'),
('David Brown', 'david.brown@example.com'),
('Michael Scott', 'michael.scott@dundermifflin.com'),
('Pam Beesly', 'pam.beesly@dundermifflin.com'),
('Jim Halpert', 'jim.halpert@dundermifflin.com'),
('Dwight Schrute', 'dwight.schrute@dundermifflin.com'),
('Zain Ali', 'zain.ali@example.com'),
('Noor Fatima', 'noor.fatima@example.com');