To Do
In-Class Exercise #5: SQL OUT
Assignment #2 – SQL Part 1
Here are the assignment instructions.
This assignment is due by the start of class on Tuesday, May 30th.
In-Class Exercise #4: Pen and Paper Query Exercise
Weekly Question #2 – Complete by May 26, 2017
Leave your response as a comment on this post by May 26, 2017. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your opinions, not so much particular “facts” from the class!
If you sign in using your AccessNet ID and password you won’t have to fill in the name, email and captcha fields when you leave your comment.
Here is the question:
What do you think is the trickiest thing about creating an ERD from a problem description? What advice would you give to deal with that issue?
In-Class Exercise #3: Converting ERDs to Schemas
In-Class Exercise #2: Creating an Entity Relationship Diagram
Assignment #1: ER Modeling
Here are the assignment instructions.
Use ERDPlus to complete the assignment. It is pretty straightforward to use, but this handy video shows you how to create an ERD and export the diagram as a graphic. That graphic can then be inserted into a Microsoft Word document.
Remember, you must submit a single Microsoft Word document – if you send multiple files, you will not get credit for the assignment.
The assignment is due by the start of class on May 25, 2017.
In-Class Exercise #1: Identifying Entities
Weekly Question #1: Complete by May 19, 2017
Leave your response as a comment on this post by May 19, 2017. Remember, it only needs to be three or four sentences. For these weekly questions, I’m mainly interested in your opinions, not so much particular “facts” from the class!
If you sign in using your AccessNet ID and password you won’t have to fill in the name, email and captcha fields when you leave your comment.
Here is the question:
Give an example in your own experience where you saw raw data turned into information.