I have one comment, For the fields contain decimal numbers, don’t use int ( integers) it’s better to use numeric(18,3) this is for decimal number field, the 3 it’s mean 3 digits after (.) point. This is my suggestion for you, because you will face problems in access when you will enter numbers like 3.567 ( for example). Thank you for your time ❤
Hello, thanks for your project. Two notes: in table ProductsCategory by CategoryID is missing Primary Key. And generaly: you can set Email Address as Unique Key, so you don't have duplicates
I don't know if you made a small mistake. In the Supplier Tabel you have a supplierID number and Supplier text. Ok. But in the Purchase tabel you have PurchaseID, ok. But than Supplier NUMBER? Is this the foreign key from the suppliertable. Than it must be SupplierID. Otherwise the type must be Text. I think the same in the product table.
It's very good but Can you make a row in product table as a product tax ? So that it can be calculated purchase and sale.
I have one comment,
For the fields contain decimal numbers, don’t use int ( integers) it’s better to use numeric(18,3) this is for decimal number field, the 3 it’s mean 3 digits after (.) point.
This is my suggestion for you, because you will face problems in access when you will enter numbers like 3.567 ( for example).
Thank you for your time ❤
Thanks, its very good suggestion. I will make the change..
@@LoopLearnings we learned from you
And i hope to take a online course with you to make my own application
@HaniAbusido thank you, much appreciated. Soon will launch my courses.
@@LoopLearnings i mean i want it privet 😁online
Hello, thanks for your project. Two notes: in table ProductsCategory by CategoryID is missing Primary Key. And generaly: you can set Email Address as Unique Key, so you don't have duplicates
Thanks for the observations, i have made the corrections.
Please can you also make a table for the customers. That will be great.
Customer table has been added :)
Is it equivalent to the POS you made in MS Access?
Sort of but little different. it will be focused only on Inventory aspect.
I don't know if you made a small mistake. In the Supplier Tabel you have a supplierID number and Supplier text. Ok. But in the Purchase tabel you have PurchaseID, ok. But than Supplier NUMBER? Is this the foreign key from the suppliertable. Than it must be SupplierID. Otherwise the type must be Text. I think the same in the product table.
I give an answer to my own question. I thought it was an Access database but it is for Sql Server.
Why you didnot complete the employees series
please let me know what would you like to see about the employees database series.
@@LoopLearnings I would like to see a different techinque like cascading comboboxs, comboboxes with listbox ...tabs ..etc
How do I join Loop Learnings as a member?
Sorry for the late reply, here is the link to become member. Thank you www.youtube.com/@looplearnings/join