Database Design I

No Thumbnail Available

Keywords

databases , database concepts , database management systems , information technology , IT , data modeling , entity relationship diagrams , database normalization , structured query language , SQL , database design , NRC , Northeast Resiliency Consortium

Project

Northeast Resiliency Consortium

Authors

Date Submitted

2016

Material Type

Syllabus

Secondary Material Type

Institution

Capital Community College

Industry Partner

N/A

License

CC BY

Funding Source

TAACCCT Round 3

Additional Public Access

Abstract

This is the course outline for Capital Community College’s Database Design I. In this course, students will learn to design and implement a database system, analyze business requirements, create logical data models, convert data models into physical database designs, and implement database designs in a relational database management system. Topics such as Data Modeling, Entity-Relationship Diagrams, Database Normalization, and Structured Query Language (SQL) are covered in detail. Students will gain hands-on experience designing databases and implementing databases in a relational database management system.

Industry (NAISC)

Professional, Scientific, and Technical Services -- Professional, Scientific, and Technical Services -- Computer Systems Design and Related Services (5415)

Occupation (SOC)

Computer and Mathematical Occupations (15-0000)

Instructional Program (CIP)

Computer and Information Sciences and Support Services (11)

Credit Type

Credential Type

Associate Degree

Educational Level

1st year Community College or equivalent
2nd Year Community College or equivalent

Skill Level

Quality Assurance Organization