lacampeona
Registered User.
- Local time
- Today, 07:54
- Joined
- Dec 28, 2015
- Messages
- 392
Hello experts,
I have some questions
1. You have to create a database to track specific items, their entry into database and their usage. You have to build 4 different type of items.
Lets say you have to mantain Cars, Books, Medicine, Reserve Parts and all their usage.
How would you make that?
Will you create 4 tables of items (tblCars, tblBooks, tblMedicine, tblReserveParts) and 4 tables for their usage tblCarsUsage, tblBooksUsage, tblMedicineUsage, tblReservePartsUsage)
and then you will create a relationship for (tblcars+tblCarsUsage),(tblBooks+tblBooksUsage), (tblMedicine+tblMedicineUsage), (tblReserveParts+tblReservePartsUsage)?
is that correct way?
what if then someone in the future say to you that he wants new item? lets say you have to mantain Essential Oils and their usage?
what you will do? Create again new table for Essential Oils and their usage? and create their relationship? tblEssentialOils+tblEssentialOilsUsage?
I am just all confused becouse all these items has their specific you can not connected then with nothing similar? hmmm
My concept for now is working but I am all the time thinking that maybe I didnt start correctly.
How would you experts make this things? What is the correct way?
Thank you very much
I have some questions
1. You have to create a database to track specific items, their entry into database and their usage. You have to build 4 different type of items.
Lets say you have to mantain Cars, Books, Medicine, Reserve Parts and all their usage.
How would you make that?
Will you create 4 tables of items (tblCars, tblBooks, tblMedicine, tblReserveParts) and 4 tables for their usage tblCarsUsage, tblBooksUsage, tblMedicineUsage, tblReservePartsUsage)
and then you will create a relationship for (tblcars+tblCarsUsage),(tblBooks+tblBooksUsage), (tblMedicine+tblMedicineUsage), (tblReserveParts+tblReservePartsUsage)?
is that correct way?
what if then someone in the future say to you that he wants new item? lets say you have to mantain Essential Oils and their usage?
what you will do? Create again new table for Essential Oils and their usage? and create their relationship? tblEssentialOils+tblEssentialOilsUsage?
I am just all confused becouse all these items has their specific you can not connected then with nothing similar? hmmm
My concept for now is working but I am all the time thinking that maybe I didnt start correctly.
How would you experts make this things? What is the correct way?
Thank you very much