Question
A doctor file contains 200 records, but only 50 doctors currently have appointments. A doctor can have a minimum of 1 and maximum of 20
A doctor file contains 200 records, but only 50 doctors currently have appointments. A doctor can have a minimum of 1 and maximum of 20 appointments in a month. Given the following Join in Tableau: DOCTOR join APPOINTMENT table, (assume Appointment table contains only current appointments)
Explain and answer
1a. What would be the minimum size of equi join table? 1b. What would be the maximum size of equi join table? 1c. What would be the size of left join table?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Professional SQL Server 2012 Internals And Troubleshooting
Authors: Christian Bolton, Justin Langford
1st Edition
1118177657, 9781118177655
