database-design Archives - Page 4 of 5

What are the lengths of Location Coordinates, latitude and longitude? [closed]

Closed. This question needs details or clarity. It is not currently accepting answers. Want to improve this question? Add details and clarify the ...

May 10, 2022
0 Comments

How to implement one-to-one, one-to-many and many-to-many relationships while designing tables?

Can anyone explain how to implement one-to-one, one-to-many and many-to-many relationships while designing tables with some examples? 4 Answers 4

May 9, 2022
0 Comments

Should each and every table have a primary key?

I’m creating a database table and I don’t have a logical primary key assigned to it. Should each and every table have a ...

May 9, 2022
0 Comments

What are the best practices for using a GUID as a primary key, specifically regarding performance? [closed]

Closed. This question is opinion-based. It is not currently accepting answers. Want to improve this question? Update the question so it can be ...

May 9, 2022
0 Comments

Is storing a delimited list in a database column really that bad?

Imagine a web form with a set of check boxes (any or all of them can be selected). I chose to save them ...

May 8, 2022
0 Comments

Can I have multiple primary keys in a single table?

Can I have multiple primary keys in a single table? 12 Answers 12

May 6, 2022
0 Comments

What is the ideal data type to use when storing latitude / longitude in a MySQL database?

Bearing in mind that I’ll be performing calculations on lat / long pairs, what datatype is best suited for use with a MySQL ...

May 4, 2022
0 Comments

Database development mistakes made by application developers [closed]

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, ...

May 1, 2022
0 Comments

MongoDB vs. Cassandra [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question ...

April 23, 2022
0 Comments

MongoDB vs. Cassandra [closed]

Closed. This question does not meet Stack Overflow guidelines. It is not currently accepting answers. Want to improve this question? Update the question ...

April 23, 2022
0 Comments