Change Contents of the Bubble
Welcome to CS1315. Click on the python to add comments.

Looking for the book? They have it at the Engineer's Bookstore at 748 Marietta St NW. Here is there website: http://www.engrbookstore.com/ - Monica

Hotspots: Slides and Code • TA Corner • Comments? • Announcements • FAQ • Static Webspace
View this PageEdit this Page (locked)Uploads to this PageHistory of this PageHomeRecent ChangesSearchHelp Guide

Final Exam Review Fall 2003: Questions on Databases

Questions, comments, answers?

Back to Fall2003 Final Exam Review

1) Well-designed relational databases store information in tables where columns are named and rows of data are assumed to be related. Multiple tables are used to store complex relationships.
2) SQL is a powerful language for database creation and manipulation that is used for large, complex tables.
3) A join is an access across multiple tables to represent a more complex relationship.

Can you expand on 2 and 3? Is SQL only useful on large, complex tables? What does a join do? Mark Guzdial

BTW, nice job emphasizing relational databases. There are other kinds, but modern databases are relational and that's what SQL works on. Mark Guzdial

join is a function that combines structures within a relational database
What's a "structure" in a relational database? There are only "tables" in relational databases. Could you provide a more detailed description of what a join does? Mark Guzdial

It relates record on two or more tables to each other, essentially it allows you to query data from more than one table for complex relationships. Join works better for simpler tables with one relation per row.
That's true. So, for example, if you had a student name, student ID, and student address in one "Students" table, and a separate "Transcripts" table with student ID and classes and grades information, you could get the student name for a given transcript by JOINING the two tables on the Student ID – that's the one field that's in both, so that you can relate the student ID of a given transcript back to the student name. Mark Guzdial

1. Store multiple tables that are related to each other by some key fields that are common in more than one table. Each table has defined fields, which are the columns, and data entries for each field, which are the rows. Each intersection point of a row and a column corresponds to one and only one entry.

3. To link tables in a relational database by key fields that are common in more than one table.

Pls. correct me if I am wrong.
what is a better answer for number 2?


SQL is used for many kinds of relational databases, but I don't think it's used for other kinds of databases. Mark Guzdial




Link to this Page