 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 01-05-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 Thursday. |
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
| |
6th period- On page 419, in the 2nd paragraph type lines 3 and 4, that start “When we sort based”
7th period-
On page 419, in the 1st paragraph type lines 3 and 4, that start “In addition to storing”.
On page 419, in the 2nd paragraph type lines 3 and 4, that start “When we sort based”
| |
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 import RAW data from mystery people file
Remember: must be formatted AND SAVED as TEXT,
must be separated at field breaks with a COMMA (DELIMITATED)
@ Students will solve Robbery 1 (with teacher) and Robbery 2 (without teacher)
@ Students will create a clue worksheet and trade with a partner.
@ Students will create a query to solve Robbery 3.
If time:
| |
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 Question: 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.
|
