Hi all, my first time on the site so apologies if it's tagged incorrectly or been answered elsewhere... I keep running into particular situation on my current project and I was wondering how you guys would deal with it. The pattern is: a parent with a collection of children, and the parent has one or more references to particular items...
I'm trying to model timesheets, billable hours, projects, users Whats the best way to represent these in a database Elaborating more on the question: My biggest predicament is how to keep date, hours, project together One possible solution User (PK id, name) Project (PK id, name, FK user_id) BillableHour (PK id, FK project_id, hour...
Hi all.. First of all, I'm sorry about the feedback-nature of this question. I'm trying to generalize it as much as I can so others can gain from it as well, but I don't really have anyone to give me feedback on this design, so I hoped you guys could help me. With that being said, I wan't to model different usertypes in my database. I ...
Hi, I'm modelling a class diagram and I'm absolutely stuck with this issue: My new web application has "cards" (entries about a subject) which can be modified by the users, à là wiki. But unlike wikis, different cards hold different data. Also unlike wikis, cards are interrelated with other cards explicitly in the database. Let me show ...
In my university days I came across a Java app in one of my courses. You basically modeled your threads (any actions they perform etc.) in a simple language. It would draw a diagram and identify and issues with your threading. Does anyone know what this app is called? I have tried for the last 30 mins on Google but can't find anything. ...
I am evaluating a tool which says that it supports UML 2.2. However if I search on internet, I can't find what incremental change has occured between two version. And yes, I tried to go through OMG documents, but those are too dense to read. Is there a simple explanation anywhere? ...
Should I always have a primary key in my database tables? Let's take the SO tagging. You can see the tag in any revision, its likely to be in a tag_rev table with the postID and revision number. Would I need a PK for that? Also since it is in a rev table and not currently use the tags should be a blob of tagIDs instead of multiple entr...
Hello, I'm new to Rails and don't grasp yet all the possibilities with associations. Here's my problem: I have a couple of models like apple and lemon. Then there's the model 'relation' that holds triples of relations: subject | relation | object apple | is sweeter than | lemon The migration for 'relations' is this: create_table :...
I would like to design a metadata repository for the internal database. The repository should be able to provide simeple answers to questions like - which tables have what type of data and what are the table relationships ? Any industry standard guidelines that I should follow ? ...
I've seen several questions posted here about recommendations for UML diagramming tools as an alternative to Visio. What I seem to be missing, though, is a good database diagramming tool for OS X. I have done all of my development work in the .NET world for the last few years, and for better or worse Visio has been my go-to tool for data...
Hi If you believe that a use case flow of events creates an actor, how would you model that? I have a use case that creates a windows service, which (in my mind) is another system with its own set of use cases and actors. At the moment it is not obvious from the use case diagram that an actor gets created as part of the flow of event...
Hi, I was modeling a social networking style website where people would be able to have other people on their contacts list, i wanted to model this relationship as a HABTM relation on the Same table i.e User, is this a good idea? or is there a better way to do it? ...
Hi Guys, are there any good free native UML modelling tools for OS/X that allow you to quickly whip up simple UML diagrams. I know about ArgoUML, great for a java app (its usable), but certainly painful to use under OS/X wit the number of bugs and issues it has. ...
I was wondering if anybody had recommendations for some good datamodelling software? I've used an older version of Sybase Powerdesigner and found it a bit clunky - was hoping to get something a little easier to use... ...
I don't want anything that reads or generates code just drawing diagrams. I also must be able to enter code as text because i'm pretty sure it will not support the Eiffel langauge and i really don't want to click through a dozend buttons and dialogs just to enter a method signature (who ever invented this shit has no idea about usabilit...
At my current employer we generally adopt the old-school approach of writing a traditional functional requirements specification and then performing a full tech design. If the app is big then we break it into smaller chunks and attack it a chunk at a time but following the same basic pattern. This technique has served me well over the y...
Is there any term by the name 'consultation' in UML? If yes please explain or point to some resource. (Am writing the the paragraph below because may be you know it by some other name.) From the very limited knowledge that I have is that it is related to 'delegation'. My guess is that in delegation you transfer the task as it is to ano...
What are your favorite free CASE/UML/Code generation/diagramming tools that you use with PHP? There are various commercial products that support code generation in PHP language, are there any free CASE tools? What would you recommend? ...
Hi I am trying to refine my knowledge of N_Tier arch Inside the BLL, and In case I am using custom business objects in BLL, like CustomerInfo {FN, LS, ...}, Consider that I have Customer table and Currency table, Customer is having a default currency, thus there is a FK Currency_ID in Customer table, at UI layer, we need to show Curren...
I have a project that requires user-defined attributes for a particular object at runtime (Lets say a person object in this example). The project will have many different users (1000 +), each defining their own unique attributes for their own sets of 'Person' objects. (Eg - user #1 will have a set of defined attributes, which will ...