CIS 313 - Introduction to Database Concepts: Syllabus

Instructor Information

Refer to Discussion Forum, Facilitator Introduction and Expectations

Course Title

Course Description

This course will provide an introductory look at database concepts, emphasizing the relational database model. The course will also illustrate concepts and application of the entityrelationship diagram as well as the principles and application of normalization. The student will understand the use of structured query language (SQL) to extract information from the database. We will also take a broad overview at some advanced databases topics such as, Web Database Development, Data Warehouses and Database Administration.

Prerequisite Courses

None

Course Outcomes

Upon completion of this course, learners should be able to:

Describe the reasons and purpose of using a database
Explain the conceptual foundation of the relational model for databases
Demonstrate basic SQL statements for creating, querying, modifying and deleting data from a relational database
Discuss the basic stages of database development and the role of the data model. Describe basic database design principles
Explain the need for and importance of database administration and the need for security, backup and recovery
Describe Web database processing
Describe the basic concepts of data warehousing, OLAP, and data mining.

Course Materials

Required Texts

Kroenke, D. M., and Auer, D. J., (2013). Database Concepts (6th ed.). Pearson Prentice Hall; ISBN-13: 978-0-13-274292-4 or ISBN-10: 0132742926.

Required Resources

Download the Student Data Files for the 6th edition of the textbook at http://www.pearsonhighered.com/kroenke/

Technology Tools

Microsoft Access 2013 and Visio 2013 - you can obtain free copies of Microsoft Access and Visio 2013 through our academic alliance with Microsoft (MSDNAA). Please email the MSDNAA Administrator (msdnaa@regis.edu) with your name and course number. You will receive an email from the Administrator that provides you with a link to the Microsoft DreamSpark website and instructions. These copies are valid for one year.

technical specifications

Pre-Assignment

Classroom Delivery: Due first night of class

Reading Assignment: Chapter 1 in the textbook
Prepare a typewritten paper (two to three pages, double-spaced, using the APA format)
- How does your company or a previous company you worked for use collected data?
- What type of DBMS is used?
- How well is the system meeting the goals of the business?

Online Delivery:

Reading Assignment: Chapter 1 in the textbook.

Course Assignments and Activities

Assignments for Online Course
Week	Activities	Readings	Assignments*
1: Introduction to Databases	• Introductions • Discussion • Access Workbench	Chapter 1	MS Access Exercise – create a database
2: Relational Data Modeling and Normalizati on	• Discussion • Access Workbench	Chapter 2	MS Access Exercise – create a database
3: Data Modeling and the Entity Relationship Diagram (ERD)	• Discussion • Access Workbench	Chapter 4	Create an Entity Relationship Diagram (ERD)
4: Structured Query Language (SQL)	Discussion • Access Workbench	Chapter 3, Appendix E online	MS Access Exercise – SQL queries
5: Database Design	Discussion • Access Workbench	Chapter 5	MS Access Exercise – add database tables & update the ERD
6: Database Administration	Discussion • Access Workbench	Chapter 6	Essay – Distributed Two-Phase Locking
7: Advanced Database Concepts	Discussion • Access Workbench	Chapter 8	Essay – Summarize DB learning
8: Database Processing Applications	Discussion	Chapter 7	Final Exam

*Note to Classroom sections only: Exact dates for readings and assignments may be one week earlier or later than indicated in the Course Overview Grid. Your facilitator's syllabus, handed out the first night of class, will indicate any changes.

Summary of Assignments and Percentage Weight:

Assignments	Weighted Percentage
MS Access Assignments (4)	40%
ERD Assignment	5%
Participation/Online Forum/Papers	35%
Final Exam	20%
TOTAL	100 %

Written Assignments

An important component of this course is the completion of written assignments. All written work is expected to meet undergraduate level standards. Assignments will be graded for The Publication Manual of the American Psychological Association (APA) is to be used for written work in the College for Professional Studies. Research papers required in this and other courses are expected to follow APA guidelines. The facilitator will provide format, submission, and guidelines for the assignments.

APA Resources: http://www.regis.edu/regis.asp?sctn=ars&p1=ws

Participation

Due to the accelerated nature of the course, class participation is very important since we can learn from each other. Your participation points can make a difference in the final grade. If you do not participate during any given week, you will lose the participation points of that week. Participation means:

1. a. Present in class every session (classroom) b. Present at least three days in the forum every week (online)

2. a. Responds effectively to questions from the facilitator (classroom) b. Checks the discussion forum daily and posts all required assignments, initial discussion question(s) postings and discussion reply postings by the deadlines (online)

3. Contributes to classroom/forum discussions, etc.

CCIS Policies

Review the CCIS Policies on the Regis University website.

OTHER INFORMATION

NOTE TO LEARNERS: On occasion, the course facilitator may, at his or her discretion, alter the Learning Activities shown in this Syllabus. The alteration of Learning Activities may not, in any way, change the Learner Outcomes or the grading scale for this course as contained in this syllabus. Examples of circumstances that could justify alterations in Learning Activities could include number of learners in the course; compelling current events; special facilitator experience or expertise; or unanticipated disruptions to class session schedule.