ITE 430: Database Management and Design

Course Description

This course will focus on the design and implementation of database management systems used in a modern business environment. Topics include how to design, develop, and implement relational database management systems to solve business problems. (3 credits)

Prerequisites

  • ENG 101: English Composition 1
  • ENG 102: English Composition 2
  • ITE 101: Management Information System (Recommended)
  • MAT 115: Logic (Recommended)

Student Learning Outcomes (SLOs)

Students who successfully complete this course will be able to:

  1. Understand why organizations use DBMS
  2. Understand how to design a logical database model
  3. Understand how to translate the logical database model into a physical database design
  4. Understand how to use SQL to create and query from database management systems
  5. Understand issues that affect database administration
  6. Understand database security requirements
  7. Describe an enterprise data warehouse and identify how it supports data mining

Course Activities and Grading

AssignmentsWeight

Discussions (Weeks 1-8)

16%

Weekly Assignment (6 points each, Weeks 1-7)

42%

Final Exam (Week 8)

42%

Total

100%

Required Textbooks

Available through Charter Oak State College's online bookstore

  • Gillenson, Mark. Fundamentals of Database Management Systems. 2nd ed. Wiley & Sons, 2012. ISBN-10: 0-470-62470-1 or ISBN-13: 978-0-470-62470-8

Additional Resources

Supplemental material is listed in the Webliography, including links to download Microsoft SQL server, link to Smartdraw (if necessary), and a link to the Practice Quizzes

Computer Specifications

This course will use the evaluation version of Microsoft SQL Server; students must be using a Microsoft Operating System (XP, Vista (Professional - Home editions), 7, etc.)

Course Schedule

Week

SLOs

Readings and Exercises

Assignments

1

1

Topic: Introduction to Database Management Systems
 
  • Readings:
    • Chapter 1
    • Chapter 2
  • Read assigned chapters
  • Participate in the Discussion Board
  • Review the PowerPoint Lecture Material
  • Install Microsoft SQL Server
  • Install Smartdraw (If needed)
  • Take the Practice Quiz (not graded)
  • Complete Minicase #1 (page 39)

2

2

Topic: The Database Concept
 
  • Readings:
    • Chapter 3
  • Read assigned chapter
  • Participate in the Discussion Board
  • Review the PowerPoint Lecture Material
  • Take the Practice Quiz (not graded)
  • Complete Minicase # 1, part E, F & G (page 65)

3

2, 3

Topic: SQL
 
  • Readings:
    • Chapter 4
  • Read assigned chapters
  • Participate in the Discussion Board
  • Review the PowerPoint Lecture Material
  • Take the Practice Quiz (not graded)
  • Complete Minicase #1 part A-M (page 102-103)

4

2

Topic: Logical Database Design
  • Readings:
    • Chapter 5
    • Chapter 6
  • Read assigned chapters
  • Participate in the Discussion Board
  • Review the PowerPoint Lecture Material
  • Take the Practice Quiz (not graded)
  • Complete Minicase # 1, part B & D

5

3, 4

Topic: Physical Database Design
  • Readings:
    • Chapter 7
    • Chapter 8
  • Read assigned chapter
  • Participate in the Discussion Board
  • Review the PowerPoint Lecture Material
  • Take the Practice Quiz (not graded)
  • Complete Questions 1, 2 & 4 (page 194)

6

4

Topic: SQL Revisted
  • Read assigned chapter
  • Participate in the Discussion Board
  • Review the PowerPoint Lecture Material
  • Take the Practice Quiz (not graded)
  • Complete Minicase #2, part A-F, (page 103)

7

5,6

Topic: Database Administration and Security
  • Readings:
    • Chapter 11
    • Chapter 12
  • Read assigned chapters
  • Participate in the Discussion Board
  • Review the PowerPoint Lecture Material
  • Take the Practice Quiz (not graded)
  • Complete Question 3, page 333

8

7

Topic: Database Warehouses
  • Readings:
    • Chapter 13
  • Read assigned chapter
  • Participate in the Discussion Board
  • Complete Final Exam

Final Exam
Chapters 1-8, 11-13
SLOs 1, 2, 3, 4, 5, 6, 7

COSC Accessibility Statement

Charter Oak State College encourages students with disabilities, including non-visible disabilities such as chronic diseases, learning disabilities, head injury, attention deficit/hyperactive disorder, or psychiatric disabilities, to discuss appropriate accommodations with the Office of Accessibility Services at OAS@charteroak.edu.

COSC Policies, Course Policies, Academic Support Services and Resources

Students are responsible for knowing all Charter Oak State College (COSC) institutional policies, course-specific policies, procedures, and available academic support services and resources. Please see COSC Policies for COSC institutional policies, and see also specific policies related to this course. See COSC Resources for information regarding available academic support services and resources.