Database Design

Reply

Join Date: Feb 2009
Posts: 3
Reputation: itcraze is an unknown quantity at this point 
Solved Threads: 0
itcraze itcraze is offline Offline
Newbie Poster

Database Design

 
0
  #1
Feb 8th, 2009
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!!!!!!!!
Reply With Quote Quick reply to this message  
Join Date: Aug 2006
Posts: 2,065
Reputation: Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice Ramy Mahrous is just really nice 
Solved Threads: 256
Featured Poster
Ramy Mahrous's Avatar
Ramy Mahrous Ramy Mahrous is offline Offline
Postaholic

Re: Database Design

 
0
  #2
Feb 8th, 2009
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...
BI Developer | LINKdotNET
B.Sc Computer Science, Helwan University
Technical blog | http://ramymahrous.wordpress.com
LinkedIn | http://www.linkedin.com/in/ramymahrous
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC