441 reputation
36
bio website damirsystems.com/?page_id=5
location Toronto, Canada
age 53
visits member for 2 years, 1 month
seen 2 days ago

May
21
awarded  Constituent
May
7
revised How to design this database to avoid cyclic dependency?
exactly one
May
7
answered How to design this database to avoid cyclic dependency?
Mar
15
comment What alternatives exist when a table requires too many foreign keys?
Could you provide schema example for say 5 of these tables ...
Mar
15
revised Enforce data integrity with a recursive table
edited body
Mar
15
answered Enforce data integrity with a recursive table
Mar
10
comment Simple scenario needs to go from Unnormalized Data to 3NF - Review Please
.. (cont) So to summarize, if "normalizing" using decomposition, you should include enough examples to expose all FDs and JDs. The other way is not to use normalization at all, but to apply a design process which leads to (usually) 5NF directly, as a result of the process itself. But your question is very specific, so I'll skip on that one.
Mar
10
comment Simple scenario needs to go from Unnormalized Data to 3NF - Review Please
If you just blindly follow rules on this table, you will get stuck. For example, this table has FD {ID} --> {Name}, but also {Name} --> {ID}, and {Name} --> {Supplier}. Is this correct considering the business? Add more data to include more records of dog (cat) food ...; and possibly bought from different suppliers. As you add data, FD {ID} --> {Name} will disappear, probably same for FD {Name} --> {Supplier}; but some more may pop up probably MVD or JD regarding supplier and product. ..
Mar
9
awarded  Commentator
Mar
4
comment UML class diagramm for database design?
sparxsystems.com/resources/uml_datamodel.html
Nov
11
answered Storing Phone Numbers - Proper design
Sep
25
comment Economic Database Architecture Possibilities w/ Data of Varying Length
@idubs11; they can run it on analytic tables, that's OK, but not on the temporal structure above. Well they can, but advanced users only. The thing is that any 5NF views would get bogged down due to lack of "table elimination" in optimizer, so users would have to properly pick all tables they need for each query ....
Sep
21
answered Economic Database Architecture Possibilities w/ Data of Varying Length
Sep
20
revised What are the pros and cons of this schema for flashcards app?
naming convention
Sep
20
revised What are the pros and cons of this schema for flashcards app?
added 97 characters in body
Sep
20
answered What are the pros and cons of this schema for flashcards app?
Sep
18
comment How do I optimize this database design?
Also User_Cars and Vehicles_Hardware, both FKs should be part of a PK, -- the way it is now, both tables allow duplicate entries.
Sep
18
comment How do I optimize this database design?
Tracking must point to Vehicles_Hardware FK {vehicle_number, hardware_id}. The way it is now, it allows for any combination of vehicle_number, hardware_id even if they are not paired together.
Sep
7
comment SQL Server - Database per company. How to query across databases?
And your client is aware that there can be no foreign keys (referential integrity) across DBs?
Sep
7
answered How do I develop this data model without a circular reference?