A relational database is a composition of relevant information that
displays said information through tables, consisting of rows and columns. The information (data) can be related by keys
and/or primary keys, or a unique column or group of columns. Relational databases are subject to specific
integrity rules to ensure that the information held inside the database stays
accurate, accessible, and rules out the possibilities of redundancies or erroneous
data from conflicting ‘null’ entries (Oracle, para. 2-3).
In the situation presented in the
rubric, I would be in charge of compiling a database of the family’s
information. At this juncture, I would
have to ascertain what items are important, and since this is a family reunion,
the relation of one individual to another is going to be of paramount
I would need to identify the ‘Name’ of
each person (Last in one cell, first in another), ‘Date of Birth’, and
‘Relation’, or who they are connected to within the database (i.e. spouse of
John Doe, child of Mary and Jack Person, cousin of Jill Doe, etc.) By organizing that information on each
person, it would enable a person to quickly decipher who is who prior to the
family reunion, which would alleviate confusion.
Additional information as it pertains
to the reunion itself could be added as needed, such as ‘Preferred meal type’,
with cells consisting of ‘Vegetarian’, ‘Pizza’, ‘Steak’, or ‘Seafood’. This kind of analysis would allow for easy
meal planning by organizing the information by that key and acquiring a count
of the occurrence of each data entry in that column.
The only problem that I would likely encounter is having completely
unique Primary Key’s, as this being a family reunion, there is a high
probability of repeat information being entered in respective cells (recurring
last names and first names). That being
the case, this could feasibly be solved by assigning unique number identifiers
per group. Basically, assigning Jack and
Jill Doe a ‘1**’ series number, and their children would be assigned numbers
‘101, 102, 103’ etc. This could be done
for each group to help identify each person to alleviate potential confusion if
there are two or more ‘John Doe’ entries present.