sql - Should I use Primary key here? -

-

एक उदाहरण के रूप में, मेरे पास 3 टेबल हैं: 

  स्कूल: ID int, नाम Varchar छात्र: ID int, नाम varchar StudentInSchool: StudentID int, SchoolID int

अब सवाल यह है कि मुझे एक कॉलम ID int रखना चाहिए StudentInSchool तालिका में प्राथमिक कुंजी ? यदि हां, तो क्यों?

क्या यह अनुक्रमण करने में सहायक होगा?

कोई भी मदद की सराहना की।

व्यक्तिगत तौर पर, मैं समग्र पीके ( StudentID और SchoolID ) इस तरह तैयार करता हूं। यह विशिष्टता भी सुनिश्चित करता है।

अगर, विशिष्टता की आवश्यकता नहीं है, आपको प्रत्येक पंक्ति को विशिष्ट रूप से पहचानने के लिए एक आईडी कॉलम जोड़ना होगा।

आम तौर पर, एक अलग आईडी कॉलम के अलावा ज्यादा मदद नहीं मिलेगी: बहुत कम प्रश्न (यदि कोई हो) वास्तव में इस कॉलम का उपयोग करेगा। प्रदर्शन के लिए, आप प्रत्येक कॉलम के लिए अलग-अलग अनुक्रमणिका बना सकते हैं और आप बस ठीक हो जाएंगे।


Comments

Post a Comment

Popular posts from this blog

objective c - iPhone and it's wireless area -

-
Is this a way to find other iPhones in the category of wireless areas? So I give an example. I'm staying at the airport somewhere I have an iPhone too. I and the other iPhone owners are playing the same game. Is there any way to warn me and the other player that we are close to each other? Does this work even if we are not on the same wireless network, or there is no wireless? And if there is any way to do this, can you give me some starting point? Like a link where I can learn something like this or maybe this is probably the name of this process, because I do not know how to search about this topic in Google. Thanks in advance! Can be completed with peer-to-peer discovery and connectivity you are describing Game Kit Framework Originally I thought it works only through Bluetooth, but after watching it immediately, it seems that WiFi is also supported. Hope it helps!
Read more

multithreading - Do lock objects in Java need to be static? -

-
I know in C # when you have an object that you want to use as a lock for multi-threading You must declare it stable inside a class, which class instances will be running in different threads. Is this also true for Java? Some examples online only begin declaring the last object as a lock object ... EDIT: I have a resource that I want to limit to only one thread access at a time. A class that extends the thread will be used to create many instances and will start at the same time. Thanks Depending on which context they are used they will be used. If you want a per-instance lock, go away still . If you want a per-class lock, use still in addition to actually put it the last .
Read more

java - Object vs byte[0] as lock -

-
I commented first ("why java.lang.Object is not abstract?") Stating that I have heard that one Byte [0] was slightly more efficient as a lock using a java.lang.Object . I'm sure I've read it somewhere, but I can not remember: Does anyone know that this is really true? I suspect that this requires a bit byte code compared to byte [0] / code> to object , although it was reported that the byte [0] length field requires additional storage and therefore it seems it can reject any benefit I was curious enough to test this. Source code: test for public class {public static object return object () {new object returns (); } Public stable byte [] Return back () {new byte [0]; }} Bytecode: public static java.lang.Object returnObject (); Code: 0: new # 2; // Class Java / Long / Object 3: Dip 4: Investigator # 1; // method java / lang / object "& Lt; init & gt;" :() V7: Public Static Byte [] Return Back; Code: 0: IconStage 1: Newer b...
Read more