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:

Use appropriate terms, concepts, and examples.
Explain the various types of databases.
Describe end user interaction with databases.
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:

Identify entities, attributes, and relationships for a case scenario.
Normalize entities to third normal form.
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:

Construct a single-table query.
Create a database schema using DDL statements.
Construct multi-table queries utilizing various join methods.
Construct both DDL and Outcome
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

Introducing Databases and Database Management Systems
Designing a Database
Implementing a Database using SQL
Data Access and Manipulation using SQL
Data Access and Security
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