Bill of material desing.

AdventureWorks database contain a production.billofmaterials table.

This is used to store a hierarchy of ingredients that together form a product. Take a bike for example: it consists of many parts. Some parts are themselves consisting of parts. The part that has subparts is an assembly, while the leaves parts (without any children/sub parts) are called components in the table. Bike1 consists of say a body1 and wheels1, the wheels consist of tube1, tyre1 and rays1. The 1 here to indicate the type/id.

The same wheels1 can be used with bike2, which say consists of body1 and wheels1. 

The table mentioned stores the wheels1 tree (tube1, tyre1 and rays1) twice. Once under the bike1 and another under bike2 (duplication of bom records). This approach has got pros and cons: it duplicates data and tree maintenance and updating. Another approach is to store wheels1 tree and then refer to its root once from the tree of bike1 and another time from the bike2 tree.

DHL Express Stornierung per Mail oder E-Mail

 einfach eine Mail an inkofo.express.de@dhl.com

in Germany, if you want to cancel dhl express shipment label that you purchased online and not used, send email to inkofo.express.de@dhl.com

The customer service confirmed that a non used label wont be charged anyway and will be invalidated after a while. So just dont use the label and all is fine.

Android 12 exclamation mark on mobile data internet

 pixel 4a here: after upgrading the mobile data does not work. Resetting did not work neither restarting. Here is the solution: take the same out of the device and put it again if it is a physical one (nano). This will force the carrier and phone to match their settings again.

How to fix Your DNS server might be unavailable Error in windows

This happened on my machine when two devices got the same lan ip. The windows message in my case was not precise. if you go to cmd and run: ipconfig /all

you will see that there is a '(duplicate)' string beside the lan ip. In my case the lan ip was manual. Setting it to automatic resolves the issue or you can choose another ip or you can switch off the device that has the same ip (you get this information from the router itself) then switch it on and it gets a different ip. Glad I caught the issue in half an hour and solved it, it was very disappointing.

بيوعات الاراضي في الاردن قوشان

 "الرجاء التاكد من الرقم المتسلسل حيث تعذر العثور على مالك العقار"

لاصدار براءة مالية الكترونية

هذه الرسالة تظهر بسبب الاصفار على يسار الرقم, يرجى حذفها والمحاولة