HELP: Physical Database Design

Hello to all.

I'm having trouble translating this requirement into physical DB tables:

- Information about users in general are:

- Username and Password

- Users belong to a group which have different roles

- (e.g. Customers, Administrators)

- Users can only belong to one group

- Information about groups are:

- GroupID, GroupName, Roles

- Customers and Administrators have different fields

- Customers : (CustomerID, CompanyName, BillingAddress, ShippingAddress, etc.)

- Administrators: (AdministratorID, AdministratorName)

- The system must be able to do the following:

- Ban a group

- Ban a specific user

- Information about a user must be based on the group that he/she is in. (e.g. Customer info must be queried from the Customers table) with the username as the only provided information initially.

- Add a new user type in the future

Any comments and suggestions will do. Thanks in advance.

- Raymond

Here is a good resource for classwork design problems such as this.

If you review some of the designs listed at this site, you will have a better idea of how to accomplish your assignment. (Note: the models and designs at this site are only a suggestion and should be used with caution -but they are better than nothing...)

http://www.databaseanswers.org/data_models/index.htm