What is indexing? Think of the data in the review table as being a library of books. Indexing is the process of creating an index-card catalog that lists every book alphabetically along with its location. When you need to sort, you can use the index-card catalog to locate every book and put it in its sorted position
خوب میگه از index برای پیدا کردن کتاب استفاده میکنیم و کتاب رو بر اساس حروف الفبا و جایی که هست مرتبش میکنیم
کش کردن سرعت رو بالا میبره
از دو تا راه waterfall , agile , میخوایم طراحی دیتابیس رو یادبگیریم برای دیزاین همچین کاری رو اول باید انجام بدیم
tracking inventory این اصطلاحیه که ما میخوایم استفاده کنیم برای زمانیه که یه جنسی رو میفروشیم ولی توی انبار نداریم به دلیل این که tracking inventory نداشتیم
tracking inventory numbers of in-stock products
قطعا وقتی که یه دوتا موضوع توی یه جدول کار خراب میشه باید اینطوری جداشون کنیم
If you use the waterfall approach, the database is implemented all at the same time; if you use the agile approach, the database is implemented part by part and integrated into what has been implemented
خوب waterfall همه دیتابیس یه جا طراحی میشه اون یکی نه
Functionality—You need to check whether the database performs the expected tasks correctly, such as creating, updating, and deleting a data entry
برای طراحی این دو تا کار خوبه : Get a subject-matter expert (SME) Ask for data samples whenever possible
Typically, if you can build a sentence with two nouns in which one has or owns the other, the one that is possessed is the characteristic, and the other is the subject. You can put user and password in the following sentence, for example:
A user has a password.
The password is possessed by the user, so it is a characteristic of a user, whereas the user is a subject.
