Topics Tagged with relationship

hello all, I want to make some simple database in access that would track student information, semesters etc... I have created basic tables like: students, professors, subjects.. now I am stuck with the most important part: semesters and subjects... here is the link [Click Here](http://prntscr.com/2jafl6)where you can see database relationship diagram example (had to do it again in English lang for your convenience) Probably I did it all wrong, but here is what I thought and imagined: The idea is to have a form/subform in the main form to select or enter academic year, semester and dates in the subform …

Hello I have two tables: Students and Professors (both with usual info like name, last name, email... etc) I also need to have info about their knowledge of foreign languages, and I guess that should be a third table (languages for example) it should look like: Language_id, Language, Speaking, Writing, Listening, Now, the tricky part for me is, how do I connect Language table with Students and Professors... If I make another column foreign key Student_id.... that way I can connect with Students but how do I also connect it with Professors table? Do I also put foreign key Professor_id? …

Hi I am currently searching for entities in this case study and I am hoping to create an entity relationship diagram after I have found all the entities. So far I have managed to come up with the following entities Members Group members Organised club racing Training sessions Boat Design class ManageRace Ms Access system However I am not 100% sure wether this is enough, can you spot any more entities? Here is the case study ____________________________________________________________________________ Peak Park Sailing Club PPSC is a small sailing club located in the Pennines near Sheffield. They want to organise their event programme, …

Hello, I am a student and I was assigned to create my first entity relationship diagram and I'm kind of lost. The professor hints the paintings should be broken into a generalization hierarchy since they have so many attributes but I can only break them into two sub(entities) based on my understanding of G.H.(using the "is a" rule) Anyway I'm struggling with that and finding the weak entity(professor also hinted that there is a week entity) I attached what I have so far as ERD1.pdf (didn't establish relationship type/participation constraints yet) Am I even on the right track/have the right …

I have a search in my drupal website which searches for users registered in my website (finder module). Upon clicking any user from the user search result, it takes to that user's profile page. At the top of that page, a text 'Relationship' is displayed. Under it, a link saying 'become X's friend' (X is the drupal generated name of a user). Now 'X' is the default name generated by drupal when the user registers to the site. Users have their own real name. So i want to display the link as 'become XYZ's friend' (X's real name). Where should …

Hi! So I have two "tabs" implemented using radio buttons as shown in the code (visibility is controled by CSS). There is one control in each tab contained in the div. I hope the code is clear enough. Now, I am inside a javascript function where I have the control id (say "txtArea") and I need to find its parent tabid. Is there a way to trace the tabid (I mean the radio id) from the control id? As I see it they don't have any direct or indirect relationship as per DOM structure but there is a link - …

I use Visual Basic 2008 Database is Mysql Three tables: 1. table article fields: item number, item description, color number, month number 100 chair 2 3 2. table colors fields: color number, color description 1 red 2 blue 3. table months fields: month number, month description 1 January 2 February 3 March I want a relationship between article and table table table colors and months. I want to see in the datagridview : item number, item description, color , month 100 chair ,blue , March How do I do this in Visual Basic 2008 Thanks, Andre

hi i have a simple relationship which is shown in the link below [url]http://www.flickr.co...N06/6948010043/[/url] after doing much research i cannot find a proper way of deleting rows which are linked in all 3 tables. could someone guide me on the best way of doing this. This is the code i am using currently : [CODE] strsql = "delete * from cg_security_user_right where user_id=@field1 & right_id=@field2 " Dim objcmd As New System.Data.OleDb.OleDbCommand(strsql, acsconn) ' the oledbcommand With objcmd .Parameters.AddWithValue("@field1", TextBox1.Text) .Parameters.AddWithValue("@field2", TextBox2.Text) End With Dim result As Integer = 0 result = objcmd.ExecuteNonQuery() objcmd.Dispose() MsgBox(result & " Row Deleted") End Sub …

Looking for an answer about how I can use relations in my DB, when a link is clicked. I have the main navigation in the top of the page, the table is called:"SUBJECTS", primary key is ID. I also have a local navigation in the left side of the page. The table is called "PAGES", Primary key is ID, And then I made a SUBJECTID in the PAGES table too. I want to use the SUBJECTID in my query, to use that relation from the PAGES table, and show the relevant pages in the local navigation, after a subject is …

Hey guys i d like to pick your brains about something.. Suppose i want to create a database for storing, lets say computer stuff, parts, hardware, peripherals etc.... Which way would be better? 1 ------ Create a Basictable with all the common fields (like ProductName, Price,Guarantee....) and then create multiple other tables with each categorie's specific fields and binding those tables with the Basictable with one-to-one relationships.. 2 ------- Create just one table with all possible fields and keep Null values in the fields that are not needed for specific categories.. or maybe a third way.. ? Thanx in advance..

Hey everyone and happy new year. I'm a java beginner and I am doing my first program, a dvd rental system. I've got 4 classes with the following variables: the main class the dvd class - dvdID, title, rating, producer the cleint class - cleintID, name, surname, address the rentals class - clientID, dvd1, dvd2, dvd3 I need to know how to link the clientIDs. I am using arraylist.

Dear VB Pros, Please I want to solicit your assistance on a comprehensive database design for the following explanation: I have a customer order form comprising of: 1. the following controls will get information from the customer that will be stored in the customer table. [[B]CustomerName[/B]], [[B]CustomerAddress[/B]], [[B]City[/B]], [[B]State[/B]], [[B]DateofPurchase[/B]] 2. [[B]QtyDemandedTextBox[/B]]: this will be used to get no of qty of messages demanded by a customer. This QtyDemanded will depend on QtyAvailable (i.e, if [[B]QtyDemandedTextBox[/B]] > [[B]QtyAvailableTextBox[/B]] Then, MessageMe.Show "error") 3. [[B]MessagesListBox[/B]] - used to display list of messages in the library, and the customer can select. The selected …

When I try to design relation database using MSSQL Server 2008, I find that the MSSQL Server 2008 allow designer can create two relationships with one direction from a table to other table (for example, I have two table A an B, I can create two relationship from table A to table B with key from table A map with some field in table B). Please let me know in the real-world, do we need some relationships between two tables like that? Many Thanks, John.

Hi There, I have been scouring the web for an asnwer on something I would have thought was quite common. Any help would be greatly appreciated. I have a database which contain job ads/ I have one table "dbo.tbl_jobadvert" which contains the ad itself and another table "dbo.tbl_jobFiles" which contains the path of the document(s) uploaded in relations to the job advert ( application form, job description, etc ) dbo.tbl_jobadvert has this structure: id, jobTitle,Salary,Organisation .....and a few other fields dbo.tbl_jobFiles has this structure: filepath, filename, id, VacancyRef (which is a foreign key from the dbo.tbl_jobadvert (id)) .....and a few …

Hi, I am creating an inventory control database, and my products are using serial numbers, I am stock in desinging the tables needed . Produts in stock 50 I need to store 50 serial numbers for that product. One product number has many serial numbers. Products can be in many locations (loc 1, loc 2 ...) So I need to receive my stock enter the total quantity and its initial location and record all serial numbers. Those products will be given to technician to put in there truck for install. I need to transfert ex: 10 product xyz in his …

Hello, Now i have 3 tables which are: [CODE]CREATE TABLE IF NOT EXISTS experience( experience_id int(11) NOT NULL AUTO_INCREMENT, salarie_id int(11), consultant_id int(11), post varchar(255), entreprise_name varchar(255), start_time varchar(255), end_time varchar(255), description varchar(10000), PRIMARY KEY(experience_id) ); CREATE TABLE IF NOT EXISTS salarie( salarie_id int(11) NOT NULL AUTO_INCREMENT, name varchar(255), ..., PRIMARY KEY(salarie_id) ); CREATE TABLE IF NOT EXISTS consultant( consultant_id int(11) NOT NULL AUTO_INCREMENT, nom varchar(255), ..., PRIMARY KEY(consultant_id) ); [/CODE] The context: A salarie can have several experiences and a consultant can have several experiences. But salarie and consultant are different functions. I don't think i should combine the …