 |
Archdale-Trinity Middle School
Lesson Plan
|
Date: 1-06-2015
|
Teacher:
|
Witkowski
| |
Lesson/Unit Topic:
|
Review DB Relationships and create vocabulary word presentations
| |
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 be creative on my review project and explain the items I missed. Test on Database Relationships on Thursday.
|
Students will be creative on their review projects and explain the items they missed.
|
Literacy/Vocabulary Strategies (Word Wall)
|
Junction table – a table used to join primary key field from multiple tables.
Which table is the Junction table? ( Users, UserPermissions, or Permissions)
http://commons.wikimedia.org/wiki/File:Junction_Table.svg
|
Bell-Ringer/Connecting Strategy
|
On page 423, type the 1st two sentences that start “If you were searching”.
|
Guided Lesson:
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
Review Database Tables, Primary Keys, Foreign Keys, and Relationships
0:00 Database Tables
1:36 Primary key- Candy Questions- What are the other 4 primary keys?
6:33 Foreign key- Candy Questions- What is the other foreign key in the Order table?
What is the foreign key in the Order LINE table?
Candy Questions
In the Product table, is Product Id a primary or foreign key?
What are the lines between the databases called?
One customer can have many orders. What type of database relationship is it?
If one customer was only allowed one order what type of database relationship would it be?
If Coke deletes Customer 23 (they want Pepsi now) and all of Customer 23’s data is deleted from the database, it is a good example of what item is working? Begins with a “R.”
If Time:
@ Miss W will review the review presentation rubric for database relationship word projects.
@ Students will have 10 minutes to work together.
Rubric:
50% accuracy (definition is correct)
50% creativity (time, effort, originality)
`
Independent Exercise:
@ Students will create a clue worksheet and trade with a partner.
@ Students will create a query to solve Robbery 3.
If time:
@ Students will start and present their database relationship word projects.
|
Higher Order Thinking Questions
|
How can you make your topic interesting to other students?
|
Student Technology/Differentiation
|
Students use various software programs to create their review project.
|
Closure Strategy
|
Exit Activity #14: Database relationships
Exit Activity #15: Typing Symbols
|
No comments:
Post a Comment