Course

Course Summary

Credit Type:

Course

ACE ID:

YRUP-0003

Organization's ID:

CIS 103

Organization:

Year Up

Location:

Classroom-based

Dates Offered:

Credit Recommendation & Competencies

Level	Credits (SH)	Subject
Lower-Division Baccalaureate	3	introduction to databases

Description

Objective:

The course objective is to engage in a set of hands-on activities, where students will gain familiarity with utilizing a database management system to create and populate tables, design forms, and generate customized reports; drawing ER diagrams to represent various situations and explaining the relationships represented; and answering basic business questions by obtaining information from a database to using SQL queries.

Learning Outcomes:

describe the role of database management systems in an organization
describe relational database objects such as tables, attributes, records and fields
explain relational database concepts such as constraints, indexes and normalization; design effective databases using E-R diagrams
Verbally organize and communicate networking and technical concepts, processes, thoughts, ideas, and information effectively when required to give oral presentations in a business environment
Analyze, devise, and execute tests described by a list of test cases or a traceability matrix using project summaries, requirements, and Functional Specification Documents (FSD)
Verify software features and bug fixes against a functional specification, both manually and using automated testing tools, and also provide a clear, approximated, and detailed bug report
Produce effective database design using e-r diagrams
describe relational database objects such as tables, attributes, records and fields
explain relational database concepts such as constraints, indexes and normalization; design effective databases using E-R diagrams
Identify, repair, and upgrade computer technology systems
Exhibit knowledge of tools and processes to identify the need or parts of testing
Apply master key data elements, validation rules, and default values
Create filters and queries involving multiple tables and relations to extract or update information from the database
design effective databases using E-R diagrams
utilize a database management system (DBMS) to create tables, query data and generate customized forms and reports
utilize SQL to build tables and populate them, specify constraints, and apply indexes
utilize SQL to query tables including the use of filters, calculated fields, sorting, aggregates and joins
Upon completion of the course, the student will be able to apply the fundamentals of information systems used in business and demonstrate appropriate use of computers (hardware) and software applications (e.g. Microsoft Office, Word processing, Cloud services, etc.) in a professional business environment
Design and implement strategies for testing software in structured and organized ways recognized by industry practices
Upon completion of the course, the student will be able to describe the value of relational databases
Effectively use design tools to generate customized forms and reports
And specify referential integrity and perform queries using SQL.
describe the role of database management systems in an organization
Apply critical thinking and problem-solving skills using experience gained from research assignments, individual and group projects, and troubleshooting processes and practices
Describe the role of database management systems in an organization

General Topics:

Introduction to databases and entity relationships, data normalization, building and querying using Microsoft Access, and implementing joins and advanced queries

Instruction & Assessment