for charandry only

itc.docx

Home >Information Systems homework help >for charandry only

Course Description

A 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.

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.

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. Discussion Boards: Discussion Boards are part of all CSU term courses. More information and specifications can be found in the Student Resources link listed in the Course Menu bar.

6. 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.

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

8. 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 ([email protected]) 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.

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.

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.)

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.)

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

ITC 4150, Database Design and Implementation 1