CSCI-2141 – Intro to Database Systems Reading List for Final Examination Textbook: • Carlos Coronel and Steven Morris, "Database Systems – Design, Implementation, and Management", 12e, ISBN-13: 978-1-305-62748-2. Topics Book Reading Reference and Other Resources - Introduction to Databases - Database systems - Data, Information and Knowledge Textbook, Chapter 1 includes: - Sections 1.1 – 1.7 - Review Questions 1 – 17 - Problems 1 – 11 - Relational database model - Relational database keys - Joins Textbook, Chapter 3 includes: - Sections 3.1 – 3.8 - Review Questions 1 – 8, 11 – 27 - Problems 1 – 31 - For more in-depth study on this topic: http://infolab.stan- ford.edu/~ullman/focs/ch08. pdf - Structured Query Language (SQL) - SQL’s Data Definition Language (DDL) - SQL’s Data Manipulation Language (DML) Textbook, Chapter 7 complete, in- cluding all Review Questions and Problems. MySQL Reference: - https://dev.mysql.com/ doc/refman/5.7/en/ - https://dev.mysql.com/ doc/refman/5.7/en/sql- syntax.html - Advanced SQL - SQL Join Operators - Subqueries - SQL Functions - Stored Procedures Textbook, Chapter 8 includes: - Sections 8.1 – 8.5, 8.7 - Review Questions 1 – 19 - Problems 1 – 13, 19 – 27, 44 – 67 - Identifying data requirements from business rules. Transforming user re- quirements to Database Design - Data Modelling - Conceptual, Logical and Physical Data Models - Data Modelling notations - ER Diagrams Textbook, Chapter 2 includes: - Sections 2.1 – 2.4, 2.5 (b) (c), 2.6 - Review Questions 1 – 6, 10 – 14 - Problems 1 – 2, 4 – 7, 9 – 11, 13 – 17 - Database Normalization - Conversion to 1NF, 2NF, 3NF - Denormalization Textbook, Chapter 6 includes: - Sections 6.1 – 6.4, 6.7 – 6.9 - Review Questions 1 – 10, 13 – 15 - Problems ALL (excluding BCNF and 4NF) A detailed example on Normali- zation can be found here: http://agiledata.org/es- says/dataNormalization.html - Database Design Textbook, Chapter 4 includes: - Sections 4.1 – 4.2 - Review Questions 8 – 11, 14 – 16, 18 - Problems 1 – 4 would be helpful
欢迎咨询51作业君
