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).

Contact Hours: 4
Billable Contact Hours: 4

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
(Bulleted outcomes apply to the course)

1. The graduate can integrate the knowledge and technological skills necessary to be a successful learner.

2. The graduate can demonstrate how to think competently.

3. The graduate can demonstrate how to employ mathematical knowledge.

4. The graduate can demonstrate how to communicate competently.

5. The graduate is sensitive to issues relating to a diverse, global society.

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