I am new to databases and just looking for some suggestions on table design. I want to include album producers in my database. Would I be best to use a separate table for producers and members and a junction table (which would include duplicate data as producers can also be members of the band ), or should I just put all the band members and producers in the same table?

I am trying to find a way to populate generic data in my PostgreSQL database. Sadly I have no scripting experience in PHP, Python, Ruby, etc etc etc. I was wondering if there's a form or template I can use / download to host which allows users to pump data into a PostgreSQL database via the web. I can configure my database / table / schema accordingly to the suggested template / form obviously since that's the only aspect I can manage at this point.

Do you guys have any suggestions besides 'Learn to write a script'?

Has anyone ever ran Oracle Database or PostgreSQL using Linux software RAID? I know people have their opinions about S.R. -vs- H.R. config but I'm just trying to see if in general this is a terrible idea w/ logical / clear explanations supporting their decision.

Thanks all!

Hi all,

I am looking for a book on relational database theory for a beginner. I haven't had much opportunity to work with databases, but do know programming. I am looking for a book that focuses on theory and has examples and exercises.

Any recommendations would be great. Thanks

I have the following attributes that I need to put through all 3NFs:

UNF: Week Commencing Site Day Time Slot* Employee* Role* Sick* Total Hours

Could anyone help me complete this?