OraFAQ Forum: Training & Certification

Home » Other » Training & Certification » Designing (9i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Designing [message #379164]

Mon, 05 January 2009 03:39

rajput.anshu
Messages: 45
Registered: October 2008
Location: Bangalore

Member

Suppose in a class there are 50 students........test is held 3 times in a year and there are 5 subjects for each students.......for that how many we want to create and what rows it contain

Report message to a moderator

Re: Designing [message #379180 is a reply to message #379164]

Mon, 05 January 2009 05:01

JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...

Senior Member

Homework a bit tricky is it?

Report message to a moderator

Re: Designing [message #379192 is a reply to message #379164]

Mon, 05 January 2009 05:35

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

As I said in your previous post your questions in Homework forum.

In addtion, post a Test case: create table and insert statements along with the result you want with these data.
Use SQL*Plus and copy and paste what you already tried.

Regards
Michel

Report message to a moderator

Re: Designing [message #379237 is a reply to message #379192]

Mon, 05 January 2009 11:50

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Michel

post a Test case: create table and insert statements ...

I'm afraid that @rajput.anshu wants exactly that - someone to provide CREATE TABLE statements.

Report message to a moderator

Re: Designing [message #379242 is a reply to message #379237]

Mon, 05 January 2009 11:57

Michel Cadot
Messages: 68775
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Ooops! Understood he wanted seomkind of query.

@rajput.anshu, have a look at Normalization wiki page.

Regards
Michel

Report message to a moderator

Previous Topic:	download free ocp -oracle exams and dumps
Next Topic:	what is the difference between 9i and 9g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Mar 28 04:19:34 CDT 2026