Database Store

Create Database

CREATE DATABASE Store;
USE Store;

Create Table Category

Create Table

CREATE TABLE Category(
    CategoryId TINYINT NOT NULL PRIMARY KEY AUTO_INCREMENT,
    CategoryName NVARCHAR(64) NOT NULL
);

Insert data

INSERT INTO Category (CategoryName) VALUES ('Laptop'), ('Mouse'), ('Keyboard');