cis130 intro to database

Task 4

Investigate how to design a Database

• • • • • • • • • • • • • Read Chapters 3, 4, & 5 of Beginning SQL Server 2012 for Developers
                        • Watch Lessons 3,4, & 5 in Foundations of Programming: Databases
                        • Read the Data Definition Language from http://www.w3schools.com/sql/. Complete the SQL Create DB through SQL Alter tutorials.

Then, based on reading chapters above as well as Data Definition Language in Step 1:

Explain what is Queries? What are they used for? How Database users benefit form Queries? Can we perform data manipulation on Queries to show and display data differently for certain things, fields? Please explain as much as possible about Queries from watching the video and reviewing the chapters above.

Submit a 2-3 pages of your results Document in WORD Format about Queries as above. Please submit in Word format.