![Mysql database Design for a View feature [closed]](https://937011.smushcdn.com/2450823/wp-content/uploads/2021/10/data-warehouse-84533e56.png?lossy=0&strip=1&webp=1)
I am using MySQL. I have to create a view Table. When a user creates a view from a table only a specific amount of columns from the table Employee should be displayed.
Eg: User with userId:1 wishes to only see the Emlpoyee_firstName Employee_Salary a new view needs to be created.
Are there any suggestions for the Database design of view table?
