1. Learn
    2. /
  2. Courses
    3. /
  3. Hierarchical and Recursive Queries in SQL Server

Exercise

Create a power grid

In this exercise, you will create the structure table. This table describes how power lines are connected to each other. For this task, three ID values are needed:

  • EquipmentID: the unique key
  • EquipmentID_To: the first end of the power line with ID of the connected line
  • EquipmentID_From: the second end of the power line with ID of the connected line

The other fields to describe a power line, such as VoltageLevel and ConditionAssessment, are already defined.

An example is shown in the following picture:

For the line with EquipmentID = 3 the field EquipmentID_To is 4 and the field EquipmentID_From is 2.

Instructions

100 XP
  • CREATE the structure table.
  • Define the EquipmentID field as a PRIMARY KEY of type INT.
  • Insert the record for line 1: 1, 2, <no from line>, 'HV', 'Cable', 2000, 2016, 'good'.
  • Insert the record for line 14: - 14, 15, 3, 'MV', 'Cable', 1976, 2002, 'bad'.