Need Help Organizing Media Database

Status
Not open for further replies.

Robin Hood

Banned
Banned
36
2012
2
0
I'm sorry, I have limited knowledge of Python (my only coding skills), and the SQL knowledge I've learned by reading online documentation, a few extra guilds, and the chapter in my Python book that discussed databases.

From all that, I've come to understand that proper SQL structure is important, normalization is important, etc. (just the stuff us stupid people can understand).

Quite frankly, I'm somewhat surprised I couldn't manage to use Google to find out exactly either (1) how IMDb organizes their SQL, or (2) how computer savvy people think IMDb's SQL should be structured.

Essentially, I'm looking to have the database hold almost as much of the information from IMDb that I can get, and a few extra things (images, (eventually) some internal and external references, and the likes).

I'm hoping someone is patient/accommodating enough to tell/show me what the tables should be and what rows they should contain (explicitly, I'm too stupid to be able to extract if from a basic explanation) for some sort of karmic currency.

Thanks to anyone willing to try to help.
 
2 comments
If that's correct, I guess I'm not understanding it.

The project (which has many fewer fields than I anticipate mine having), has them all in one table, no? My understanding is this is very suboptimal.
 
Status
Not open for further replies.
Back
Top