Business Rules and Data Models

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

  • click here for more information on this paper

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
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.
Recognize the basic file organization techniques.
Compose conceptual data modeling techniques to capture the information requirements.
Explain how data is physically stored and accessed.
Recognize the purpose and principles of normalizing a relational database structure.
Design a relational database so that it is at least in 3NF.
Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.
Demonstrate the basic mechanisms for accessing relational databases from various types of application development environments.
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.
Distinguish the role of databases and database management systems in the context of enterprise systems.
Describe the core concepts of data quality and their application in an organizational context.
Summarize how database systems support enterprise and Web-based applications.
Analyze the key principles of data security, and identify data security risk and violations in data management system design.
Evaluate the ethical concerns inherent in database management systems and how these concerns affect legislation or organizational policies.
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.
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
1 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

  • click here for more information on this paper

Evaluation
None
20
2 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
20
100
3 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
20
75

  • click here for more information on this paper

4 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
20
75
5 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
20
75
100
6 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
20
100
7 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

  • click here for more information on this paper

Lab 4: Structured Query Language (SQL)
20
75
8 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
20
9 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

  • click here for more information on this paper

20
100
10 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
20
11 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.
Assignment 1: Business Rules and Data Models

  • click here for more information on this paper

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:
Describe the purpose of the database.
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.
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.
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:
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.

  • click here for more information on this paper

Section 1: Visio Diagram
(Microsoft Visio or equivalent)
Use Microsoft Visio (or open source equivalent) in which you:
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)
Write a one (1) page paper in which you:
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.
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 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

0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply