The above link is a website that shows an ER diagram along with the tables. Its a simple video blog system. I require comments on whether what I have done makes sence (diagram, tables and so on)? How can the existing stuff be improved?
i would combine the User and Admin tables, and have a column named isAdmin to identify the admins
if Privilege is really 1-to-1, just combine it into the User/Admin table -- otherwise, you'll need another table between them, if an admin can have more than one priviledge (which is the most flexible scenario)
can you read this --
nounParis prepIn artThe nounSpring
difficult, isn't it? so please, remove the "tbl" prefix from your table names