Member Avatar for <maaniash>

Hi i am to design an online database system for a hospital . The requirement is that i have three types of user to login in the system online one is DOCTOR and PATIENT and CLERK. My question is how to design the table for this requirement . Either a single table will be useful in this case with the user types field or separate table is to be built for each type of user. Also note that the user have privileges according to there type and each user has its own main page or user interface.

Need Some Suggestion from Database Expert !

  • 2 Contributors
  • 1 Reply
  • 84 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by tesuji
Member Avatar for tesuji

Only starting hint, google this: generalization specialization relational modeling

Now it's your turn.

You may post in what you will then have decided, and we will discussing and possibly also improving your results.

-- tesu

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.