Standard letter grades
Total contact hours
(CIS 120 or CIS 124 or IC3 certification) and CIS 131.
Introduces database concepts. Includes the parts of a database and database management systems as well as database design theory, the concept of normalization, and data models. Introduces SQL and several of the most popular database management systems such as Access, Microsoft SQL Server and MySQL.
Course learning outcomes
1. State the reasons for using a database.
2. State how using related tables helps avoid problems.
3. Know the components elements of a database associated database management systems.
4. Design and produce relational database models using ER diagrams, integrity rules and normalization.
5. Transform ER diagrams into relational designs and apply normalization processes.
6. Use SQL to create, and modify tables as well as retrieve data from one or more tables databases.
7. Learn the reasons for database administration and associated functions.
8. Understand the classifications of applications, specifically web-based, that access databases.
9. Understand the concepts of data-mining, -warehouses -marts and how they pertain to business systems.
- purpose of a database
- relational databases
- database components
- entity relationship diagrams
- the normalization process
- administrative functions
- database applications
- data mining and warehousing
Students will need regular and reliable access to Microsoft Access.