Compiled Messages: ------------------------------------------------------------ Message no. 7529 Posted by Kelli Lemon (kmlemon) on Wednesday, April 19, 2006 12:13am Subject: Final Project On the final project within the SHIPMENT table, should SHIPMENT_ID be SHIP_ID since it is the foreign key and identified as SHIP_ID within the SHIP_LINE table or does it matter? Thanks ------------------------------------------------------------ Message no. 7533[Branch from no. 7529] Posted by Muhammad Latif (mlatif) on Wednesday, April 19, 2006 12:35am Subject: Re: Final Project Hey Kelli: The difference in column name does not matter as long as their data type is same, and when creating the foreign key you can reference the primary key in SHIPMENT table. Hope it helps. Arsal ------------------------------------------------------------ Message no. 7534[Branch from no. 7533] Posted by Harold Harris (hjharris2) on Wednesday, April 19, 2006 2:05am Subject: Re: Final Project Kelli, I agree with Arsal in that the SHIP_ID in the SHIP_LINE table references the SHIPMENT_ID in the SHIPMENT table. The heading names make no difference because both columns use NUMBER(3) as their data types. HH ------------------------------------------------------------ Message no. 7535[Branch from no. 7529] Posted by Waseem Manzoor (wmanzoor) on Wednesday, April 19, 2006 11:00am Subject: Re: Final Project Yah Kelli Arsal is right. Name does not matter. Waseem Manzoor ------------------------------------------------------------ Message no. 7539[Branch from no. 7529] Posted by Imran Pathan (ipathan) on Wednesday, April 19, 2006 11:47am Subject: Re: Final Project Hi kelli, The name does not matter. Arsal is right Imran ------------------------------------------------------------ Message no. 7542[Branch from no. 7529] Posted by Antoinette Lockett (arlockett) on Wednesday, April 19, 2006 12:09pm Subject: Re: Final Project Kelli, I understand sometime you just want to make sure that everything is ok, so that you won't run into in problems later. ------------------------------------------------------------ Message no. 7544 Posted by Rhonda Nichols (renichols2) on Wednesday, April 19, 2006 1:44pm Subject: Interesting Math ROMANCE MATHEMATICS Smart man + smart woman = romance Smart man + dumb woman = affair Dumb man + smart woman = marriage Dumb man + dumb woman = pregnancy OFFICE ARITHMETIC Smart boss + smart employee = profit Smart boss + dumb employee = production Dumb boss + smart employee = promotion Dumb boss + dumb employee = overtime SHOPPING MATH A man will pay $20 for a $10 item he needs. A woman will pay $10 for a $20 item that she doesn't need. GENERAL EQUATIONS & STATISTICS A woman worries about the future until she gets a husband. A man never worries about the future until he gets a wife. A successful man is one who makes more money than his wife can spend. A successful woman is one who can find such a man. HAPPINESS To be happy with a man, you must understand him a lot and love him a little. To be happy with a woman, you must love her a lot and not try to understand her at all. LONGEVITY Married men live longer than single men do, but married men are a lot more willing to die. PROPENSITY TO CHANGE A woman marries a man expecting he will change, but he doesn't. A man marries a woman expecting that she won't change, and she does. DISCUSSION TECHNIQUE A woman has the last word in any argument. Anything a man says after that is the beginning of a new argument. HOW TO STOP PEOPLE FROM BUGGING YOU ABOUT GETTING MARRIED Old aunts used to come up to me at weddings, poking me in the ribs and cackling, telling me, "You're next." They stopped after I started doing the same thing to them at funerals. ------------------------------------------------------------ Message no. 7545[Branch from no. 7542] Posted by Venkat Munagala (vrmunagala) on Wednesday, April 19, 2006 2:14pm Subject: Re: Final Project I too agree with u Arsal. ------------------------------------------------------------ Message no. 7546[Branch from no. 7529] Posted by Kelli Lemon (kmlemon) on Wednesday, April 19, 2006 2:47pm Subject: Re: Final Project Thanks to you all, I was just making sure ------------------------------------------------------------ Message no. 7547[Branch from no. 7542] Posted by Bikash Adhikari (badhikari) on Wednesday, April 19, 2006 4:12pm Subject: Re: Final Project That is true , better ask then be sorry for it later!!!! And yes i also do not think that the name will matter. Thank you. BIkash PS: It was nice seeing u , FINALLY, this semester....... ------------------------------------------------------------ Message no. 7548[Branch from no. 7544] Posted by Bikash Adhikari (badhikari) on Wednesday, April 19, 2006 4:16pm Subject: Re: Interesting Math Why do i this feeling that most of these statements are true...of women, love and relationships....!!!! Thank you Rhonda for sharing... BIkash ------------------------------------------------------------ Message no. 7549[Branch from no. 7544] Posted by Gnaneshwar Bukka (gbukka) on Wednesday, April 19, 2006 10:07pm Subject: Re: Interesting Math Hey Rhonda.....great stuff...the last one was excellent....had a hearty laught..... Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 7550 Posted by Rhonda Nichols (renichols2) on Thursday, April 20, 2006 8:34am Subject: Final Project ? Is it me or does the table COLOR in the final project serve no purpose? It just seems since the color is stored in INVENTORY table and the COLOR table has no other information that it is a useless table. Any other opinions? ------------------------------------------------------------ Message no. 7551[Branch from no. 7550] Posted by Krishnamurth Ashwini (kashwini) on Thursday, April 20, 2006 9:54am Subject: Re: Final Project ? Phonda, As far as I know..I don't think we can neglect the COLOR table. This table stores the standard colors that is being offered. The INVENTORY table is basically a table that is showing the details of items that is purchased. The COLOR column in the INVENTORY table has just a few of those colors and not all that is listed in the COLOR table. In other words..COLOR in INVENTORY table is a foreign key referencing the COLOR table. aSH ------------------------------------------------------------ Message no. 7552[Branch from no. 7551] Posted by Krishnamurth Ashwini (kashwini) on Thursday, April 20, 2006 9:57am Subject: Re: Final Project ? Rhonda, Very sorry for misspelling you name in the previous posting. Ash ------------------------------------------------------------ Message no. 7553[Branch from no. 7551] Posted by Rohini Shrestha (rshrestha) on Thursday, April 20, 2006 11:21am Subject: Re: Final Project ? Thankx Ash for the information. Even I was confused with this. Rohini ------------------------------------------------------------ Message no. 7554[Branch from no. 7552] Posted by Rhonda Nichols (renichols2) on Thursday, April 20, 2006 11:22am Subject: Re: Final Project ? I agree that we need it for this project (only because we are instructed to) BUT I don't agree that we NEED it in a business sense. In all practicality, what we have in COLOR we can have in INVENTORY (an already do- except for a few colors that can be added to the orders as needed). To me it doesn't make sense to have a PK/FK in this situation when the data is the same. Usually you have a PK/FK scenario when you use an ID to reference other data instead of putting the primary data within the table. Do you understand what I am getting at? ------------------------------------------------------------ Message no. 7555[Branch from no. 7554] Posted by Krishnamurth Ashwini (kashwini) on Thursday, April 20, 2006 1:19pm Subject: Re: Final Project ? Rhonda, Ok...now let us consider a real case scenario...Customer Puala is interested in "Women's fleece pullover" which is being offered in different colors(listed in the COLOR table). Assume she is shopping online....when she click's on the color selection part of the transaction for the pullover, the database displays the list of colors that are being offered. She chooses the color of her choice and when the order is finally processed, the INVENTORY table gets updated automatically which essentially shows the QOH (quantity on hand) along with the details of the items, price and color. As you say..." what we have in COLOR we can have in INVENTORY (an already do- except for a few colors that can be added to the orders as needed)." How can the inventory table show all the color choices, when it is supposed to show the ones that are just remaining(QOH). Another example to clarify... if there is a color say MAROON that you plan to stock in Spring 2007, you should be able to make an entry in the COLOR table as soon as you know that this is going to be in your inventory in the future. This information cannot be stored in the inventory table since there is no item associated with it. Likewise, this COLOR table can grow to indicate all items that were in stock in the past as well as those that will be in the future. It is a BIG burden for somebody to check EVERYTIME whether a color already exists in the inventory table before adding a record there. Hope I'm not confusing you more.... Ash ------------------------------------------------------------ Message no. 7556[Branch from no. 7555] Posted by Rhonda Nichols (renichols2) on Thursday, April 20, 2006 1:50pm Subject: Re: Final Project ? Ok....give me a bit to absorb this. (I'm a little slow) ------------------------------------------------------------ Message no. 7557[Branch from no. 7555] Posted by Rhonda Nichols (renichols2) on Thursday, April 20, 2006 2:08pm Subject: Re: Final Project ? OK...I feel like we are having a big debate here....but in fun. I want to understand so thanks for talking (typing) this out with me. ...first example. The inventory table doesn't just show the ones remaining (>0) it can show 0 for no QOH (and does). I would also think it could possibly show a negative number for back orders (if allowed). Also you are not going to have a color without an entry in the inventory table so here again, color table no necessary. There should always be an entry in the inventory table for all products which includes their color. If you had a one to many relationship (the one being the pullover with the many being the colors) I would understand that --but that is not the case here. There is an entry for each pullover with each color with each size in the inventory table. ...second example. Why would you want a color that has no corresponding inventory item? Along the lines of could-of, should-of, would-of--why would you add a color until you know for sure there is an inventory item to correspond? You might add Maroon thinking that there would be an item to correspond but maybe you never receive that item. Now you have an entry in a table that is unused and unnecessary consuming time (maintaining) and space. your turn.... ------------------------------------------------------------ Message no. 7558[Branch from no. 7529] Posted by Sagun Piya (srpiya2) on Thursday, April 20, 2006 4:16pm Subject: Re: Final Project yeah u can use it, name does not matter Sagun ------------------------------------------------------------ Message no. 7561[Branch from no. 7553] Posted by Rohini Shrestha (rshrestha) on Thursday, April 20, 2006 4:53pm Subject: Re: Final Project ? Great discussions ladies and I think both of you are right. However, I found this information in our course book, and this might help to understand the need of COLOR table. The COLOR field of the INVENTORY table is a foreign key which refers to the COLOR table. The COLOR table is a lookup table. A LOOKUP TABLE is also sometimes called a PICK LIST. It contains a list of legal values for a field in another table. The example of that the book has given about how it works is as follow: If the user want to have LIGHT GREY color, and but misspelled it as LIGHT GRAY, a query looking for this item will not find instances of this item. Thus, a user enters the value of COLOR in the INVENTORY table by selecting a color from a PICK LIST that displays values from the COLOR table. Thus, the user need not type the color directly, which reduces errors. Small lists that are unlikely to change over time might be coded directly into an application, but lists with many items that might be added to over time are usually stored in a separate LOOKUP table. I hope I am not confusing you even more. If you want to refer to the book, the page number is 21. The whole case study starts from page number 17 for detail information. Rohini ------------------------------------------------------------ Message no. 7562[Branch from no. 7561] Posted by Krishnamurth Ashwini (kashwini) on Thursday, April 20, 2006 6:15pm Subject: Re: Final Project ? Great...It would have been much easier if we knew the solution was right there in the book. Thanks Rohini :- ) But, I think of it in a positive way though. If we knew the answer we would have missed the opportunity to think and critically analyze this issue in detail. Atleast I did scratch my head for a while today:-) Rhonda, Sorry this debate had to end. But thanks for the great discussion. I wish we could have had more of such discussions. Unfortunately, this will be our last discussion for this class. Have a great week, Ash ------------------------------------------------------------ Message no. 7565[Branch from no. 7562] Posted by Rohini Shrestha (rshrestha) on Thursday, April 20, 2006 9:19pm Subject: Re: Final Project ? I’m sorry that I interrupted this discussion. I thought we were supposed to post the correct answer, whether be it from the book or elsewhere. I did not realize that we were supposed to give some time for people to brainstorm. I would like to request our instructor to take my 10 points off. Ash, to be very honest, I would like to thank you for all the previous comments and the help you have provided…but the discussions seem to be getting more and more unhealthy each week. Rohini ------------------------------------------------------------ Message no. 7566[Branch from no. 7562] Posted by Rhonda Nichols (renichols2) on Thursday, April 20, 2006 9:21pm Subject: Re: Final Project ? All good things must come to an end...and so must this conversation. Rohini---thanks for the clarification. Who would have thought to look in the book! (I shouldn't focus so much on the internet for answers) Ash---thanks for the challenging discussion. Maybe we will meet again! -RHonda ------------------------------------------------------------ Message no. 7568[Branch from no. 7565] Posted by Krishnamurth Ashwini (kashwini) on Thursday, April 20, 2006 10:27pm Subject: Re: Final Project ? Rohini, What's the matter....what's wrong..who said you interrupted our discussion. I was actually thanking you for helping us find a solution. I'm sorry if you got offended by my sincere appreciation. My mistake. Very sorry to know that you found our discussion unhealty. Ash ------------------------------------------------------------ Message no. 7569[Branch from no. 7558] Posted by Abhash Bhandary (abhandary) on Thursday, April 20, 2006 10:28pm Subject: Re: Final Project Ya i think the same .....i dont think the name should actually matter Abhash ------------------------------------------------------------ Message no. 7570[Branch from no. 7549] Posted by Abhash Bhandary (abhandary) on Thursday, April 20, 2006 10:29pm Subject: Re: Interesting Math really good Rhonda...thanx for sharing Abhash ------------------------------------------------------------ Message no. 7571[Branch from no. 7562] Posted by Abhash Bhandary (abhandary) on Thursday, April 20, 2006 10:42pm Subject: Re: Final Project ? I think discussions are good way to find answers and if the answer comes from the book or the internet should not matter at all......and i dont understand why you ladies are saying the discussion is over ...c'mon we still have one more week to go and we can learn some more from it as well..... And Ash ...i dont think we know answers from before...we do have to scratch our head sometime ...tear the book some other times .......its our luck that sometimes its me on the first or some time its you......well this is a discussion and it should not matter ...right??? We should take it as fun ...and go together on the run ...it should be focused more on fun and learning .....and not exactly on some grade or bonuses ...... What do you guys think so???? Abhash ------------------------------------------------------------ Message no. 7572[Branch from no. 7571] Posted by Krishnamurth Ashwini (kashwini) on Thursday, April 20, 2006 10:54pm Subject: Re: Final Project ? Guys, I don't even know what you all are talking about. I would really appreciate it if someone can tell me what you interpreted out of my mail (something that offended others). Abhash I agree with you. I too enjoy the discussions and care to learn as much as possible about the subject. Ash ------------------------------------------------------------ Message no. 7573[Branch from no. 7570] Posted by Venkat Munagala (vrmunagala) on Thursday, April 20, 2006 11:08pm Subject: Re: Interesting Math Good one Rhonda. Thanks for posting such interesting things. ------------------------------------------------------------ Message no. 7576[Branch from no. 7544] Posted by Sagun Piya (srpiya2) on Friday, April 21, 2006 1:33am Subject: Re: Interesting Math good one Rhonda, Sagun ------------------------------------------------------------ Message no. 7581[Branch from no. 7529] Posted by Alex Auffenorde (aaauffenorde) on Friday, April 21, 2006 8:47am Subject: Re: Final Project Kelli, Unlike the others, I believe that column names do matter and not just the data type. The column names between tables do not have to be exactly the same, but should reflect the link those tables have. In our instance we have SHIPMENT_ID and SHIP_ID, not the same but similar. We can look at these names and see the link between the SHIPMENT and SHIP_LINE tables. If for example SHIPMENT_ID were used for the SHIPMENT table and STU_ID were used in the SHIP_LINE table, there would be confusion. We could not look at these column names and see they serve as the link between these tables, even if the datatypes were exactly the same. Hope this helps, Alex ------------------------------------------------------------ Message no. 7582[Branch from no. 7550] Posted by Alex Auffenorde (aaauffenorde) on Friday, April 21, 2006 9:00am Subject: Re: Final Project ? Rhonda, What the COLOR table should have is a "COLOR_ID" to be used as PK. Then in the INVENTORY table, there should a FK called "COLOR" or "COLOR_ID" to link back to the COLOR table. This would save on space, because the INVENTORY table would not have to waste space accounting for the longest (in length) color from the COLOR table. It would only have to account for a 3 digit code. I agree with you, this table without a numbered PK is rather worthless. -Alex ------------------------------------------------------------ Message no. 7583[Branch from no. 7582] Posted by Harold Harris (hjharris2) on Friday, April 21, 2006 9:21am Subject: Re: Final Project ? Good point Alex. HH ------------------------------------------------------------ Message no. 7589[Branch from no. 7582] Posted by Rhonda Nichols (renichols2) on Friday, April 21, 2006 1:31pm Subject: Re: Final Project ? Alex, YES!!! That is what I was trying to say. It is worthless (to me) "as is" but to have a code or id to link the color to another table would make more sense. I can see know what Ash was saying but still feel there is a better way to use it. We all have our own opinions and I bet each one of us would set it up different. What I am struggling with now is to whether still use the COLOR as a PK and the COLOR in inventory as FK. I still don't think it makes sense. -Rhonda ------------------------------------------------------------ Message no. 7590[Branch from no. 7544] Posted by Waseem Manzoor (wmanzoor) on Friday, April 21, 2006 10:45pm Subject: Re: Interesting Math Good stuff Rhonda :) ------------------------------------------------------------ Message no. 7596[Branch from no. 7581] Posted by Gwendolyn Mobley (gdmobley) on Saturday, April 22, 2006 3:38am Subject: Re: Final Project Alex, never looked at table names from that prespective. thanks. Gwen ------------------------------------------------------------ Message no. 7597[Branch from no. 7544] Posted by Gwendolyn Mobley (gdmobley) on Saturday, April 22, 2006 3:40am Subject: Re: Interesting Math nice one Rhonda Gwen ------------------------------------------------------------ Message no. 7599[Branch from no. 7561] Posted by Gwendolyn Mobley (gdmobley) on Saturday, April 22, 2006 3:44am Subject: Re: Final Project ? Rohini, thanks..this info made things clearer. Gwen ------------------------------------------------------------ Message no. 7600[Branch from no. 7582] Posted by Gwendolyn Mobley (gdmobley) on Saturday, April 22, 2006 3:48am Subject: Re: Final Project ? Alex, good point. Gwen ------------------------------------------------------------ Message no. 7601[Branch from no. 7544] Posted by Imran Pathan (ipathan) on Saturday, April 22, 2006 2:01pm Subject: Re: Interesting Math Excellent math Rhonda Imran ------------------------------------------------------------ Message no. 7604[Branch from no. 7601] Posted by Muhammad Latif (mlatif) on Saturday, April 22, 2006 2:53pm Subject: Re: Interesting Math Hey Rhonda: Awesome math :) Arsal ------------------------------------------------------------ Message no. 7605[Branch from no. 7600] Posted by Muhammad Latif (mlatif) on Saturday, April 22, 2006 2:58pm Subject: Re: Final Project ? Hey Alex: Good job! Arsal ------------------------------------------------------------ Message no. 7609[Branch from no. 7581] Posted by Gnaneshwar Bukka (gbukka) on Saturday, April 22, 2006 5:17pm Subject: Re: Final Project Good info alex....thank you..... Gnaneshwar Bukka. ------------------------------------------------------------ Message no. 7615[Branch from no. 7581] Posted by Imran Pathan (ipathan) on Saturday, April 22, 2006 9:54pm Subject: Re: Final Project Thanks for the information Imran ------------------------------------------------------------ Message no. 7616[Branch from no. 7582] Posted by Imran Pathan (ipathan) on Saturday, April 22, 2006 9:57pm Subject: Re: Final Project ? Good information Alex Imran ------------------------------------------------------------ Message no. 7618[Branch from no. 7555] Posted by Imran Pathan (ipathan) on Saturday, April 22, 2006 10:07pm Subject: Re: Final Project ? Inventory table shows the items purchased, this table automatically gets updated. ------------------------------------------------------------ Message no. 7619[Branch from no. 7544] Posted by Swarna Bangaru (sbangaru) on Saturday, April 22, 2006 10:23pm Subject: Re: Interesting Math Really is interesting, thanks for sharing. ------------------------------------------------------------ Message no. 7620[Branch from no. 7582] Posted by Krupa Kandavalli (kkandavalli) on Saturday, April 22, 2006 10:26pm Subject: Re: Final Project ? Good points Alex, helping while doing the project. Thanks Alex. ------------------------------------------------------------ Message no. 7623[Branch from no. 7550] Posted by Venkat Munagala (vrmunagala) on Saturday, April 22, 2006 10:38pm Subject: Re: Final Project ? Thanks for the information. It was really helpful. ------------------------------------------------------------ Message no. 7628[Branch from no. 7581] Posted by Kelsey Pooley (kjpooley) on Saturday, April 22, 2006 11:56pm Subject: Re: Final Project Alex sounds right to me. I remember in one of the earlier projects, a number of us got points off because we made the wrong comparisons (remember "apples to oranges"?). When the names are so similar, it becomes tricky to keep them all straight. The column names are important. ------------------------------------------------------------ Message no. 7634[Branch from no. 7628] Posted by Phanindra Maddhi (pmaddhi) on Sunday, April 23, 2006 11:06pm Subject: Re: Final Project Yaa i agree with u all ------------------------------------------------------------ Message no. 7635[Branch from no. 7544] Posted by Phanindra Maddhi (pmaddhi) on Sunday, April 23, 2006 11:08pm Subject: Re: Interesting Math good maths.. i think i need to improve in some areas....hee...hee ------------------------------------------------------------ Message no. 7636[Branch from no. 7550] Posted by Phanindra Maddhi (pmaddhi) on Sunday, April 23, 2006 11:08pm Subject: Re: Final Project ? Thanks u ------------------------------------------------------------