text: -- use the database context
  USE RetailStoreManagement_Team10;
  
  -- 2. Insert rows into branch table
  -- Branch(branch_id PK, branch_name, location_id FK)
  INSERT INTO dbo.[branch] VALUES (101,'Fenway',1001);
  INSERT INTO dbo.[branch] VALUES (102,'Kenmore',1002);
  INSERT INTO dbo.[branch] VALUES (103,'Huntington',1003);
  INSERT INTO dbo.[branch] VALUES (104,'Jamaica',1004);
  INSERT INTO dbo.[branch] VALUES (105,'Riverway',1005);
  INSERT INTO dbo.[branch] VALUES (106,'HeathSt',1006);
  INSERT INTO dbo.[branch] VALUES (107,'SouthH',1007);
  INSERT INTO dbo.[branch] VALUES (108,'Cleveland',1008);
  INSERT INTO dbo.[branch] VALUES (109,'Ht',1009);
  INSERT INTO dbo.[branch] VALUES (110,'MissonMain',1010);