• Support PF! Buy your school textbooks, materials and every day products Here!

Practical book on relational databases with SQL

  • Other
  • Thread starter ZeGato
  • Start date
  • #1
32
27

Main Question or Discussion Point

Hello,

I'm looking for a book on relational databases, that uses SQL, that is practical with lots of examples, and the least possible amount of jargon. Specifically, I have issues understanding how to translate the E/R model into the relational model (relations to tables), and the book that I have right now has lots of text but no structured examples to learn from.

Thank you for any help!
 

Answers and Replies

  • #2
11,495
5,033
This may answer your ER model question:

https://www.tutorialspoint.com/dbms/er_model_to_relational_model.htm

There are other online references on this site too. O'reilly has some SQL books that are good references but won't necessarily teach you how to use it effectively or conceptually.

Other onlines are:

https://www.google.com/search?newwindow=1&hl=en&ei=xDq-W--aO8z8jwSc9bO4Cg&q=connverting+ER+model+to+relational+model&oq=connverting+ER+model+to+relational+model&gs_l=psy-ab.3..0i13j0i22i30l6.186865.196300..196581...1.0..0.92.2398.41......0....1..gws-wiz.......0j0i71j35i39j0i131j0i131i67j0i67j0i10i67j0i10j0i13i10j0i13i30j0i22i10i30j0i8i13i30.CwSQl7e2X_w

There H2Database.com which is a java based database as a single jar file that can do a lot of SQL commands for experimentation.

http://h2database.com/html/main.html

It has a command line or web based access. It can run standalone of connected to an application with other apps accessing it via JDBC api. And is quite cool.
 
  • #3
verty
Homework Helper
2,164
198
Hello,

I'm looking for a book on relational databases, that uses SQL, that is practical with lots of examples, and the least possible amount of jargon. Specifically, I have issues understanding how to translate the E/R model into the relational model (relations to tables), and the book that I have right now has lots of text but no structured examples to learn from.

Thank you for any help!
Can I steer you away from this mentality? You want the best, most accurate database model possible so that it works the way you expect. And it needs to be laid out the right way or you could run into problems later when you do more complicated stuff. So I agree with the authors who write about the theory because it's only when you know the theory that you will understand what is good and what is bad. Otherwise you will have a recipe to follow without understanding it and that is no good, IMHO.
 

Related Threads on Practical book on relational databases with SQL

Replies
1
Views
707
Replies
2
Views
4K
Replies
1
Views
2K
Replies
4
Views
1K
Replies
32
Views
7K
Replies
2
Views
294
Replies
1
Views
12K
Replies
4
Views
2K
Top