 |  |  |  |  |  |  |  |
problem with database
Please support our ASP.NET advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
 |
hai friends,,
i am new for the project development.
i am developing a application like naukri/monster.
i created the tables like employeename,phonenumber,skills,technology,role,work experience,location like that i am taking attributes.
my boss said " to create the database like each table for name and first name,lst name like that..
please send me how to do that ..
i am getting so confused on that..
please help me ASAP
i am new for the project development.
i am developing a application like naukri/monster.
i created the tables like employeename,phonenumber,skills,technology,role,work experience,location like that i am taking attributes.
my boss said " to create the database like each table for name and first name,lst name like that..
please send me how to do that ..
i am getting so confused on that..
please help me ASAP
•
•
Join Date: Mar 2008
Posts: 269
Reputation: 
Solved Threads: 19
Posting Whiz in Training
Ok so U have 2 tables and u want to connect the tables to each other, what u can do is to have a primary key and the foreign key in the master table, that means, on Job table u can have a skillId as a foreign key and then on Skills Table u gona have SkillId as a primary then u will know what Job is associated with what skill
so one more question which Database ur using, MS Access, SQL, Oracle or what?
Then the code will merely depend on which Technology ur using for ur database
so one more question which Database ur using, MS Access, SQL, Oracle or what?
Then the code will merely depend on which Technology ur using for ur database
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
•
•
Join Date: Mar 2008
Posts: 269
Reputation:
Solved Threads: 19
Posting Whiz in Training
Yah sure u can
The code to connect 2 tables will be something look like this
example
Sample code
on the above code u are changing the job table by adding a foreign key which is originated on Skill table
The code to connect 2 tables will be something look like this
example
alter table tableName Add Constraint anyLegalvariable Foreign Key(ColumnName that u want to be a foreign as it is from the table) References Name of the table u are getting a key from(Column name as it is from the table)
Sample code
alter table Job Add CONSTRAINT fk_Skill_Id FOREIGN KEY (SkillID) REFERENCES Skills (SkillID)
on the above code u are changing the job table by adding a foreign key which is originated on Skill table
Some people get so rich they lose all respect for humanity. That's how rich I want to be.
|
Similar Threads
- database questions I have (Database Design)
- Problem with database connection (JSP)
- Display image from a database get me ascii codes (ASP)
- Pls help me regarding to access database in vb6 (Visual Basic 4 / 5 / 6)
- Problem with VB.NET and MS Access (VB.NET)
- Problem With database Connectivity (ASP.NET)
- problem after migration (MySQL)
Other Threads in the ASP.NET Forum
- Previous Thread: Online Payment Options
- Next Thread: C# server.transfer to save form data and send email
Views: 615 | Replies: 4
| Thread Tools | Search this Thread |
Latest ASP.NET Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for ASP.NET
.net 2.0 3.5 activexcontrol advice ajax anathor asp asp.net bc30451 bottomasp.net browser businesslogiclayer button c# c#gridviewcolumn checkbox child click commonfunctions compatible confirmationcodegeneration content contenttype courier css database datagrid datagridview datagridviewcheckbox datalist deadlock development dgv dropdown dropdownmenu edit expose feedback flash flv folder form formatdecimal forms formview google grid gridview homeedition hosting identity iframe iis index javascript jquery list menu migration mono mssql multistepregistration nameisnotdeclared object objects order problem ratings refer rotatepage save search security serializesmo.table session silverlight smartcard sql sqlserver2005 suse textbox tracking typeof unauthorized update validation vb vb.net video view virtualdirectory vista visual-studio visualstudio web webarchitecture webdevelopemnt xml youareanotmemberofthedebuggerusers
