CS 101/Additional Materials/Chapter 12

From Worcester State University Computer Science Department Wiki
< CS 101‎ | Additional Materials
Revision as of 13:59, 24 March 2016 by Karl Wurst (Talk | contribs) (Beginning clean up)

Jump to: navigation, search

Section 12.1 Managing Information

Section 12.2 Spreadsheets

Spreadsheet Formulas

Circular References

Spreadsheet Analysis

Section 12.3 Database Management Systems

The Relational Model

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


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 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://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


Database Management Systems

{{#ev:youtube|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

Database Management Systems

https://www.youtube.com/watch?v=Q-PUoZA-VLA&list=PLnxBrInqFEs7DqOUljmVlgZ_xRRSsyesu&index=4

Date posted: Mar 21, 2014

Database Management Systems

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.

{{#ev:youtube|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=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.


Introduction To Database Management Systems

{{#ev:youtube|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


Peter Doyle

Chapter 12 Information Systems

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.

Bob Lafrance Chapter 12 Information Systems

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.


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

Relational Database Design 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

Database Design {{#ev:youtube|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

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


SQL

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