Untitled

describe customer;
INSERT INTO customer (customer_ID, name, email, phone_number)
VALUES
    ('001', 'David', '[email protected]', 1234567890),
    ('002', 'Allen', '[email protected]', 0987654321),
    ('003', 'Micheal', '[email protected]', 5432198760),
    ('004', 'Don', '[email protected]', 827346501),
    ('005', 'Daniel', '[email protected]', 1987532075),
    ('006', 'Whitney', '[email protected]', 49620763957),
    ('007', 'Tyler', '[email protected]', 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', '[email protected]', 5551234567),
    ('002', 'Coffee Beans Co.', '[email protected]', 5559876543),
    ('003', 'Clean & Fresh', 'clean&[email protected]', 5551234567),
    ('004', 'Appliance Plus', '[email protected]', 568207927840);
select * from supplier;