# Insert 10 dummy data into Pubs database each table

-- Insert dummy data into Authors table
INSERT INTO Authors (AuthorID, AuthorLastName, AuthorFirstName, AuthorPhone)
VALUES 
(1, 'Smith', 'John', '555-1234'),
(2, 'Johnson', 'Michael', '555-5678'),
(3, 'Williams', 'Emily', '555-7890'),
(4, 'Brown', 'David', '555-2345'),
(5, 'Jones', 'Jessica', '555-6789'),
(6, 'Miller', 'Daniel', '555-4321'),
(7, 'Davis', 'Sarah', '555-9876'),
(8, 'Garcia', 'James', '555-3456'),
(9, 'Wilson', 'Jennifer', '555-8765'),
(10, 'Martinez', 'Robert', '555-5432');
GO

-- Insert dummy data into Publishers table
INSERT INTO Publishers (PublisherID, PublisherName, PublisherCity, PublisherState)
VALUES 
(1, 'ABC Publications', 'New York', 'NY'),
(2, 'XYZ Books', 'Los Angeles', 'CA'),
(3, 'Acme Publishing', 'Chicago', 'IL'),
(4, 'Global Books', 'Houston', 'TX'),
(5, 'City Press', 'Miami', 'FL'),
(6, 'Metro Publishers', 'Seattle', 'WA'),
(7, 'Sunrise Books', 'Boston', 'MA'),
(8, 'Golden Pages', 'Atlanta', 'GA'),
(9, 'Harbor Publishing', 'San Francisco', 'CA'),
(10, 'Peak Publications', 'Denver', 'CO');
GO

-- Insert dummy data into Titles table
INSERT INTO Titles (TitleID, Title, PublisherID, PublicationYear)
VALUES 
(1, 'Introduction to SQL', 1, 2020),
(2, 'Advanced SQL Techniques', 2, 2021),
(3, 'Database Design Fundamentals', 3, 2019),
(4, 'Data Warehousing Basics', 4, 2022),
(5, 'SQL Server Administration Guide', 5, 2018),
(6, 'Programming with T-SQL', 6, 2023),
(7, 'Big Data Analytics', 7, 2020),
(8, 'Data Science Essentials', 8, 2021),
(9, 'Machine Learning Algorithms', 9, 2019),
(10, 'Python for Data Analysis', 10, 2022);
GO

-- Insert dummy data into TitleAuthor table
INSERT INTO TitleAuthor (TitleID, AuthorID, Sequence)
VALUES 
(1, 1, 1),
(1, 2, 2),
(2, 3, 1),
(2, 4, 2),
(3, 5, 1),
(3, 6, 2),
(4, 7, 1),
(4, 8, 2),
(5, 9, 1),
(5, 10, 2);
GO

-- Insert dummy data into Stores table
INSERT INTO Stores (StoreID, StoreName, StoreCity, StoreState)
VALUES 
(1, 'Books & More', 'New York', 'NY'),
(2, 'Readers Paradise', 'Los Angeles', 'CA'),
(3, 'Bookworms Corner', 'Chicago', 'IL'),
(4, 'Literary Haven', 'Houston', 'TX'),
(5, 'Pages Galore', 'Miami', 'FL'),
(6, 'Book Nook', 'Seattle', 'WA'),
(7, 'Sunset Books', 'Boston', 'MA'),
(8, 'Bookshelf Emporium', 'Atlanta', 'GA'),
(9, 'City Lights Books', 'San Francisco', 'CA'),
(10, 'Mountain Books', 'Denver', 'CO');
GO

-- Insert dummy data into Sales table
INSERT INTO Sales (SaleID, StoreID, TitleID, SaleDate, QuantitySold)
VALUES 
(1, 1, 1, '2024-03-01', 50),
(2, 2, 2, '2024-03-02', 40),
(3, 3, 3, '2024-03-03', 30),
(4, 4, 4, '2024-03-04', 20),
(5, 5, 5, '2024-03-05', 10),
(6, 6, 6, '2024-03-06', 15),
(7, 7, 7, '2024-03-07', 25),
(8, 8, 8, '2024-03-08', 35),
(9, 9, 9, '2024-03-09', 45),
(10, 10, 10, '2024-03-10', 55);
GO

-- Insert dummy data into Discounts table
INSERT INTO Discounts (DiscountID, DiscountPercentage)
VALUES 
(1, 10),
(2, 15),
(3, 20),
(4, 25),
(5, 30),
(6, 35),
(7, 40),
(8, 45),
(9, 50),
(10, 55);
GO

-- Insert dummy data into Jobs table
INSERT INTO Jobs (JobID, JobTitle)
VALUES 
(1, 'Manager'),
(2, 'Sales Representative'),
(3, 'Developer'),
(4, 'Analyst'),
(5, 'Designer'),
(6, 'Administrator'),
(7, 'Engineer'),
(8, 'Consultant'),
(9, 'Coordinator'),
(10, 'Specialist');
GO

-- Insert dummy data into Employee table
INSERT INTO Employee (EmployeeID, EmployeeName, JobID, HireDate, Salary)
VALUES 
(1, 'John Doe', 1, '2020-01-01', 80000),
(2, 'Jane Smith', 2, '2021-02-01', 60000),
(3, 'Michael Johnson', 3, '2019-03-01', 70000),
(4, 'Emily Williams', 4, '2022-04-01', 90000),
(5, 'David Brown', 5, '2018-05-01', 75000),
(6, 'Jessica Jones', 6, '2023-06-01', 85000),
(7, 'Daniel Miller', 7, '2020-07-01', 95000),
(8, 'Sarah Davis', 8, '2021-08-01', 65000),
(9, 'James Garcia', 9, '2019-09-01', 78000),
(10, 'Jennifer Wilson', 10, '2022-10-01', 72000);
GO