Deprecated: add_custom_background is deprecated since version 3.4.0! Use add_theme_support( 'custom-background', $args ) instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5084

Deprecated: add_custom_image_header is deprecated since version 3.4.0! Use add_theme_support( 'custom-header', $args ) instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5084

Notice: wp_enqueue_script was called incorrectly. Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks. This notice was triggered by the jquery handle. Please see Debugging in WordPress for more information. (This message was added in version 3.3.0.) in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5536

Notice: wp_enqueue_script was called incorrectly. Scripts and styles should not be registered or enqueued until the wp_enqueue_scripts, admin_enqueue_scripts, or login_enqueue_scripts hooks. This notice was triggered by the smoothscroll handle. Please see Debugging in WordPress for more information. (This message was added in version 3.3.0.) in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5536

Deprecated: The called constructor method for WP_Widget in Yoko_SocialLinks_Widget is deprecated since version 4.3.0! Use __construct() instead. in /home/pqmz7qzy9yt5/public_html/wp-includes/functions.php on line 5177
Intro to Databases, Video Lecture 2: Relational Databases, The Relational Model | Megan Taylor

Megan Taylor

front-end dev, volunteacher, news & data junkie, bibliophile, Flyers fan, sci-fi geek and kitteh servant

Intro to Databases, Video Lecture 2: Relational Databases, The Relational Model

-used by all commercial db systems
-very simple model
-query with high-level languages: simple yet expressive
-efficient implementations

Database = set named relations (or tables)
Each relation has a set of named attributes (or columns)
Each tuple (or row) has a value for each attribute
Each attribute has a type (or domain)

Schema – structural description of relations in database
Instance – actual contents at given point in time
NULL – unknown or undefined
Key – attribute whose value is unique in each tuple or set of attributes whose combined values are unique

Creating relations (tables) in SQL:
Create Table Student(ID, name, GPA, photo)
Create Table College(name string, state char(2), enrollment integer)

October 13, 2011 | Comments Off on Intro to Databases, Video Lecture 2: Relational Databases, The Relational Model | Categories: Posts | Permalink

Comments are closed.


Notice: Undefined index: host in /home/pqmz7qzy9yt5/public_html/wp-content/plugins/jetpack/modules/stats.php on line 209