2 Replies Latest reply: Sep 23, 2011 6:20 AM by 589533 RSS

    User Authentication Logical Model

    589533
      Hi Im attaching a logical model. Experts please take a look an guide for changes or to include more details. This is basically a user authentication logical model ERD
      Eagerly awaiting your reply. I am unable to attach a file if i can share the file it willl be easier... please tell me how to attach a word file .
      Thanks
      Organization

      OrgId PK
      LocId FK Location
      ClientId FK Clients
      Org Desc
      Org Location
      Create Date
      Last Updated By
      Location

      LocId PK
      Loc Desc
      Address
      Create Date
      Last Updated By
      Update Date

      Clients
      ClientID PK
      ClientName

      Department

      DeptId PK
      ClientID FK Clients
      UserId FK Users
      BookId FK
      DeptName
      Location
      Create Date
      Last Updated By
      Update Date
      USERS

      UserId PK
      Password :
      User_Role_Id FK Roles/Grps
      OrgId FK Organization
      Effective Dt
      Status
      Create Date
      Last Updated By
      Update Date

      User Roles ( Groups )

      User_Role Id PK
      UserId FK USERS
      BookId Fk Book_Types
      Role Id FK Roles
      Group Desc
      Create Date
      Last Updated By
      Update Date

      Roles
      Role Id PK
      Role Name
      Create Date
      Last Updated By
      Update Date

      BookTypes

      BookId PK
      BookType
      Create Date
      Last Updated By
      Update Date

      USER_Details

      UserId FK USERS
      DeptId FK Department
      Force Password Change Days
      Secret Question
      User Phone
      User Address
      DOB
      User Email
      User Mobile
      User Status
      User Supervisor
      Last Updated By
        • 1. Re: User Authentication Logical Model
          433582
          Hello,

          Will admit I am a bit confused at what you are asking for, if you require a template logical model which provides a thorough list of entities and attributes for various industries I highly recommend referencing the following books:

          The Data Model Resource Book: A Library of Universal Data Models for All Enterprises: Vol 1 and Vol 2

          From what I can see you will only need to reference Vol 1.

          You can purchase them from Amazon.

          Hope that helps.

          Kind regards,
          Yusef
          • 2. Re: User Authentication Logical Model
            589533
            Thanks for your reply Yusef.
            I am actually creating an ERD for authenticating the user when he logs into the database. So I will need a set of tables to identify if user exis and password is correct.
            After this some tables will exist for checking his department, his group. On the basis of his group he will be able to access only relevant parts of application. Its like a role or a privelege thing.
            Please tell me if the database tables that I have identified are correct ? Please ask questions so I may get to the best solution please.
            Thanks