| | |
Database Design
Please support our Database Design advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
![]() |
•
•
Join Date: Feb 2009
Posts: 3
Reputation:
Solved Threads: 0
Hello Everyone,
I have to make an online examination webapplication for a company.
In this system there will be one superadmin who can access and updates all areas of the system i.e this admin can also be known IT System administrator .
This administrator has to create different admins who will be controlling particular exams ..for example one admin will be controllinmg the C examination so that he can only create questions related to C That is he is restricted to c administration part only .Similarly there will be other types of admin who will be controlling diifferent exams.And there are some others types of users also and have to give different rights to each types of users.
I am finding difficulty in table design of superadmin and admin parts and how to assign different rights to each type of user ...As in this application there are 4 or 5 admins and other users also so how to design the table .......I am getting confused in table designing part ...Please help in designing the table for my application.Any help would be highly appreciated ...............So please help me out of this situation .
What I have thinked is that :
There will be one table named "RoleMst" - This tables will list all the roles like admin,user etc.
Fields:RoleId,RoleName and Desc.
But where to store various admins and their access rights ..........Please help me with the Database Design.........I don't want full database design ...I only want help in maintaining user roles and thier access rights in my application .................Please Guys help me out as tommorrow I have to present the table design in my company,,,,,,,,,,,,,,,,.....Thanking u ALL!!!!!!!!
I have to make an online examination webapplication for a company.
In this system there will be one superadmin who can access and updates all areas of the system i.e this admin can also be known IT System administrator .
This administrator has to create different admins who will be controlling particular exams ..for example one admin will be controllinmg the C examination so that he can only create questions related to C That is he is restricted to c administration part only .Similarly there will be other types of admin who will be controlling diifferent exams.And there are some others types of users also and have to give different rights to each types of users.
I am finding difficulty in table design of superadmin and admin parts and how to assign different rights to each type of user ...As in this application there are 4 or 5 admins and other users also so how to design the table .......I am getting confused in table designing part ...Please help in designing the table for my application.Any help would be highly appreciated ...............So please help me out of this situation .
What I have thinked is that :
There will be one table named "RoleMst" - This tables will list all the roles like admin,user etc.
Fields:RoleId,RoleName and Desc.
But where to store various admins and their access rights ..........Please help me with the Database Design.........I don't want full database design ...I only want help in maintaining user roles and thier access rights in my application .................Please Guys help me out as tommorrow I have to present the table design in my company,,,,,,,,,,,,,,,,.....Thanking u ALL!!!!!!!!
User table has recursive relationship because SuperAdmin, Admin and user (I think you understand me)
There's column in User table links to Type of user (RoleMst) SuperAdmin, Admin, User, etc...
There's column in User table links to Type of user (RoleMst) SuperAdmin, Admin, User, etc...
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
![]() |
Similar Threads
- your ideas on database design??? (Database Design)
- Database design regarding two 'linking' tables (Database Design)
- Database Design for storing versions (Database Design)
- Database Design feedback (absolute beginner here :) (Database Design)
- Help with contact/mailing list database design... (Database Design)
- Database design - subtypes and instances of an entity (Database Design)
- Database Design - Supertypes and Subtypes (Database Design)
- Database Design Advice (MySQL)
Other Threads in the Database Design Forum
- Previous Thread: urgent
- Next Thread: Creating in-memory database
| Thread Tools | Search this Thread |






