Home » SQL & PL/SQL » SQL & PL/SQL » Need School Management Schema (Oracle Developer, Forms 6i, Windows 8)
Need School Management Schema [message #615753] Sun, 08 June 2014 23:55 Go to next message
azamkhan
Messages: 492
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 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
Senior Member
Is GOOGLE broken for you?
Re: Need School Management Schema [message #615812 is a reply to message #615754] Mon, 09 June 2014 07:58 Go to previous messageGo to next message
azamkhan
Messages: 492
Registered: August 2005
Senior Member
Google is not helping.
Re: Need School Management Schema [message #615813 is a reply to message #615812] Mon, 09 June 2014 08:03 Go to previous messageGo to next message
msol25
Messages: 234
Registered: June 2011
Location: Mumbai
Senior Member
Please check below mentioned URL :

http://docs.oracle.com/cd/B19306_01/server.102/b25398.pdf
Re: Need School Management Schema [message #615817 is a reply to message #615813] Mon, 09 June 2014 09:36 Go to previous messageGo to next message
EdStevens
Messages: 295
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?
Re: Need School Management Schema [message #615818 is a reply to message #615817] Mon, 09 June 2014 10:27 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2411
Registered: May 2013
Location: World Wide on the Web
Senior Member
Moreover OP wants it in Oracle forms as mentioned in topic title.
Re: Need School Management Schema [message #615825 is a reply to message #615818] Mon, 09 June 2014 12:32 Go to previous messageGo to next message
Littlefoot
Messages: 19653
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?
Re: Need School Management Schema [message #615827 is a reply to message #615825] Mon, 09 June 2014 12:48 Go to previous messageGo to next message
Lalit Kumar B
Messages: 2411
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.
Re: Need School Management Schema [message #615836 is a reply to message #615827] Mon, 09 June 2014 17:15 Go to previous messageGo to next message
Littlefoot
Messages: 19653
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.
Re: Need School Management Schema [message #615837 is a reply to message #615836] Mon, 09 June 2014 17:26 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
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.
Re: Need School Management Schema [message #615841 is a reply to message #615837] Mon, 09 June 2014 18:19 Go to previous messageGo to next message
EdStevens
Messages: 295
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
Re: Need School Management Schema [message #615847 is a reply to message #615841] Mon, 09 June 2014 23:39 Go to previous messageGo to next message
azamkhan
Messages: 492
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.
Re: Need School Management Schema [message #615848 is a reply to message #615847] Tue, 10 June 2014 00:11 Go to previous messageGo to next message
Littlefoot
Messages: 19653
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).
Re: Need School Management Schema [message #615861 is a reply to message #615847] Tue, 10 June 2014 06:07 Go to previous messageGo to next message
oralover2006
Messages: 118
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.

Re: Need School Management Schema [message #616032 is a reply to message #615847] Wed, 11 June 2014 15:14 Go to previous messageGo to next message
LKBrwn_DBA
Messages: 439
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 Go to previous messageGo to next message
BlackSwan
Messages: 22845
Registered: January 2009
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?
Re: Need School Management Schema [message #616038 is a reply to message #616033] Wed, 11 June 2014 17:09 Go to previous messageGo to next message
Littlefoot
Messages: 19653
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.
Re: Need School Management Schema [message #616044 is a reply to message #616032] Wed, 11 June 2014 23:50 Go to previous messageGo to next message
azamkhan
Messages: 492
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
Re: Need School Management Schema [message #616045 is a reply to message #616044] Thu, 12 June 2014 00:11 Go to previous message
Littlefoot
Messages: 19653
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)?
Previous Topic: Query help with CUBE function
Next Topic: Purpose of ODCIAggregateMerge
Goto Forum:
  


Current Time: Thu Oct 02 07:49:46 CDT 2014

Total time taken to generate the page: 0.11640 seconds