Activity aim: Students should learn to strip sentences down to basic components necessary to determine the elements of ERD. They will learn to spot nouns and verbs in each sentence, and translate them into Entities and Relationships elements accordingly. Subsequently … Continue reading English Sentences into Entity Relationship Diagrams (CIS)
Activity aim: Learn normalization techniques by having students set up cases that need normalizing, and their peers resolving the normalization errors. Materials: Blackboard Discussion Board discussion. Time estimated: 30 minutes Prep for teacher: Set up Discussion Board discussion. Prepare the … Continue reading Normalization Game (CIS)
Activity aim: Spot common error in SQL statements, fix errors by writing correct SQL Materials: Printed worksheets Time estimated: 60 minutes Prep for teacher: Set up worksheets. Break students into pairs or groups (no more than 4) Note: Designed for … Continue reading Fix “Broken” SQL Statement (CIS)
Activity aim: To get students to understand and be able to differentiate between the domains of database, data, database management systems; to understand the professional roles and functions of database developer, data administrator, database administrator, data modeler, database architect, database … Continue reading Database Universe: Mix and Match (CIS)