How to create a database for school management .

Question

How to create a database for school management .

arunnrj87

Mr or Mrs. 500

Points: 565
More actions
November 30, 2014 at 6:56 am

#298997

Hi friends,
We got a new project and developer told to create a new database and told to design me.
They given the Details in Excel sheet which i have attachment below.
Please go through it and help me to design the database.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1004447 More actions · Answer 1

arunnrj87 (11/30/2014)
Hi friends,
We got a new project and developer told to create a new database and told to design me.
They given the Details in Excel sheet which i have attachment below.
Please go through it and help me to design the database.

Considering the denormalized design of the "Student Master" table, the fact that the Section and Group names contain more than 1 type of data (description, grade, and time), the fact that the "Subject Master" is a totally orphaned table (has no relationships with the other tables), the fact that there are no temporal references in the "Student Transaction" table, and all of that is just for starters, I'm going to suggest that the folks that gave this design to the Developer don't actually know what they're doing when it comes to database design and that you good folks should actually hire a consultant to set this database up right for you. I'm not saying that to be mean... it's just that designing a whole database without being paid is way beyond what you could expect from someone on a forum.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

aaron.reese SSChampion Points: 13498 More actions · Answer 2

Fully Agree with Jeff, get a consultant in to set this up if this is the standard they are giving you to work with. That said - aint never gonna happen 🙂

Professor and Student are both classifications of people so you should have a person table and a role table that links the person to being a student or Professor (or possibly both)

Schools and students both have addresses which should be delegated to an addresses table with a bridge table between the master table and the address; this means you can update the address through the bridge table and even have more than one active address: A school may be spread across more than one campus and a student may have a term time and holiday address.

Jeff Moden SSC Guru Points: 1004447 More actions · Answer 3

Not to mention a "near campus" and one or more "home" addresses depending on whether Mom & Dad have a time share or not. In fact, you might want to put some dates on the addresses.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

aaron.reese SSChampion Points: 13498 More actions · Answer 4

and an address type - home, correspondence, holiday, emergency, temporary;

in fact why limit it to location addressees; it could be all addresses (email, ip)

in which case you could hold all contact methods in the contact_method table(phone, skype, facebook, etc... ).

GET A CONSULTANT!