what's the concept behind relational databases.
what is the role that SQL plays in a relational database.
any help would b appreciated
thanx
questions bout databases n stuff
5 public posts in this discussion.
Post 2
I would answer but... it looks like you are posting your IT homework on the net and expecting other people to do it for ya. :P Sorry. Try a google search for:
"Relational Databases"
"Computing Concepts"
"SQL Tutorial"
"Role of SQL"
You will be surprised how easily the answers come, padiwan..
Post 3
lol... i did that lol
this is what i got so far, dunno how to expand on it
Write 100 words describing the concept behind relational databases.
A relational database is where a database stores information in a number of tables, which are all linked to each other using a primary and foreign key, and uses relational data which is not duplicated.
Write 200 words describing the role that SQL plays in a relational database.
The role of SQL in a relational database is to take data from the tables and group it together in a new table making it easier to find information that you need, and organize the data so it’s output is more understandable.
Post 4
Dont forget BCNF and normalisation ....
1st Normal Form
2nd " "
3rd " "
and BCNF
SQL can be used to create and maintain/query DB's too ....
I did a unit on DB's at Uni .... amazing how much I remember ....
We used Ingress Forms and SQL on a VAX .....
Post 5
SQL is a query language. It is used to retrieve, store and/or manipulate data in a database. Saying that its role is "to take data from the tables and group it together in a new table" is either inaccurate or just plain wrong, depending on your point of view.
If you want more words for the first one expand on the concept of relational vs. non relational databases - it will help to point out that you understand the differences which is most likely what the marker is trying to get at.