Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. General Programming
  3. Design and Architecture
  4. Creating Use Case for Stored Procedure

Creating Use Case for Stored Procedure

Scheduled Pinned Locked Moved Design and Architecture
databasebusinessquestion
5 Posts 3 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • P Offline
    P Offline
    puromtec1
    wrote on last edited by
    #1

    Is it conceptually possible and/or appropriate to create a use case, robustness and sequence diagrams for a sql stored procedure? This would allow business analyst to see clearly what the stored procedure is doing and its purpose.

    R J 2 Replies Last reply
    0
    • P puromtec1

      Is it conceptually possible and/or appropriate to create a use case, robustness and sequence diagrams for a sql stored procedure? This would allow business analyst to see clearly what the stored procedure is doing and its purpose.

      R Offline
      R Offline
      riced
      wrote on last edited by
      #2

      It's possible since the user in a use case is not necessarily a person; could be a process (whatever calls the SP). If it helps the BA then why not do it? In my experience BAs need all the help they can get. :-D

      Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis

      P 1 Reply Last reply
      0
      • P puromtec1

        Is it conceptually possible and/or appropriate to create a use case, robustness and sequence diagrams for a sql stored procedure? This would allow business analyst to see clearly what the stored procedure is doing and its purpose.

        J Offline
        J Offline
        Jonathan Davies
        wrote on last edited by
        #3

        When designing a Robotics system with an interface needed to a database, without creating Action Diagrams and Sequence diagrams which showed the everyone concerned the planned interaction between User, Robot and Data I don't think the project would have suceeded. So sounds good to me.

        P 1 Reply Last reply
        0
        • R riced

          It's possible since the user in a use case is not necessarily a person; could be a process (whatever calls the SP). If it helps the BA then why not do it? In my experience BAs need all the help they can get. :-D

          Regards David R --------------------------------------------------------------- "Every program eventually becomes rococo, and then rubble." - Alan Perlis

          P Offline
          P Offline
          puromtec1
          wrote on last edited by
          #4

          True. Thanks.

          1 Reply Last reply
          0
          • J Jonathan Davies

            When designing a Robotics system with an interface needed to a database, without creating Action Diagrams and Sequence diagrams which showed the everyone concerned the planned interaction between User, Robot and Data I don't think the project would have suceeded. So sounds good to me.

            P Offline
            P Offline
            puromtec1
            wrote on last edited by
            #5

            Thanks. Like everything database oriented, it typically isn't treated the same as developing with oop languages. I appreciate your input.

            1 Reply Last reply
            0
            Reply
            • Reply as topic
            Log in to reply
            • Oldest to Newest
            • Newest to Oldest
            • Most Votes


            • Login

            • Don't have an account? Register

            • Login or register to search.
            • First post
              Last post
            0
            • Categories
            • Recent
            • Tags
            • Popular
            • World
            • Users
            • Groups