· Chapter 12: XML. Notes.
· Test will be Monday from 8:00 a.m. to 8:00 p.m.
· Part 4 of project is due today at 11:59 p.m.
· Chapter 11: Database standards. Notes.
· Chapter 11: ODBC, OLE DB, ADO.NET. PPT.
· OLE DB coding example: Video
· OLE DB example with Access MDB file: Notes.
· OLE DB example with Access ACCDB file: Notes.
· All of these video examples use SQL Server and the SQL Server Management Studio
· Part 1
· Part 2
· Part 3
· Part 4, creating a view
· Part 5, creating a stored procedure: Insert customer and interest
· Part 6, creating a stored procedure: Insert customer with transaction
· Part 7, trigger example
· Read chapter 12: XML
· Using SQL Server Management Studio: Notes.
· SQL Files. These are the files from the textbook that are used in the videos.
· Read chapter 11: The Web Server Environment
· Chapter 9. Multi-user databases. Notes. There are no videos over chapter 9.
· Chapter 9 questions. Answer the questions and submit to the drop box by 9:30 a.m. Thursday (4/23/2020).
· Chapter 8. Notes.
· Chapter 8 data files:
· Chapter 8 videos:
o Part 1
o Part 2
o Part 3
o Part 4
o Part 5
o Part 6
o Part 7
o Part 8
o Part 9
· Read chapter 9
· Chapter 7: SQL for inner joins, outer joins, views. Notes.
· Chapter 7 videos and data files:
o Video: Views: View Ridge
· Read chapter 8
· Chapter 7: SQL for creating and modifying databases. Notes.
· Chapter 7 videos:
o Part 1
· TEST Thursday over chapter 5-6. You will create an ER diagram in MySQL Workbench. You will have from 8:00 a.m. until 8:00 p.m. to complete it.
· Finish reading chapter 7.
· Please read: Chapter 6 notes
· Test #3 over chapters 5 & 6 will be Thursday, April 9.
· Read chapter 7, pages 246-272
· This is the example we would have gone through in class today: Classic DB example: Invoices
· Medical clinic ER diagram. Use MySQL Workbench to create the ER diagram. Use Word for all else. Put files in the drop box.
· Read chapter 6.
· Due: Students, teachers, and classes. Solution.
· ER diagram: Video Store Rentals. Use MySQL Workbench to create the ER diagram. Use Word for everything else. Put both documents in the drop box.
· Note: I had originally intended to spend another day on using Access, but we covered the basics the last time we met, and given the fact that we lost two classes last week, I think we can omit that.
· Interesting tech: small computer
· Interesting article: The importance of computer science fundamentals
· ER diagram: Students, teachers, and classes. Use MySQL Workbench to create the ER diagram. Use Word for all else. Put both documents in the drop box.
· 25 most recommended programming books of all time.
· Return tests.
· Chapter 5: Intro to ER Diagrams. Notes.
· Assign projects:
- Airline: Erin, Christian, Tamas
- Basketball: Feddy, Jake
- Parish: Ben, Casey
· Read Appendix A: Getting Started with Access.
· Test #2: Chapters 3, 4. Dependencies and normalization.
· Read chapter 5, pages 155-168. Expect a quiz.
· Notes from Day 10.
· Homework due today: functional dependencies #6 (Jobs, applicants) solution.
· Database Design Using Normalization (chapter 4). Notes
· Discuss auto license/title functional dependencies (#7)
· NEXT CLASS: Test #2, over chapters 3 and 4. List of review terms.
· Notes from Day #9
· Go over Functional dependencies #3.
· Functional dependencies #4. Do in class.
· Functional dependencies #5. Do in class.
· Functional dependencies #6. Hand in a hard copy.
· Notes from Day 8.
· Go over functional dependencies #2 homework.
· Today's notes.
· Boyce-Codd Normal Form, 4th Normal Form. Normalization Examples
· Functional dependencies #3. Hand in a hard copy. Hint: 5 tables.
· Read chapter 4. Expect a quiz.
· Notes from day 7.
· History: first hard disk drive
· Interesting tech: Apollo 11
· More on normalizing a database.
· Project file.
· Go over tests
· Normalizing a database, part 1
· Finish reading chapter 3. Expect a quiz.
· Functional dependencies #1. Turn in a hard copy. NO DROP BOX.
· Test #1, over chapter 2.
· You will be expected to write SQL statements (open book).
· Use this file for the test.
· Read chapter 3, pages 100-112 (up to Normal Forms). Expect a quiz.
· Notes from Day 4.
· Notes/Review for today.
· SQL workday:
· Do question 2.63 (A-H) using the CH02-NDX-SQL-92.accdb database.
· Do the questions over the Marcia's Dry Cleaning questions at the end of chapter 2 (A-Q) using the CH02-MarciasDryCleaning-SQL-92.accdb. NOTE: Marcia's Dry Cleaning question K should say "Sort" instead of "Group". List all fields. Compare your answers with the solution. Here is a document with all of the questions.
· Study for a test over chapter 2. Be prepared to read SQL queries (and produce their output) and to write SQL queries. You will be expected to know how to read/write each type of query in chapter 2. You will be allowed to use your book. Writing queries will be hands-on with an Access database that will be provided. You will NOT be allowed to use the computer when reading queries, but you will be allowed to use the book.
· Chapter 2: Introduction to SQL, part 3: Joins
· Notes from Day 3.
· Review Questions #2.40 through 2.50. NOTE: Use the linked document rather than the textbook. There are some minor changes and corrections. Continue to use the Chapter 2 Cape Codd database. When you save your queries, name them Q2-40 through Q2-50. What to hand in: a copy of the database in the drop box.
· Chapter 2: Introduction to SQL, part 2.
· Notes from Day 2.
· Review Questions #2.29 through 2.38, except 2.35. NOTE: Use the linked document rather than the textbook. There are some minor changes and corrections. Continue to use the Chapter 2 Cape Codd database. When you save your queries, name them Q2-29 through Q2-38. What to hand in: a copy of the database file in the drop box.
· Chapter 2: Introduction to SQL, part 1.
· Finish reading chapter 2 (pages 63-82). Expect a quiz.
· Review Questions #2.17 through 2.28. Make a copy of the Chapter 2 Cape Codd database. When you save your queries, name them Q2-17 through Q2-28. Put a copy of the database file in the drop box. Note: If a field is included in a WHERE clause, include it as a selected field (after all of the other fields), too (even though he doesn't say that—it'll make it easier to check your work).
· Print, READ, and sign class policies statement.
· Read chapter 1 and chapter 2 pages 31-63. Be prepared for a quiz.
· Incompatible date formats. Hand in a hard copy at class time.
· Part 4 of project is due today