Alias names are optional. The main purpose of using table alias is better readablity. As per your scanario, the prefix of column names will help us to understand the table name. So it is not required.