Sql for dummies 8th edition pdf

ITC 4150, Database Design and Implementation 1

Course Description Comprehensive coverage of database systems design, development, and implementation. Examines the tools and techniques necessary in creating data models and subsequent database designs. Provides hands-on experience using diagramming tools.

Course Textbook Conger, S. (2014). Hands on database: An introduction to database design and development (2nd ed.). Upper Saddle

River, NJ: Pearson. The following ebook can be accessed in the ebrary database within the CSU Online Library: Taylor, A. G. (2013). SQL for Dummies (8th ed.). Hoboken, NJ: Wiley.

Course Software

 Drawing software is required in order to create some diagrams in this course. You can use the drawing tools in MS Visio, or you can use free open source diagramming software called Dia Diagraming Editor at http://sourceforge.net/projects/dia-installer/

 SQL Server is required in order to complete assignments in this course. SQL Server Express is a free program that can be downloaded from Microsoft. 1. Go to www.microsoft.com 2. Enter SQL Express in the search box. 3. Select SQL Server Express. 4. Follow the instructions to complete the appropriate installation that matches your operating system.

 Students with Microsoft Windows XP or Vista should use SQL Express 2012.

 Students with Microsoft Windows 7 or Windows 8 should use SQL Express 2014.

 Students with VisualBasic will need to download and install Management Studio.

 Macintosh users must have Windows installed in order to use the SQL software. More information can be found in Appendix B in the Hands on Database textbook. For additional information, click here for Frequently Asked Questions.

Course Learning Outcomes Upon completion of this course, students should be able to:

1. Examine the relevance and components of relational databases. 2. Create documentation throughout the database development lifecycle. 3. Identify business rules, entities, relationships, and attributes for a specific database scenario. 4. Create a logical and physical database design. 5. Demonstrate database normalization techniques. 6. Utilize Structured Query Language (SQL) to create and interact with a database. 7. Apply solutions to identified database security issues.

ITC 4150, Database Design and Implementation Course Syllabus

http://sourceforge.net/projects/dia-installer/
http://www.microsoft.com/
https://online.columbiasouthern.edu/CSU_Content/courses/Business/ITC/ITC4150/14J/FAQ_for_IT_Students_and_Faculty.pdf
ITC 4150, Database Design and Implementation 2

Credits Upon completion of this course, the students will earn three (3) hours of college credit.

Course Structure

1. Unit Learning Outcomes: Each unit contains Learning Outcomes that specify the measurable skills and knowledge students should gain upon completion of the unit.

2. Unit Lesson: Each unit contains a Unit Lesson, which discusses unit material. 3. Reading Assignments: Each unit contains Reading Assignments from one or more chapters from the textbook

or outside resource. Suggested Readings are listed in the in the unit study guides to aid students in their course of study. The readings themselves may or may not be provided in the course, but students are encouraged to read the resources listed if the opportunity arises as they have valuable information that expands upon the lesson material. Students will not be tested on their knowledge of the Suggested Readings. Chapter presentations are provided in each unit study guide as Suggested Reading to aid students in their course of study.

4. Learning Activities (Non-Graded): These non-graded Learning Activities are provided in Units I-VIII to aid students in their course of study.

5. Unit Assignments: Students are required to submit for grading Unit Assignments in Units I-VIII. Unit III contains two assignments. Specific information and instructions regarding these assignments are provided below. Grading rubrics are included with the Unit Assignments. Specific information about accessing these rubrics is provided below.

6. Ask the Professor: This communication forum provides you with an opportunity to ask your professor general or course content related questions.

7. Student Break Room: This communication forum allows for casual conversation with your classmates.

CSU Online Library The CSU Online Library is available to support your courses and programs. The online library includes databases, journals, e-books, and research guides. These resources are always accessible and can be reached through the library webpage. To access the library, log into the myCSU Student Portal, and click on “CSU Online Library.” You can also access the CSU Online Library from the “My Library” button on the course menu for each course in Blackboard. The CSU Online Library offers several reference services. E-mail (library@columbiasouthern.edu) and telephone (1.877.268.8046) assistance is available Monday – Thursday from 8 am to 5 pm and Friday from 8 am to 3 pm. The library’s chat reference service, Ask a Librarian, is available 24/7; look for the chat box on the online library page. Librarians can help you develop your research plan or assist you in finding relevant, appropriate, and timely information. Reference requests can include customized keyword search strategies, links to articles, database help, and other services.

Unit Assignments Unit I Project For this assignment, choose one of the first three scenarios from the end of Chapter 1 in your course textbook (on pages 17-18): “Wild Wood Apartments,” “Vince’s Vinyl,” or “Grandfield College.” (You will work on the scenario you choose throughout this course.) Do NOT choose the scenario titled “Westlake Research Hospital” because this scenario will act as an example throughout this course. Click here to review the suggested answer for this scenario to gain an understanding of what is expected of you on this assignment. Instructions:

1. Read your selected scenario on page 17 or 18. 2. Review the “Deliverables” section below. 3. Review the “Suggestions for Scenarios” section on page 19 of your textbook for important details and ideas to

assist you with your deliverables. 4. Review “The Statement of Work” section on pages 14-15. Use this as a model for your own statement of work.

mailto:library@columbiasouthern.edu
https://online.columbiasouthern.edu/CSU_Content/courses/Business/ITC/ITC4150/14J/Unit_I_Westlake_Hospital_Example.pdf
ITC 4150, Database Design and Implementation 3

5. When you have completed all of the deliverables, compress the files together into a single .zip file for upload. Contact your instructor if you have any questions.

Deliverables:

1. Major Topics: List the major topics for this database, and explain why each should be considered a major topic of the database.

2. Statement of Work: Write a draft statement of work. Include a brief history, a statement of scope, objectives, and a preliminary timeline.

Scenario Page Number for “To Do” List

Wild Wood Apartments Page 17-18

Vince’s Vinyl Page 18

Grandfield College Page 18

Information about accessing the Blackboard Grading Rubric for this assignment is provided below. Unit II Project For this assignment, you will continue to work with the scenario you chose from the end of Chapter 1. The initial scenarios are discussed on pages 17-18 of your textbook. (Again, the “Westlake Research Hospital” scenario will act as an example throughout this course.) Instructions:

1. Read your selected scenario on page 17 or 18. 2. Read your scenario for Chapter 2 on pages 37-45. 3. Review the “Deliverables” section below. 4. Review the “Suggestions for Scenarios” section on page 45 of your textbook for important details and ideas to

assist you with your deliverables. 5. Read the “Westlake Research Hospital” scenario on pages 18-19 and pages 41-45. Click here to review the

suggested answer for this scenario to gain an understanding of what is expected of you on this assignment. When you have completed all of the deliverables, compress the files together into a single .zip file for upload.

Deliverables:

1. Complete the tasks in the “To Do” section at the end of your scenario. The table below shows where you can find each “To Do” list:

2. Your scenario “To Do” list may ask you to meet with your instructor. That step is not required, although your instructor can provide feedback if you are interested.

Scenario Page Number for “To Do” List

Wild Wood Apartments Page 39

Vince’s Vinyl Page 40

Grandfield College Page 41

Unit III Project For this assignment, you will continue to work with the scenario you began in Chapters 1 and 2. The initial scenarios are discussed on pages 17-18 of your textbook and are continued on pages 40-43. (Again, the “Westlake Research Hospital” scenario will act as an example throughout this course.) Instructions:

1. Reread the introduction to your selected scenario on page 17 or 18 and the continuations on pages 37-41. 2. Read your scenario for Chapter 3 on pages 60-61. 3. Review the “Deliverables” section below. 4. Review the “Suggestions for Scenarios” section on page 61 of your textbook for important details and ideas to

assist you with your deliverables. 5. Read the “Westlake Research Hospital” scenario on page 18, pages 41-44, and page 61. Click here to review the

suggested answer for this scenario to gain an understanding of what is expected of you on this assignment.

https://online.columbiasouthern.edu/CSU_Content/courses/Business/ITC/ITC4150/14J/Unit_II_Westlake_Hospital_Example.pdf
https://online.columbiasouthern.edu/CSU_Content/courses/Business/ITC/ITC4150/14J/Unit_III_Westlake_Hospital_Example.pdf
ITC 4150, Database Design and Implementation 4

6. When you have completed all of the deliverables, compress the files together into a single .zip file for upload. Contact your instructor if you have any questions.

Deliverables:

1. Complete the tasks in the “To Do” section at the end of your scenario. The table below shows where you can find each list:

Scenario Page Number for “To Do” List

Wild Wood Apartments Page 60

Vince’s Vinyl Page 60-61

Grandfield College Page 61

Unit III Scholarly Activity Using the SQL for Dummies textbook in the CSU Online Library, refer to Table 3-4 “Types of Protection” on page 74 to create three scenarios in which the use of protection operations are used to secure a database. Describe the scenario, select which protection operations users should use in the scenario, and then explain your selection. Your paper should be three pages in length. All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations, and cited per APA guidelines. Unit IV Project For this assignment, you will continue to work with the scenario you began in Chapters 1-3. The initial scenarios are discussed on pages 17-18 of your textbook and continued on pages 37-41 and pages 60-61. (Again, the “Westlake Research Hospital” scenario will act as an example throughout this course.) Instructions:

1. Reread the introduction to your selected scenario on page 17 or 18 and the continuations on pages 37-41 and pages 60-61.

2. Read your scenario for Chapter 4 on pages 79-81. 3. Review the “Deliverables” section below. 4. Review the “Suggestion for Scenarios” section on page 81 of your textbook for important details and ideas to

assist you with your deliverables 5. Review Appendix D, Common Relational Patterns, on page 191 of your textbook. 6. Read the “Westlake Research Hospital” scenario on page 18, pages 41-45, page 61, and page 80. Click here to

review the suggested answer for this scenario to gain an understanding of what is expected of you on this assignment.

7. When you have completed all of the deliverables, compress the files together into a single .zip file for upload. Deliverables:

1. Complete the numbered tasks for your scenario. The table below shows where you can find each list: 2. Your scenario “To Do” list may ask you to review your work with another student or group. That step is not

required for this assignment.

Scenario Page Number for “To Do” List

Wild Wood Apartments Page 79

Vince’s Vinyl Page 79-80

Grandfield College Page 80

Unit V Project For this assignment, you will continue to work with the scenario you began in Chapters 1-4. The initial scenarios are discussed on pages 17-18 of your textbook and continued on pages 37-41, pages 60-61, and pages 79-80. (Again, the “Westlake Research Hospital” scenario will act as an example throughout this course.)

https://online.columbiasouthern.edu/CSU_Content/courses/Business/ITC/ITC4150/14J/Unit_IV_Westlake_Hospital_Example.pdf
ITC 4150, Database Design and Implementation 5

Instructions:

1. Reread the introduction to your selected scenario on page 17 or 18 and the continuations on pages 37-41, pages 60-61, and pages 79-80.

2. Read your scenario for Chapter 5 on pages 100-101. 3. Review the “Deliverables” section below. 4. Review the “Suggestions for Scenarios” section on page 101 of your textbook for important details and ideas to

assist you with your deliverables. 5. Read the “Westlake Research Hospital” scenario on page 18, pages 41-45, page 61, page 80, and page 101.

Click here to review the suggested answer for this scenario to gain an understanding of what is expected of you on this assignment.

6. When you have completed all of the deliverables, compress the files together into a single .zip file for upload. Deliverables:

1. Complete the numbered tasks in the “To Do” section for your scenario. The table below shows where you can find each list:

Scenario Page Number for “To Do” List

Wild Wood Apartments Page 100

Vince’s Vinyl Page 100

Grandfield College Page 101

Unit VI Project For this assignment, you will continue to work with the scenario you began in Chapters 1-5. Reread the information from each of these assignments at the end of each chapter. (Again, the “Westlake Research Hospital” scenario will act as an example throughout this course.) Instructions:

1. Reread your selected scenario at the end of all previous chapters. 2. Read your scenario for Chapter 6 on pages 123-124. 3. Review the “Deliverables” section below. 4. Review the “Suggestions for Scenarios” section on page 124 of your textbook for important details and ideas to

assist you with your deliverables. 5. Read the “Westlake Research Hospital” scenario on page 18, pages 41-45, page 61, page 80, page 101, and

page 124. Click here to review the suggested answer for this scenario to gain an understanding of what is expected of you on this assignment.

6. Your final deliverable will be a script file that you create from your database. To generate an SQL Script, right click on the database, go to TASKS on the context menu, and then GENERATE SCRIPTS. In the wizard you should change “Script Data” from “false” to “true” and then generate a script of the database you have built to turn in.

Deliverables:

1. Complete the numbered tasks in the “To Do” section for your scenario, EXCEPT number 6. You DO NOT need to create a data dictionary. The table below shows where you can find each list of tasks:

Scenario Page Number for “To Do” List

Wild Wood Apartments Page 123-124

Vince’s Vinyl Page 124

Grandfield College Page 124

Unit VII Project For this assignment, you will continue to work with the scenario you began in Chapters 1-6. Reread the information from each of these assignments at the end of each chapter. (Again, the “Westlake Research Hospital” scenario will act as an example throughout this course.)

https://online.columbiasouthern.edu/CSU_Content/courses/Business/ITC/ITC4150/14J/Unit_V_Westlake_Hospital_Example.pdf
https://online.columbiasouthern.edu/CSU_Content/courses/Business/ITC/ITC4150/14J/Unit_VI_Westlake_Hospital_Example.pdf
ITC 4150, Database Design and Implementation 6

Review the Textbook/Course Materials section of the syllabus and appendix B of your textbook for guidance on using the correct software programs. Instructions:

1. Reread the introduction to your selected scenario at the end of all previous chapters. 2. Read your scenario for Chapter 7 on page 155. 3. Review the “Deliverables” section below. 4. Review the “Suggestions for Scenarios” section on page 156 of your textbook for important details and ideas to

assist you with your deliverables. 5. Read the “Westlake Research Hospital” scenario on page 18, pages 41-45, page 61, page 80, page 101, page

124, and pages 155-156. Click here to review the suggested answer for this scenario to gain an understanding of what is expected of you on this assignment.

6. Your SQL queries should be created, tested, and then copied and pasted into a Word file to be submitted to your instructor. Contact your instructor if you have any questions.

Deliverables:

1. Review the scenario and complete the task for your given scenario. The table below shows where you can find each list of tasks:

Scenario Page Number for “To Do” List

Wild Wood Apartments Page 155

Vince’s Vinyl Page 155

Grandfield College Page 155

Unit VIII Project For this assignment, you will continue to work with the scenario you began in Chapters 1-7. Reread the information from each of these assignments at the end of each chapter. (Again, the “Westlake Research Hospital” scenario will act as an example throughout this course.) Instructions:

1. Reread your selected scenario at the end of all previous chapters. 2. Read your scenario for Chapter 7 on page 175 to 177. 3. Review the “Deliverables” section below. 4. Review the “Suggestions for Scenarios” section on page 177 of your textbook for important details and ideas to

assist you with your deliverables. 5. Read the “Westlake Research Hospital” scenario on page 18, pages 41-45, page 61, page 80, page 101, page

124, pages 155-156, and page 176. Click here to review the suggested answer for this scenario to gain an understanding of what is expected of you on this assignment.

6. When you have completed all of the deliverables, compress the files together into a single .zip file for upload. Contact your instructor if you have any questions.

Deliverables:

1. Complete the numbered tasks in the “To Do” section for your scenario. The table below shows where you can find each list of tasks:

Scenario Page Number for “To Do” List

Wild Wood Apartments Page 175-176

Vince’s Vinyl Page 176

Grandfield College Page 176

https://online.columbiasouthern.edu/CSU_Content/courses/Business/ITC/ITC4150/14J/Unit_VII_Westlake_Hospital_Example.pdf
https://online.columbiasouthern.edu/CSU_Content/courses/Business/ITC/ITC4150/14J/Unit_VIII_Westlake_Hospital_Example.pdf
ITC 4150, Database Design and Implementation 7

APA Guidelines The application of the APA writing style shall be practical, functional, and appropriate to each academic level, with the primary purpose being the documentation (citation) of sources. CSU requires that students use APA style for certain papers and projects. Students should always carefully read and follow assignment directions and review the associated grading rubric when available. Students can find CSU’s Citation Guide in the myCSU Student Portal by clicking on the “Citation Resources” link in the “Learning Resources” area. This document includes examples and sample papers and provides information on how to contact the CSU Success Center.

Grading Rubrics This course utilizes analytic grading rubrics as tools for your professor in assigning grades for all learning activities. Each rubric serves as a guide that communicates the expectations of the learning activity and describes the criteria for each level of achievement. In addition, a rubric is a reference tool that lists evaluation criteria and can help you organize your efforts to meet the requirements of that learning activity. It is imperative for you to familiarize yourself with these rubrics because these are the primary tools your professor uses for assessing learning activities. Rubric categories include: (1) Assessment (Written Response) and (2) Assignment. However, it is possible that not all of the listed rubric types will be used in a single course (e.g., some courses may not have Assessments). The Assessment (Written Response) rubric can be found embedded in a link within the directions for each Unit Assessment. However, these rubrics will only be used when written-response questions appear within the Assessment.

Each Assignment type (e.g., article critique, case study, research paper) will have its own rubric. The Assignment rubrics are built into Blackboard, allowing students to review them prior to beginning the Assignment and again once the Assignment has been scored. This rubric can be accessed via the Assignment link located within the unit where it is to be submitted. Students may also access the rubric through the course menu by selecting “Tools” and then “My Grades.” Again, it is vitally important for you to become familiar with these rubrics because their application to your Assessments and Assignments is the method by which your instructor assigns all grades.

Communication Forums These are non-graded discussion forums that allow you to communicate with your professor and other students. Participation in these discussion forums is encouraged, but not required. You can access these forums with the buttons in the Course Menu. Instructions for subscribing/unsubscribing to these forums are provided below. Once you have completed Unit VIII, you MUST unsubscribe from the forum; otherwise, you will continue to receive e-mail updates from the forum. You will not be able to unsubscribe after your course end date. Click here for instructions on how to subscribe/unsubscribe and post to the Communication Forums. Ask the Professor This communication forum provides you with an opportunity to ask your professor general or course content questions. Questions may focus on Blackboard locations of online course components, textbook or course content elaboration, additional guidance on assessment requirements, or general advice from other students. Questions that are specific in nature, such as inquiries regarding assessment/assignment grades or personal accommodation requests, are NOT to be posted on this forum. If you have questions, comments, or concerns of a non- public nature, please feel free to email your professor. Responses to your post will be addressed or emailed by the professor within 48 hours. Before posting, please ensure that you have read all relevant course documentation, including the syllabus, assessment/assignment instructions, faculty feedback, and other important information.

https://online.columbiasouthern.edu/CSU_Content/common_files/instructions/DB/Create_New_Thread_Subscribe.pdf
ITC 4150, Database Design and Implementation 8

Student Break Room This communication forum allows for casual conversation with your classmates. Communication on this forum should always maintain a standard of appropriateness and respect for your fellow classmates. This forum should NOT be used to share assessment answers.

Grading

Unit Projects (8 @ 11%) = 88% Unit III Scholarly Activity = 12% Total = 100%

Course Schedule/Checklist (PLEASE PRINT) The following pages contain a printable Course Schedule to assist you through this course. By following this schedule, you will be assured that you will complete the course within the time allotted.

ITC 4150, Database Design and Implementation 9

ITC 4150, Database Design and Implementation Course Schedule

By following this schedule, you will be assured that you will complete the course within the time allotted. Please keep this schedule for reference as you progress through your course.

Unit I An Introduction to Databases

Review:  Unit Study Guide  Learning Activities (Non-Graded): See Study Guide

Read:

Hands on Database:  Chapter 1: Who Needs a Database

SQL for Dummies:  Part I: Getting Started with SQL  Suggested Reading: See Study Guide

Submit:  Project

Notes/Goals:

Unit II The Data Behind the Database

Review:  Unit Study Guide  Learning Activities (Non-Graded): See Study Guide

Read: Hands on Database:

 Chapter 2: Gathering Information  Suggested Reading: See Study Guide

Submit:  Project

Notes/Goals:

Unit III Requirements and Business Rules

Review:  Unit Study Guide  Learning Activities (Non-Graded): See Study Guide

Read: Hands on Database:

 Chapter 3: Requirements and Business Rules  Suggested Reading: See Study Guide

Submit:  Project  Scholarly Activity

Notes/Goals:

ITC 4150, Database Design and Implementation 10

ITC 4150, Database Design and Implementation Course Schedule

Unit IV Database Design

Review:  Unit Study Guide  Learning Activities (Non-Graded): See Study Guide

Read:

Hands On Database:  Chapter 4: Database Design  Appendix C, pp. 188-190  Appendix D, pp. 191-194

SQL for Dummies:  Chapter 4: Building and Maintaining a Simple Database Structure  Suggested Reading: See Study Guide

Submit:  Project

Notes/Goals:

Unit V Normalization and Design Review

Review:  Unit Study Guide  Learning Activities (Non-Graded): See Study Guide

Read:

Hands on Database:  Chapter 5: Normalization and Design Review

SQL for Dummies:  Chapter 5: Building a Multitable Relational Database  Suggested Reading: See Study Guide

Submit:  Project

Notes/Goals:

Unit VI Physical Database

Review:  Unit Study Guide  Learning Activities (Non-Graded): See Study Guide

Read:

Hands on Database:  Chapter 6: Physical Design  Appendix A, pp. 178-184  Appendix B, pp. 185-187  Suggested Reading: See Study Guide

Submit:  Project

Notes/Goals:

ITC 4150, Database Design and Implementation 11

ITC 4150, Database Design and Implementation Course Schedule

Unit VII Structured Query Language (SQL)

Review:  Unit Study Guide  Learning Activities (Non-Graded): See Study Guide

Read: Hands on Database:

 Chapter 7: SQL  Suggested Reading: See Study Guide

Submit:  Project

Notes/Goals:

Unit VIII Database Security

Review:  Unit Study Guide  Learning Activities (Non-Activities): See Study Guide

Read:

Hands on Database:  Chapter 8: Is it Secure?

SQL for Dummies:  Chapter 14: Providing Database Security  Suggested Reading: See Study Guide

Submit:  Project

Notes/Goals: