Proffessor 2013, Are you going to write Assignment 1: Business Rules and Data Models

cis111_student_guide.docx

Home >Human Resource Management homework help >Proffessor 2013, Are you going to write Assignment 1: Business Rules and Data Models

CIS 111 – Student Notes

(Prerequisite: CIS 105 or CIS 106 or CIS 109)

COURSE DESCRIPTION

This course provides the students with an introduction to the theory and applied concepts of database design, database management and information management. Students will focus on identifying organizational information requirements, express those requirements using conceptual data modeling techniques, verifying the structural characteristics with normalization techniques and convert conceptual data models into physical database models.

INSTRUCTIONAL MATERIALS

Required Resources

Coronel, C., Morris, S., & Rob, P. (2013). Database systems: Design, implementation, and management (10th ed.). Independence, KY: Cengage.

Microsoft Office and Microsoft Visio or their equivalents such as Open Office and Dia are required. Tutorials for Microsoft Office 2007 through 2013 can be found on Microsoft’s support site, located at http://office.microsoft.com/en-us/support/training-FX101782702.aspx.

EasyPHP and MySQL will be used for lab assignments in which tables and queries will be implemented. Students can purchase the EasyPHP and MySQL USB drive when they purchase new course materials from the Strayer University bookstore, located at http://www.strayerbookstore.com/, or download it at http://www.easyphp.org.

Note: The USB drive that students can purchase includes the necessary software installed and is ready to use. However, if students choose not to purchase the USB drive and elect to download it from http://www.easyphp.org, an installation instruction guide has been provided in the online course shell.

Supplemental Resources

Chao, L. (2014). Cloud Database Development and Management. Boca Raton, FL: Taylor & Francis Group.

Connolly, T. M., & Begg, C. E. (2010). Database Systems: A practical approach to design, implementation and management (5th ed.). Addison-Wesley.

MySQL. (2014). MySQL Workbench. Retrieved from http://dev.mysql.com/doc/workbench/en/index.html

COURSE LEARNING OUTCOMES

1. Describe the role of databases and database management systems in managing organizational data and information.

2. Recognize the historical development of database management systems and logical data models.

3. Recognize the basic file organization techniques.

4. Compose conceptual data modeling techniques to capture the information requirements.

5. Explain how data is physically stored and accessed.

6. Recognize the purpose and principles of normalizing a relational database structure.

7. Design a relational database so that it is at least in 3NF.

8. Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.

9. Demonstrate the basic mechanisms for accessing relational databases from various types of application development environments.

10. Summarize the difference between on-line transaction processing (OLTP) and online analytic processing (OLAP), and their relationship among business intelligence, data warehousing, and data mining.

11. Distinguish the role of databases and database management systems in the context of enterprise systems.

12. Describe the core concepts of data quality and their application in an organizational context.

13. Summarize how database systems support enterprise and Web-based applications.

14. Analyze the key principles of data security, and identify data security risk and violations in data management system design.

15. Evaluate the ethical concerns inherent in database management systems and how these concerns affect legislation or organizational policies.

16. Use technology and information resources to research issues in database systems.

17. Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

WEEKLY COURSE SCHEDULE

The standard requirement for a 4.5 credit hour course is for students to spend 13.5 hours in weekly work. This includes preparation, activities, and evaluation regardless of delivery mode.

Week

Preparation, Activities, and Evaluation

Points

Preparation

· Reading(s)

· Chapter 1: Database Systems

· Chapter 2: Data Models

· Video(s), accessible in the online course shell

· “Database Management System” (05 min 39 s)

· “Data Models” (02 min 05 s)

· “Data Model Basic Building Blocks” (03 min 30 s)

· “Business Rules” (04 min 08 s)

Activities

· Discussion

Evaluation

· None

Preparation

· Reading(s)

· Chapter 3: The Relational Database Model

· Video(s), accessible in the online course shell

· “Relational Database tables and their Characteristics” (03 min 13 s)

· “Relational Database Keys” (01 min 48 s)

Activities

· Discussion

Evaluation

· Assignment 1: Business Rules and Data Models

100

Preparation

· Reading(s)

· Chapter 4: Entity Relationship (ER) Modeling

· Video(s), accessible in the online course shell

· “Entity Relationship Diagrams Part 1” (03 min 46 s)

· “Entity Relationship Diagrams Part 2” (01 min 19 s)

· “Entity Relationship Diagrams Part 3” (03 min 54 s)

· “Entity Relationship Diagrams Part 4” (02 min 13 s)

· “Entity Relationship Diagrams Part 5” (01 min 19 s)

· “Entity Relationship Diagrams” (08 min 06 s)

· “Entity Relationship Diagrams” (05 min 48 s)

· “Entity Relationship Diagrams” (01 min 29 s)

Activities

· Discussion

Evaluation

· Lab 1: Creating a Database Design in Visio

Preparation

· Reading(s)

· Chapter 6: Normalization of Database Tables

· Video(s), accessible in the online course shell

· “Normalization of Database Tables” (10 min 44 s)

· “Improving the Design” (08 min 34 s)

Activities

· Discussion

Evaluation

· Lab 2: Modifying a Database Design in Visio

Preparation

· Reading(s)

· Chapter 7: Introduction to Structured Query Language

· Video(s), accessible in the online course shell

· “Structured Query Language (SQL)” (03 min 44 s)

· “Structured Query Language (SQL)” (03 min 51 s)

· “Structured Query Language (SQL)” (04 min 38 s)

Activities

· Discussion

Evaluation

· Lab 3: EasyPHP and MySQL Setup

· Midterm Exam: Chapters 1, 2, 3, 4, and 6

100

Preparation

· Reading(s)

· Chapter 8: Advanced SQL (Sections 8.1, 8.4, and 8.7 only)

· Chapter 9: Database Design (Sections 9.1 through 9.7 only)

· Video(s), accessible in the online course shell

· “SQL Set Operators” (06 min 13 s)

· “Database Design: Conceptual Design” (14 min 15 s)

Activities

· Discussion

Evaluation

· Assignment 2: Normalization

100

Preparation

· Reading(s)

· Chapter 10: Transaction Management and Concurrency Control

· Video(s), accessible in the online course shell

· “Transaction Management” (05 min 35 s)

Activities

· Discussion

Evaluation

· Lab 4: Structured Query Language (SQL)

Preparation

· Reading(s)

· Chapter 13: Business Intelligence and Data Warehouses

· Video(s), accessible in the online course shell

· “Introduction to Data Warehouses” (05 min 27 s)

· e-Activity

· Review one (1) of the following case studies, and be prepared to discuss.

· “343 Industries: 343 Industries Gets New User Insights from Big Data in the Cloud”, located in the online course shell and on the Web at http://www.microsoft.com/casestudies/Case_Study_Detail.aspx?CaseStudyID=710000002102.

· “Klout: Data Services Firm Uses Microsoft BI and Hadoop to Boost Insight into Big Data”, located in the online course shell and on the Web at http://www.microsoft.com/casestudies/Microsoft-SQL-Server-2012-Enterprise/Klout/Data-Services-Firm-Uses-Microsoft-BI-and-Hadoop-to-Boost-Insight-into-Big-Data/710000000129.

· “Yahoo!: Yahoo! Improves Campaign Effectiveness, Boosts Ad Revenue with Big Data Solution”, located in the online course shell and on the Web at http://www.microsoft.com/casestudies/Microsoft-SQL-Server-2012-Enterprise/Yahoo/Yahoo-Improves-Campaign-Effectiveness-Boosts-Ad-Revenue-with-Big-Data-Solution/710000001707.

· “Department of Special Investigation: Thai Law Enforcement Agency Optimizes Investigations with Big Data Solution”, located in the online course shell and on the Web at http://www.microsoft.com/casestudies/Microsoft-SQL-Server-2012-Enterprise/Department-of-Special-Investigation/Thai-Law-Enforcement-Agency-Optimizes-Investigations-with-Big-Data-Solution/710000001175.

Activities

· Discussion

Evaluation

· None

Preparation

· Reading(s)

· Chapter 14: Database Connectivity and Web Technologies

· Video(s), accessible in the online course shell

· “Cloud Computing Services” (05 min 38 s)

· “ColdFusion Web Contents Demo” (05 min 03 s)

· “ColdFusion Web Contents Demo” (04 min 12 s)

· e-Activities

· Visit Amazon’s Website located at http://aws.amazon.com/ec2/, and read about the Amazon EC2 cloud solution. Be prepared to discuss the ways in which EC2 provides services to customers.

· Visit Microsoft Azure’s Website located at http://www.windowsazure.com/en-us/, and read about the ways in which Azure provides services to customers. Be prepared to discuss.

· Visit Microsoft Office’s 365 Website located at http://office.microsoft.com/en-us/business/office-365-small-business-premium-office-online-FX103037625.aspx, and read the ways in which Office 365 provides services for business. Be prepared to discuss.

Activities

· Discussion

Evaluation

· Assignment 3: Business Intelligence and Data Warehouses

100

Preparation

· Reading(s)

· Chapter 15: Database Administration and Security

· Video(s), accessible in the online course shell

· “Database Administration” (02 min 36 s)

· “Installing the MS SQL Server RDBMS” (03 min 02 s)

· “Creating Student Accounts in MS SQL Server” (05 min 33 s)

· “Installing the Oracle 9i RDBMS” (04 min 37 s)

· “Creating Student Accounts in Oracle 9i” (04 min 55 s)

Activities

· Discussions

Evaluation

· None

Preparation

· Reading(s): None

Activities

· Discussion

Evaluation

· Final Exam: Chapters 7, 8 (Sections 8.1, 8.4, and 8.7 only), 9 (Sections 9.1 through 9.7 only),10, 13, 14, and 15

100

GRADING SCALE – UNDERGRADUATE

Assignment	Total Points	% of Grade
Lab 1: Creating a Database Design in Visio	75	7.5%
Lab 2: Modifying a Database Design in Visio	75	7.5%
Lab 3: EasyPHP and MySQL Setup	75	7.5%
Lab 4: Structured Query Language (SQL)	75	7.5%
Assignment 1: Business Rules and Data Models	100	10%
Assignment 2: Normalization	100	10%
Assignment 3: Business Intelligence and Data Warehouses	100	10%
Midterm Exam (Chapters 1, 2, 3, 4, and 6)	100	10%
Final Exam (Chapters 7, 8 [Sections 8.1, 8.4, and 8.7 only], 9 [Sections 9.1 through 9.7 only], 10, 13, 14, and 15)	100	10%
Tests are open book with a 2-hour time limit and may contain multiple choice, true / false, and essay questions.
Participation (10 discussions worth 20 points apiece,) Note: Week 11 discussion is not graded.	200	20%
Totals	1,000	100%

Points	Percentage	Grade
900 – 1,000	90% – 100%	A
800 – 899	80% – 89%	B
700 – 799	70% – 79%	C
600 – 699	60% – 69%	D
Below 600	Below 60%	F

Writing Assignments

The objective of the School of Information Systems’ writing assignments is to promote attitudes and skills that will improve a student’s ability to communicate in writing, develop research skills and documentation techniques, and encourage critical analysis of data and conclusions specific to the course learning outcomes in the information systems and technology domain.

CIS 111 – Introduction to Relational Database Management Systems

© 2014 Strayer University. All Rights Reserved. This document contains Strayer University Confidential and Proprietary information and may not be copied, further distributed, or otherwise disclosed in whole or in part, without the expressed written permission of Strayer University.

CIS 111 Student Version 1144 (1018 3-20-2014) Final Page 1 of 3

Assignment 1: Business Rules and Data Models

Due Week 2 and worth 100 points

Suppose a local college has tasked you to develop a database that will keep track of students and the courses that they have taken. In addition to tracking the students and courses, the client wants the database to keep track of the instructors teaching each of the courses.

Use the internet to research the types of information that a college would want to track in a database. Focus your attention on information that could represent entities within a database as well as attributes of such entities.

Write a two to three (2-3) page paper in which you:

1. Describe the purpose of the database.

2. Based on your research and / or common knowledge of a college and the information tracked by a college, describe the entities of the database and the attributes of each entity.

3. Based on your research and / or common knowledge of a college and the information tracked by a college, describe the business rules that could impact the structure of the database.

4. Determine the information that the conceptual model of the database would include and determine the information that the physical model of the database would include.

Your assignment must follow these formatting requirements:

· Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.

· Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

· Describe the role of databases and database management systems in managing organizational data and information.

· Compose conceptual data modeling techniques to capture the information requirements.

· Use technology and information resources to research issues in database systems.

· Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 100	Assignment 1: Business Rules and Data Models
Criteria	Unacceptable Below 60% F	Meets Minimum Expectations 60-69% D	Fair 70-79% C	Proficient 80-89% B	Exemplary 90-100% A
1. Describe the purpose of the database. Weight: 15%	Did not submit or incompletely described the purpose of the database.	Insufficiently described the purpose of the database.	Partially described the purpose of the database.	Satisfactorily described the purpose of the database.	Thoroughly described the purpose of the database.
2. Describe the entities of the database and the attributes of each entity, based on your research and / or common knowledge of a college and the information tracked by a college. Weight: 25%	Did not submit or incompletely described the entities of the database and the attributes of each entity, based on your research and / or common knowledge of a college and the information tracked by a college.	Insufficiently described the entities of the database and the attributes of each entity, based on your research and / or common knowledge of a college and the information tracked by a college.	Partially described the entities of the database and the attributes of each entity, based on your research and / or common knowledge of a college and the information tracked by a college.	Satisfactorily described the entities of the database and the attributes of each entity, based on your research and / or common knowledge of a college and the information tracked by a college.	Thoroughly described the entities of the database and the attributes of each entity, based on your research and / or common knowledge of a college and the information tracked by a college.
3. Describe the business rules that could impact the structure of the database, based on your research and / or common knowledge of a college and the information tracked by a college. Weight: 25%	Did not submit or incompletely described the business rules that could impact the structure of the database, based on your research and / or common knowledge of a college and the information tracked by a college.	Insufficiently described the business rules that could impact the structure of the database, based on your research and / or common knowledge of a college and the information tracked by a college.	Partially described the business rules that could impact the structure of the database, based on your research and / or common knowledge of a college and the information tracked by a college.	Satisfactorily described the business rules that could impact the structure of the database, based on your research and / or common knowledge of a college and the information tracked by a college.	Thoroughly described the business rules that could impact the structure of the database, based on your research and / or common knowledge of a college and the information tracked by a college.
4. Determine the information that the conceptual model of the database would include and determine the information that the physical model of the database would include. Weight: 25%	Did not submit or incompletely determined the information that the conceptual model of the database would include and did not submit or incompletely determined the information that the physical model of the database would include.	Insufficiently determined the information that the conceptual model of the database would include and insufficiently determined the information that the physical model of the database would include.	Partially determined the information that the conceptual model of the database would include and partially determined the information that the physical model of the database would include.	Satisfactorily determined the information that the conceptual model of the database would include and satisfactorily determined the information that the physical model of the database would include.	Thoroughly determined the information that the conceptual model of the database would include and thoroughly determined the information that the physical model of the database would include.
5. Clarity, writing mechanics, and formatting requirements Weight: 10%	More than 8 errors present	7-8 errors present	5-6 errors present	3-4 errors present	0-2 errors present

Lab 1: Creating a Database Design in Visio

Due Week 3 and worth 75 points

This assignment contains two (2) Sections: Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment.

Use “Appendix A: Designing Databases with Visio Professional: A Tutorial,” located in the online course shell to help you complete Section 1: Visio Database Design. (Note: This tutorial focuses on the use of Microsoft Visio. Open source applications are not covered in Appendix A; however, the use of open source applications within labs is permitted.)

Use the scenario from Assignment 1: Business Rules and Data Models to complete the lab:

Section 1: Visio Diagram

(Microsoft Visio or equivalent)

1. Use Microsoft Visio (or open source equivalent) in which you:

a. Create a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).

Section 1 of your assignment must follow these formatting requirements:

· Submit the Visio diagram as a Visio file.

Section 2: Design Summary

(Microsoft Word or equivalent)

2. Write a one (1) page paper in which you:

a. Discuss the degree to which you believe the Visio diagram reflects the database design.

Section 2 of your assignment must follow these formatting requirements:

· Submit the design summary as a Microsoft Word file.

· Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page is not included in the required assignment page length.

The specific course learning outcomes associated with this assignment are:

· Describe the role of databases and database management systems in managing organizational data and information.

· Compose conceptual data modeling techniques to capture the information requirements.

· Use technology and information resources to research issues in database systems.

· Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 75	Lab 1: Creating a Database Design in Visio
Criteria	Unacceptable Below 60% F	Meets Minimum Expectations 60-69% D	Fair 70-79% C	Proficient 80-89% B	Exemplary 90-100% A
1a. Create a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors). Weight: 60%	Did not submit or incompletely created a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).	Insufficiently created a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).	Partially created a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).	Satisfactorily created a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).	Thoroughly created a database diagram with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).
2a. Discuss the degree to which you believe the Visio diagram reflects the database design. Weight: 30%	Did not submit or incompletely discussed the degree to which you believe the Visio diagram reflects the database design.	Insufficiently discussed the degree to which you believe the Visio diagram reflects the database design.	Partially discussed the degree to which you believe the Visio diagram reflects the database design.	Satisfactorily discussed the degree to which you believe the Visio diagram reflects the database design.	Thoroughly discussed the degree to which you believe the Visio diagram reflects the database design.
3. Clarity, writing mechanics, and formatting requirements Weight: 10%	More than 8 errors present	7-8 errors present	5-6 errors present	3-4 errors present	0-2 errors present

Lab 2: Modifying a Database Design in Visio

Due Week 4 and worth 75 points

This assignment contains two (2) Sections: Modified Visio Diagram and Design Summary. You must submit both sections as separate files in order to complete this assignment.

Use “Appendix A: Designing Databases with Visio Professional: A Tutorial,” located in the online course shell to help you complete Section 1: Modified Visio Database Design. (Note: This tutorial focuses on the use of Microsoft Visio. Open source applications are not covered in Appendix A. However, the use of open source applications within labs is permitted.)

After reviewing your database design from Lab 1: Creating a Database Design in Visio, the college has provided more information for the database that they want developed:

· For each student, the college needs to track the student ID, student names, addresses, start date, phone numbers and types (such as mobile, home, work), email addresses and types (such as personal, school, work), gender, and birth date.

· For each course, the college needs to track the course ID, course name, department, quarters offered, sections, and instructor teaching each course.

· For each instructor, the college needs to track the instructor ID, name, address, phone numbers and types (such as mobile, home, work), email addresses and types (such as personal, school, work), gender, birth date, and the courses that each instructor is qualified to teach.

· Additionally, the college needs to track the final grades for each student after each course has completed.

Section 1: Modified Visio Diagram

(Microsoft Visio or equivalent)

1. Use Microsoft Visio (or open source equivalent) in which you:

a. Modify the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).

b. Create the appropriate relationships between each entity within the diagram.

Section 1 of your assignment must follow these formatting requirements:

· Submit the Visio diagram as a Visio file.

Section 2: Design Summary

(Microsoft Word or equivalent)

2. Write a one to two (1-2) page paper in which you:

a. Discuss the degree to which you believe the Visio diagram reflects the database design.

b. Describe any assumptions that you had to make about the business rules to in order to create the Visio diagram and the associated relationships.

Section 2 of your assignment must follow these formatting requirements:

· Submit the design summary as a Microsoft Word file.

The specific course learning outcomes associated with this assignment are:

· Describe the role of databases and database management systems in managing organizational data and information.

· Recognize the historical development of database management systems and logical data models.

· Compose conceptual data modeling techniques to capture the information requirements.

· Use technology and information resources to research issues in database systems.

· Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 75	Lab 2: Modifying a Database Design in Visio
Criteria	Unacceptable Below 60% F	Meets Minimum Expectations 60-69% D	Fair 70-79% C	Proficient 80-89% B	Exemplary 90-100% A
1a. Modify the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors). Weight: 30%	Did not submit or incompletely modified the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).	Insufficiently modified the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).	Partially modified the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).	Satisfactorily modified the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).	Thoroughly modified the database diagram from Lab 1 with the entities and attributes that the scenario identified (i.e., a college tracking students, courses, and instructors).
1b. Create the appropriate relationships between each entity within the diagram. Weight: 30%	Did not submit or incompletely created the appropriate relationships between each entity within the diagram.	Insufficiently created the appropriate relationships between each entity within the diagram.	Partially created the appropriate relationships between each entity within the diagram.	Satisfactorily created the appropriate relationships between each entity within the diagram.	Thoroughly created the appropriate relationships between each entity within the diagram.
2a. Discuss the degree to which you believe the Visio diagram reflects the database design. Weight: 15%	Did not submit or incompletely discussed the degree to which you believe the Visio diagram reflects the database design.	Insufficiently discussed the degree to which you believe the Visio diagram reflects the database design.	Partially discussed the degree to which you believe the Visio diagram reflects the database design.	Satisfactorily discussed the degree to which you believe the Visio diagram reflects the database design.	Thoroughly discussed the degree to which you believe the Visio diagram reflects the database design.
2b. Describe any assumptions that you had to make about the business rules to in order to create the Visio diagram and the associated relationships. Weight: 15%	Did not submit or incompletely described any assumptions that you had to make about the business rules to in order to create the Visio diagram and the associated relationships.	Insufficiently described any assumptions that you had to make about the business rules to in order to create the Visio diagram and the associated relationships.	Partially described any assumptions that you had to make about the business rules to in order to create the Visio diagram and the associated relationships.	Satisfactorily described any assumptions that you had to make about the business rules to in order to create the Visio diagram and the associated relationships.	Thoroughly described any assumptions that you had to make about the business rules to in order to create the Visio diagram and the associated relationships.
3. Clarity, writing mechanics, and formatting requirements Weight: 10%	More than 8 errors present	7-8 errors present	5-6 errors present	3-4 errors present	0-2 errors present

Lab 3: EasyPHP and MySQL Setup

Due Week 5 and worth 75 points

· Install EasyPHP and MySQL and take a screen shot that shows the MySQL prompt on your screen. (Note: You must include the screen shot which shows that MySQL is installed on your computer as part of your assignment. An installation guide to aid the installation of EasyPHP and MySQL is located in the online course shell.)

· Research the capabilities of MySQL.

Write a one to two (1-2) page paper in which you:

1. Describe your experiences related to your setup of MySQL. Include any difficulties or issues that you had encountered during the installation.

2. Based on your post-installation research, describe the main capabilities of MySQL.

3. Describe the approach that you would take to go from a conceptual or logical model that you created in Visio to the implementation of that database structure in MySQL. Determine the additional information that you will need to implement the database design in a database management system.

4. Include the screen shot which shows that MySQL is installed on your computer.

Your assignment must follow these formatting requirements:

The specific course learning outcomes associated with this assignment are:

· Describe the role of databases and database management systems in managing organizational data and information.

· Recognize the historical development of database management systems and logical data models.

· Use technology and information resources to research issues in database systems.

· Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 75	Lab 3: EasyPHP and MySQL Setup
Criteria	Unacceptable Below 60% F	Meets Minimum Expectations 60-69% D	Fair 70-79% C	Proficient 80-89% B	Exemplary 90-100% A
1. Describe your experiences related to your setup of MySQL. Include any difficulties or issues that you had encountered during the installation. Weight: 15%	Did not submit or incompletely described your experiences related to your setup of MySQL. Did not submit or incompletely included any difficulties or issues that you had encountered during the installation.	Insufficiently described your experiences related to your setup of MySQL. Insufficiently included any difficulties or issues that you had encountered during the installation.	Partially described your experiences related to your setup of MySQL. Partially included any difficulties or issues that you had encountered during the installation.	Satisfactorily described your experiences related to your setup of MySQL. Satisfactorily included any difficulties or issues that you had encountered during the installation.	Thoroughly described your experiences related to your setup of MySQL. Thoroughly included any difficulties or issues that you had encountered during the installation.
2. Describe the main capabilities of MySQL, based on your post-installation research. Weight: 30%	Did not submit or incompletely described the main capabilities of MySQL, based on your post-installation research.	Insufficiently described the main capabilities of MySQL, based on your post-installation research.	Partially described the main capabilities of MySQL, based on your post-installation research.	Satisfactorily described the main capabilities of MySQL, based on your post-installation research.	Thoroughly described the main capabilities of MySQL, based on your post-installation research.
3. Describe the approach that you would take to go from a conceptual or logical model that you created in Visio to the implementation of that database structure in MySQL. Determine the additional information that you will need to implement the database design in a database management system. Weight: 30%	Did not submit or incompletely described the approach that you would take to go from a conceptual or logical model that you created in Visio to the implementation of that database structure in MySQL. Did not submit or incompletely determined the additional information that you will need to implement the database design in a database management system.	Insufficiently described the approach that you would take to go from a conceptual or logical model that you created in Visio to the implementation of that database structure in MySQL. Insufficiently determined the additional information that you will need to implement the database design in a database management system.	Partially described the approach that you would take to go from a conceptual or logical model that you created in Visio to the implementation of that database structure in MySQL. Partially determined the additional information that you will need to implement the database design in a database management system.	Satisfactorily described the approach that you would take to go from a conceptual or logical model that you created in Visio to the implementation of that database structure in MySQL. Satisfactorily determined the additional information that you will need to implement the database design in a database management system.	Thoroughly described the approach that you would take to go from a conceptual or logical model that you created in Visio to the implementation of that database structure in MySQL. Thoroughly determined the additional information that you will need to implement the database design in a database management system.
4. Include the screen shot which shows that MySQL is installed on your computer. Weight: 15%	Did not submit or incompletely included the screen shot which shows that MySQL is installed on your computer.	Insufficiently included the screen shot which shows that MySQL is installed on your computer.	Partially included the screen shot which shows that MySQL is installed on your computer.	Satisfactorily included the screen shot which shows that MySQL is installed on your computer.	Thoroughly included the screen shot which shows that MySQL is installed on your computer.
5. Clarity, writing mechanics, and formatting requirements Weight: 10%	More than 8 errors present	7-8 errors present	5-6 errors present	3-4 errors present	0-2 errors present

Assignment 2: Normalization

Due Week 6 and worth 100 points

Suppose that you are the database developer for a local college. The Chief Information Officer (CIO) has asked you to provide a summary of normalizing database tables that the IT staff will use in the upcoming training session.

Write a two to three (2-3) page paper in which you:

1. Describe the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form.

2. Provide one (1) example that is relevant to a college environment that illustrates reasons for converting database tables to the First, Second, and Third Normal Forms.

3. Explain typical situations when denormalizing a table is acceptable. Provide one (1) example of denormalizing a database table to justify your response.

4. Explain the significant manner in which business rules impact both database normalization and the decision to denormalize database tables.

5. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

The specific course learning outcomes associated with this assignment are:

· Recognize the purpose and principles of normalizing a relational database structure.

· Design a relational database so that it is at least in 3NF.

· Use technology and information resources to research issues in database systems.

· Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 100	Assignment 2: Normalization
Criteria	Unacceptable Below 60% F	Meets Minimum Expectations 60-69% D	Fair 70-79% C	Proficient 80-89% B	Exemplary 90-100% A
1. Describe the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form. Weight: 21%	Did not submit or incompletely described the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form.	Insufficiently described the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form.	Partially described the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form.	Satisfactorily described the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form.	Thoroughly described the steps that you would use in order to convert database tables to the First Normal Form, the Second Normal Form, and the Third Normal Form.
2. Provide one (1) example that is relevant to a college environment that illustrates reasons for converting database tables to the First, Second, and Third Normal Forms. Weight: 21%	Did not submit or incompletely provided one (1) example that is relevant to a college environment that illustrates reasons for converting database tables to the First, Second, and Third Normal Forms.	Insufficiently provided one (1) example that is relevant to a college environment that illustrates reasons for converting database tables to the First, Second, and Third Normal Forms.	Partially provided one (1) example that is relevant to a college environment that illustrates reasons for converting database tables to the First, Second, and Third Normal Forms.	Satisfactorily provided one (1) example that is relevant to a college environment that illustrates reasons for converting database tables to the First, Second, and Third Normal Forms.	Thoroughly provided one (1) example that is relevant to a college environment that illustrates reasons for converting database tables to the First, Second, and Third Normal Forms.
3. Explain typical situations when denormalizing a table is acceptable. Provide one (1) example of denormalizing a database table to justify your response. Weight: 21%	Did not submit or incompletely explained typical situations when denormalizing a table is acceptable. Did not submit or incompletely provided one (1) example of denormalizing a database table to justify your response.	Insufficiently explained typical situations when denormalizing a table is acceptable. Insufficiently provided one (1) example of denormalizing a database table to justify your response.	Partially explained typical situations when denormalizing a table is acceptable. Partially provided one (1) example of denormalizing a database table to justify your response.	Satisfactorily explained typical situations when denormalizing a table is acceptable. Satisfactorily provided one (1) example of denormalizing a database table to justify your response.	Thoroughly explained typical situations when denormalizing a table is acceptable. Thoroughly provided one (1) example of denormalizing a database table to justify your response.
4. Explain the significant manner in which business rules impact both database normalization and the decision to denormalize database tables. Weight: 21%	Did not submit or incompletely explained the significant manner in which business rules impact both database normalization and the decision to denormalize database tables.	Insufficiently explained the significant manner in which business rules impact both database normalization and the decision to denormalize database tables.	Partially explained the significant manner in which business rules impact both database normalization and the decision to denormalize database tables.	Satisfactorily explained the significant manner in which business rules impact both database normalization and the decision to denormalize database tables.	Thoroughly explained the significant manner in which business rules impact both database normalization and the decision to denormalize database tables.
5. 3 references Weight: 6%	No references provided	Does not meet the required number of references; all references poor quality choices.	Does not meet the required number of references; some references poor quality choices.	Meets number of required references; all references high quality choices.	Exceeds number of required references; all references high quality choices.
6. Clarity, writing mechanics, and formatting requirements Weight: 10%	More than 8 errors present	7-8 errors present	5-6 errors present	3-4 errors present	0-2 errors present

Lab 4: Structured Query Language (SQL)

Due Week 7 and worth 75 points

Refer to the database design crested in Lab 2: Modifying a Database Design in Visio to complete this Lab.

Perform the following steps in MySQL:

1. Create the tables and relationships from the database design discussed in Lab 2.

2. Add at least five (5) records into each table (Note: You must determine the field values).

3. Create a query with all fields from the student table, where the student's last name is "Smith".

4. Create a query that includes students’ first names, last names, and phone numbers.

5. Create a query that includes instructors' first names, last names, and courses they teach.

Include the following screen shots in a Microsoft Word document to show the completion of the steps above:

· Screen shot depicting the tables created within MySQL.

· Screen shots depicting the records added into each table.

· Screen shots depicting the SQL code and the query results from each of the queries created.

Your assignment must follow these formatting requirements:

· Submit the lab as a Microsoft Word document.

The specific course learning outcomes associated with this assignment are:

· Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.

Grading for this assignment will be based on the creation of the tables and queries, using the following rubric.

Points: 75	Lab 4: Structured Query Language (SQL)
Criteria	Unacceptable Below 60% F	Meets Minimum Expectations 60-69% D	Fair 70-79% C	Proficient 80-89% B	Exemplary 90-100% A
1. Create the tables and relationships from the database design discussed in Lab 2. Weight: 25%	Did not submit or incompletely created the tables and relationships from the database design discussed in Lab 2.	Insufficiently created the tables and relationships from the database design discussed in Lab 2.	Partially created the tables and relationships from the database design discussed in Lab 2.	Satisfactorily created the tables and relationships from the database design discussed in Lab 2.	Thoroughly created the tables and relationships from the database design discussed in Lab 2.
2. Add at least five (5) records into each table (Note: You must determine the field values). Weight: 20%	Did not submit or incompletely added at least five (5) records into each table (Note: You must determine the field values).	Insufficiently added at least five (5) records into each table (Note: You must determine the field values).	Partially added at least five (5) records into each table (Note: You must determine the field values).	Satisfactorily added at least five (5) records into each table (Note: You must determine the field values).	Thoroughly added at least five (5) records into each table (Note: You must determine the field values).
3. Create a query with all fields from the student table, where the student's last name is "Smith". Weight: 15%	Did not submit or incompletely created a query with all fields from the student table, where the student's last name is "Smith".	Insufficiently created a query with all fields from the student table, where the student's last name is "Smith".	Partially created a query with all fields from the student table, where the student's last name is "Smith".	Satisfactorily created a query with all fields from the student table, where the student's last name is "Smith".	Thoroughly created a query with all fields from the student table, where the student's last name is "Smith".
4. Create a query that includes students’ first names, last names, and phone numbers. Weight: 15%	Did not submit or incompletely created a query that includes students’ first names, last names, and phone numbers.	Insufficiently created a query that includes students’ first names, last names, and phone numbers.	Partially created a query that includes students’ first names, last names, and phone numbers.	Satisfactorily created a query that includes students’ first names, last names, and phone numbers.	Thoroughly created a query that includes students’ first names, last names, and phone numbers.
5. Create a query that includes instructors' first names, last names, and courses they teach. Weight: 15%	Did not submit or incompletely created a query that includes instructors' first names, last names, and courses they teach.	Insufficiently created a query that includes instructors' first names, last names, and courses they teach.	Partially created a query that includes instructors' first names, last names, and courses they teach.	Satisfactorily created a query that includes instructors' first names, last names, and courses they teach.	Thoroughly created a query that includes instructors' first names, last names, and courses they teach.
6. Clarity, writing mechanics, and formatting requirements Weight: 10%	More than 8 errors present	7-8 errors present	5-6 errors present	3-4 errors present	0-2 errors present

Assignment 3: Business Intelligence and Data Warehouses

Due Week 9 and worth 100 points

Businesses today are extremely reliant on large amounts of data for making intelligent business decisions. Likewise, the data warehouses are often structured in a manner that optimizes processing large amounts of data.

Write a two to three (2-3) page paper in which you:

1. Outline the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data.

2. Outline the main differences between database requirements for operational data and for decision support data.

3. Describe three (3) examples in which databases could be used to support decision making in a large organizational environment.

4. Describe three (3) examples in which data warehouses and data mining could be used to support data processing and trend analysis in large organizational environment.

5. Use at least three (3) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:

The specific course learning outcomes associated with this assignment are:

· Describe the role of databases and database management systems in managing organizational data and information.

· Distinguish the role of databases and database management systems in the context of enterprise systems.

· Use technology and information resources to research issues in database systems.

· Write clearly and concisely about relational database management systems using proper writing mechanics and technical style conventions.

Grading for this assignment will be based on answer quality, logic / organization of the paper, and language and writing skills, using the following rubric.

Points: 100	Assignment 3: Business Intelligence and Data Warehouses
Criteria	Unacceptable Below 60% F	Meets Minimum Expectations 60-69% D	Fair 70-79% C	Proficient 80-89% B	Exemplary 90-100% A
1. Outline the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data. Weight: 21%	Did not submit or incompletely outlined the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data.	Insufficiently outlined the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data.	Partially outlined the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data.	Satisfactorily outlined the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data.	Thoroughly outlined the main differences between the structure of a relational database optimized for online transactions versus a data warehouse optimized for processing and summarizing large amounts of data.
2. Outline the main differences between database requirements for operational data and for decision support data. Weight: 21%	Did not submit or incompletely outlined the main differences between database requirements for operational data and for decision support data.	Insufficiently outlined the main differences between database requirements for operational data and for decision support data.	Partially outlined the main differences between database requirements for operational data and for decision support data.	Satisfactorily outlined the main differences between database requirements for operational data and for decision support data.	Thoroughly outlined the main differences between database requirements for operational data and for decision support data.
3. Describe three (3) examples in which databases could be used to support decision making in a large organizational environment. Weight: 21%	Did not submit or incompletely described three (3) examples in which databases could be used to support decision making in a large organizational environment.	Insufficiently described three (3) examples in which databases could be used to support decision making in a large organizational environment.	Partially described three (3) examples in which databases could be used to support decision making in a large organizational environment.	Satisfactorily described three (3) examples in which databases could be used to support decision making in a large organizational environment.	Thoroughly described three (3) examples in which databases could be used to support decision making in a large organizational environment.
4. Describe three (3) examples in which data warehouses and data mining could be used to support data processing and trend analysis in large organizational environment. Weight: 21%	Did not submit or incompletely described three (3) examples in which data warehouses and data mining could be used to support data processing and trend analysis in large organizational environment.	Insufficiently described three (3) examples in which data warehouses and data mining could be used to support data processing and trend analysis in large organizational environment.	Partially described three (3) examples in which data warehouses and data mining could be used to support data processing and trend analysis in large organizational environment.	Satisfactorily described three (3) examples in which data warehouses and data mining could be used to support data processing and trend analysis in large organizational environment.	Thoroughly described three (3) examples in which data warehouses and data mining could be used to support data processing and trend analysis in large organizational environment.
5. 3 references Weight: 6%	No references provided	Does not meet the required number of references; all references poor quality choices.	Does not meet the required number of references; some references poor quality choices.	Meets number of required references; all references high quality choices.	Exceeds number of required references; all references high quality choices.
6. Clarity, writing mechanics, and formatting requirements Weight: 10%	More than 8 errors present	7-8 errors present	5-6 errors present	3-4 errors present	0-2 errors present

CIS 111 – Assignments and Rubrics

Weekly Course Schedule

The purpose of the course schedule is to give you, at a glance, the required preparation, activities, and evaluation components of your course. For more information about your course, whether on-ground or online, access your online course shell.

The expectations for a 4.5 credit hour course are for students to spend 13.5 hours in weekly work. This time estimate includes preparation, activities, and evaluation regardless of the delivery mode.

Instructional Materials

In order to be fully prepared, obtain a copy of the required textbooks and other instructional materials prior to the first day of class. When available, Strayer University provides a link to the first three (3) chapters of your textbook(s) in eBook format. Check your online course shell for availability.

Review the online course shell or check with your professor to determine whether Internet-based assignments and activities are used in this course.

Strayer students are encouraged to purchase their course materials through the Strayer Bookstore. http://www.strayerbookstore.com If a lab is required for the course, the Strayer Bookstore is the only vendor that sells the correct registration code so that Strayer students may access labs successfully.

Kaltura Video Sessions

Instructors will record video or screen capture sessions using Kaltura in Weeks 2 and 4. Your instructor may also provide these sessions on a weekly basis to act as student tutorials on the following applicable procedures:

· Running and navigating the software or labs that will be used in this course

· Demonstrating the use of relevant programming languages and tools through screen capture and live navigation

· Logging into the lab environments and running a sample lab required in this course (if labs are required)

· Demonstrating the downloading and installing of software to a student’s computer (if necessary) or using the software already installed in the Strayer University campus labs

· Locating or finding files and other student materials that may be required to use in assignments

· Submitting assignments in Blackboard

You are strongly advised to use the material provided by faculty in these sessions. Online and Ground instructors will post the Kaltura video recorded sessions to the Instructor Insights folder within the weekly tabs of the online course shell (Blackboard).

Discussions

To earn full credit in an online threaded discussion, students must have one original post and a minimum of one other post per discussion thread.

Please note: Material in the online class will be made available three weeks at a time to allow students to work ahead, however, faculty will be focused on and responding only to the current calendar week. As it is always possible that students could lose their work due to unforeseen circumstances, it is a best practice to routinely save a working draft in a separate file before posting in the course discussion area. Professors hold discussions during class time for on-ground students. Check with your professor if any additional discussion participation is required in the online course shell outside of class hours.

Tests

Tests (quizzes, midterm and final exams, essay exams, lab tests, etc.) are available for student access and completion through the online course shell. Check the online course shell to determine how students are expected to take the tests. Do not change these questions or their point values in any way. This disrupts the automated grade book preset in the online course shell.

· Online students are to complete the test by Monday 9:00 a.m. Details regarding due dates are posted in the Blackboard Calendar tool.

· On-ground students are to complete the tests after the material is covered and before the next class session.

Assignments

A standardized performance grading rubric is a tool your professor will use to evaluate your written assignments. Review the rubric before submitting assignments that have grading rubrics associated with them to ensure you have met the performance criteria stated on the rubric.

Grades are based on individual effort. There is no group grading; however, working in groups in the online or on-ground classroom is acceptable.

Assignments for online students are always submitted through the online course shell. On-ground professors will inform students on how to submit assignments, whether in paper format or through the online course shell.

Association for Computing Machinery (ACM) Digital Library

The ACM Digital Library is a complete collection of all of ACM’s publications, including ACM journals, conference proceedings, magazines, newsletters, and multimedia titles. The ACM Digital Library contains the largest and most complete full-text archive of articles on computing available today, consisting of: 2.0+ million pages of full-text articles, 20,000 new full-text articles added each year, 40+ high-impact journals, 270+ conference proceedings titles, 9 magazines (including the flagship Communications of the ACM), and 43 special interest groups contributing content.

You are encouraged to search the ACM Digital Library for full-text articles for your writing assignments and term papers refereed referenced material. For more information on the ACM Digital Library, please watch the video located in the Student Center tab of the online course shell (Blackboard).

To access the ACM Digital Library:

Students:

1. Login to iCampus: http://icampus.strayer.edu

2. Click on Student Services

3. Click on Learning Resource Center

4. Click on Databases

5. Scroll down to Information Systems / Computing

6. Click on ACM Digital Library

Resources

The Resource Center navigation button in the online course shell contains helpful links. Strayer University Library Resources are available here as well as other important information. You should review this area to find resources and answers to common questions.

Technical support is available for the following:

· For technical questions, please contact Strayer Online Technical Support by logging in to your iCampus account at https://icampus.strayer.edu/login and submitting a case under “Student Center,” then “Submit Help Ticket.” If you are unable to log in to your iCampus account, please contact Technical Support via phone at (877) 642-2999.

· For concerns with your class, please access the Solution Center by logging in to your iCampus account at https://icampus.strayer.edu/login and submitting a case under “Student Center,” then “Submit Help Ticket.” If you are unable to log in to your iCampus account, please contact the IT Help Desk at (866) 610-8123 or at mailto:[email protected].

TurnItIn.com is an optional online tool to assess the originality of student written work. Check with your professor for access and use instructions.

The Strayer Policies link on the navigation bar in the online course shell contains academic policies. It is important that students be aware of these policies.