Using the information that Rory has gathered, his next step is to separate the data from Mary's contact list into the data object groupings of people, companies, and addresses. To do this, he carries out the following:
The contact list is in Microsoft Outlook and Rory uses the Export feature of this program to create a single tab delimited text file. He then imports that into a spreadsheet which gives him a single table with all the field names across the top.
On a large sheet of paper, he creates three tables, each with two columns. He labels the three tables: People, Companies, and Addresses, respectively.
He then works through each of the field names, decides which data object the field belongs to, and enters that on his sheet of paper in the appropriate table in the left column. He starts with the first field
Title
that relates to the title a person uses, and is therefore a property of the person. So Rory entersTitle
in the left column of thePeople
table. The next four...