Difference between revisions of "CS 101/Additional Materials/Chapter 12"

From Worcester State University Computer Science Department Wiki
Jump to: navigation, search
(Beginning clean up)
(Finished cleanup)
Line 1: Line 1:
 
== Section 12.1 Managing Information ==
 
== Section 12.1 Managing Information ==
  
== Section 12.2 Spreadsheets ==
+
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.
 
+
=== Spreadsheet Formulas ===
+
 
+
=== Circular References ===
+
 
+
=== Spreadsheet Analysis ===
+
 
+
== Section 12.3 Database Management Systems ==
+
 
+
=== The Relational Model ===
+
 
+
  
 +
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.
 
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
+
https://www.youtube.com/user/learnexcelfunctions -Matt Lanteigne
-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
+
  
---------------------------------------------------------------------------------------------------------------
+
=== Spreadsheet Formulas ===
;Database Management Systems
+
{{#ev:youtube|FR4QIeZaPeM}}
+
  
;Date posted: 4/11/2015
+
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.
;Date published: Jul 12, 2013
+
  
This video explains what a database management system is and the types of DBMS.
+
=== Circular References ===
  
;Sudarshan T
+
=== 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
Database Management Systems
+
  
https://www.youtube.com/watch?v=Q-PUoZA-VLA&list=PLnxBrInqFEs7DqOUljmVlgZ_xRRSsyesu&index=4
+
== Section 12.3 Database Management Systems ==
  
Date posted: Mar 21, 2014
+
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
  
===Database Management Systems===
+
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
+
  
 +
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.
+
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
  
{{#ev:youtube|aR44FbeeFH8}}
+
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
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
 
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
'''Peter Doyle
+
  
Chapter 12 Information Systems'''
+
=== The Relational Model ===
  
Spreadsheet Formulas
+
=== Relationships ===
  
http://deathbybloomingflowers.blogspot.com/2013/12/the-spreadsheet-tools.html
+
=== Structured Query Language ===
  
Date Accessed: 11/3/15
+
http://www.itl.nist.gov/div897/ctg/dm/sql_examples.htm
Date Published: 12/20/13
+
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
  
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.
+
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
  
'''Bob Lafrance'''
+
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.
Chapter 12 Information Systems
+
  
http://social.technet.microsoft.com/wiki/contents/articles/24236.importing-an-excel-spreadsheet-into-a-sql-server-database.aspx
+
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
  
importing an excel spreadsheet into an SQL server.
+
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
  
This website provides for the spreadsheet instruction in chapter 12 and correlates it to the SQL instruction in that chapter.
+
==== Queries ====
  
------------------------------------------------------------------------------------------------------------------------------------------
+
==== Modifying Database Content ====
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.
+
=== Database Design ===
  
Jaclyn Mason
+
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
  
'''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
 
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'''
+
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
{{#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
+
== Section 12.4 E-Commerce ==
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
+

Revision as of 08:27, 25 March 2016

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