DATABASE ANALYSIS =============================== Processed 9 Records from Employees.XML COLUMNS ======= >Integer(3) 1 EmployeeID >Text(10) 9 LastName >Text(10) 8 FirstName >Text(10) 24 Title >Text(10) 4 TitleOfCourtesy >Date(8) 10 BirthDate >Date(8) 10 HireDate >Text(10) 30 Address >Text(10) 8 City >Text(10) 2 Region >Text(10) 7 PostalCode >Text(10) 3 Country >Text(10) 14 HomePhone >Integer(3) 4 Extension >Text(10) 13 Photo >Memo(12) 448 Notes >Text(10) 1 ReportsTo DATA ANALYSIS ======================== Integer(3) 1 EmployeeID '1' 1 11.11% '2' 1 11.11% '3' 1 11.11% '4' 1 11.11% '5' 1 11.11% '6' 1 11.11% '7' 1 11.11% '8' 1 11.11% '9' 1 11.11% =============================== Text(10) 9 LastName 'B' 1 11.11% 'C' 1 11.11% 'D' 2 22.22% 'F' 1 11.11% 'K' 1 11.11% 'L' 1 11.11% 'P' 1 11.11% 'S' 1 11.11% 'a' 9 100.00% 'c' 3 33.33% 'd' 1 11.11% 'e' 4 44.44% 'g' 2 22.22% 'h' 3 33.33% 'i' 3 33.33% 'k' 1 11.11% 'l' 6 66.67% 'm' 1 11.11% 'n' 5 55.56% 'o' 5 55.56% 'r' 3 33.33% 's' 1 11.11% 't' 1 11.11% 'u' 3 33.33% 'v' 2 22.22% 'w' 1 11.11% 'y' 1 11.11% =============================== Text(10) 8 FirstName 'A' 2 22.22% 'J' 1 11.11% 'L' 1 11.11% 'M' 2 22.22% 'N' 1 11.11% 'R' 1 11.11% 'S' 1 11.11% 'a' 7 77.78% 'b' 1 11.11% 'c' 2 22.22% 'd' 1 11.11% 'e' 8 88.89% 'g' 1 11.11% 'h' 1 11.11% 'i' 1 11.11% 'l' 1 11.11% 'n' 6 66.67% 'o' 1 11.11% 'r' 5 55.56% 't' 4 44.44% 'u' 1 11.11% 'v' 1 11.11% 'w' 1 11.11% 'y' 1 11.11% =============================== Text(10) 24 Title ' ' 11 122.22% ',' 1 11.11% 'C' 1 11.11% 'I' 1 11.11% 'M' 1 11.11% 'P' 1 11.11% 'R' 6 66.67% 'S' 9 100.00% 'V' 1 11.11% 'a' 18 200.00% 'c' 1 11.11% 'd' 3 33.33% 'e' 38 422.22% 'g' 1 11.11% 'i' 10 111.11% 'l' 9 100.00% 'n' 10 111.11% 'o' 3 33.33% 'p' 6 66.67% 'r' 10 111.11% 's' 17 188.89% 't' 14 155.56% 'v' 6 66.67% =============================== Text(10) 4 TitleOfCourtesy '.' 9 100.00% 'D' 1 11.11% 'M' 8 88.89% 'r' 5 55.56% 's' 5 55.56% =============================== Date(8) 10 BirthDate '/' 18 200.00% '0' 14 155.56% '1' 14 155.56% '2' 6 66.67% '3' 5 55.56% '4' 2 22.22% '5' 5 55.56% '6' 5 55.56% '7' 3 33.33% '8' 4 44.44% '9' 14 155.56% =============================== Date(8) 10 HireDate '/' 18 200.00% '0' 13 144.44% '1' 20 222.22% '2' 4 44.44% '3' 5 55.56% '4' 5 55.56% '5' 4 44.44% '7' 2 22.22% '8' 1 11.11% '9' 18 200.00% =============================== Text(10) 30 Address LF 3 33.33% CR 3 33.33% ' ' 26 288.89% '-' 2 22.22% '.' 11 122.22% '0' 4 44.44% '1' 5 55.56% '2' 5 55.56% '4' 3 33.33% '5' 1 11.11% '6' 1 11.11% '7' 4 44.44% '8' 1 11.11% '9' 1 11.11% 'A' 4 44.44% 'B' 2 22.22% 'C' 2 22.22% 'E' 3 33.33% 'G' 1 11.11% 'H' 4 44.44% 'M' 2 22.22% 'N' 1 11.11% 'O' 1 11.11% 'R' 4 44.44% 'W' 4 44.44% 'a' 7 77.78% 'c' 1 11.11% 'd' 9 100.00% 'e' 10 111.11% 'g' 1 11.11% 'h' 5 55.56% 'i' 4 44.44% 'l' 7 77.78% 'm' 2 22.22% 'n' 5 55.56% 'o' 9 100.00% 'p' 2 22.22% 'r' 5 55.56% 's' 5 55.56% 't' 10 111.11% 'u' 2 22.22% 'v' 4 44.44% 'w' 1 11.11% 'y' 4 44.44% =============================== Text(10) 8 City 'K' 1 11.11% 'L' 4 44.44% 'R' 1 11.11% 'S' 2 22.22% 'T' 1 11.11% 'a' 5 55.56% 'c' 1 11.11% 'd' 7 77.78% 'e' 5 55.56% 'i' 1 11.11% 'k' 1 11.11% 'l' 3 33.33% 'm' 2 22.22% 'n' 10 111.11% 'o' 10 111.11% 'r' 1 11.11% 't' 4 44.44% =============================== Text(10) 2 Region 'A' 5 55.56% 'W' 5 55.56% =============================== Text(10) 7 PostalCode ' ' 4 44.44% '0' 4 44.44% '1' 5 55.56% '2' 5 55.56% '3' 2 22.22% '4' 1 11.11% '5' 2 22.22% '7' 2 22.22% '8' 6 66.67% '9' 6 66.67% 'C' 1 11.11% 'E' 1 11.11% 'G' 2 22.22% 'J' 2 22.22% 'L' 1 11.11% 'P' 1 11.11% 'R' 3 33.33% 'S' 2 22.22% 'T' 1 11.11% 'W' 2 22.22% =============================== Text(10) 3 Country 'A' 5 55.56% 'K' 4 44.44% 'S' 5 55.56% 'U' 9 100.00% =============================== Text(10) 14 HomePhone ' ' 9 100.00% '(' 9 100.00% ')' 9 100.00% '-' 9 100.00% '0' 5 55.56% '1' 8 88.89% '2' 9 100.00% '3' 2 22.22% '4' 8 88.89% '5' 30 333.33% '6' 5 55.56% '7' 8 88.89% '8' 7 77.78% '9' 4 44.44% =============================== Integer(3) 4 Extension '1' 1 11.11% '2' 3 33.33% '3' 6 66.67% '4' 8 88.89% '5' 8 88.89% '6' 3 33.33% '7' 3 33.33% '8' 1 11.11% =============================== Text(10) 13 Photo ' ' 9 100.00% '1' 9 100.00% '7' 9 100.00% 'O' 9 100.00% 'T' 9 100.00% 'b' 9 100.00% 'c' 9 100.00% 'e' 18 200.00% 'j' 9 100.00% 'p' 9 100.00% 't' 9 100.00% 'y' 9 100.00% =============================== Memo(12) 448 Notes ' ' 397 4411.11% '"' 12 133.33% '(' 5 55.56% ')' 5 55.56% ',' 14 155.56% '-' 1 11.11% '.' 32 355.56% '0' 1 11.11% '1' 20 222.22% '2' 5 55.56% '3' 4 44.44% '4' 2 22.22% '5' 1 11.11% '6' 5 55.56% '7' 3 33.33% '8' 5 55.56% '9' 27 300.00% 'A' 17 188.89% 'B' 11 122.22% 'C' 14 155.56% 'D' 2 22.22% 'E' 5 55.56% 'F' 7 77.78% 'G' 2 22.22% 'H' 6 66.67% 'I' 5 55.56% 'J' 5 55.56% 'K' 1 11.11% 'L' 6 66.67% 'M' 14 155.56% 'N' 2 22.22% 'P' 5 55.56% 'R' 3 33.33% 'S' 24 266.67% 'T' 5 55.56% 'U' 8 88.89% 'W' 1 11.11% 'a' 168 1866.67% 'b' 9 100.00% 'c' 57 633.33% 'd' 61 677.78% 'e' 236 2622.22% 'f' 40 444.44% 'g' 39 433.33% 'h' 69 766.67% 'i' 124 1377.78% 'j' 3 33.33% 'k' 4 44.44% 'l' 73 811.11% 'm' 55 611.11% 'n' 166 1844.44% 'o' 116 1288.89% 'p' 30 333.33% 'r' 121 1344.44% 's' 111 1233.33% 't' 130 1444.44% 'u' 34 377.78% 'v' 18 200.00% 'w' 12 133.33% 'x' 2 22.22% 'y' 23 255.56% =============================== Text(10) 1 ReportsTo '2' 5 55.56% '5' 3 33.33% =============================== >Employees