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