ArgosyUniversity

COURSE SYLLABUS

B6701

Database and Information Management Systems

Faculty Information

Faculty Name: Dr. Edward N Balli

Campus: Argosy Chicago

Contact Information:

Cell phone: 815-501-0175

Office Hours: 5:00 PM to 6:00 PM Friday

Short Faculty Bio: Edward N. Balli is a partner in Financial and Managerial Solutions in Dekalb, Illinois. He earned a Doctorate in Business Administration in Accounting with a minor in MIS from ArgosyUniversity in August 2007. His experience is in working with small to medium size private and public firms in the Midwest with accounting and information systems. The recommendations may include a complete audit of the operations to recommendations of proposed application software, telecommunications, and hardware. He has over 25 years of work experience and has taught part time for over 20 years at AuroraUniversity.

Dr. Balli is a member of American Institute of Certified Public Accountants (AICPA); Information Systems Audit and Control Association (ISACA); Certified Internal Auditor (CIA); Special Interest Group on Knowledge Discovery and Data Mining (SIGKDD); and Society for Industrial and Applied Mathematics (SIAM); American Mathematical Society (AMS); and Illinois CPA Society (ICPAS).

Course description:

This course explores data and information that are critical to the modern organization. Principles of data management explored such as knowledge management, business intelligence, enterprise resource planning, product design, marketing, personalization and other aspects of managing customer relationships. Students learn the components and functions of relational database management systems (RDBMS) using a popular database product. A focus on the various elements of a RDBMS assists students in learning how to access, synthesize and analyze data. Report generation and transferring data to and from a web-based RDBMS are explored.

Course Pre-requisites: None

Required Textbook: Rob, P. and Coronel, C. (2007) Database Systems: Design, Implementation, and Management.
(8th Ed.). Thomson Course Technology. ISBN: 1-4239-0201-7

Technology: Pentium III CPU/ Windows 98; 128MB RAM printer; Microsoft Office; Adobe Acrobat Reader (full version); Microsoft Internet Explorer 5.5 (PC), 5.0 (MAC), or Netscape Navigator 4.08; Norton Antivirus.

Course length: 7.5 Weeks

In Class Meetings

Session DATESTIMES

Session 1 05/09 6 PM to 10PM

Session 205/166 PM to 10PM

Session 305/236 PM to 10PM

Session 405/306 PM to 10PM

Session 506/066 PM to 10PM

Session 606/136 PM to 10PM

Session 706/206 PM to 10PM

Contact Hours: 45 Hours

Credit Value: 3.0

Program Outcomes:

  1. Communication
  2. Oral/Written – Present business information orally and in writing using appropriate technology that is concise, clear, organized, supported, and persuasive in a professional manner appropriate to the business context
  3. Critical Thinking/Problem Solving
  4. Critical Thinking– Incorporate and synthesize information, theory, and practice in order to implement appropriate business actions
  5. Problem Solving/Decision Making – Given a business situation, diagnose the underlying causes of the situation, evaluate possible solutions, and determine and defend appropriate course of action
  6. Information Literacy– Access information from a variety of sources, evaluate the credibility of the sources, and apply that information to solve business problems
  7. Team
  8. Leadership – Describe the requirements of team members and leaders to work effectively and creatively in achieving team goals
  9. Collaboration – Collect, categorize, and consider the views of all stakeholders
  10. Ethics
  11. Ethics – Identify the ethical principles related to personal and corporate behavior in specific business situations and explains the potential consequences
  12. Diversity
  13. Diversity – Identify the impact of both cultural and economic factors on the modern enterprise and explain the potential consequences
  14. Analysis/Application
  15. Applied Technology– Select and defend business technology solutions to typical business problems
  16. Integration– Describe the interrelationship of the functional business areas of statistics, accounting, finance, marketing, operations, and strategy within the context of specific organizational goals

Information Systems Management

  1. Organizational Constructs
  2. Given a specific case, integrate IT strategies with organizational objectives

Course Objectives:

  1. Analyze the development of databases and data models. (Program Outcomes: 1.1, 2.1, 2.2, 2.3, 3.1, 3.2, 4.1, 5.1, 6.1, 6.2)
  1. Based on the foundation for relational data base model and using entity relationship diagrams and normalization processes, build an efficient database design. (Program Outcomes: 1.1, 2.1, 2.2, 2.3, 3.1, 3.2, 4.1, 5.1, 6.1, 6.2)
  1. Through the use of Structured Query Language (SQL), design and build additional examples of Relational Database Management Systems (RDBMS). (Program Outcomes: 1.1, 2.1, 2.2, 2.3, 3.1, 3.2, 4.1, 5.1, 6.1, 6.2)
  1. Given diverse business examples, evaluate database performance and perform query optimization. (Program Outcomes: 1.1, 2.1, 2.2, 2.3, 3.1, 3.2, 4.1, 5.1, 6.1, 6.2)
  1. Examine the management of transactions in a distributed database environment and analyze the effect of distributed environment on the design of database. (Program Outcomes: 1.1, 2.1, 2.2, 2.3, 3.1, 3.2, 4.1, 5.1, 6.1, 6.2)
  1. Compare and contrast decision support systems (DSS) within Data Mining, Data Warehousing, and operational systems. (Program Outcomes: 1.1, 2.1, 2.2, 2.3, 3.1, 3.2, 4.1, 5.1, 6.1, 6.2)
  1. Analyze different database connectivity technologies and the web-to Database middleware in integrating databases with the Internet. (Program Outcomes: 1.1, 2.1, 2.2, 2.3, 3.1, 3.2, 4.1, 5.1, 6.1, 6.2)
  1. Examine the managerial and technical role of database administrator, tools and strategies for database administration and analyze the technological, managerial, and cultural organizational issues of DBMS. (Program Outcomes: 1.1, 2.1, 2.2, 2.3, 3.1, 3.2, 4.1, 5.1, 6.1, 6.2)

Assignment Table

Topics / Readings / Assignments
1 / 1.1 Examine the types of Database Systems; what they do and why some types yield better results. This examination is based on:
  • The differences between data and information.
  • The different types of databases – single user, multi-user, and enterprise.
  • The importance of database.
  • The evolution from files to file systems.
  • The flaws in file systems management.
  • The DBMS functions within the database system.
1.2 Examine Data Models and how they serve a bridge between real-world objects and the database. This examination is based on:
  • The importance of data models.
  • Learning about the basic data-modeling building blocks.
  • The business rules requirements affecting database design.
  • The evolution of major data models, their advantages and disadvantages.
  • The levels of data model abstraction.
/ Read Chapter 1
Read the following Articles:
  • Sankaran, S. and AlHashim, D.D. (2006). An Accounting Information System for Harmonization. Journal of AmericanAcademy of Business. 9(2), 250.
Review the following websites:
  • MySQL
  • A Brief History of Databases
  • EIC - The International Electrotechnical Commission
  • A Relational Model of Data for Large Shared Data Banks (Codd’s lecture: must read)
  • SearchDatabase.com
  • PostgreSQL
Read Chapter 2
Read the following Articles:
  • The Entity-Relationship Model-Toward a Unified View of Data by Peter Pin-Shan Chen.
Review the following websites:
  • The Entity-Relationship Model: Toward a Unified View of Data
  • Oracle Products Centers
  • SQL.org
  • ANSI Electronic Standards Store
  • Windows Database Service: Introduction to Data Modeling
/ Online Discussion Board: Describe and contrast centralize and
distributed systems.
2 / 2.1 Comprehend the basic concepts of the development of the Relational Database Model; its logical structure, and the use of entity relationship diagrams (ERD) in model design.
  • The concepts include the understanding of entities, attributes, and relationships among entities.
  • The organization of entities and their attributes.
  • The operations of relational database, data dictionary, and the system catalog.
  • The handling of data redundancy.
  • The importance of indexing.
2.2 Analyze Entity Relationship (ER) Modeling, involving a deeper and broader investigation into the graphic depiction of relationships among entities and the data requirements for successful design and implementation.
  • The analysis of relationships between entities and the incorporation process.
  • The effect of ERD components on database design and implementation.
  • The interpretation of ER modeling symbols.
  • The reconciliation of confliction design goals in a real-world setting.
/ Read Chapter 3
Read the following Articles:
  • Subramoniam, S. and Krishnankutty, K. V. (2005). EDSIM: expert database system for inventory management. Kybernetes. 34(5/6), 721.
Review the following websites:
  • FOLDC - Computing Dictionary
  • DB2 Product Family - Family Overview
  • Pal's Linux RDBMS Library
  • Experts-exchange: Databases
  • Comparison of Oracle and Microsoft Access SQL
Read Chapter 4
Read the following Articles:
  • Entity-Relationship Modeling-Historical Events, Future Trends, and Lessons Learned by Peter Pin-Shan Chen.
Review the following websites:
  • IDEF1x Overview
  • National Institute of Standards and Technology (NIST)
  • Visio 2003 Product Information
  • Charles W. Bachman Papers
  • CASE tool index
  • CASE Tool Information
  • Software Design Center
/ 1. Write 2- 3 APA pages on Expert database systems from the Kybernetes Article.
3 / 3.1 Evaluate and design Normalization of Database Tables to control data redundancies and avoiding data anomalies.
The evaluation and design involve building good table structure and normalizing process.
  • The role of normalization in the database design.
  • The types of normal forms.
  • The transformation of normal forms.
  • The application of normalization and ER modeling for a good database design.
  • The de-normalization process for achieving efficiency.
3.2 Evaluate and design Advanced Data Modeling based on Extended Entity Relationship (EER).
  • The building of EER model constructs.
  • The use of entity clusters to represent multiple entities and relationships.
  • The selection of primary keys.
  • The use of flexible solutions for special data modeling situations.
  • The consideration of issues for developing data models based on EER diagrams.
/ Read Chapter 5
Read the following Articles:
  • Blomgren, M. I. (2003). Are SQL Server, DB2, and Oracle really relational? Handelshögskolan VID GÖTEBORGS UNIVERSITET, Institutionen för informatik. Master’s Thesis. (
Review the following websites:
  • Database Normalization Basics
  • SQL by Design: Why You Need Database Normalization
  • SearchDatabase.techtarget.com
  • SQL Server database coding conventions
  • schema
Read Chapter 6
Read the following Articles:
  • Allen, R. G. (2005).The Entity-Relationship Diagram as Query Tool. Business Intelligence Journal. 10(1), 51.
Review the following websites:
  • SQL standard
  • ASCII - References
  • Free SQL Database System written in PHP
  • Microsoft Jet SQL
  • Fundamental Microsoft Jet SQL for Access 2000
  • SQL Course
  • SQL Tutorial
  • Introduction to SQL
/ 2. Online Discussion Board: Describe Normalization of data.
In class discussion of Websites and Articles.
4 / 4.1 Comprehend the basic concepts and definitions of Structured Query language (SQL).
  • Create database and table structures – tables, indexes & views.
  • Perform data manipulation and data administration – add, modify, delete & retrieve.
  • Query the database to extract useful information.
4.2 Application of SQL at advanced level.
  • The manipulation of relational set operators.
  • The use of advanced SQL operators.
  • The use of different types of sub-queries and correlated queries.
  • The use of SQL functions to manipulated data.
  • The creation and use of views, triggers, stored procedures, and embedded SQL.
/ Read Chapter 7
Read the following Articles:
  • Suleiman, J. and Garfield, G. J. (2006). Conceptual Data Modeling in the Introductory Database Course: Is it Time for UML? Journal of Information Systems Education. 17(1), 93.
Review the following websites:
  • SQL Reference
    ftp://ftp.software.ibm.com/ps/products/db2/info/vr7/pdf/letter/db2s0e70.pdf
  • SQL Quiz
  • SQL Server 2000 vs. Oracle 9i
  • DevGuru SQL Syntax Introduction
Read Chapter 8
Read the following Articles:
  • Rumbaugh, J. (2006). ER Is UML. Journal of Information Systems Education. 17(1), 21.
Review the following websites:
  • System Analysis and Design
  • System Architect
  • Just Enough Structured Analysis
  • DotnetCoders - Guide to UML Diagrams
  • Database Design: The Semantic Modeling Approach
/ 3. Online Discussion Board: Describe and compare SQL and report writers.
In class discussion of Web sites and articles.
5 / 5.1 The design of Relational Database Management System (RDBMS).
  • The design of information systems within the Systems Development Life Cycle (SDLC) framework.
  • The evaluation of information systems within SDLC and Database Life Cycle (DBLC).
  • The design strategies – top-down vs. bottom up and centralized vs. decentralized.
5.2 The Transaction Management and Concurrency Control.
  • The properties of database transactions.
  • The management of database transactions.
  • The role of concurrency control and maintenance of database integrity.
  • The use of data locking methods.
  • The database recovery management and maintenance.
/ Read Chapter 9
Read the following Articles:
  • Tribunella, T. (2002). Designing relational database systems. The CPA Journal. 72(7), 69.
Review the following websites:
  • Concurrency Control and Recovery in Database Systems
  • Concurrency Control
  • PostgreSQL 8.2devel Documentation
  • Advanced SQL Server Locking
  • DB2 Help
  • DBAsupport.com
  • Optimistic Locking with Concurrency in Oracle
Read Chapter 10
Read the following Articles:
  • Seltzer, M. (2005). Beyond relational databases. ACM Queue. 3(3), 50.
Review the following websites:
  • Using Specification-Driven Concepts for Distributed Data Management and Dissemination
  • Data Replication
  • Group of Parallel and Distributed Processing
  • Distributed processing via Internet-connected computers
  • Distributed Database Concepts
/ 4. Online discussion board: IS the System Design Life Cycle out of Date? (SDLC)
In class discussion of Web Sites and articles.
6 / 6.1 The Tuning of Database Performance and Query Optimization.
  • The basic concepts of database performance-tuning.
  • The process of DBMS SQL queries.
  • The importance of indexes in query processing.
  • The decision types of query optimizer.
  • The common practices for writing efficient SQL code.
  • The formulation of queries and tuning for optimal performance.
6.2 The Distributed Database Management Systems (DDBMS).
  • The components of DDBMS.
  • The effect of different levels of data and process distribution on database implementation.
  • The management of transactions in a distributed database environment.
  • The effect of distributed environment on the design of database.
/ Read Chapter 11
Read the following Articles:
  • Lee, K. M., Lau, H. C. W., Hui, I-K. and Yu, K-M. (2003). On an adaptive product development system: A hybrid database approach. Integrated Manufacturing Systems. 14(1), 57.
Review the following websites:
  • Object-oriented database articles and products
  • object-oriented - internet resources
  • The Journal of Object-Oriented Programming
  • The Third Manifesto
  • Mapping objects to relational databases
  • InterSystems Cache - Cache Technology - White Papers
  • Object Management Group
  • Back to the Relational Future
Read Chapter 12
Read the following Articles:
  • Ho, R., Bai, L. and Elliman, D. (2002). A new data model for XML databases. International Journal of Intelligent Systems in Accounting, Finance and Management. 11(3), 149.
Review the following websites:
  • Inmon Associates
  • Enterprise Business Intelligence
  • Ralph Kimball Associates and Kimball University
  • The Data Warehousing Information Center
  • Data Mining Group
  • OLAPinfo
  • The OLAP Report
  • CC DW RR - German OLAP and Data Warehouse Forum
/ Review and discuss in class Websites and Lee, Lau, Hui and Yu article.
7 / 7.1 The Data Warehouse.
  • The differences between operational and decision support systems data (DSS).
  • The requirements of DSS Database.
  • The preparation and implementation of data warehouse.
  • The construction of star schemas.
  • The Data Mining and its role in decision support.
  • The Online Analytical Processing (OLAP) and SQL extensions for OLAP-type data manipulation.
7.2 The Database Connectivity and Web Development.
  • The different database connectivity technologies.
  • The use of Web-to Database middleware in integrating databases with the Internet.
  • The building of Web-based database front end.
  • The Extensible Markup Language (XML) and its importance for Web database development.
/ Read Chapter 13
Read the following Articles:
  • Cunningham, C., Song, I. and Chen, P.P. (2006). Data Warehouse Design to Support Customer Relationship Management Analyses. Journal of Database Management. 17(2), 62.
Review the following websites:
  • World Wide Web Consortium
  • XML.org
  • E-Commerce Times
  • Secure Electronic Transaction (SET) protocol
  • Advisory Commission on Electronic Commerce
  • E-Business Research Center
  • UMBC Institute for Global Electronic Commerce
Read Chapter 14
Read the following Articles:
  • Zhao, J. and Ma, H. (2006). ASM-based design of data warehouses and on-line analytical processing systems. The Journal of Systems and Software. 79(5), 613
  • Watson, W. J., Wixom, B. H., Hoffer, J. A., Anderson-Lehman, R. and Reynolds, A. M. (2006). Real-Time Business Intelligence: Best Practices At Continental Airlines. Information Systems Management. 23(1), 7.
Review the following websites:
  • The CGI Resource Index
  • Application Programming Interface
  • Open Database Connectivity Without Compromise
  • Macromedia ColdFusion MX 7
  • MSDN Library: Dynamic-Link Libraries
  • The Source for Java Technology (Have fun with games)
  • SYS-CON Media: Java, XML, .NET, Web Sphere, Web Logic, Linux.
/ Write and Present Peer-Review Article Journal of Database Management.
10 pages APA

Grading Criteria

Grading Scale Grading requirements

A / 100 – 93
A- / 92 – 90
B+ / 89 – 88
B / 87 – 83
B- / 82 – 80
C+ / 79 – 78
C / 77 – 73
C- / 72 – 70
F / 79 and below
Attendance/participation / 20%
Weekly Review Assignments / 20%
2-3 page APA paper / 12%
Online Discussion contribution 4 parts / 28%
Presentation of Peer review paper. 10 pages / 20%
100%

Library:

All resources in ArgosyUniversity’s online collection are available through the Internet. The campus librarian will provide students with links, user IDs, and passwords.

Library Resources: ArgosyUniversity’s core online collection features nearly 21,000 full-text journals and 23,000 electronic books and other content covering all academic subject areas including Business & Economics, Career & General Education, Computers, Engineering & Applied Science, Humanities, Science, Medicine & Allied Health, and Social & Behavior Sciences. Many titles are directly accessible through the Online Public Access Catalog at Detailed descriptions of online resources are located at

In addition to online resources, ArgosyUniversity’s onsite collections contain a wealth of subject-specific research materials searchable in the Online Public Access Catalog. Catalog searching is easily limited to individual campus collections. Alternatively, students can search combined collections of all Argosy University Libraries. Students are encouraged to seek research and reference assistance from campus librarians.