Jump to content
Larry Ullman's Book Forums

Search the Community

Showing results for tags 'keys'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Single Editions
    • Modern Javascript: Develop and Design
    • The Yii Book
    • Effortless Flex 4 Development
    • Building a Web Site with Ajax: Visual QuickProject
    • Ruby: Visual QuickStart Guide
    • C++ Programming: Visual QuickStart Guide
    • C Programming: Visual QuickStart Guide
    • Adobe AIR: Visual QuickPro Guide
  • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (5th Edition)
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (4th Edition)
    • PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide (3rd Edition)
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (2nd Edition)
    • PHP and MySQL for Dynamic Web Sites: Visual QuickPro Guide (1st Edition)
  • PHP for the Web: Visual QuickStart Guide
    • PHP for the Web: Visual QuickStart Guide (5th Edition)
    • PHP for the Web: Visual QuickStart Guide (4th Edition)
    • PHP for the Web: Visual QuickStart Guide (3rd Edition)
    • PHP for the World Wide Web: Visual QuickStart Guide (2nd Edition)
    • PHP for the World Wide Web: Visual QuickStart Guide (1st Edition)
  • Effortless E-commerce with PHP and MySQL
    • Effortless E-Commerce with PHP and MySQL (2nd Edition)
    • Effortless E-Commerce with PHP and MySQL
  • PHP Advanced: Visual QuickPro Guide
    • PHP Advanced and Object-Oriented Programming: Visual QuickPro Guide (3rd Edition)
    • PHP 5 Advanced: Visual QuickPro Guide (2nd Edition)
    • PHP Advanced: Visual QuickPro Guide
  • MySQL: Visual QuickStart Guide
    • MySQL: Visual QuickStart Guide (2nd Edition)
    • MySQL: Visual QuickStart Guide (1st Edition)
  • Other
    • Announcements
    • Newsletter, Blog, and Other Topics
    • Forum Issues
    • Social

Find results in...

Find results that contain...


Date Created

  • Start

    End


Last Updated

  • Start

    End


Filter by number of...

Joined

  • Start

    End


Group


Found 1 result

  1. I think I am stuck here. I am confused if I am getting the right concept. 1) Index 2) 2NF & 3NF 3) Character SET & Collation 4) Primary Keys, Foreign keys I think this is Important for me to understand before I jump to chapter 7. Index), By index, what I understand after watching some videos and reading from book too, that its something like creating a copy of a 'column', maybe in memory so that searching data can be easy. 2NF & 3NF), I think I am lost here, 1NF is to make sure columns are atomic that is no multiple data, 2NF is to make sure that nothing is being repeated or minimum redundancy as well as to assign primary and foreign keys. 3NF is achieved once we already achieve 1NF and 2NF. 3Nf makes sure database is normalized with keys, minimum redundancy, atomic columns. Character set), so character set is other word for encoding, when assigned to a column or table, only that type of data/texts can be stored. and collations are rules for it or a type within charset. Keys), primary key is the main key and foreign key is a copy of primary key, or points to primary key, or is a reference to primary key. So if primary key is altered i.e if its incremented, foreign key gets incremented automatically? I am not sure if I got the right concept, if not please correct me. This is really confusing for me. I am not getting whats behind, I mean okay I now know how to create/update/ database tables columns etc. But whats happening in background is confusing me. how are all these linked together. MySQL manual is kind of more complex for a newbie like me. Please help me. Thank you.
×
×
  • Create New...