Database Design Question

[morgandawn]

 If you are designing an Excel database with creator names how do you handle entries where the creator is listed as "possibly Morgan Dawn"? 

I can think of several ways...

Creator:  Unknown-Morgan Dawn might be best.  That way if you sort, all the Unknown-Morgan Dawn works will still be listed together.  They won't be listed next to the confirmed Morgan Dawn works, but still searchable. If and when the ID is confirmed it could then be moved to "Morgan Dawn" or even updated to "Mary Sue Lamb". It could also handle multiple guesses: "Unknown-Morgan Dawn-Mary Sue Lamb

The idea is to leave "Unknown" for those were we have no clue, and keep the ones where we are guessing in another grouping.

The other way is to have a second column that would add a Y/N in  "Presumed Creator" but I don't like separating data. Plus one more cell to fill in is a pain.

Comments

[morgandawn]

A vid entry will always have

Title Fandom (even if unknown) Vidder (even if unknown)

Each vid will have its own unique identifier. Since most of the names will be "unknown" we want to hold off assigning identifiers to them. We also need to address fan names/real names. Other constraints - this must be worked on within Google Sheets (to start).

Col 1 Vid Title XXXX Col 2: Vidder Name Confirmed Y/N (in this case N) Col 2 Vidder Name Unknown Col 3 Vidder Name Alternate 1 Morgan Dawn Col 4: Vidder name Alternate 2 Mary Sue Lamb

For a known vid

Col 1 Vid Title XXXX Col 2: Vidder Name Confirmed Y/N (in this case Y) Col 2 Vidder Name Morgan Dawn Col 3 Vidder Name Alternate 1 ---- Col 4: Vidder name Alternate 2 ----

This is not for personal use - this will be used for many other purposes and many people.

https://mailtrack.io/ Sent with Mailtrack https://mailtrack.io/install?source=signature&lang=en&referral=morgandawn@gmail.com&idSignature=22 <#>

[laisserais]

Here's an example of what I mean. If you want to build something that will be useful long term, this is the way to go. I think you're on the right track!

[morgandawn]

Thank you. The only time we would have any alternate names would be if the Vidder Name was not confirmed. So in your example, the Vid Alternate boxes would only be filled in on the second line.