Quran database schema

Question

2.33/5 (2 votes)

See more:

I need some help building tables for a quran database in MySQL. I am unsure on how to lay this information out in a table.

I want my database alquran , can play the audio and can translate a quran
b

C#

b
asically anything that has to do with organizing quran. I'm new to databases and I have some ideas. But if I'm going to learn I might as well learn the right way of doing it.

Any thoughts on how to design my table(s) would be awesome.

What I have tried:

table ayah
table juz
table surah
table meaning
table languange

Posted 25-Mar-16 11:25am

Member 12062589

Updated 26-Mar-16 11:55am

v2

Add a Solution

Comments

Garth J Lancaster 25-Mar-16 20:16pm

Some thoughts
1) What is the layout of the Quran ? It (is) a book, it has chapters (surah) .. (I dont know what juz and ayah are, are they 'subdivisions' of 'chapter'?) dont worry about 'tables' to start with, but the type of information you need to store

- eg book -> chapters -> division -> ...... -> text/content

once you have that mapped out, then you can see what tables are required

2) why dont you post the SQL 'create' table statements you have.

Member 12062589 26-Mar-16 10:40am

Please I wan't to know your schema
juz can have many surah
surah can have many ayah (verses)
ayah can have many translation and a audio

BillWoodruff 25-Mar-16 20:44pm

I would expect that there has been substantial work done on preparing indexed digital versions of the Quran ... unless there is some specific prohibition in Islam from doing so. I expect that if you search in Arabic, you will find scholarly articles complete with schema.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CHill60 · Answer 1 · 2016-03-26T11:55:00

As suggested by @BillWoodruff there are indeed scholarly articles around.

This one - http://www.sciencepub.net/report/report0607/001_24497report060714_1_6.pdf[^] has some suggested table layouts. (It may have been taken from this report though http://www.lifesciencesite.com/lsj/life1101/025_20725life1101_160_171.pdf[^])

Drupal has an entire project at Quran | Drupal.org[^]

This resource may also be useful - SemanticQuran - Datasets - the Datahub[^]

You might also gain some insight by looking at how the christian bible has been digitalised as the structure is similar e.g. GitHub - scrollmapper/bible_databases: Bible versions and cross-reference databases.[^]

As you say you are new to databases then you should make sure you understand The basics of Normalization[^].