INFM 603
Information Technology and Organizational Context
Spring 2015
Assignment H6


JavaScript is only one kind of programming, and at this point in the semester we will be looking at some other examples. Our second programming language, a non-procedural language, is SQL. So our goal in this assignment is to get some experience writing and running SQL. To do that, you should install MySQL and then try writing the commands that you need to do this assignment. Again, we don't care about the specific task (making an access control list) -- that just gives us a context in which to learn how to create this program. You should not need the JOIN operator for this assignment.

  1. Create a set of SQL statements for MySQL that will create an access control list with userid's and encrypted passwords for three people and then retrieve the encrypted password for one of those people.
  2. Send the statements to the professor as a text document attached to an email.

Doug Oard
Last modified: Wed Jan 14 21:03:10 2015