OraFAQ Forum: SQL & PL/SQL » Need School Management Schema

Home » SQL & PL/SQL » SQL & PL/SQL » Need School Management Schema (Oracle Developer, Forms 6i, Windows 8)

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

Need School Management Schema [message #615753]

Sun, 08 June 2014 23:55

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Hi Guys,

I am looking for a sample schema for a school management database.

If any of you could help me in this prospective I would really great full.

[Updated on: Sun, 08 June 2014 23:56]

Report message to a moderator

Re: Need School Management Schema [message #615754 is a reply to message #615753]

Mon, 09 June 2014 00:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Is GOOGLE broken for you?

Report message to a moderator

Re: Need School Management Schema [message #615812 is a reply to message #615754]

Mon, 09 June 2014 07:58

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Google is not helping.

Report message to a moderator

Re: Need School Management Schema [message #615813 is a reply to message #615812]

Mon, 09 June 2014 08:03

msol25
Messages: 396
Registered: June 2011

Senior Member

Please check below mentioned URL :

http://docs.oracle.com/cd/B19306_01/server.102/b25398.pdf

Report message to a moderator

Re: Need School Management Schema [message #615817 is a reply to message #615813]

Mon, 09 June 2014 09:36

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

msol25 wrote on Mon, 09 June 2014 08:03

Please check below mentioned URL :

http://docs.oracle.com/cd/B19306_01/server.102/b25398.pdf

Seriously?
The System Administration Guide 10g for IBM z/OS on System z?

Uh ... which page should the OP check to find his needed sample schema?

Report message to a moderator

Re: Need School Management Schema [message #615818 is a reply to message #615817]

Mon, 09 June 2014 10:27

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

Moreover OP wants it in Oracle forms as mentioned in topic title.

Report message to a moderator

Re: Need School Management Schema [message #615825 is a reply to message #615818]

Mon, 09 June 2014 12:32

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

Senior Member
Account Moderator

I didn't know that there are special schemas designed for Forms. How do they differ from non-Forms schemas?

Report message to a moderator

Re: Need School Management Schema [message #615827 is a reply to message #615825]

Mon, 09 June 2014 12:48

Lalit Kumar B
Messages: 3174
Registered: May 2013
Location: World Wide on the Web

Senior Member

There are specific/special documentations and illustrations/demonstrations for Oracle forms. If not, why do we have SPECIFIC forums for Oracle forms here?

Note : In my previous comment I just echoed Ed, that the server administration link is not going to help OP.

Report message to a moderator

Re: Need School Management Schema [message #615836 is a reply to message #615827]

Mon, 09 June 2014 17:15

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

Senior Member
Account Moderator

My impression is that you didn't answer my question (but you managed to post two consecutive useless messages). Note that this is just my impression.

Report message to a moderator

Re: Need School Management Schema [message #615837 is a reply to message #615836]

Mon, 09 June 2014 17:26

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> If not, why do we have SPECIFIC forums for Oracle forms here?
Forms & Reports is a separate software package that provides capability to produce a User Interface to access data within Oracle database.
Tables can & should exist 100% independent of any User Interface that may access the tables.

Report message to a moderator

Re: Need School Management Schema [message #615841 is a reply to message #615837]

Mon, 09 June 2014 18:19

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

+1
Too often people design their tables based on a particular form or report instead of the fundamentals of data relationships

Report message to a moderator

Re: Need School Management Schema [message #615847 is a reply to message #615841]

Mon, 09 June 2014 23:39

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Guys...! I want to know ER design for school management system for fee and other payments related to students only.

I would be really thankful to you all if any one of you can give his/her suggestions.

Report message to a moderator

Re: Need School Management Schema [message #615848 is a reply to message #615847]

Tue, 10 June 2014 00:11

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

Senior Member
Account Moderator

A suggestion? Here's one: do you know processes which are involved in school management system?

If not, quit what you are doing now as you are doing it in vain. Even if someone provides sample schema, what will you do with it? A bunch of tables that store some sort of information, but you don't know what to do with it.
If yes, what prevents you from creating your own schema? Design it! Doing so, you'll exactly know what is what and what it is used for. It doesn't have to be perfect, but will teach you a lot

Finally, once you know the processes and design data model, start with creating forms and reports (as that's what you are interested in). If you do the first part of the job correctly, Forms' Wizards will do a lot of job for you (create master-detail relations, set certain item properties to correct values (instead of default ones), create necessary triggers etc. and you'll actually enjoy what you are doing (instead of crying in pain).

Report message to a moderator

Re: Need School Management Schema [message #615861 is a reply to message #615847]

Tue, 10 June 2014 06:07

oralover2006
Messages: 144
Registered: January 2010
Location: India

Senior Member

azamkhan wrote on Tue, 10 June 2014 10:09

Guys...! I want to know ER design for school management system for fee and other payments related to students only.

I would be really thankful to you all if any one of you can give his/her suggestions.

try Google Image and search entering following: " database schema for school management system " ( without quotes )
hope, this may help.

Report message to a moderator

Re: Need School Management Schema [message #616032 is a reply to message #615847]

Wed, 11 June 2014 15:14

LKBrwn_DBA
Messages: 487
Registered: July 2003
Location: WPB, FL

Senior Member

Try this one: School Management System

[Updated on: Wed, 11 June 2014 15:15] by Moderator

Report message to a moderator

Re: Need School Management Schema [message #616033 is a reply to message #616032]

Wed, 11 June 2014 15:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

> (Oracle Developer, Forms 6i, Windows Cool

Nice unsupported combination of software.
Why are folks willing to use current OS, but cling to obsoleted & unsupported Oracle software from the previous Century?

Report message to a moderator

Re: Need School Management Schema [message #616038 is a reply to message #616033]

Wed, 11 June 2014 17:09

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

Senior Member
Account Moderator

My guess: because client-server application is simpler to run when compared to web applications that require complex IAS setup and configuration.

Report message to a moderator

Re: Need School Management Schema [message #616044 is a reply to message #616032]

Wed, 11 June 2014 23:50

azamkhan
Messages: 557
Registered: August 2005

Senior Member

LKBrwn_DBA wrote on Wed, 11 June 2014 15:14

Try this one: School Management System

Dear LKBrwn_DBA thanks for the useful link. I really appreciate your effect in this context. And LittleFoot you should also consider reply in the manner. What you did was not helpful at all.

Once again thankyou LKBrwn_DBA

Report message to a moderator

Re: Need School Management Schema [message #616045 is a reply to message #616044]

Thu, 12 June 2014 00:11

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

Senior Member
Account Moderator

What exactly are you referring to (as I posted more than a single message in this topic)?

Report message to a moderator

Previous Topic:	Query help with CUBE function
Next Topic:	Purpose of ODCIAggregateMerge

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 06:12:28 CDT 2024