CIS 135DB : Database Theory/SQL
Standard letter grades
Contact hours total
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.
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.
The course letter grade is determined by an accumulation of points from quizzes, assignments, and exams.