4m7u1
BAN USER- 1 Answer Data Structures
Real life applications of Post and Prefix evaluation?
- 4m7u1 September 12, 2013| Flag | PURGE - 11 Answers DATABASE DESIGN
Suppose I have tables student(sid,name,cid) and course(cid,cname)
- 4m7u1 August 29, 2013
how do i make sure that a student can take more than one course without redundant rows (like
sid name cid
101 xyz 02,
101 xyz 03,
101 xyz 04...ie it would be redundant if each student takes a large number of courses).| Flag | PURGE - 4 Answers ORACLE INTERVIEW QUESTIONS
Hey everyone !
- 4m7u1 July 07, 2013
Actually, Oracle is coming to recruit students from our college this year. So can anyone please tell me the important concepts asked by them? I mean, which areas do they question in mostly, like ds,networks,dbms..etc etc.. your replies would be very very helpful to me. Thank you :) !| Flag | PURGE
surely, the new table stores sid,cid right.
suppose there is a student with sid-01 and he takes courses c01,c02,c03,c04,c05,c06,c07 and c08.
then we need to have rows and table as
sid cid
01-c01
01-c02
01-c03
.......
01-c08.
what i meant to ask is, can this redundancy be removed in any way?
nice. thanks. but is there anyway we could further optimize it , i mean without having to store redundant data( like if a student takes 20 courses then we need to store the students name 20 times against the appropriate courses).
P.S: I was asked this in Capital IQ, when i gave answer same as yours he asked me remove redundancy.
Plz Reply :(
- 4m7u1 September 29, 2013