CREATE TABLE Owner_Dimension (
    Owner_Id INT PRIMARY KEY,
    Name VARCHAR(100),
    Contact VARCHAR(15),
    Address VARCHAR(100)
);

INSERT INTO Owner_Dimension (Owner_Id, Name, Contact, Address) VALUES
(1, 'Amit Sharma', '9876543210', 'Mumbai, India'),
(2, 'Priya Mehta', '9123456780', 'Pune, India'),
(3, 'Rahul Verma', '9988776655', 'Delhi, India'),
(4, 'Sneha Kapoor', '9090909090', 'Bengaluru, India'),
(5, 'Ravi Patel', '9876501234', 'Ahmedabad, India'),
(6, 'Neha Joshi', '9123098765', 'Chennai, India'),
(7, 'Arjun Singh', '9998887770', 'Kolkata, India'),
(8, 'Meera Iyer', '9812345670', 'Hyderabad, India'),
(9, 'Karan Desai', '9080706050', 'Surat, India'),
(10, 'Rohit Bansal', '9955443322', 'Noida, India'),
(11, 'Pooja Nair', '9765432109', 'Thiruvananthapuram, India'),
(12, 'Anil Kumar', '9801234567', 'Patna, India'),
(13, 'Divya Rathi', '9797979797', 'Indore, India'),
(14, 'Vivek Menon', '9654321987', 'Kochi, India'),
(15, 'Isha Malhotra', '9009009000', 'Nagpur, India'),
(16, 'Suresh Pillai', '9543219876', 'Visakhapatnam, India'),
(17, 'Akash Jain', '9876123456', 'Jaipur, India'),
(18, 'Ritika Gupta', '9898989898', 'Chandigarh, India'),
(19, 'Harsh Trivedi', '9123450000', 'Rajkot, India'),
(20, 'Shreya Ghosh', '9911223344', 'Lucknow, India');

SELECT * FROM Owner_Dimension;

CREATE TABLE Pet_Dimension (
    Pet_Id INT PRIMARY KEY,
    Name VARCHAR(50),
    Species VARCHAR(50),
    Breed VARCHAR(100),
    Age INT,
    Sex VARCHAR(10),
    Weight DECIMAL(5,2),
    Medical_Condition VARCHAR(100)
);

INSERT INTO Pet_Dimension (Pet_Id, Name, Species, Breed, Age, Sex, Weight, Medical_Condition) VALUES
(1, 'Bella', 'Dog', 'Labrador', 5, 'Female', 25.5, 'Arthritis'),
(2, 'Max', 'Dog', 'Beagle', 3, 'Male', 12.8, 'Healthy'),
(3, 'Luna', 'Cat', 'Persian', 2, 'Female', 4.5, 'Allergy'),
(4, 'Charlie', 'Dog', 'German Shepherd', 4, 'Male', 30.2, 'Hip Dysplasia'),
(5, 'Coco', 'Parrot', 'African Grey', 6, 'Male', 0.9, 'Feather Plucking'),
(6, 'Rocky', 'Dog', 'Pug', 7, 'Male', 8.3, 'Obesity'),
(7, 'Milo', 'Cat', 'Siamese', 1, 'Male', 3.8, 'Healthy'),
(8, 'Ruby', 'Rabbit', 'Holland Lop', 2, 'Female', 1.5, 'Dental Issues'),
(9, 'Buddy', 'Dog', 'Golden Retriever', 5, 'Male', 28.4, 'Arthritis'),
(10, 'Daisy', 'Dog', 'Cocker Spaniel', 3, 'Female', 11.2, 'Ear Infection'),
(11, 'Shadow', 'Cat', 'Maine Coon', 4, 'Male', 6.9, 'Fever'),
(12, 'Oliver', 'Dog', 'Bulldog', 6, 'Male', 24.0, 'Breathing Issues'),
(13, 'Chloe', 'Cat', 'Bengal', 2, 'Female', 4.0, 'Healthy'),
(14, 'Bubbles', 'Fish', 'Goldfish', 1, 'Male', 0.1, 'Healthy'),
(15, 'Snowy', 'Dog', 'Samoyed', 4, 'Female', 22.0, 'Healthy'),
(16, 'Zara', 'Cat', 'Ragdoll', 3, 'Female', 5.2, 'Hairball Problem'),
(17, 'Tiger', 'Dog', 'Rottweiler', 5, 'Male', 40.0, 'Joint Pain'),
(18, 'Peppy', 'Parrot', 'Macaw', 2, 'Female', 1.1, 'Healthy'),
(19, 'Simba', 'Cat', 'Himalayan', 4, 'Male', 5.0, 'Kidney Issues'),
(20, 'Lily', 'Rabbit', 'Mini Rex', 1, 'Female', 1.4, 'Healthy');

CREATE TABLE Treatment_Dimension (
    Treatment_Id INT PRIMARY KEY,
    Description VARCHAR(100),
    Diagnosis VARCHAR(100),
    Medicines VARCHAR(100),
    Cost DECIMAL(10,2)
);
INSERT INTO Treatment_Dimension (Treatment_Id, Description, Diagnosis, Medicines, Cost) VALUES
(1, 'Vaccination', 'Routine Immunization', 'Rabies, Distemper', 1500.00),
(2, 'Check-up', 'General Health Check', 'Multivitamins', 800.00),
(3, 'Surgery', 'Spaying', 'Antibiotics', 5000.00),
(4, 'Dental Cleaning', 'Tartar Removal', 'Mouth Rinse', 1200.00),
(5, 'Allergy Treatment', 'Skin Allergy', 'Antihistamines', 1800.00),
(6, 'Neutering', 'Population Control', 'Painkillers', 4500.00),
(7, 'Deworming', 'Parasite Removal', 'Deworming Tablets', 500.00),
(8, 'X-Ray', 'Bone Fracture', 'None', 2500.00),
(9, 'Ultrasound', 'Pregnancy Check', 'None', 3000.00),
(10, 'Blood Test', 'Health Diagnosis', 'None', 1500.00),
(11, 'Chemotherapy', 'Cancer Treatment', 'Cancer Drugs', 15000.00),
(12, 'Microchipping', 'Pet Identification', 'None', 2000.00),
(13, 'Ear Cleaning', 'Ear Infection', 'Ear Drops', 900.00),
(14, 'Grooming', 'Hair Cut & Bath', 'Shampoo, Conditioner', 1000.00),
(15, 'Physiotherapy', 'Joint Pain Relief', 'Therapy Exercises', 2500.00),
(16, 'Diet Consultation', 'Obesity Management', 'Diet Plan', 1200.00),
(17, 'Wound Dressing', 'Injury Care', 'Bandages, Ointment', 700.00),
(18, 'Vaccination', 'Booster Shot', 'Parvo, Rabies', 1600.00),
(19, 'Eye Surgery', 'Cataract Removal', 'Eye Drops', 10000.00),
(20, 'Heart Check-up', 'Cardiac Health', 'Cardiac Medicines', 4000.00);

CREATE TABLE Payment_Dimension (
    Payment_Id INT PRIMARY KEY,
    Payment_Method VARCHAR(50),
    Payment_Status VARCHAR(20),
    Total_Bill DECIMAL(10,2)
);
INSERT INTO Payment_Dimension (Payment_Id, Payment_Method, Payment_Status, Total_Bill) VALUES
(1, 'Cash', 'Paid', 1500.00),
(2, 'Credit Card', 'Paid', 800.00),
(3, 'UPI', 'Pending', 5000.00),
(4, 'Debit Card', 'Paid', 1200.00),
(5, 'UPI', 'Paid', 1800.00),
(6, 'Cash', 'Paid', 4500.00),
(7, 'UPI', 'Paid', 500.00),
(8, 'Credit Card', 'Paid', 2500.00),
(9, 'UPI', 'Paid', 3000.00),
(10, 'Debit Card', 'Paid', 1500.00),
(11, 'Credit Card', 'Paid', 15000.00),
(12, 'Cash', 'Paid', 2000.00),
(13, 'Cash', 'Paid', 900.00),
(14, 'UPI', 'Paid', 1000.00),
(15, 'Debit Card', 'Paid', 2500.00),
(16, 'Credit Card', 'Pending', 1200.00),
(17, 'UPI', 'Paid', 700.00),
(18, 'UPI', 'Paid', 1600.00),
(19, 'Cash', 'Paid', 10000.00),
(20, 'Debit Card', 'Paid', 4000.00);