Hello everyone!
I'm currently working on a database, but it's been a few years since I've made one, so I could really use some guidance to get me going in the right direction.
Here's the situation. I monitor people who record audiobooks on a daily basis, and have to judge their voice/speech. A lot of them have several sessions a day, a few times a week. I'd like to be able to track their session scores in a database, along with some additional remarks I might have relating to the session. Ideally, I'd like to create a form I can open where I can select the specific reader, fill out their score for a session, and save it to the database. Eventually I may want to create reader profiles I can load up, to see their progression over time and retrieve any comments that were added to their sessions.
Here's what I was thinking I'd need when it comes to tables:
- Reader table
- Name
- Comment table
- Comment
- Comment author
- Reader the comment pertains to
- Reading Session
- Date
- Reader
- Book
- Voice
- Articulation
- Optional comment
- User table (for me and whoever does the monitoring?)
- Username
Am I missing something rudimentary? Any hints/tips/guidance would be greatly appreciated!
Thanks in Advance!