Relational Database Concepts

In the CIS 103 course students learn concepts and skills related to relational database and their functionality. In this course, through extensive hands-on exercises, students master skills in the use of relational databases and their objects. Students also learn techniques for designing and building a relational database for an organization. Using case studies and “beyond the classroom” projects students practice how to transform raw data into meaningful and useful information for business purposes. Business Intelligence (BI) using Access can handle a large amount of unstructured data to identify, develop and then create new opportunities. Relational database, entity-relationship models, normal forms, data manipulation language to query and modify databases, and Web applications concepts will be taught. Students work in teams. Each student actively participates in the course through playing role of the Team Leader or Team Member in rotation. Capstone projects are used in the classroom, which simulate real business projects. The course introduces use of English-like Structured Query Language (SQL). Prerequisites: CIS 103. Offered spring semester.