SQL Store Database - Lois Grocery Store

For this project, I created a database called loisgrocery_store to manage inventory for a small grocery store. The database includes:

• 5 Fields: Product ID, Name, Category, Quantity, and Price.

• 15 Records: Covering various fruits and their pricing and inventory.

This project marks my entry into SQL database design, an essential data management and analysis skill. I’m excited to expand this knowledge with more advanced projects!

Code

CREATE TABLE loisgrocery_store(id INTEGER PRIMARY KEY, name TEXT, category TEXT, quantity INTEGER, price INTEGER);

INSERT INTO loisgrocery_store VALUES (1, "Apple", "fruits", 12, 5);

INSERT INTO loisgrocery_store VALUES (2, "bananas", "fruits", 7, 5);

INSERT INTO loisgrocery_store VALUES (3, "oranges", "fruits", 20, 4);

INSERT INTO loisgrocery_store VALUES (4, "mangoes", "fruits", 4, 2);

INSERT INTO loisgrocery_store VALUES (5, "pineapple", "fruits", 3, 4);

INSERT INTO loisgrocery_store VALUES (6, "grapes", "fruits", 50, 6);

INSERT INTO loisgrocery_store VALUES (7, "strawberry", "fruits", 18, 7);

INSERT INTO loisgrocery_store VALUES (8, "watermelon", "fruits", 2, 8);

INSERT INTO loisgrocery_store VALUES (9, "Blueberry", "fruits", 30, 3);

INSERT INTO loisgrocery_store VALUES (10, "peach", "fruits", 8, 8);

INSERT INTO loisgrocery_store VALUES (11, "cherry", "fruits", 25, 2);

INSERT INTO loisgrocery_store VALUES (12, "kiwi", "fruits", 10, 6);

INSERT INTO loisgrocery_store VALUES (13, "pomegranate", "fruits", 6, 4);

INSERT INTO loisgrocery_store VALUES (14, "papaya", "fruits", 4, 5);

INSERT INTO loisgrocery_store VALUES (15, "avocado", "fruits", 9, 9);

SELECT *

FROM loisgrocery_store;