6 kyu
Finding the Friday Night DVD Rental Kings/Queens
181bornForThis
Loading description...
Databases
SQL
This comment has been reported as {{ abuseKindText }}.
Show
This comment has been hidden. You can view it now .
This comment can not be viewed.
- |
- Reply
- Edit
- View Solution
- Expand 1 Reply Expand {{ comments?.length }} replies
- Collapse
- Spoiler
- Remove
- Remove comment & replies
- Report
{{ fetchSolutionsError }}
-
-
Your rendered github-flavored markdown will appear here.
-
Label this discussion...
-
No Label
Keep the comment unlabeled if none of the below applies.
-
Issue
Use the issue label when reporting problems with the kata.
Be sure to explain the problem clearly and include the steps to reproduce. -
Suggestion
Use the suggestion label if you have feedback on how this kata can be improved.
-
Question
Use the question label if you have questions and/or need help solving the kata.
Don't forget to mention the language you're using, and mark as having spoiler if you include your solution.
-
No Label
- Cancel
Commenting is not allowed on this discussion
You cannot view this solution
There is no solution to show
Please sign in or sign up to leave a comment.
Rental table has an inventory id, yet that table is not part of the domain. It seems the schema is not complete.
I am in a sort of dilemma is that for sample test, static dump is used that contains all columns, but for random tests I use only necessary for query columns because if I try to populate all columns I will need to populate tables and relations that are not needed for a query with a resultant timeouts and cumbersome code. So for schema 2 approaches can be implemented: either to show all columns, or only necessary for a query. Both are not fully correct.
Perhaps you should just state in the description that you only describe part of the domain required to solve this kata. (Inventory and other tables not relevant, out of scope)
done that - updated the description. Thank you for the suggestion, solving the kata and the feedback! Have a nice day, cheers