User Privileges Normalization

preview_player
Показать описание
This assignment shows how we can build tables and its relation for user privileges in an application. In a real life scenario, we will use a practical Relational Database Management System like the MSSQL, MySql, PostgreSql etc...
Рекомендации по теме
Комментарии
Автор

Why are the table names different?
1. "assign_role_to_user" (one_to_one)
2. "assign_modules_to_roles" (many_to_many)

In the "user_privileges" table, there are column names that are reserved in SQL. I guess you shouldn't use those?

rutenowynidoking