CSC 310

Last Revised:

Announcements Database Systems: A Practical Approach to Design, Implementation, and Management *5th edition* by Thomas Connolly and Carolyn Begg, Addison-Wesley, 2009, ISBN: 0-321-52306-7	Class Notes and Examples Example of Multiple File-based Systems Chapter 2: Database Environment Chapter 3: Database Architectures and the Web Chapter 4: The Relational Model Chapter 5: Relational Algebra Relational Algebra Examples Library and School Databases Primer on SQL SELECT statement for retrieving data from table(s) Primer on SQL INSERT, UPDATE, DELETE statements Basketball tables example of CREATE TABLE & INSERT INTO Entity-Relationship Modeling More E-R Modeling Student Grades: Non-1NF Student Grades: 1NF Student Grades: Update and Insertion Anomaly Student Grades: Deletion Anomaly Normalization Overview Normalization Example Normalization - More Details Normalization Example 2 Advanced Normalization Example (BCNF) SELECT to Make INSERT Commands Transactions -- Introduction XML -- Chapter 31 Outline
Course Information Office Hours Syllabus Schedule
General Resources Textbook Resources for Students (5th Ed) SQL Server 2008 R2 Transact-SQL Reference XML Tutorial at PerfectXML XML including namespaces DTDs - Document Type Definitions XML Declaration Line pseudo-attributes version, encoding, standalone Lots of XML examples Lots of DTD examples XML at W3C XML Tutorial at W3C XML Namespaces at W3C XML Schemas at W3C