 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 05-21-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Database Basics- Many to Many relationships and Queries
| |
Standards:
|
DB-1 Know the Use and Purpose of a Database
DB-2 Know Data Types associated with a Database
DB-3 Demonstrate the Management of a Database
|
“I Can…” Statement
|
Criteria for Success-Formative/Summative Assessments
|
I can understand many to many database relationships. Test on Database Relationships on Tuesday.
|
Students understand many to many database relationships.
|
Literacy/Vocabulary Strategies (Word Wall)
| |
With our Netflix examples, we talked about a one-to-many database relationship and a one-to-one database relationship. Today, we are going to talk about a many-to-many database relationship.
Movie studios sometimes work together to make multiple movies.
http://commons.wikimedia.org/wiki/File:Warner_Brothers_Presents.png
| |
Bell-Ringer/Connecting Strategy
| |
On page 99, type lines 47 and 48..
Today’s typing is a general review using all of the alphabetic keystrokes we have learned this semester
| |
Lesson-Instructional Strategies & Procedures for Teacher and Students
(Detailed Plans Including Best Practices, Researched Based Strategies)
| |
Guided Lesson:
Candy Questions-
Pet example- review of all database relationships
Many-to-Many – when multiple records from both (or more) tables are linked. A Many-to-many relationship is actually two one-to-many tables that are connected by a junction table.
Car example- many to many database relationship
Studios like Warner Brothers, Dream Works, 20th Century Fox make many movies per year.
Some studios may work together to make a movie, this is because it is expensive to film a movie.
The Towering Inferno. The production budget was so high that nobody wanted to finance it. Irwin Allen (the producer) talked two major studios - 20th Century Fox and Warner Brothers - into each financing half the movie. Of course both studios got credits. https://www.youtube.com/watch?v=zsRnQQpklPM
Independent Exercise
@ Students will create a DB Relationship Vocabulary word PowerPoint
@ Exit Activity 14 | |
Important Dates- Last Grades if you want to improve your final grade.
Design Principles PowerPoint due today, Tuesday, May 19
Test Corrections or Correction Voki due today, Tuesday, May 19
Database Relationship Words PowerPoint due Thursday, May 21
Final typing improvement test is Tuesday, May 26th
Database Relationships test is Tuesday, May 26th
Mystery Database import/filter is Friday, May 29th
Daily Review Grades from Monday, June 1st through Thursday, June 4th
Daily typing grade on Thursday, June 4th
Official End of Semester test for this class is Friday, June 5th
| |
Higher Order Thinking Questions
| |
How is a many to many database relationship like a one to many database relationship?
How is it different? | |
Student Technology/Differentiation
| |
Students will Access to understand queries.
| |
Closure Strategy
| |
Exit Activity #14: Database relationships
| |
Lesson Reflections
| |
Answer to Candy Questions:
What is referential integrity for a database?
Referential Integrity protects related data that is stored in multiple tables. Referential Integrity would prevent a customer in a customers table from being deleted if the customer’s ID also appears in the order table. If you do not have correct referential integrity your database can be hacked.
Name one company that has been hacked for credit card data or other information?
Target Staples P.F. Changs UPS
Blue Cross KMart Neiman Marcus Google
Chick-fil-a Dairy Queen Michaels Apple icloud
Sony (emails) Jimmy John’s AT & T and many more...
US Postal Service Home Depot Ebay
| |
No comments:
Post a Comment