Database kathulu- help

[Mr Mirchi]

Naaku oka column vundhi... e column lo ki values 3 primary key tables numdi vasthavi..... oka column ni 3 primary tables ki foreign key references pettichaaa

P.S: e child column lo duplicate values expected 

[Bhai]

20 minutes ago, Mr Mirchi said:

Naaku oka column vundhi... e column lo ki values 3 primary key tables numdi vasthavi..... oka column ni 3 primary tables ki foreign key references pettichaaa

P.S: e child column lo duplicate values expected 

Sample data beyyi 

[former]

TABLE1, TABLE2, TABLE3  --> 3 tables vunayi. oka comon Primary Key (DISTINCT & NOT NULL) column vunda ? Danini nevu foreign key ga cheyali anukotunavu?

 

Technical ga idi possible kadu anukonta. LTT for experts.

[Spartan]

qn correct ga adugu.. @loveindia uncle cheptadu.

[former]

LTT @loveindia

[ICANWIN]

You can i believe but clear ga adugute confirmed ga cheppachu.

[Mr Mirchi]

44 minutes ago, former said:

TABLE1, TABLE2, TABLE3  --> 3 tables vunayi. oka comon Primary Key (DISTINCT & NOT NULL) column vunda ? Danini nevu foreign key ga cheyali anukotunavu?

 

Technical ga idi possible kadu anukonta. LTT for experts.

Yaaa

 

table a , table b, table c vunnavi - primary tables

veeti primary key value tabcle D lo oke column loki vasthunnavi... so column of table D is going to have values from table a,b,c .... so e column of table D ni pyna 3 tables ki foreign key reference pettichaa ani

 

inka clear ga kavali ante

student table - student.id (id primary key column)

teacher table - teacher.id (id primary key)

colleges - colleges.id (id column is primary key)

 

transaction table - user_id column (dheeni values from 3 tables numdi) - so e column ni foreign key reference pettocha pyna 3 tables ki create table code raseppudu

[Bhai]

34 minutes ago, Mr Mirchi said:

Yaaa

 

table a , table b, table c vunnavi - primary tables

veeti primary key value tabcle D lo oke column loki vasthunnavi... so column of table D is going to have values from table a,b,c .... so e column of table D ni pyna 3 tables ki foreign key reference pettichaa ani

 

inka clear ga kavali ante

student table - student.id (id primary key column)

teacher table - teacher.id (id primary key)

colleges - colleges.id (id column is primary key)

 

transaction table - user_id column (dheeni values from 3 tables numdi) - so e column ni foreign key reference pettocha pyna 3 tables ki create table code raseppudu

pettochu.

 

kani kalagapulagam la untadi use chesevallaki.

 

Student ID, Teacher ID same unte ela identify chestavu??? -- Uniques unte. how do you identify it is a student or techer or college?? so, daniki inko identifier column add cheyyali table lo to identify teacher or student or college. Same column transaction table lo kooda undali. 

[MeetFriendz]

i dont think so .. oo table create chesi test cheyee .. simple ... 

[princeofheaven]

1 hour ago, Mr Mirchi said:

Yaaa

 

table a , table b, table c vunnavi - primary tables

veeti primary key value tabcle D lo oke column loki vasthunnavi... so column of table D is going to have values from table a,b,c .... so e column of table D ni pyna 3 tables ki foreign key reference pettichaa ani

 

inka clear ga kavali ante

student table - student.id (id primary key column)

teacher table - teacher.id (id primary key)

colleges - colleges.id (id column is primary key)

 

transaction table - user_id column (dheeni values from 3 tables numdi) - so e column ni foreign key reference pettocha pyna 3 tables ki create table code raseppudu

CHeyoochu no problem..

[Mr Mirchi]

2 hours ago, MeetFriendz said:

i dont think so .. oo table create chesi test cheyee .. simple ... 

Repu adhe cheyali office lo

 

firat time sql server meedha working... oracle lo pacakges rasi anni stored procs pettochu... sql server lo packages concept ledhu anipisthumdhi chusthe

[k2s]

Out of syllabus man