Database Systems - First Normal Form
Download the PDF (83KB)
( ! ) Warning: Undefined array key "feedback_submitted" in /home/hsntest/includes/body/course/download.php on line 17 Call Stack # Time Memory Function Location 1 0.0004 443704 {main}( ) .../resources: 0 2 0.0223 1415760 hsnPage->outputFullPage( ) .../resources: 326 3 0.0225 1440064 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0227 1457952 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126
( ! ) Warning: Undefined array key "vote" in /home/hsntest/includes/class/pres/course.pres on line 307 Call Stack # Time Memory Function Location 1 0.0004 443704 {main}( ) .../resources: 0 2 0.0223 1415760 hsnPage->outputFullPage( ) .../resources: 326 3 0.0225 1440064 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0227 1457952 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0228 1458488 presCourse->personal_rating_tosubmit( $object = ['id' => '31010'] , $change_sep = '' ) .../download.php: 19
( ! ) Warning: Undefined array key "vote" in /home/hsntest/includes/class/pres/course.pres on line 311 Call Stack # Time Memory Function Location 1 0.0004 443704 {main}( ) .../resources: 0 2 0.0223 1415760 hsnPage->outputFullPage( ) .../resources: 326 3 0.0225 1440064 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0227 1457952 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0228 1458488 presCourse->personal_rating_tosubmit( $object = ['id' => '31010'] , $change_sep = '' ) .../download.php: 19
( ! ) Warning: Undefined array key "vote" in /home/hsntest/includes/class/pres/course.pres on line 315 Call Stack # Time Memory Function Location 1 0.0004 443704 {main}( ) .../resources: 0 2 0.0223 1415760 hsnPage->outputFullPage( ) .../resources: 326 3 0.0225 1440064 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0227 1457952 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0228 1458488 presCourse->personal_rating_tosubmit( $object = ['id' => '31010'] , $change_sep = '' ) .../download.php: 19
( ! ) Warning: Undefined variable $html in /home/hsntest/includes/class/pres/course.pres on line 319 Call Stack # Time Memory Function Location 1 0.0004 443704 {main}( ) .../resources: 0 2 0.0223 1415760 hsnPage->outputFullPage( ) .../resources: 326 3 0.0225 1440064 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0227 1457952 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0228 1458488 presCourse->personal_rating_tosubmit( $object = ['id' => '31010'] , $change_sep = '' ) .../download.php: 19
( ! ) Warning: Undefined variable $html in /home/hsntest/includes/class/pres/course.pres on line 436 Call Stack # Time Memory Function Location 1 0.0004 443704 {main}( ) .../resources: 0 2 0.0223 1415760 hsnPage->outputFullPage( ) .../resources: 326 3 0.0225 1440064 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0227 1457952 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0228 1458488 presCourse->personal_rating_tosubmit( $object = ['id' => '31010'] , $change_sep = '' ) .../download.php: 19 6 0.0231 1458584 presCourse->unrated_stars( $item_id = '31010' , $tosubmit = TRUE , $foradd = ??? ) .../course.pres: 324
( ! ) Warning: Undefined array key "vote" in /home/hsntest/includes/class/pres/course.pres on line 334 Call Stack # Time Memory Function Location 1 0.0004 443704 {main}( ) .../resources: 0 2 0.0223 1415760 hsnPage->outputFullPage( ) .../resources: 326 3 0.0225 1440064 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0227 1457952 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0228 1458488 presCourse->personal_rating_tosubmit( $object = ['id' => '31010'] , $change_sep = '' ) .../download.php: 19
( ! ) Warning: Undefined variable $html in /home/hsntest/includes/class/pres/course.pres on line 418 Call Stack # Time Memory Function Location 1 0.0004 443704 {main}( ) .../resources: 0 2 0.0223 1415760 hsnPage->outputFullPage( ) .../resources: 326 3 0.0225 1440064 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0227 1457952 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0228 1458488 presCourse->personal_rating_tosubmit( $object = ['id' => '31010'] , $change_sep = '' ) .../download.php: 19 6 0.0233 1460024 presCourse->rated_stars( $item_id = '31010' , $number = NULL ) .../course.pres: 334
Rate it :
Note: JavaScript must be enabled if you want to rate this release. Please adjust your browser options and reload this page.
Details
Takes a simple example through to 1NF to illustrate the process. Also stresses why normalising is important.
These notes are intended for use with Important Concepts .
Credit
Higher Still Notes
Disclaimer
While every effort is made to ensure that the content of this release is accurate, Higher Still Notes
does not accept liability for any problems which may arise from inaccuracies in this release.
By downloading this release, you confirm that you have read the disclaimer .
( ! ) Warning: Undefined array key "feedback_submitted" in /home/hsntest/includes/body/course/download.php on line 59 Call Stack # Time Memory Function Location 1 0.0004 443704 {main}( ) .../resources: 0 2 0.0223 1415760 hsnPage->outputFullPage( ) .../resources: 326 3 0.0225 1440064 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0227 1457952 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126
Download the PDF (83KB)
