CS 101/Additional Materials/Chapter 12

From Worcester State University Computer Science Department Wiki
< CS 101‎ | Additional Materials
Revision as of 08:27, 25 March 2016 by Karl Wurst (Talk | contribs) (Finished cleanup)

Jump to: navigation, search

Section 12.1 Managing Information

Information Systems https://www.youtube.com/watch?v=Qujsd4vkqFI 03/30/2013-11/15/2015 This video is a informational explanation of why we need this information systems to store our data and accurately access it. With out these system it would be impossible to find all the data we create. In this video it explains how much data that actually is. Zachary Nader.

Information Systems: http://www.journals.elsevier.com/information-systems/ 11/17/2015 -Joseph Clark

Section 12.2 Spreadsheets

I found this youtube channel dedicated to teaching how to use spreadsheets, spreadsheets are typically confusing to me so this helped out. https://www.youtube.com/user/learnexcelfunctions -Matt Lanteigne

Spreadsheet Formulas

http://deathbybloomingflowers.blogspot.com/2013/12/the-spreadsheet-tools.html Date Accessed: 11/3/15 Date Published: 12/20/13 Although this is just a person's blog it discussed the formulas you will sometimes see within spreadsheets. It provides valuable time-saving formulas to use within excel. The information is similar to what we have listed in the book but breaks it down just a little further.

Circular References

Spreadsheet Analysis

https://www.youtube.com/watch?v=vMveTKPR9gU This video helps explain how to use excel for queries in more details by going step by step. Jaclyn Mason

Section 12.3 Database Management Systems

https://www.youtube.com/watch?v=FR4QIeZaPeM Date posted: 4/11/2015 Date published: Jul 12, 2013 This video explains what a database management system is and the types of DBMS. Sudarshan T

https://www.youtube.com/watch?v=Q-PUoZA-VLA&list=PLnxBrInqFEs7DqOUljmVlgZ_xRRSsyesu&index=4 Date posted: Mar 21, 2014

http://www.brighthub.com/internet/web-development/articles/110654.aspx I chose this website because it broke down the various models in a very basic way. The definitions were easier to understand than in the book, I believe. Date Added: 11/13/2015 Zachary Brogna

This video helped me to understand databases and what a Database Management system is. https://www.youtube.com/watch?v=aR44FbeeFH8 This video gives the basic information of DMS. Posted April 4, 2013 Added April 11, 2015 by Leon Ngo

https://www.youtube.com/watch?v=6u2zsJOJ_GE This video gives all the information for someone who wants to know about Database Management Systems in a distinct way Date Published: September 24, 2013 Date Added: April 11, 2015 Zachary Zona

http://social.technet.microsoft.com/wiki/contents/articles/24236.importing-an-excel-spreadsheet-into-a-sql-server-database.aspx importing an excel spreadsheet into an SQL server.This website provides for the spreadsheet instruction in chapter 12 and correlates it to the SQL instruction in that chapter. Bob Lafrance

The Relational Model

Relationships

Structured Query Language

http://www.itl.nist.gov/div897/ctg/dm/sql_examples.htm This website helped me understand structured query language better. It provides examples and shows you how it is done. -Jess Krafft https://www.youtube.com/watch?v=mQ4D0drMrYI

http://www.sqlcourse.com/table.html This site teaches you the sign query language. It helped me to understand with better explanations than the text. -Nicole Berry

https://www.youtube.com/watch?v=44zAgV7zZi0 : Structured Query Language Tutorial. Date added: 12 April 2015. Date created: 4 November 2010. This video gives a basic introduction to SQL. It is the first in a series of CS videos. Olivia Giedymin.

http://www.sqlcourse.com/table.html I liked this website because it broke down each aspect of SQL on a different page with examples that made more sense than what the book says. Edited in 2015 Added: 11-17-15 ~Rebecca Sherr

SQL Structured Query Language https://www.youtube.com/watch?v=tOFyHyEjup8 posted on youtube March 3 2015 covers group by, union, except, natural joins, inner joins, outer join. Rebecca Peacott 3/24/2015

Queries

Modifying Database Content

Database Design

This video brings you through all the information and steps that deal with the entity relationship modeling. It shows definitions and examples explain in more detail about the process. I It helped me have a better understanding. - Steve Gannon

http://www3.ntu.edu.sg/home/ehchua/programming/sql/relational_database_design.html Date Added 11/14/15. Last Edited Sept. 2010. This link talks about the Relational Database Design. It goes over how this model came to be, what the objective of this design is, and the process of using this design. In the link briefly takes about each step of the process including how to define the purpose of the database, gather the data, specify the primary keys, how to organize tables, the different types of relationships between tables, and then how to refine and normalize the design. ~Caitlyn Lambert-Hutchinson

https://www.youtube.com/watch?v=vmFFEok91GU Date added 11/14/15. Date uploaded 7/30/14. This video focuses on database design using ER (entity-relationship) modeling. Calebthevideomaker on youtube has great tutorials and is always my first stop because they are simple and fun. After watching I had a better understanding of the concept and ER diagramming. Antoinette Cabral

Section 12.4 E-Commerce