IS 312 Lecture Notes - Lecture 11: Third Normal Form, Sql, Subset

• School: CSUN
• Department: Accounting and Information Systems
• Course: IS 312
• Professor: Christopher G Jones

Document Summary

Re-typed powerpoints plug it in 3: fundamentals of relational database operations . Demonstrate the ability to query a relational database using qbe (query by example) and sql (structured. Understand how to create and read edrs (entity-relationship diagrams) Normalize a database into 3nf (third normal form). Attributes properties that describe the entity"s characteristics. Pi 3. 3 data normalization and table joins . Video: understanding normalization: 3rd normal form (3nf): all the attributes (of an entity in 2nf) are determined only the candidate keys of the table and not any non-prime attributes. Functional dependencies: the value of one particular attribute is associated with a specific single value of another attribute. Join operations: combine records from two or more tables. 3rd normal form: every non-key attribute must depend on the key, the whole key, and nothing but the key, so help me. Raw data gathered from pizza shop orders (slide 12) St , 2 nd , 3 rd normal form.