Love, Yorkshire Style

Mary Agnes Baker / Lindner / Coulson, 1896-1983

Aunty Mary, who died over 30 years ago, is the primary source for much of my earliest Coulson family history. She was born in Wyoming but she must have spent a lot of time listening to her folks, because she knew quite a lot about her grandparents and great-grandparents back in Yorkshire. It gives me great pleasure to track down her stories and see how true they are. I’ve become Aunty Mary’s posthumous fact-checker.

She knew a lot about her father’s mother, Mary Coulson. According to Aunty Mary, her grandmother Mary’s first two children– George Lindley Coulson and Emily Ann Coulson– were born out of wedlock to Mary and a man named Jim Barlow. But instead of marrying Barlow she went and married Tom Henson. By that time, though, George and Emily had already been adopted by their maternal grandfather, William Coulson (who later clobbered a man with a shovel and ran off to Australia) and that is why my great-grandfather George was surnamed Coulson, not Barlow or Henson. It would be nice to try to validate some of these facts, wouldn’t it?

First thing I found was George and Emily’s baptismal record…

Emily and George were both baptized on May 5, 1867. I have found other documents showing that Emily was in fact born in December 1866, and that George was born on December 10, 1864. I can’t imagine why Mary took so long getting George baptized, but the thing I wanted to point out about the baptismal register is that only Mary’s name appears; there is no father.

Later I found the marriage registration for Mary Coulson and Tom Henson– they were married later that same year, 1867. By the time of the 1871 Census, Mary, Tom, George, and Emily are one big happy family… but note that 6-year-old George is still a Coulson (or here, “Colson”). Apparently Tom hasn’t adopted him yet (and, for some reason, he never will… which is why we’re named Coulson, not Henson).

Also note that Tom, Mary, and the children are living as lodgers in the home of John Black, a musician… There’s another one of Aunty Mary’s stories lying in plain sight there, but that’ll have to wait for another day.

Well, we have accounted for Tom Henson. So far, Aunty Mary’s story checks out. What happens if we go looking in the opposite direction?

In 1861, I found a 13-year-old Mary Coulson living with her 74-year-old grandfather, George Mitchell, a grocer. Mary’s occupation is “General Servant”. Their address is 38 New Street in Barnsley, Yorkshire.

I can’t be 100% certain that this is my great-great-grandmother because “Mitchell” is a name I never heard about from Aunty Mary, and I never heard of Mary living with her grandfather. However, this girl’s parents are obviously absent, and that fits with Aunty Mary’s story of Mary’s father running off to Australia. Plus, this Mary’s age is exactly 10 years younger than the young woman in the 1871 Census, and the birthplace of the two Marys (Bawtry, Yorkshire) is a match, too. And, of course, her name lines up with what I think I know.

Well, here’s another piece of evidence, which seals it for me. This is also from the 1861 Census:

Here we have a 16-year-old “Tinner & Brazier Apprentice” named James Barlow, living with his parents, Edwin and Rebecca, and several brothers and sisters. Hm, that’s interesting. Didn’t Aunty Mary say that Jim Barlow was the father of Mary’s first two children?

Check out James Barlow’s address: 74 New Street, Barnsley, Yorkshire.

James and Mary were practically neighbors.

To give you an idea of how close they lived, here’s a modern photo of New Street in Barnsley taken from Google Streetview (image copyright Google, retrieved on Nov. 25 2017):

Mary’s house is the white one on the right. James’ house is a little before the end of the street, also on the right.

Obviously this is highly conjectural. I have no documentation regarding the true parentage of George Lindley Coulson and his sister Emily. I have no reason to link the census page recording Edwin Barlow’s family with the one recording George Mitchell and his grand-daughter. All I have is the word of Aunty Mary, who has been dead for a third of a century.

Well, that’s good enough for me. I think James and Mary met in the course of their young working-class lives on the streets of Barnsley. Mary’s grandfather being a grocer, perhaps the Barlows were customers of his. Mary was only 13 in 1861, but by the time her son George was born she would have been 16, and James would have been 19. A perfect age to start a family. But for some reason things didn’t work out for them, and they didn’t get married… I have traced James through the United Kingdom censuses up into the early part of the 20th century, and I know that he eventually married a woman named Angelica and had many children by her. Mary, as we have seen, went on to marry Tom Henson and the whole family– including George Lindley, Emily, and Tom and Mary’s own natural children– all emigrated to North America around 1888.

Funny how a tiny scrap of scurrilous family gossip can lead you to an important find. Without these stories I would have no clue about the true identity of my great-great-grandfather Jim Barlow. I can’t speculate much on the relationship between Mary, Jim, and Tom, but what I can say is that Aunty Mary’s facts are checking out.

Posted in Genealogy | Leave a comment

Nat Griffin’s Draft Card

When I was driving through Havre, Montana a while back I decided to stop at the public library to see if they had any books on local history. I wanted to investigate a story I had heard that my grandfather’s sister, my notorious Aunty Mary, had worked at a hotel there as a girl.

It turns out the library does have quite a rich section dedicated to local history and genealogy which I could have spent days perusing. I didn’t discover anything about Aunty Mary’s hotel but one thing I did make note of before the library closed was an ancient dusty set of books containing Montana marriage registrations going back to the start of the 20th century. I wished I could have taken it home with me because I had a feeling it would come in handy someday.

Fortunately there was no need to walk off with it. The reason such valuable old records are lying out in the open is that they were digitized and indexed long ago by the Mormons and they are now available as the Montana, County Marriages, 1865-1993 database on FamilySearch.org. Searching through those marriage registrations, as well as census records from those days, has taken my research to a new level. Another resource I’m putting to good use is the free collection of old newspapers hosted by the Library of Congress.

One interesting character I traced through the years was John C. “Bear Paw Jack” Griffin. Here’s an excerpt from his obituary, which appeared in the Choteau Acantha on September 10, 1913:

During the early eighties Mr. Griffin came to Fort Assinniboine and had the contract for hauling wood to the post for some time. About 1888 or 1889 he settled on a ranch in the Bear Paw mountains, about 25 miles south of Havre, where he has since resided. As the years rolled by he increased his land holdings and stock interests until at this time he has over two thousand acres of the finest land along the Clear Creek valley, besides hundreds of head of cattle and horses.

In the 1910 Census I found Jack Griffin’s family living in Clear Creek as the obituary states. His wife, Mary T. Griffin, is identified as French Canadian, born about 1862 in Canada. I used the list of children in the household (the eldest being Nathaniel, born about 1886) to trace the family back to the 1900 Census. There the head of the household is identified as Mary T. Davis, born in Canada in 1862. This has to be the same Mary T. as is in the 1910 Census. All the children are surnamed Griffin and it says they had been married 20 years; it seems Mary and Jack must have had a common-law marriage.

Sure enough, I found their actual marriage registration in that database comprising the marriage registers I saw in the Havre library. In 1902, after more than 20 years of living as man and wife, John C. Griffin married Mrs. M. T. Davis, previously married and divorced. Her maiden name was Paul and she was born in Manitoba, Canada. Her race is listed as “Half-breed”, which is what they were calling the Métis back then.

The census says that Mary T. immigrated to the U.S. in 1879 (aged 17). It says Jack immigrated in 1866 (aged 16). I wonder whether any of the children belonged to Mary’s first marriage with this Davis fellow. If we take the statements on the census at face value then I suspect Mary left her first husband Mr. Davis in Manitoba in 1879 and headed south, meeting Jack when he was hauling wood to Fort Assinniboine in 1880; that is the year of the birth of her first (known) daughter, Betsy. It’s hard to say since Mary and Jack weren’t actually married until 1902 and her first marriage didn’t leave a paper trail that I have found.

The eldest son Nathaniel was a bit of a troublemaker, according to a snippet I found in the Fort Benton newspaper:

The River Press, May 29, 1912
A news item from Havre reports the escape of Nat Griffin from the Hill county jail. The prisoner was being held for trial on a charge of cruelty to animals at Box Elder, and conviction would have given him a term in the penitentiary.

Old Bear Paw Jack died the following year (September 1913, as we have seen). Then I found, again in those Montana marriage registers, Mary T. Griffin of Havre marrying one Martin Nelson, a 53-year-old Norwegian immigrant.

After that I lose track of Mary and Martin Nelson. Nathaniel pops up in the Montana State Penitentiary records in 1916, when he was sentenced to 2-8 years for Grand Larceny. In September 1918 Nathaniel, despite being in prison, had to register for the Draft, since the U.S. Army was desperate for recruits and had to start reaching pretty low to satisfy The Great War’s unquenchable thirst for human life. Mercifully Germany and Austria were collapsing at that point and the war was over two months later, so it doesn’t look like Nathaniel got to see action.

Interesting stuff, but this is not a story about Bear Paw Jack or his wayward son. Those people are not in my family tree at all. No, this is a story about the identity of my great-grandfather’s second wife. Let’s back up a bit.

My great-grandfather George Lindley Coulson was born in 1864 and grew up in the coal mines of Yorkshire. He married Lucy Ann Scarlett, a tiny but tough woman from Staffordshire. The story of their epic journey from England to Pittsburgh to Wyoming and finally to Saskatchewan will have to be told another day. They stopped for a while in Havre, Montana, and that’s where their daughter (my Aunty Mary) stayed to work in the hotel. The rest of the family continued on, crossing the extremely porous U.S.-Canada border in the summer of 1911 (on foot, walking alongside their livestock). Almost as soon as they arrived at Fort Walsh, Saskatchewan, Lucy, aged 44, dropped dead from tuberculosis and pneumonia. She had had two miscarriages along the way, and she was exhausted. She lies buried in the Northwest Mounted Police cemetery at Fort Walsh, one of the few civilian graves to have a real headstone. She was highly esteemed by all her children. Fifteen-year-old Aunty Mary had to come racing up from Havre in her employer’s buckboard to take charge of the family, since George Lindley, having gone to Maple Creek to buy a casket for his dead wife, wound up spending the money on a drinking binge while his wife’s body lay back at the Fort ripening beneath the hot August sun.

The family kind of fell apart after that, and discovering what happened next has been one of my enduring genealogical quests. My grandfather was only 6 years old at the time of his mother’s death and his recollections don’t really begin until the Influenza Epidemic of 1919. I did find something that gives me a clue, though: a Canadian immigration record from April 5, 1917 at the border crossing at Coutts, Alberta.

That’s definitely my great-grandfather George Lindley Coulson, en route from Havre, Montana, to Lac La Biche, Alberta. Accompanying him are his sons Tom (my Uncle Tom, who later settled in Edmonton and had a big family there) and 9-year-old “Master G.” (that would have to be my grandfather, George Arthur). Also there is “Mrs. Geo. Coulson”.

This is immensely interesting. It seems that after dragging his family to Saskatchewan in 1911, George Lindley eventually drifted back to Havre and got married again. Then he moved to Lac La Biche in 1917. And boy, was he rich! He was carrying $3,600 in cash and $1,150 in “effects”. It looks like he was the richest man on Train #239. Knowing what I know about him I have a feeling he didn’t earn that money himself. I think it must have belonged to this mysterious second wife.

My grandfather never mentioned any of this. I know that George Lindley had a second wife, and all I know about her comes from my grandfather’s recollections of growing up on his father’s farm near Plamondon, a hamlet about 20 miles from Lac La Biche. I know that my grandfather hated his step-mother, and she didn’t like him either; he was chucked off the farm when he was 16 and went to live with his sister in Saskatchewan. He didn’t see his father again for almost 20 years after that, and he certainly never saw his step-mother again; he couldn’t even remember her name.

Lac La Biche, interestingly, has an ancient association with Canada’s fur trade and it played a role in the Northwest Rebellion of 1885. It was a center of Métis culture long before the colonization of the Canadian prairies and it had strong ties to the Red River settlement in Manitoba. This is actually a clue in our story which I’ll return to later.

So then I went hunting for the elusive “Mrs. Geo. Coulson” and I soon found her amongst the death registrations in the Alberta Archives. Her name was Mary Theresa and she died on December 23, 1938, in Edmonton. She was born August 19, 1862 in Winnipeg, Manitoba. Her racial origin is listed as French and her nationality Canadian. Religion, Roman Catholic. My great-grandfather signed the certificate, meaning that all this information came from him. She died in the old Misericordia Hospital, which, coincidentally, was the hospital where I would be born many years later.

But here, I at last had a name! Mary Theresa Coulson. Not a maiden name, but it was a start. I used the index of graves at the Alberta Genealogical Society to track her down in St. Joachim’s Catholic Cemetery in downtown Edmonton. I visited the grave site but it’s just a patch of grass. I fear that George Lindley was so poor by 1938 that he didn’t have enough money for a headstone.

Getting back to the Montana marriage registers, I found the record of George and Mary’s marriage in 1915. Or at least, I think I did. It’s a little confusing.

On October 19, 1915, a George Coulson married a Mary Griffin. Is this the George and Mary I’m looking for? Well, it was a Catholic wedding, which fits our bride. Mary was born in Winnipeg, which also fits. The ages of the bride and groom are a perfect match. But there are two extremely odd things to note: first, the fields for Mary’s parents are blank. Second, the parents listed for George absolutely do not line up with what I know (or think I know). George (according to Aunty Mary’s tales) was the illegitimate son of Mary Coulson and James Barlow, and he only bears the surname Coulson because he was adopted by Mary’s father in order to spare the family disgrace. When this Mary Coulson eventually did get married it was to a man named Henson, not Mitchell. I have got no idea who this “Thos. Coulson” and “Mary Mitchell” are. This might constitute new information for my family tree, or it may be completely spurious.

I questioned the validity of this marriage registration for a long time. Mary Griffin’s marriage to Martin Nelson in May 1914 was another real problem for my timeline, because just 18 months later Mary Griffin married George Coulson. Was this the same Mary Griffin? If Martin had died, I should be able to find a death record for him… Why can’t I? Was this George Coulson my great-grandfather, or some other George? If it’s the same Mary and George, why all the missing and incorrect information on the marriage documents? Did they have something to hide?

And that’s where things sat for quite a while. I was unwilling accept “Griffin” as the surname of my grandfather’s step-mother because this incomplete marriage registration was the sole evidence I had, and it was too shaky. There could have been more than one Mary Griffin in Havre in those days, right? And George Lindley might have gotten married someplace else and I just haven’t found it yet.

That’s when my casual research into Bear Paw Jack Griffin blew the case wide open. Could Jack’s wife Mary T. Griffin, born in Winnipeg in 1862, be the same as Mary Theresa Coulson, also born in Winnipeg in 1862?

You will remember that Jack’s son Nathaniel had to register for the Draft. His draft card holds the key to this mystery, because on it he identified his mother.

Nat identifies his nearest relative as “Mrs. George Carlson, Plamondon, Canada”. That, without a doubt, is Mary Theresa, whose unmarked grave I found in Edmonton.

In fact, Nat has two draft cards, both issued on the same day. Here’s the second one:

It’s identical in every respect, except the next-of-kin’s name is changed to “Mrs. George Coulson”. At least it might be Coulson; the third letter in the name is a little squiggly. One can picture Nat trying to remember the name of his mother’s latest husband… was it Carlson? Coulson? How did she spell that? The draft board official did his best to take down both names.

These cards, mentioning the Coulson/Carlson name, combined with the mention of the tiny hamlet of Plamondon, establish beyond a shadow of a doubt that there was only one Mary Griffin, and that she was married both to Bear Paw Jack and later to George Lindley. With this discovery I now feel confident putting the pieces together…

Mary Theresa Paul, daughter of Oliver Paul, was born in the Red River settlement in 1862 when Rupert’s Land was still claimed by the Hudson’s Bay Company, 11 years before the incorporation of Winnipeg. She had a brief marriage that ended around 1879 and she left for (or perhaps fled to) Fort Assinniboine, Montana, which would later become a focal point for the Cree and Métis people fleeing persecution in Canada in the wake of the Northwest Rebellion of 1885. There she met John C. Griffin and became his common-law wife, and together they had a large family and she managed his ranch in the Bear Paw Mountains. They finally got married, and when John C. died in 1913 I would have to guess she inherited his land and was a wealthy woman. She then married Martin Nelson, the Norwegian, and I don’t know what happened to him. Then in quick succession she married my great-grandfather George Lindley Coulson. They decided to move to Plamondon, Alberta, because she would probably have had family connections there via her Métis roots and George was, after all, still a British Subject.

This is probably not the final word on this adventure. I feel encouraged to learn a little more about Métis history than what we were taught in Canadian history class, because now I seem to have a fleeting family connection to it. I’d also like to get confirmation of poor Martin’s fate.

And, I wonder what happened to all that money?

Update: November 7, 2017

One of the exciting things about airing your family secrets in public is that you never know who you’ll meet. Since posting this story a couple of days ago a fellow-researcher I met on Find-A-Grave was intrigued by the mystery so she picked up the torch and went searching in the Montana newspapers for clues. She came up with a clipping that proves definitively that Bear Paw Jack’s wife Mary T. Griffin was none other than my great-grandfather’s second wife who moved up to Alberta and died in Edmonton. The children’s names– Margaret, Thomas, Frank, Bennett, and Nat– match the ones I already know from the census records.

Great Falls Tribune (Great Falls, Montana)
31 Dec 1938, Sat • Page 5

Mr. and Mrs. Thomas Cole of the West hotel returned Friday from Edmonton, Alta., where they were called by the death of Mrs. Cole’s mother, Mrs. Mary Theresa Coulson. Other survivors, in addition to her husband, are three daughters, Margaret Spencer, Chinook; Louise Ward, Havre; Belle Jernberg, Kalispell, and five sons, William Griffin, Browning; Thomas Griffin, Rocky Boy; Frank Griffin, Chinook; Bennett Griffin, Washington, and Nat Griffin, Browning.

Here’s to serendipity and chance meetings on the Internet.

Posted in Genealogy | Leave a comment

Finding Grandma

I never knew my grandmother. As far as I know she never knew me, or even knew I existed.

I knew her name, but that was all. After she and my grandfather got divorced it’s as if she fell off the face of the earth. My mother refused to talk about her. When my grandfather wrote his memoirs, he didn’t even mention her name.

That sounds like a good entry-level genealogical project, doesn’t it? Finding your own grandmother. OK then, let’s get started.

The evidence I had to start out with was slim…

First there are the clues in my grandfather’s memoir, in which he states that he got married in 1932. Later in the memoir he talks about adventures he had with his “wife” in London during World War Two. This is clearly not the woman he claims to have married earlier, but he never says anything about how the transition from Wife #1 to Wife #2 came about. Rather confusing.

From my mother, I at least got a name: Mary Emma Berkley. She also gave me to understand that my grandfather had divorced her during or after the War. (Details were not forthcoming, but I was given to believe that he was the injured party). I got the names of Mary Emma’s parents, and where they had lived, but beyond that my mother clammed up tight. She claimed to not even know the date of Mary Emma’s death. She thought it might have been before I was born. She had no contact with her mother after the divorce, apparently.

I tried asking my father, but he had never met her and all he could say was that he never heard anything about her, either. He did remember one episode, shortly after he and my mother were married, though… He recalled my mother going to a funeral in Olds, and he thinks it might have been her mother’s. He remembers hearing that when my mother walked into the funeral home everyone was startled, she looked so much like the deceased it was as if she were standing there amongst them! Because of what I knew about my parents’ movements and residences before I was born I had to place that incident in 1961. So at least I had a tentative date, and I put a lot of weight in it.

I think I may have asked my mother about that funeral once, and she said she didn’t remember.

When I started getting my feet wet in online genealogical research one of the first websites I became familiar with was FamilySearch, mainly because it’s free. There I discovered something called a “Pedigree Resource File”, which is basically a member-submitted family tree. Here’s one that mentions my grandmother:

https://familysearch.org/ark:/61903/2:2:3WH5-9LX

Whoever submitted this data certainly knew about my grandmother, since her parents match what I already knew. But it says that Mary Emma was born on August 29, 1911 and died on March 6, 1977. It gives no documentary source for those dates, and it has no information about her husband (my grandfather) or her children (my mother and her siblings). I took this information with a big grain of salt, especially because it contradicted the death year that I thought was correct, 1961. I thought it must be a mistake.

Since online research was a dead end I decided I needed to visit the Alberta Provincial Archives in Edmonton to get answers. What I discovered there blew the lid off everything I had previously thought about my grandmother.

The first big discovery I made was my grandparents’ actual marriage registration, which I got to hold in my own hands. I made a photocopy and brought it home with me:

Marriage Registration for John Elliott and Mary Emma Berkley, March 8, 1933

This gave me pause, because it contradicts my grandfather’s marriage year as stated in his memoir (1932). I also have a handwritten family tree of his in the notes that I inherited from him, where he states he was married in 1931. Wrong on both counts: he and Mary Emma were married on March 8, 1933.

Why would he mis-state his year of marriage? Didn’t he remember it? I’ll return to that in a moment.

My next discovery in the Archives was the decree nisi from my grandparents’ divorce proceedings, which contained a summary of the evidence presented at the trial and believe me, it’s a page-turner. I won’t get into details but it must have caused quite a family scandal back in the day (I’m starting to understand why nobody wanted to talk about any of this). Suffice it to say that it was Mary Emma who sued John for divorce (not the other way around), and in my humble opinion she was right to do so. The divorce was final in March of 1946.

I made those discoveries within the first hour or two of my initial visit to the Archives, and they knocked the wind out of me. As I was wandering around the place trying to get a sense of what other resources were available, a kindly researcher from the Alberta Genealogical Society noticed my wandering and asked if there was anything she could help me find. I described what I was looking for, and she led me straight to a row of bookshelves that contained the Local and Alberta Histories collection, a large set of books containing family and community histories, written by the locals themselves. There I quickly found the book that pertained to Hainstock, Alberta, a farming district near Olds that I had passing familiarity with because I knew that was where my great-grandfather received a homestead when he immigrated from Scotland in 1927.

In those pages, in black and white, I found an article all about my long-lost grandmother and her family.

The book is Glimpses of the past, 1894-1994 and you can read it online (no need to travel to Edmonton to get it); the relevant passage, written by Janis (Kilpatrick) Berkley, begins on page 45. Here it is:

Glimpses of the Past (Bowden, Alberta: Hainstock Centennial History Book Association, 1994), pp.45-46.

This confirmed the dates in the Pedigree Resource File, and gave me a wealth of information about the Berkleys that I had had no clue of. Apparently my supposition that she died in 1961 was incorrect. It also told me she had been married to someone named Furguson (or Ferguson) before she died.

Just who was this Janis Berkley, and how did she know so much about my grandmother?

Part of the reason for my trip to Alberta, apart from researching at the Archives, was attending the funeral of my grandfather’s sister-in-law in Olds. I scarcely knew Aunt Esther but since she was almost the last survivor of my grandfather’s generation of siblings and their spouses, I considered it important to go. I might also meet cousins I never knew I had who might be able to give me more information about the things I was researching.

I also planned to use the opportunity to look up Janis Berkley, whoever she was, and interrogate her about my grandmother.

The first thing I did when I got to Olds was to visit the Hainstock Cemetery since I had a few hours to kill before the funeral. It’s a small cemetery and I was able to walk the length and breadth of it in under an hour. There I found the Berkley family plot, and nearby was an unkept grave with a broken headstone…

Well, there she was. And beside her with an identical headstone was her second husband George, who died the year after she did. I suppose in a perfect world he would have been my step-grandfather. I said hello.

Aunt Esther’s funeral was a success, from the perspective of my personal data-gathering goals. I learned from my cousins why my grandfather had fudged his marriage date– it was to hide the fact that his first child had been conceived out of wedlock, which was a big deal in his mind, although probably a lot more common than he was prepared to admit.

I also hung around outside the Olds Museum until it opened and talked to the archivist there. Wouldn’t you know, he did know Janis Berkley. She had moved down East but he promised to pass my email address on to her.

I waited against hope for a couple of weeks, and was delighted when she contacted me. She knows so much because she is married to one of Mary Emma’s nephews, and she took on the role of family historian back when the old timers were still alive and able to talk to us. I’m coming late to that game but fortunately Janis was more than willing to give me all the information I could handle, not only about my grandmother but about her siblings and their families. I was happy to reciprocate with information of my own, since they knew very little about us too.

I’m glad I was able to rehabilitate my grandmother’s memory and get to know her a little bit, so long after her death. It’s too bad this research came too late for my mother, who died before I embarked on this project and was never able to reconcile herself to her mother’s memory.

Here’s the best picture I have been able to find of Mary Emma. It came, surprisingly, from my grandfather’s collection.

John Elliott, Mary Emma Elliott (Berkley), 1940. Children (L-R): Sheila, Ruby, Archie, Boyd

My best guess for dating this photo is August 1940, just before the Calgary Highlanders departed Camp Shilo en route to the War, when my grandfather had a few days leave to return home to say goodbye to his wife. This portrait paints quite the lovely picture of a happy family, and while I now know their marriage was pretty much on the rocks at this point, perhaps this is the best way to remember them.

Postscript

A few people have asked me, publicly and privately, whatever happened to Mary Emma. Eventually she married a man who was able to care for her more than my grandfather could. This was George Ferguson, and since he was Roman Catholic he had to wait a number of years before he could get a dispensation to marry (her being a divorced Protestant and all). They had no children, and lived out the remainder of their lives in relative seclusion on George’s farm, quite uneventfully it seems.

Meanwhile my grandfather poisoned his children’s minds against their mother. He rewrote the story so many times in his own mind that he started forgetting the details. But since he had literary aspirations, and since he was an officer of the Crown and a Freemason and a pillar of the community, his side of the story endured. Mary Emma’s just sank quietly into the earth.

Posted in Genealogy | 3 Comments

The Irish Connection, Part 2

In The Irish Connection, Part 1 we learned that my presumably Scottish family had its origins in Ireland. There’s more to the story, though.

To help keep things straight, here’s the family tree so far.

Elliott Family Tree

A is “young” John, the Scotophile who discovered he may have Irish roots. B is “old” John, young John’s grandfather, whom we learned in Part 1 was indeed born in Ireland (most likely in County Fermanagh, in the vicinity of Irvinestown), and emigrated to Paisley, Scotland before he was 5.

John Elliott (1859-1915) and his daughter Mary Andrews (Elliott) (1895-1981). This photo of “old” John is undated, but I suspect it might have been taken a year or two before Mary got married, so perhaps 1913 or 1914.

Old John’s father William was also born in Ireland; we confirmed this with his own statements on the Scottish Census records. William, who died in 1908 in Paisley, gives us some more clues via his death registration:

William Elliott's death registration, August 25, 1908

William Elliott’s death registration, August 25, 1908

According to this, William’s father was Archibald Elliott, a farmer, and his mother’s name was Mary Johnston. William was 70 years old at the time of his death, putting his year of birth around 1838. This information would have been supplied to the county registrar by A[rchibald] Elliott, William’s youngest son. We can use these names to delve into the Irish Census records.

The state of the Irish Census in the 19th century is, unfortunately, a mess. Many of the census returns were destroyed, for one reason or another, and what we have are only fragments of what used to exist. The National Archives of Ireland give a brief history of the destruction on their website.

We got lucky, though, and found what I believe to be the “right people” (i.e. my direct ancestors) in the Irish Census of 1841.

1841 Irish Census for the Archibald Elliott household (located in Arva, Drumalt, Killeshandra, Tullyhunco, Cavan)

1841 Irish Census for the Archibald Elliott household (located in Arva, Drumalt, Killeshandra, Tullyhunco, Cavan)

The clues connecting this family with my grandfather’s grandfather’s family are overwhelming.

  • The head of the family is named Archibald Elliott.
  • Archibald is a farmer.
  • His wife’s name is Mary (Mary Anne, to be exact).
  • There is a 43-year-old unmarried woman living with them, identified as “sister-in-law”, named Hariett Johnston. This tells us that Mary Elliott’s maiden name must have been Johnston too.
  • There is a 3-year-old boy living there named William, with a birth year of about 1838.

The only thing to keep this from being a perfect match, though, is wee William: he is identified as Archibald’s grandson, not his son. William’s parents are not identified.

There are 101 possible reasons why William might be living with Archibald and Mary Anne rather than his own parents. His parents might be dead. He might be a neighbor’s orphan. He might be the illegitimate child of one of Archibald’s other children. It’s hard to know, without more documentation, and for the time being this is all we’ve got. Based on these three pieces of evidence–

  • What William’s son Archibald knew about the age of his father and the names of his father’s parents;
  • The information on William’s marriage record; and
  • The evidence in the 1841 Census

— I am reasonably sure that this little boy is the same William who died in Paisley in 1908, my great-great-great grandfather, and that he believed that his parents were Archibald and Mary Anne. He might not even have been aware that he was actually Archibald’s grandson.

This takes our family back to 1781, the approximate year of Archibald’s birth. I consider this quite a discovery.

How William found his way to Paisley is unknown; our family’s oral history doesn’t mention it at all. But we can take a stab at it because his migration coincides with an important historical event: the Great Irish Famine.

Since William was only 3 when we find him living with old Archibald, it’s reasonable to assume that he was born on or near Archibald’s place of residence, which was the town of Arva within the Townland of Drumalt, Parish of Killeshandra, Barony of Tullyhunco, in County Cavan, Ireland. William would have been 9 years old when the Famine arrived at his doorstep in Killeshandra Parish in 1847, and while he lived in a relatively prosperous area, it appears that there was hardship nevertheless (see this brief article on Killeshandra and the Famine).  It is logical that young William would have journeyed 40 miles away to nearby Fermanagh to seek his fortune, where there was a seaport, a bustling industry, and many other people who shared the surname Elliott (who may have been related, although I don’t yet know how). There he married Mary Ingram, the butcher’s daughter, and started a family, but times were no doubt tough. People were leaving Ireland in droves in the 1850s, bound for North America and the industrial port cities of Scotland and England.

For reasons we can only guess at William and Mary chose Paisley, Scotland as the new home for their small but growing family, and the rest is history.

Posted in Genealogy | Leave a comment

The Irish Connection

John Elliott in 1981.

John Elliott in 1981.

My grandfather John was a big fan of all things Scottish. He continued to speak with a brogue (or tried to) despite living in Canada for 64 years, played the bagpipes (until he chopped two fingers off, that’s another story), and wore a kilt at every opportunity. He styled himself “Head of the Clan” and hosted large family reunions at his acreage near Rocky Mountain House where there was bagpipe music and plenty of Johnny Walker Red (although purists might not regard that as proper Scotch at all, but I digress).

There’s a good reason for all that Scottish-ness. He was, after all, Scottish. He was born in Paisley, an industrial city on the boundary between the Scottish Highlands and Lowlands. He grew up in the Highlands, though. His father was employed as a gamekeeper for the great estates and John, as the eldest son, helped his father as much as he could. The family lived in several locations across the Highlands in the decade following World War One (here is a Google Map I prepared of all the places they lived in those days) and John drank in the culture of those parts with gusto. It was a formative time for him and he remembered it with great longing for the rest of his life.

In my post about The Family That Almost Was, I presented a letter wherein John alluded to a rumor that his grandfather had actually come from Ireland. I have subsequently conferred with various cousins and they, too, received wind of this rumor through their forebears, John’s brothers and sisters, so it must have been fairly common knowledge to that generation. Nobody, though, has been able to give me any details, so I suspect that a rumor is all it was to them. How to confirm or dispel that rumor?

John’s grandfather (the alleged Irishman) was also named John Elliott, so for the sake of convenience let’s refer to him as “old” John. While I had little information about him I did know his date of marriage and his wife’s maiden name, and that led me to their marriage registration:

John Elliott and Margaret Milligan marriage registration, December 31, 1889

John Elliott and Margaret Milligan marriage registration, December 31, 1889

This contains lots of fascinating details, but the one to focus on here is the names of old John’s parents: William Elliot and Mary Ingram. Where did they come from?

A quick search of the Scottish archives doesn’t turn up any likely marriages between William Elliot(t) and Mary Ingram. If, however, we make the assumption that they were married in Ireland, we find the following record in the LDS Church’s database known as Ireland Marriages, 1619-1898:

Name William Elliott
Spouse’s Name Mary Ingram
Event Date 09 Nov 1857
Event Place Lowtherstown, Ferm, Ireland
Father’s Name Archibald Elliott
Spouse’s Father’s Name David Ingram

“Ireland Marriages, 1619-1898,” database, FamilySearch (https://familysearch.org/ark:/619031:1:FGCN-6JK : 12 December 2014), William Elliott and Mary Ingram, 09 Nov 1857; citing Lowtherstown, Ferm, Ireland, reference 506, index based upon data collected by the Genealogical Society of Utah, Salt Lake City; FHL microfilm 101,388.

We cannot be 100% certain that this is the marriage we’re looking for yet, because those were extremely common names in that area in that time. But it gives us some clues: namely, that William Elliott’s father may have been named Archibald, and Mary Ingram’s father may have been named David.

Making a long story short, I worked my way through all of William and Mary’s children using census, birth, death and marriage records, and discovered that the marriage record found on the LDS website is, in fact, correct: they were married on November 9, 1857 in Lowtherstown, County Fermanagh, Ireland, part of what was then referred to as the Ulster Plantation. While I have been unable to find a birth or baptism record for old John (the Irish vital statistics search tools are not, I find, as easy to work with as the Scottish ones), it is clear from the Scottish Census that old John was indeed born in Ireland; the family first appears on the Scottish Census in 1871 when old John is 12 and is recorded to have been born in Ireland. He had a younger sister, Mary Jean, also born in Ireland about 1861. Between 1861 and 1864, it seems, the family moved from Ireland to Paisley, and 6 more children were added to the family, all of whom I’ve been able to trace through their birth, marriage, and death records.

So, paydirt! We’re actually Irish. It’s almost enough to make “young” John (my grandfather) spin in his grave.

But that’s not the end of the story. Read The Irish Connection, Part 2.

Posted in Genealogy | Leave a comment

Private Frank Elliott, 1897-1917

Today is the one-hundredth anniversary of the death of my great-uncle Frank (Francis Milligan) Elliott, 1/6 Argyll & Sutherland Highlanders, who died in a field hospital in France on May 21, 1917.

In commemoration, here is a page I wrote that summarizes everything I have been able to find out about his short life.

Francis Milligan Elliott June 3, 1897 – May 21, 1917

Posted in Genealogy | Leave a comment

The Family That Almost Was

I’ve decided to resurrect this old blog of mine with musings about what I’m learning from genealogy.

My grandfather, who died over a quarter-century ago, got bit by the genealogy bug a few years before he died, and he left behind some notes and charts of his research. Nobody else (including me) was at all interested in the family tree at that time, so his notes lay in a box all these years and never saw the light of day until my mother died recently and those papers came to me. I had already started my own research by then, and his notes were a welcome addition to my own growing body of knowledge.

My grandfather, having left Scotland at the age of 17 and spending most of his life in Canada, had little knowledge of his roots beyond his own parents and grandparents and his cousins and uncles and aunts back in the Old Country that he kept in touch with (albeit infrequently). He started getting curious in his old age, so in early 1990 he wrote to his Uncle Archie back in Paisley with questions about the family history, and Archie provided a few details, but all in all it wasn’t much. My grandfather gathered up this information and sent it to the Elliott Clan Historian in Scotland, thinking that he might find something out that way. I have a carbon copy of that letter; it contains some helpful names and dates, and a couple of tantalizing pieces of news that I hadn’t known about.

Letter from John Elliott to Brian Piercy, April 2, 1990

April 2nd 1990
Mr Brian Piercy
Dear Brian.

I have gleaned some more information of the family which may give you a hand for your research. There is record of some members using Elliot one t. The i was not pronounced in my knowledge and time but in that area pronounced Ellot without the i.
John Elliott – married 1866 – 31st Dec. Margaret Milligan. I remember her. had 14 children. listing those who reached maturity in sequence. mother my Great Grandmother.

William, married Robina Woods, 1909, my father and mother
Mary – married Robert Andrews
Mathew
James
John
Archibald

Family legend is that my Grandfather John came from Ireland.
Grandfather John born 1859
Grandfather John married age 30 to married 1889 31st Dec. born 1866 Margret Milligan married age 23 this may have been Grandfathers second marriage.
I trust the above information may be of some use. Perhaps uncover some skeleton of intrest indeed!!
Thanking you in anticipation
Sincerely
J Elliott

Mr. Piercy wasn’t able to throw much light on the matter, since it appears from his reply that all he had to go on in those days was the IGI (International Genealogical Index, a rather rudimentary list of names published by the LDS Church). I, however, with the magic of the Internet at my fingertips, was able to hunt down all these people, and many more besides, using the extremely helpful vital statistics archive published by the Government of Scotland, ScotlandsPeople. But the two tidbits my grandfather had learned from his relatives back in Scotland, that piqued my interest, were these:

A Family legend is that my Grandfather John came from Ireland.

I’ll write more about that in a future post.

What I wanted to mention here is

B this may have been Grandfathers second marriage

“Grandfather”– i.e. John Elliott Sr., 1859-1915, my great-great-grandfather, about whom I now know quite a bit– probably had very little schooling and worked at manual labor his whole life. I’ve been able to trace his various addresses and occupations through the years using the Scottish Census and the birth and marriage records of his many children. For most of his life he was a brickfield laborer, and as he got older he became a “roadman” (a polite word, I believe, for ditch digger). He died on April 9, 1915 after suffering with a perforated gastric ulcer for a week. He was scarcely 56 years old when he died.

His wife Margaret survived him by almost 15 years and she was an iconic figure amongst the children of my grandfather’s generation. Known as Grandma Elliott or just Granny, it was she who stood on the dock at Port Glasgow and watched her eldest son (my great-grandfather) and his family embark for Canada in 1927. She gave birth to a very large family, and I guess her descendants are still going strong over in Paisley and Glasgow, although I don’t have any contact with them and the ones I have any knowledge of are surely long dead. (But if any of you are reading this don’t be shy about contacting me! I’d love to get caught up.)

John and Margaret were married in Paisley on December 31, 1889, when John was 30 and Margaret was quite a bit younger. Who could this mysterious first wife have been? Starting with the clue in my grandfather’s letter, I searched the ScotlandsPeople archive for John Elliotts who had been married in Renfrewshire prior to 1889 and after, let’s say, 1877 (when John would have been 18, a likely time to start thinking about marriage). What I came up with was this marriage registration, indicating that John had been married just two years previously, on December 9, 1887:

Marriage of John Elliott and Agnes Scott, December 9, 1887

Marriage of John Elliott and Agnes Scott, December 9, 1887

I knew I had the right John Elliott because his parents’ names, William Elliott and Mary Ingram, matched what I had already learned.

But the bride’s name was completely new to me: Agnes Scott, aged 30 (a wee bit older than the groom). She was a threadmill worker– Paisley was famous for the Coats Threadmill in those days (amongst other important industries). The bride’s mother, Agnes Gibb, was deceased by the time of the wedding (she died in 1875 after suffering from “Paralysis” for two and a half years). The bride’s father, William, was a Shawl Weaver. William, I have learned from various Census records, was born in Paisley around 1809, and his wife Agnes was born in Glasgow around 1813.

The wedding ceremony took place at 64 Millarston Drive, Paisley, which was also the residence of both the bride and groom, so it seems they had already moved in together. The wedding took place according to the forms of the Free Church of Scotland which is interesting because I know from other sources that John’s family were Anglican, so Free Church of Scotland must have been the Scott family’s denomination. Witnesses were William Elliott (either John’s father or his younger brother, both of whom bore that name) and one “I. (or J.) Scott” (possibly a cousin of Agnes’; in the 1861 Census there is a Janet Scott living in William Scott’s household, identified as his niece).

If we dig back in the Census records we see that 64 Millarston was actually the home of Agnes’ father William. In 1881 William’s household consisted of young Agnes (then aged 24, working at the threadmill), along with his son Robert (a Fire Clay Moulder) and Robert’s wife Mary, and their two children aged 5 and 7.

John, 22, was still living with his parents and seven siblings in the 1881 Census. And here’s the discovery that made me sit up and take notice: John and Agnes were next-door neighbors. John’s family and Agnes’ family appear on the same page of the 1881 Census; the Elliotts lived just a few doors down (at 62 Millarston). Furthermore, both John and his father William worked in the same industry as Agnes’ brother. I later confirmed (using birth records) that the Elliotts resided at 62 Millarston as early as 1867, when John would have been 8. The earliest mention I can find of the Scotts living at 64 Millarston is the mother’s death registration in 1875, when young Agnes would have been about 16 and John would have been about 14.

The bottom line here is that the Elliott and Scott families were neighbors for at least 12 years, and perhaps longer. John and Agnes may have known each other since childhood.

So, they finally decided to tie the knot late in 1887. Maybe John got Agnes pregnant and the wedding was forced; it’s not unlikely but impossible to know for sure. What happened then?

Agnes and John went on living in her father’s household after their marriage. But sadly, less than four months after the wedding, Agnes quite suddenly died.

Death Registration for Agnes Elliott (Scott), April 4, 1888.

Death Registration for Agnes Elliott (Scott), April 4, 1888.

In mid-March she came down with something called Puerperal Peritonitis. This is (so I have read) a post-partum infection, not necessarily fatal, but frequently so back then. Since a stillbirth should have generated a registration of death, and I can find none in the archives, I surmise that Agnes must have had a miscarriage and then, on top of the sorrow of losing her baby, suffered from an infection for two weeks before dying at home.

And with that, Agnes vanishes from our family history, along with the rest of the Scott family.

This is pretty heady stuff to think about. Agnes might have been the mother of a big family, but instead she died and Margaret came along the following year and took her place. John and Agnes knew each other for a long time before getting married… What kind of bond did they have? Agnes’ father and John’s father must have known each other for at least as long; what was their relationship? Was religion a point of contention between them? Did the fact that Agnes’ father was a (skilled) weaver whereas John’s father was an unskilled fireclay laborer ever come between them? Or the fact that Agnes’ father was twenty years older than John’s father? Did the fact that William was born in Scotland but John’s family were immigrants from Ireland figure in it? I am throwing out these wild speculations for a reason: It’s puzzling that John and Agnes knew each other for so long but waited and waited and waited before getting married. They were, after all, unusually old (29 and 30) at the time of their marriage.

My pet theory is that John and Agnes were long-time sweethearts but her father forbade them to marry because he didn’t think John was “good enough” for his daughter. When he finally relented, her advanced age contributed directly to complications that led to her death, obstetric medicine being as poor as it was in those days. Keep in mind that this is conjecture on my part, based on highly circumstantial evidence. There is absolutely no family oral history that I know of that supports my conclusion, and there are other ways to interpret the evidence.

I wonder how much of this story was known to John’s second wife Margaret. Margaret, though much younger than Agnes, worked at the Paisley threadmill too; could they have known each other? Been friends? Or is it possible that I, nosing around in the archives over a century later, actually know more now about John’s past than my great-great-grandmother Margaret did?

For me, discovering all this was intensely sad, but at the same time exciting. I was glad to be able to bring Agnes’ brief story to light at last. Previously she had been nothing more than a rumor in a letter that few people knew about, but now at least she has a name.

Posted in Genealogy | Leave a comment

Modality? What’s Modality?

Here’s a comment I received from Paul the other day about my database normalization tutorial:

Very nice. Excellent. The only thing I would question would be that a customer could have zero orders. In order to exist as a customer in your system, they must have placed an order at some point. So, the modality should be one.

I always like hearing nice things about my work, but the remark about modality gave me pause. What does that mean? That’s not a word I ever learned at the Database School of Hard Knocks. What is Paul talking about?

Modality, it turns out, is another word for what we database people call cardinality, or “the number of unique things in a set”. You might also hear it referred to as degree amongst erudite set-theory folks. When we talk about one-to-one relationships (or one-to-many, many-to-many, etc.), we’re talking about the modality or cardinality of the relationship between things in different sets. In other words, one row in a table can be related to rows of data in another table. It doesn’t have to be, but it can be, depending on what real-world relationships you are trying to model.

For instance, suppose you have a database of people, and EMAIL_ADDRESS is an optional field in your database. A person might have an email address, or she might not. We say there is a one-to-zero-or-one relationship, because one person can have zero or one email addresses.

If, on the other hand, EMAIL_ADDRESS is not optional, the relationship becomes one-to-one because one person must have one email address.

If, on the third hand, a person can have any number of email addresses, we call that one-to-many, because one person can have many email addresses. If the email address is still optional, we call that one-to-zero-or-many.

Each of these possibilities can be shown in an Entity Relationship Diagram or ERD, which is a visual representation of the relationships in your database. There are different ways of showing the relationships on a diagram, and terrible religious wars have been fought over which system is best. The system I chose for my tutorial uses the following symbols:

One-to-one
One-to-one
  • Every A has exactly one B.
  • Every B has exactly one A.
One-to-one
One-to-one
  • Any A can have no more than one B; maybe none.
  • Any B can have no more than one A; maybe none.
One-to-many
One-to-many
  • Every A has one or more Bs.
  • Any B has no more than one A; maybe none.
One-to-many
One and only one-to-many
  • Every A has one or more Bs.
  • Every B has exactly one A.
One-to-zero-or-many
One-to-zero or many
  • Any A can have any number of Bs; maybe none.
  • Any B can have no more than one A; maybe none.
Many-to-many
Many-to-many
  • Every A has one or more Bs.
  • Every B has one or more As.

Notice how the symbols (which are sometimes called “crowsfeet” for reasons that should be obvious) change the cardinality of the relationship. You should understand that this is not an exhaustive list of entity relationships, and again, there are many different sets of symbols out there.

So what’s all this got to do with my tutorial?

Check out Figure J, the diagram representing Third Normal form. Originally I had drawn it like this:

Third Normal Form: incorrect relationship

See if you can spot the problem.

Give up?

The symbols connecting ORDERS with CUSTOMERS say,

Every order has exactly one customer

and

Every customer can have any number of orders; maybe none.

In other words, a customer could exist in the database without ever placing an order.

I call this a “problem” rather than a “mistake” because there are lots of databases out in the real world that have customers who have never placed an order. Although logically, the definition of “customer” is “someone who has bought something from you”, I can think of all sorts of reasons why you might want to keep track of order-less customers… maybe their order is pending. Or maybe the customer is just a sales prospect, in which case they should perhaps go into a PROSPECTS table, and then migrate to CUSTOMERS after the order is made… or maybe you could add a STATUS field to the table to differentiate between pending customers, prospective customers, and actual customers… The possibilities are delightfully many, as are the possible solutions.

But guess what? I don’t care. At least not in the context of my tutorial. I wanted things to be clean and simple– I just wanted to model a stack of invoices, where every invoice has a customer, and every customer has made a purchase. But by selecting the wrong crowsfoot symbol, I introduced a whole big mess that would need considerable explanation that would dilute the simplicity of the tutorial.

So, what to do?  Easy; just change the symbol connecting CUSTOMERS to ORDERS. Here’s my new Figure J.

Third Normal Form

Which says,

Every order has exactly one customer

and

Every customer has one or more orders.

I’m grateful to Paul for pointing out this inconsistency.

Posted in Databases | 3 Comments

The whole truth behind candidate keys

A reader of my tutorial on the 3 Normal Forms recently asked:

The question is: why was customer_id not used as part of the composite primary key (order_id, customer_id , item_id) in 1NF in the first place?

It’s a good question. The questioner identified one of the normalization issues that I simplified in order to make (I hope) my tutorial more readable.

Going back to the tutorial, we said that every table row has to have a column or group of columns that uniquely identifies it, right? We called this the Primary Key. Formal database jargon refers to this as a “candidate key”. There could be more than one candidate key in a table; the one that we actually select becomes the Primary Key.

In truth, that’s only part of the story. The candidate key has to have two properties: First is Uniqueness (as we just stated); the second property is called Irreducibility (or Minimality).

Let’s consider some examples of the three columns the questioner mentioned: order_id, customer_id, item_id:

 order_id  customer_id  item_id
125 56 563
125 56 851
125 56 652
126 2 563

Does this set of columns satisfy the Uniqueness property? Yes, it does. Every combination of {order_id, customer_id, item_id} is unique in our table, and this makes sense according to the invoicing rules of our imaginary business: Every item ordered by a customer appears once and only once on an invoice, and invoices are never duplicated (if a customer makes a duplicate order, we issue a new invoice).

The trouble is, it is redundant to say this. We don’t call {order_id, customer_id, item_id} the candidate key because customer_id isn’t required to satisfy the uniqueness requirement; each row is already uniquely identified by {order_id, item_id}. This is what is meant by the Irreducibility property: If a set of columns can be reduced to a smaller set of columns that still satisfies the Uniqueness property, then it does not qualify as a candidate key.

Here’s a somewhat more formal definition of these two properties (quoted from C.J. Date’s An Introduction to Database Systems, 7th Ed., p. 258):

Let K be a set of attributes of relvar R. Then K is a candidate key for R if and only if it possesses both of the following properties:

  1. Uniqueness: No legal value of R ever contains two distinct tuples with the same value for K.
  2. Irreducibility: No proper subset of K has the uniqueness property.

If you’re unfamiliar with database set theory terminology, here relvar (“relation variable” in case you’re curious) means “table” and tuple means “row”. A proper subset is a subset that does not include the whole set itself (in other words if you have a set of things {a,b,c} then {a} is a subset, {a,b} is a subset, {a,b,c} is a subset, and so forth; a proper subset includes {a}, {a,b}, etc., but does not include {a,b,c}).

I don’t think it’s necessary to get into this kind of detail in the tutorial itself, but it’s worthwhile mentioning and I’m glad someone asked.

Posted in Databases | 2 Comments

3 Normal Forms Tutorial update

Many people have, over the years, both in the blog comments and in private messages, objected to my contention in the Normal Forms tutorial that ITEM_PRICE leads to failure of Second Normal Form. I always go back and forth about this, and I generally tell people something like “it depends on the business rules, it’s not a matter for Normalization to solve, I wanted to keep things simple,” etc. Enough people have pointed this out that I finally decided to spell out the problem in the tutorial itself, under the NF2 discussion. Hopefully this will not prove too confusing for beginners, while at the same time keep the advanced readers satisfied!

Posted in Databases | Leave a comment