#data-modeling

‪#‎Structured‬ ‪#‎Systems‬ ‪#‎Analysis‬ and ‪#‎Design‬ ‪#‎Method‬ (SSADM) is the method which is used at projecting and analysis of Computer Choice System Requirement to design Database security system.

‪#‎SSADM‬ uses a combination of three techniques: (1) ‪#‎Logical‬ ‪#‎Data‬ ‪#‎Modeling‬, (2) #Data ‪#‎Flow‬ Modeling, (3) ‪#‎Entity‬ ‪#‎Behavior‬ Modeling.

How to: What's the best way to model recurring events in a calendar application? #it #development #answer

What’s the best way to model recurring events in a calendar application?

I’m building a group calendar application that needs to support recurring events, but all the solutions I’ve come up with to handle these events seem like a hack. I can limit how far ahead one can look, and then generate all the events at once. Or I can store the events as repeating and dynamically display them when one…

Fix: How do you recommend implementing tags or tagging #answer #programming #it

How do you recommend implementing tags or tagging

I’ve heard of a few ways to implement tagging; using a mapping table between TagID and ItemID (makes sense to me, but does it scale?), adding a fixed number of possible TagID columns to ItemID (seems like a bad idea), Keeping tags in a text column that’s comma separated (sounds crazy but could work). I’ve even heard someone recommend a sparse…

How to: Are soft deletes a good idea?

Are soft deletes a good idea?

Are soft deletes a good idea or a bad idea?

Instead of actually deleting a record in your database, you would just flag it as IsDeleted = true, and upon recovery of the record you could just flag it as False.

Is this a good idea?

Is it a better idea to physically delete the record, then move it to an archive database, and if the user wants the record back, then…

Fixed What's the difference between identifying and non-identifying relationships? #dev #it #asnwer

What’s the difference between identifying and non-identifying relationships?

I haven’t been able to fully grasp the differences. Can you describe both concepts and use real world examples?

Answer: What’s the difference between identifying and non-identifying relationships?

An Identifying relationship specifies that a child object cannot exist without the parent object

Non-identifying…

How to: What's the best way to model recurring events in a calendar application?

What’s the best way to model recurring events in a calendar application?

I’m building a group calendar application that needs to support recurring events, but all the solutions I’ve come up with to handle these events seem like a hack. I can limit how far ahead one can look, and then generate all the events at once. Or I can store the events as repeating and dynamically display them when one…

How to: How do you recommend implementing tags or tagging

How do you recommend implementing tags or tagging

I’ve heard of a few ways to implement tagging; using a mapping table between TagID and ItemID (makes sense to me, but does it scale?), adding a fixed number of possible TagID columns to ItemID (seems like a bad idea), Keeping tags in a text column that’s comma separated (sounds crazy but could work). I’ve even heard someone recommend a sparse…