meta user
network profile
| bio | website | damirsystems.com/?page_id=5 |
|---|---|---|
| location | Toronto, Canada | |
| age | 52 | |
| visits | member for | 11 months |
| seen | 46 mins ago | |
| stats | profile views | 27 |
|
42m |
awarded | Caucus |
|
42m |
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? |
