How to start the database structure?

Databases
1

i have one concept for studying in abroad and for that, i want to showing the all colleges, univversities and courses information.
so hows to create the database structure instead of directing create the database table.
i need some help for that.

so give me some idea for how to preplanning the database structure and algorithm

2

Hi Ramesh_Prajapati welcome to the forum

It is wise of you to think about how to plan.

From your post it is clear you will be interested in something like

CREATE TABLE institutions (
id INT NOT NULL PRIMARY KEY
, name VARCHAR(50)
)

But “courses information” could be just about anything and everything.

Can you list what kind of information you imagine you will be wanting to have?

(btw the term you’re looking for isn’t algorithm, search for “schema”)

3

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.