database-design Archives - Page 3 of 5

Max length for client ip address [duplicate]

This question already has answers here: Closed 9 years ago. Possible Duplicate: Maximum length of the textual representation of an IPv6 address? What ...

May 18, 2022
0 Comments

What are database normal forms and can you give examples? [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 18, 2022
0 Comments

Relational Database Design Patterns? [closed]

Closed. This question needs to be more focused. It is not currently accepting answers. Want to improve this question? Update the question so ...

May 18, 2022
0 Comments

How can you represent inheritance in a database?

I’m thinking about how to represent a complex structure in a SQL Server database. Consider an application that needs to store details of ...

May 17, 2022
0 Comments

Create unique constraint with null columns

I have a table with this layout: CREATE TABLE Favorites ( FavoriteId uuid NOT NULL PRIMARY KEY, UserId uuid NOT NULL, RecipeId uuid ...

May 16, 2022
0 Comments

Recommended SQL database design for tags or tagging [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 14, 2022
0 Comments

What does character set and collation mean exactly?

I can read the MySQL documentation and it’s pretty clear. But, how does one decide which character set to use? On what data ...

May 13, 2022
0 Comments

What are OLTP and OLAP. What is the difference between them?

Actually what do they mean? All articles I find about them don’t give me an idea, or my knowledge is too insufficient to ...

May 12, 2022
0 Comments

Calendar Recurring/Repeating Events – Best Storage Method

I am building a custom events system, and if you have a repeating event that looks like this: Event A repeats every 4 ...

May 12, 2022
0 Comments

Auto Generate Database Diagram MySQL [closed]

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

May 11, 2022
0 Comments