Any SQL users out there feeling bored..? Please help.

oreilly2311 · Nov 3, 2011

So I need a simple database schema for a DVD database. Here is my criteria:

- database has to allow storage of customer details (names, etc.)

- customer preferences (favourite genres, actors, directors etc.)

- a catalogue of films held in stock ready for rental or borrowed

- a table cross-referencing the DVDs to the customers who have borrowed them

- a list of main actors linked to the list of films, genres, directors (to allow searching by category) etc.

Can anyone help??

marusia · Nov 3, 2011

Ha! I had to build something JUST like this when I was in school for database admin. I <3 SQL. I'm at work right now, but give me a bit, and I'll see what I can remember.

oreilly2311 · Nov 3, 2011

marusia said:
Ha! I had to build something JUST like this when I was in school for database admin. I <3 SQL. I'm at work right now, but give me a bit, and I'll see what I can remember.

Sounds good buddy!

marusia · Nov 3, 2011

Try this.

http://publib.boulder.ibm.com/infocenter/idm/v2r1/index.jsp?topic=/com.ibm.datatools.sqlbuilder.tutorial.doc/topics/sqlquery_introduction.html

If you need help with it, I'll be back later. Just send me a PM and I'll help you tweak it as needed.

a_z_0_9 · Nov 3, 2011

Do you still need help with schema diagram, PM me i can help you

dannyduberstein · Nov 3, 2011

marusia said:
Ha! I had to build something JUST like this when I was in school for database admin. I <3 SQL. I'm at work right now, but give me a bit, and I'll see what I can remember.

hehe me too. My first guess was that this was a homework assignment!

marusia · Nov 3, 2011

Yeah, my same thoughts. I still have that book.

Any SQL users out there feeling bored..? Please help.

oreilly2311

Regular Member

marusia

Compromised Account

oreilly2311

Regular Member

marusia

Compromised Account

a_z_0_9

Junior Member

dannyduberstein

Regular Member

marusia

Compromised Account

Main Menu

Marketplace

Making Money

BlackHat World