Mar 29, 2024  
College Catalog 2021-2022 
    
College Catalog 2021-2022 [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

ITCS 1170 - Database Design & Implementation With SQL

Credit Hours: 4.00


Prerequisites: ITCS 1140  or ITCS 1950 ; and  ITCS 1010  

No credit after ITCS 2280. ITCS 1170 familiarizes students with database usage, design, and implementation. It also explores fundamentals of Structured Query Language (SQL).

Billable Contact Hours: 4

Search for Sections
OUTCOMES AND OBJECTIVES
Outcome 1: Upon completion of this course, students will be able to outline the various database types and applications as it pertains to common industry usage.

Objectives:

  1. Use appropriate terms, concepts, and examples.
  2. Explain the various types of databases.
  3. Describe end user interaction with databases.
  4. Describe database maintenance.

Outcome 2: Upon completion of this course, students will be able to model or design a simple transaction processing database system utilizing the relational database model.

Objectives:

  1. Identify entities, attributes, and relationships for a case scenario. 
  2. Normalize entities to third normal form.
  3. Create an entity relationship diagram based on a set of normalized entities or software package. 

Outcome 3: Upon completion of this course, students will be able to apply techniques for constructing a basic SQL statement, multi-table query, and using server-side database administration commands.

Objectives:

  1. Construct a single-table query.
  2. Create a database schema using DDL statements.
  3. Construct multi-table queries utilizing various join methods.
  4. Construct both DDL and Outcome
  5. Determine which server-side database administration commands are needed.

COMMON DEGREE OUTCOMES (CDO)
• Communication: The graduate can communicate effectively for the intended purpose and audience.
• Critical Thinking: The graduate can make informed decisions after analyzing information or evidence related to the issue.
• Global Literacy: The graduate can analyze human behavior or experiences through cultural, social, political, or economic perspectives.
• Information Literacy: The graduate can responsibly use information gathered from a variety of formats in order to complete a task.
• Quantitative Reasoning: The graduate can apply quantitative methods or evidence to solve problems or make judgments.
• Scientific Literacy: The graduate can produce or interpret scientific information presented in a variety of formats.

CDO marked YES apply to this course:
Critical Thinking: YES
Information Literacy: YES
Quantitative Reasoning: YES
COURSE CONTENT OUTLINE

  1. Introducing Databases and Database Management Systems
  2. Designing a Database
  3. Implementing a Database using SQL
  4. Data Access and Manipulation using SQL
  5. Data Access and Security
  6. Database Processing for Business Intelligence Systems

Primary Faculty
Jenaway, Elizabeth
Secondary Faculty

Associate Dean
Evans-Mach, Patrick
Dean
Balsamo, Michael



Official Course Syllabus - Macomb Community College, 14500 E 12 Mile Road, Warren, MI 48088



Add to Favorites (opens a new window)