Contents
Which is the most efficient database design for blog posts?
Comment CommentID int auto number PK BlogPostID int FK to BlogPost.BlogPostID, index ReplyToCommentID int FK to Comment.CommentID <
What should I consider when designing a database?
Understanding the purpose of your database will inform your choices throughout the design process. Make sure you consider the database from every perspective. For instance, if you were making a database for a public library, you’d want to consider the ways in which both patrons and librarians would need to access the data.
How are comments stored in a blog database?
Every database system you would be using to implement your blog will use indexing. What this means is that, rather than “trawling through a large table”, your database system maintains a seperate list of comments and which posts they are associated with, much like the index at the back of a book.
Why do you need a description table in a database?
If you have a field with optional data, such as “description,” that is blank for many of the records, you can move all of the descriptions into their own table, eliminating empty space and improving database performance.
Which is a good practice in database design?
In simple terms, normalization means to distribute the data into multiple smaller related tables instead of storing all the data in one large table. It is a good database design practice to normalize data for efficiency.
Which is better for structured data SQL or NoSQL?
First, based on the query language that a database uses to define and manipulate the data. Databases that use SQL are most popular for structured data. Whereas, NoSQL databases are better for machine learning, web analytics, and IoT (Internet of Things) because of features such as higher scalability, flexibility, and speed.
When to design a database for an e-commerce website?
For example, if an e-commerce website expects the number of visitors to increase drastically in a month when sales are going to be high, then this should be taken into account in the database design process so that the database can accommodate increasing visitors and endure the high workload.