Untitled

describe customer;
INSERT INTO customer (customer_ID, name, email, phone_number)
VALUES
    ('001', 'David', 'David.Attenbrough@gmail.com', 1234567890),
    ('002', 'Allen', 'Allen.Parker@gmail.com', 0987654321),
    ('003', 'Micheal', 'Micheal.Myers@gmail.com', 5432198760),
    ('004', 'Don', 'Don.Julio@gmail.com', 827346501),
    ('005', 'Daniel', 'Daneil.Jack@gmail.com', 1987532075),
    ('006', 'Whitney', 'Whitney.Houston@gmail.com', 49620763957),
    ('007', 'Tyler', 'Tyler.Hero@gmail.com', 863027508639);
select * from customer;

describe employee;
INSERT INTO employee (employee_ID, name, role)
VALUES
    ('001', 'John Adams', 'Barista'),
    ('002', 'Alice Chain', 'Manager'),
    ('003', 'Bobbie Brown', 'Cashier'),
    ('004', 'Nash Norman', 'Barista'),
    ('005', 'Tatum Taylor', 'Assitant Manager'),
    ('006', 'Larry Lugo', 'Barista'),
    ('007', 'Marisol Brandt', 'Cashier'),
select * from employee;

describe rewards;
INSERT INTO rewards (reward_ID, customer_ID, points)
VALUES
    ('15078', '001', 100),
    ('78086', '002', 200),
    ('67883', '003', 150),
    ('73802', '004', 250),
    ('16739', '005', 300),
    ('78304', '006', 315),
    ('10836', '007', 350);
select * from rewards;

describe product;
INSERT INTO product (product_ID, type, name, price, size)
VALUES
    ('001', 'Coffee', 'Americano', 4.99, 'Medium'),
    ('002', 'Coffee', 'Latte', 5.99, 'Large'),
    ('003', 'Pastry', 'Croissant', 2.99, 'One Size'),
	('004', 'Food', 'Sandwich', 9.99, 'One Size'),
    ('005', 'Coffee', 'Cappucino', 3.99, 'Small'),
    ('006', 'Coffee', 'Expresso Shot', 2.99, 'One Size');
select * from product;

describe supplier;
INSERT INTO supplier (supplier_ID, name, email, contact_number)
VALUES
    ('001', 'Bakers Delight', 'contact@bakersdelight.com', 5551234567),
    ('002', 'Coffee Beans Co.', 'sales@coffeebeans.com', 5559876543),
    ('003', 'Clean & Fresh', 'clean&fresh@gmail.com', 5551234567),
    ('004', 'Appliance Plus', 'appliance+@gmail.com', 568207927840);
select * from supplier;