1
It's a database about actors and movies. I want fill it with their age too, so I can answer the queries:
- at what age they made their last movie.
- what is the average age when they made their movies?
etc. These are my proposed tables: Actor table with the fields:
- name
- age
- name of films made
- year of films made
a Film table with the fields:
- name of films made
- year of films made
- names of actors in that film
What would be the best one to use as key?
C. Then I'd probably need a linking table, with the fields:
- Actors
- Films
For all 3 tables: What would be the best field to use as a key?
my follow up question is: What other tables would I need?
And Access 2003 is the only one the client has a license for. Labor of love, volunteer stuff.
Your criticism seems iffy, considering the fact that Mokubai answered all my questions pretty accurately. And precisely.
But, I'm open minded, so: how do you think I should make the question less broad? I'm really asking, I hope you can help me. Please be specific where I should be more precise. Bottom line: How do you think that I can improve upon the question and its subquestions? If you can't think of ways how I can do that, I'm asking you kindly to take this question on hold. Please don't hold the past against me. That's prejudice. Thanks! – GwenKillerby – 2018-09-27T21:43:47.633
of course I meant OFF hold. please remove the on hold thing. – GwenKillerby – 2018-09-28T17:39:32.800