I am creating student table in SQL Server 2012. I thought to create separate schema for each module. Like Attendance, Assessment, etc. However student table will be used in all of them or most of them. In that case is it a good idea to create separate schema like 'common' or use one of the available schema even though table is used across.
Also i have some confusion on using varchar vs. nvarchar. As of now i do not have any ideas to use any foreign languages. But in future i might have a need to do but may not be in all tables just few tables like getting student names or grade details. in this scenario should i create them with nvarchar or no? For ex for student name i would like to have the name in english and also in foreign language. How to handle this?
Thanks for your time.