tag:blogger.com,1999:blog-13085908733123586082024-11-01T04:58:03.252-07:00Here we are to learn Database, Understanding Administration, Management and Development of Databases primarily using Microsoft SQL Server 2008.Abdul Majid Tayyabihttp://www.blogger.com/profile/06695143952223160912noreply@blogger.comBlogger2612tag:blogger.com,1999:blog-1308590873312358608.post-5757212680631853392011-10-27T05:51:00.000-07:002011-10-27T05:52:08.246-07:00Qalam Karwa`n ... قلم کارواں<br /><br />السلام علیکم !<br /><br />کیا آپ لکھنا جانتے ہیں ؟؟؟ کیا کہا نہیں ارے تو پریشان مت ہوں ہم ہیں نا ۔۔۔<br /><br />جی تو ہم لائیں ہیں آپ کے لئے ایک ایسی محفل جس کا نام ہے قلم کارواں !<br /><br />جس میں شامل ہوں گے آپ کے آئیڈیاز اور تبصرے ۔۔۔<br /><br />قلم کارواں دراصل رائٹرز کلب ہے۔۔۔<br /><br />قلم کارواں ! جی ہاں یہ محفل میں ہمارے ساتھ ہونگے لکھاری ادیب شاعر اور نئے لکھاری بھی ۔۔۔۔<br /><br />اس محفل کا مقصد نئے لکھاریوں کی صلاحیتوں کو نکھارنے اور ان میں لکھنے کی صلاحیت پیدا کرنا ہے سینئیرز اور نئے لکھاریوں میں دوستانہ تعلق پیدا کرنا اس کمیونٹی میں شامل ہوں گے طلبہ بھی ، اساتذہ بھی ، ادیب بھی ، اور وہ تمام افراد جو لکھنا چاہتے ہوں ۔ اس گروپ کے تحت منتخب موضوعات پر تحریرں لکھوا کر انہیں اخبارات میں شائع کروایا جائے گا ۔ لہٰذا اگر آپ لکھ سکتے ہیں اور لکھنے کا شوق رکھتے ہیں تو آئیے ہماری اس محفل کا حصہ بنئیے معاشرے میں جاری برائیوں کا مقابلہ کیجئے اپنے قلم سے کیونکے آپ کے پاس ہے قلم کی طاقت ۔۔۔۔ تو آئیے معاشرے میں پھیلے اندھیروں کو اپنے قلم کی طاقت سے روشنی میں<br />بدل دیجئے کیا آپ اس جہاد میں ہمارا ساتھ دیں گے؟؟؟<br />join us at<br /><br /> <br />http://www.orkut.com/Main#CommTopics?cmm=87401702<div class="blogger-post-footer"><script type="text/javascript"><!-- google_ad_client = "pub-5863745455635774"; /* 728x90, created 5/25/09 */ google_ad_slot = "8775121146"; google_ad_width = 728; google_ad_height = 90; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></div>ssg_fatirhttp://www.blogger.com/profile/12619285345965786946noreply@blogger.com0tag:blogger.com,1999:blog-1308590873312358608.post-57716662414851714602009-06-24T04:08:00.004-07:002009-06-24T04:33:27.008-07:00<p class="MsoNormal" style="margin-top:.1in;margin-right:0in;margin-bottom:.2in; margin-left:0in;line-height:13.6pt"><span class="Apple-style-span" style="color:#CC0000;"><b></b></span></p><span class="Apple-style-span" style="color:#CC0000;"><b><p class="MsoNormal" style="margin-top:.1in;margin-right:0in;margin-bottom:.2in; margin-left:0in;line-height:13.6pt"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; font-family:&quot;;font-size:12.0pt;color:black;">Below is the solution of the QuestionNo.2 from the <a href="http://learnsql2008.blogspot.com/2009/06/nomalization-exercises.html">Normalization Exercises</a> that I posted earlier. <o:p></o:p></span></p></b></span><p></p><p class="MsoNormal" style="margin-top:.1in;margin-right:0in;margin-bottom:.2in; margin-left:0in;line-height:13.6pt"><b><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; font-family:&quot;;font-size:12.0pt;color:#CC0000;">QuestionNo2: </span></b><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; font-family:&quot;;font-size:12.0pt;color:black;">Following are the attributes required to be stored by an organization during transactions. You are required to identify how many tables are required to store these attribute in Normalized Form.</span><span style="mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">Quantity Sold,</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">Date/Time of Sale,</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">Salesperson,</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">Product Name,</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">Product Category,</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">Product SubCategory,</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">Manufacturer Name,</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">Store Location,</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">Phone Number,</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">City Name,</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">State,</span><span style="font-size: 14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;mso-line-height-alt:13.6pt"><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:12.0pt;color:#548DD4;">Population</span><span style="font-size:14.0pt;mso-bidi-mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height: 13.6pt"><span style="mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#548DD4;"> </span><span style="mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:black;">You can assume any example data for this exercise.<o:p></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height: 13.6pt"><span style="mso-fareast-font-family:&quot;Times New Roman&quot;; mso-bidi-Times New Roman&quot;;font-family:&quot;;font-size:12.0pt;color:#494949;"><o:p> <span class="Apple-style-span" style="color: rgb(204, 0, 0); font-weight: bold; ">Solution:</span></o:p></span></p> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;text-align: justify;tab-stops:35.45pt 87.4pt 114.4pt"><b><span style="color:black;">Sales Detail<o:p></o:p></span></b></p> <table class="MsoTableColorfulGridAccent5" border="1" cellspacing="0" cellpadding="0" style="background:#B6DDE8;mso-background-thememso-background-themetint: 102;border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:480;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insideh: .5pt solid windowtext;mso-border-insidev:.5pt solid windowtextcolor:accent5;"> <tbody><tr style="mso-yfti-irow:-1;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:21.7pt"> <td width="102" style="width:76.85pt;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt;height:21.7pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal;mso-yfti-cnfc:5"><span style="color:black;">ProductID<o:p></o:p></span></p> </td> <td width="97" style="width:72.6pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:21.7pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal;mso-yfti-cnfc:17"><span style="color:black;">StoreID<o:p></o:p></span></p> </td> <td width="124" style="width:92.75pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:21.7pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal;mso-yfti-cnfc:1"><span style="color:black;">SalesPersonID<o:p></o:p></span></p> </td> <td width="124" style="width:92.75pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:21.7pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal;mso-yfti-cnfc:17"><span style="color:black;">QuantitySold<o:p></o:p></span></p> </td> <td width="149" style="width:112.1pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:21.7pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal;mso-yfti-cnfc:9"><span style="color:black;">Date_Timeof Sale<o:p></o:p></span></p> </td> </tr> </tbody></table> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;tab-stops: 57.45pt 98.05pt 168.1pt"><b><span style="color:black;"><o:p> Product Details</o:p></span></b></p> <table class="MsoTableMediumGrid1Accent5" border="1" cellspacing="0" cellpadding="0" style="border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:480;mso-padding-alt:0in 5.4pt 0in 5.4pt;mso-border-insideh: .5pt solid windowtext;mso-border-insidev:.5pt solid windowtext"> <tbody><tr style="mso-yfti-irow:-1;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes"> <td width="97" style="width:72.4pt;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .5pt;background:#B6DDE8;mso-background-theme mso-background-themetint:102;padding:0in 5.4pt 0in 5.4ptcolor:accent5;"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal;mso-yfti-cnfc:5"><span style="color:black;">Product id<o:p></o:p></span></p> </td> <td width="119" style="width:89.3pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#B6DDE8;mso-background-thememso-background-themetint: 102;padding:0in 5.4pt 0in 5.4ptcolor:accent5;"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal;mso-yfti-cnfc:17"><span style="color:black;">ProductName<o:p></o:p></span></p> </td> <td width="152" style="width:113.85pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#B6DDE8;mso-background-thememso-background-themetint: 102;padding:0in 5.4pt 0in 5.4ptcolor:accent5;"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal;mso-yfti-cnfc:1"><span style="color:black;">ProductCategoryID<o:p></o:p></span></p> </td> <td width="133" style="width:99.8pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#B6DDE8;mso-background-thememso-background-themetint: 102;padding:0in 5.4pt 0in 5.4ptcolor:accent5;"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal;mso-yfti-cnfc:17"><span style="color:black;">ProductSub CategoryID<o:p></o:p></span></p> </td> <td width="138" style="width:103.45pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; background:#B6DDE8;mso-background-thememso-background-themetint: 102;padding:0in 5.4pt 0in 5.4ptcolor:accent5;"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal;mso-yfti-cnfc:9"><span style="color:black;">ManufacturerID<o:p></o:p></span></p> </td> </tr> </tbody></table> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;tab-stops: 57.45pt 98.05pt 168.1pt"><b><span style="color:black;"><o:p> Product Categories</o:p></span></b></p> <table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="background:#B6DDE8;mso-background-thememso-background-themetint: 102;border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:480;mso-padding-alt:0in 5.4pt 0in 5.4ptcolor:accent5;"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:22.35pt"> <td width="165" style="width:123.95pt;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt;height:22.35pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">ProductCategory ID<o:p></o:p></span></p> </td> <td width="190" style="width:142.75pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:22.35pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">ProductCategoryName<o:p></o:p></span></p> </td> <td width="190" style="width:142.75pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:22.35pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">ParentCategory ID<o:p></o:p></span></p> </td> </tr> </tbody></table> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;tab-stops: 57.45pt 98.05pt 168.1pt"><b><span style="color:black;"><o:p> SalesPerson Details</o:p></span></b></p> <table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="background:#B6DDE8;mso-background-thememso-background-themetint: 102;border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:480;mso-padding-alt:0in 5.4pt 0in 5.4ptcolor:accent5;"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:20.35pt"> <td width="147" style="width:110.45pt;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt;height:20.35pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">SalesPersonID<o:p></o:p></span></p> </td> <td width="168" style="width:126.15pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:20.35pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">SalespersonName<o:p></o:p></span></p> </td> <td width="168" style="width:126.15pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:20.35pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">StoreID<o:p></o:p></span></p> </td> </tr> </tbody></table> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;tab-stops: 57.45pt 98.05pt 168.1pt"><b><span style="color:black;"><o:p> Manufacturer Details</o:p></span></b></p> <table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" width="488" style="width:366.25pt;background:#B6DDE8;mso-background-theme mso-background-themetint:102;border-collapse:collapse;border:none;mso-border-alt: solid windowtext .5pt;mso-yfti-tbllook:480;mso-padding-alt:0in 5.4pt 0in 5.4ptcolor:accent5;"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:21.05pt"> <td width="149" style="width:111.55pt;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt;height:21.05pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">ManufacturerID<o:p></o:p></span></p> </td> <td width="170" style="width:127.35pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:21.05pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">ManufacturerName<o:p></o:p></span></p> </td> <td width="170" style="width:127.35pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:21.05pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">ManufacturerAddress<o:p></o:p></span></p> </td> </tr> </tbody></table> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;tab-stops: 57.45pt 98.05pt 168.1pt"><b><span style="color:black;"><o:p> Store Details</o:p></span></b></p> <table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="background:#B6DDE8;mso-background-thememso-background-themetint: 102;border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:480;mso-padding-alt:0in 5.4pt 0in 5.4ptcolor:accent5;"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:23.7pt"> <td width="83" style="width:62.45pt;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt;height:23.7pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">StoreID<o:p></o:p></span></p> </td> <td width="76" style="width:56.95pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:23.7pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">CityID<o:p></o:p></span></p> </td> <td width="126" style="width:94.3pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:23.7pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">StoreLocation<o:p></o:p></span></p> </td> <td width="132" style="width:99.15pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:23.7pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">PhoneNumber<o:p></o:p></span></p> </td> </tr> </tbody></table> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;tab-stops: 57.45pt 98.05pt 168.1pt"><b><span style="color:black;"><o:p> City Details</o:p></span></b></p> <table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="background:#B6DDE8;mso-background-thememso-background-themetint: 102;border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:480;mso-padding-alt:0in 5.4pt 0in 5.4ptcolor:accent5;"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:21.75pt"> <td width="71" style="width:53.4pt;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt;height:21.75pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">CityID<o:p></o:p></span></p> </td> <td width="100" style="width:74.9pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:21.75pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">CityName<o:p></o:p></span></p> </td> <td width="63" style="width:47.2pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:21.75pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">StateID<o:p></o:p></span></p> </td> <td width="104" style="width:78.15pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:21.75pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">Population<o:p></o:p></span></p> </td> </tr> </tbody></table> <p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;tab-stops: 57.45pt 98.05pt 168.1pt"><b><span style="color:black;"><o:p> State Details</o:p></span></b></p> <table class="MsoTableGrid" border="1" cellspacing="0" cellpadding="0" style="background:#B6DDE8;mso-background-thememso-background-themetint: 102;border-collapse:collapse;border:none;mso-border-alt:solid windowtext .5pt; mso-yfti-tbllook:480;mso-padding-alt:0in 5.4pt 0in 5.4ptcolor:accent5;"> <tbody><tr style="mso-yfti-irow:0;mso-yfti-firstrow:yes;mso-yfti-lastrow:yes; height:19.05pt"> <td width="81" style="width:60.4pt;border:solid windowtext 1.0pt;mso-border-alt: solid windowtext .5pt;padding:0in 5.4pt 0in 5.4pt;height:19.05pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">StateID<o:p></o:p></span></p> </td> <td width="113" style="width:84.65pt;border:solid windowtext 1.0pt;border-left: none;mso-border-left-alt:solid windowtext .5pt;mso-border-alt:solid windowtext .5pt; padding:0in 5.4pt 0in 5.4pt;height:19.05pt"> <p class="MsoNormal" align="center" style="margin-bottom:0in;margin-bottom:.0001pt; text-align:center;line-height:normal"><span style=" mso-fareast-font-family:&quot;Times New Roman&quot;;mso-bidi-Times New Roman&quot;; mso-bidi-font-weight:boldfont-family:&quot;;font-size:10.0pt;color:black;">StateName<o:p></o:p></span></p> </td> </tr> </tbody></table> <p class="MsoNormal" style="tab-stops:35.45pt 87.4pt 114.4pt"><b><span style="color:black;"><o:p> </o:p></span></b></p><div class="blogger-post-footer"><script type="text/javascript"><!-- google_ad_client = "pub-5863745455635774"; /* 728x90, created 5/25/09 */ google_ad_slot = "8775121146"; google_ad_width = 728; google_ad_height = 90; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script></div>Abdul Majid Tayyabihttp://www.blogger.com/profile/06695143952223160912noreply@blogger.com0