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 442720 {main}( ) .../resources: 0 2 0.0215 1414896 hsnPage->outputFullPage( ) .../resources: 326 3 0.0217 1439200 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0218 1457088 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 442720 {main}( ) .../resources: 0 2 0.0215 1414896 hsnPage->outputFullPage( ) .../resources: 326 3 0.0217 1439200 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0218 1457088 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0220 1457624 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 442720 {main}( ) .../resources: 0 2 0.0215 1414896 hsnPage->outputFullPage( ) .../resources: 326 3 0.0217 1439200 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0218 1457088 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0220 1457624 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 442720 {main}( ) .../resources: 0 2 0.0215 1414896 hsnPage->outputFullPage( ) .../resources: 326 3 0.0217 1439200 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0218 1457088 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0220 1457624 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 442720 {main}( ) .../resources: 0 2 0.0215 1414896 hsnPage->outputFullPage( ) .../resources: 326 3 0.0217 1439200 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0218 1457088 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0220 1457624 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 442720 {main}( ) .../resources: 0 2 0.0215 1414896 hsnPage->outputFullPage( ) .../resources: 326 3 0.0217 1439200 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0218 1457088 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0220 1457624 presCourse->personal_rating_tosubmit( $object = ['id' => '31010'] , $change_sep = '' ) .../download.php: 19 6 0.0222 1457720 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 442720 {main}( ) .../resources: 0 2 0.0215 1414896 hsnPage->outputFullPage( ) .../resources: 326 3 0.0217 1439200 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0218 1457088 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0220 1457624 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 442720 {main}( ) .../resources: 0 2 0.0215 1414896 hsnPage->outputFullPage( ) .../resources: 326 3 0.0217 1439200 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0218 1457088 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126 5 0.0220 1457624 presCourse->personal_rating_tosubmit( $object = ['id' => '31010'] , $change_sep = '' ) .../download.php: 19 6 0.0223 1459160 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 442720 {main}( ) .../resources: 0 2 0.0215 1414896 hsnPage->outputFullPage( ) .../resources: 326 3 0.0217 1439200 include( '/home/hsntest/includes/page/hsn2.1.tpl ) .../hsnPage.class: 518 4 0.0218 1457088 include( '/home/hsntest/includes/body/course/download.php ) .../hsn2.1.tpl: 126
Download the PDF (83KB)
