Home » Other » Training & Certification » Designing (9i)
Designing [message #379164] Mon, 05 January 2009 03:39 Go to next message
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
Re: Designing [message #379180 is a reply to message #379164] Mon, 05 January 2009 05:01 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Homework a bit tricky is it?
Re: Designing [message #379192 is a reply to message #379164] Mon, 05 January 2009 05:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Designing [message #379237 is a reply to message #379192] Mon, 05 January 2009 11:50 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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.
Re: Designing [message #379242 is a reply to message #379237] Mon, 05 January 2009 11:57 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ooops! Understood he wanted seomkind of query.

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

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


Current Time: Thu Mar 28 12:42:06 CDT 2024