Course

Course Summary
Credit Type:
Course
ACE Course Number:
YRUP-0003
Organization Course Number:
YRUP-0003
Organization:
Location:
Classroom-based
Dates Offered:
Credit Recommendation & Competencies
Level Credits (SH) Subject
Lower-Division Baccalaureate 3 introduction to databases
Description

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 Course Topics:

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

Instructional Strategies:

  • Audio Visual Materials
  • Case Studies
  • Classroom Exercise
  • Computer Based Training
  • Discussion
  • Laboratory
  • Learner Presentations
  • Lectures
  • Practical Exercises

Methods of Assessment:

  • Case Studies
  • Examinations
  • Performance Rubrics (Checklists)
  • Presentations
  • Quizzes
  • Written Papers

Minimum Passing Score:

70%
Supplemental Materials