Implementing TBL Activities – Winter 2014 ITLAL TBL Seminar



Implementing TBL Activities – Winter 2014 ITLAL TBL Seminar

0 0


ITLAL-Seminar-Activities

This encounter runs down Jurkat's thoughts on TBL activity construction for the winter 2014 ITLAL seminar

On Github SUNY-Albany-CCI-LearningEncounters / ITLAL-Seminar-Activities

Implementing TBL Activities

Winter 2014 ITLAL TBL Seminar

Created by M Alexander Jurkat

This learning encounter was created by
M Alexander Jurkat
and is licensed under

CRUD

Functions of a database:

Create: Insert data.

Read: Query data.

Update: Modify data.

Delete: Remove data.

Relational = SQL

SQL (SEE-quill), short for Structured Query Language, is a special-purpose programming language designed for managing data held in a relational database management systems (RDBMS).

Inserting Records (Create)

Task: Which SQL statement adds one employee record?
A. INSERT INTO Staff VALUES ("SA4", "Brown", "Assistant", 8300, "B007", "16 Argyll St., Aberdeen");
B. INSERT INTO Staff (staffNo, sName, branchNo) VALUES ("SA4", "Alan Brown", "B007");
C. INSERT INTO Staff VALUES ("SA4", "Alan Brown", "Assistant", NULL, "B007", "16 Argyl Rd., Aberdeen");

Modifying Records (Update)

Task: Which SQL statement properly adjusts an address?
A. UPDATE Staff SET bAddress = "195 Post Rd., Glasgow" WHERE staffNo = "SG37";
B. UPDATE Staff SET bAddress = "195 Post Rd., Glasgow";
C. UPDATE Staff SET bAddress = "195 Post Rd., Glasgow" WHERE branchNo = "B003";

Removing Records (Delete)

Task: Which SQL statement properly deletes a staff record?
A. DELETE FROM Staff WHERE staffNo = "SA9"; 
B. DELETE FROM Staff;
C. DELETE FROM Staff WHERE position = "Assistant";

A Treasure of Personal Data

Think about your smartphone and all the things you do with it each day. What kind of data about you does it contain?
Task: Discuss and agree on three kinds of data or pieces of information about you that are recorded in your smartphone. You can't list your phone number.

Intellectual Property

Copyright
Exclusive rights on the use of expression of ideas
Patent
Exclusive rights on non-obvious, useful, new ideas
Trademark
Exclusive rights to names, logos, symbols for a particular business use
Trade Secret
Exclusive rights to formula, practice, process

How do I protect?

A. Copyright
B. Patent
C. Trademark
D. Trade Secret

How do I protect?

A. Copyright
B. Patent
C. Trademark
D. Trade Secret

How do I protect?

A. Copyright
B. Patent
C. Trademark
D. Trade Secret