Msaada: Sequence & Unique number generator

Software Engineer · 2016-04-07T09:19:56+00:00

Tunatengeneza software kwaajili ya kampuni ku manage wafanyakazi wake 1. Mfumo wa namba ya mfanyakazi e.g. 100 50 000120 > 100 (1st three digits) zinasimama kama branch ya kampuni alipo mfanyakazi > 50 ni namba ya department alipo mfanyakazi > 00120 (120 ndiyo namba halisi ya mfanyakazi) Database table design iko hivi > Branch (ID,Name,Code,CompanyID) e.g. (100,Makete,100,2) > Department(ID,Name,Code,BranchID) e.g. (500,HR,10050,100) > Employee(ID,Name,Code,DepartmentID) e.g. (120,Samuel,10050000120,500) Constraints > Branch hazitazidi 100 hivyo DDD mask inatosha > Department hazitazidi 10 hivyo DD mask inatosha > Employee hawatazidi laki moja Swali: Tutumie approach gani nzuri ku generate hizo ID za aina tatu? BrachID,DeptID,EmployeeID? Tumefanya nini hadi sasa? Tumetumia MS SQL sequence number feature ku generate hizi number lakini tunaona kama siyo the best solution.

Thread starter Software Engineer
Start date Apr 7, 2016

Software Engineer

JamiiForums uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.

Accept Learn more…

Back

Top Bottom

Forums

New posts

Msaada: Sequence & Unique number generator

Software Engineer

JF-Expert Member

Our Community

Regional Communities