Part I: (about 150 word is good enough)
You have two options to post your initial post: Option 1: Choose one of the following topics; Options 2: Post a new question and answer it. In your initial post, try to choose a different topic, or offer a different point of view.
1. Give an example of indexes and answer why indexes are important for a database. (Primary key is limited to 2 initial posts.)
2. What are the pros and cons of normalization in web database design?
3. The DDL (Data Definition Language) statements create, modify, and remove database objects such as tables, fields, indexes, and users. Give two examples of DDL statements and explain what the statements are used for. (Try not to repeat commands in the existing posts.)
4. The DML (Data Manipulation Language) statements add, modify, delete, and query data in a database. Give two examples of DML statements and explain what the commands are used for. (Be creative and try not to repeat commands in the existing posts.)
Part II:
reply to the following posts in short.
1.Normalization Pros & Cons
COLLAPSE
The advantages of normalization include:
- It makes the table smaller, run and updates the table quicker, and smoothly.
- Each table contains the related information.
- It prevents the duplication of data.
The disadvantages of normalization include:
- Tables become complicated to read and understand.
- Indexes do not function properly, because join does not work well with indexes, and join is mainly used normalization.
2.Give an example of indexes and answer why indexes are important for a database
COLLAPSE
An example of an index is the index that is automatically created when a primary key is created.Indexes are important for a database because theyallow thedatabase management system tolocate information faster.The more data there is,the slower querying becomes.However, even with a relatively small database,querying data without indexes can take a long time, so it is definitely worth it to create them on columns that are used frequently.