Kevin M. Fleming
Introduction to relational database management systems, focused on relational theory and the application of conceptual, logical, and physical database modeling. Key topics include the relational model, SQL, entity-relationship modeling, three-tier architectures, implementation of database applications, and related topics in information systems. Prerequisite: CSE 142.
1. Develop a conceptual understanding of relational database systems 2. Develop a conceptual understanding of information retrieval systems 3. Develop skill set in working with database and information retrieval tools. 4. Develop an understanding of how databases fit into the larger scope of software and project development.
Student learning goals
Understand and understand core Database Theory
Understand and have knowledge of the role and components of modern Database Management Systems (DBMS)
Have knowledge in Database Design, with the ability to evaluate real-world problems and develop a relational model to support solutions to the problem.
Have a solid understanding of the Structured Query Language (SQL) and be able to construct queries to retrieve information for given problems.
Understand Information Retrieval systems, how the relate and differ from databases, and their use in modern systems, especially web search engines.
Understand and be able to develop software that interacts with databases.
General method of instruction
The course will be blend of lectures, lab work, homework, and projects. Hands on projects and real world problems will be emphasized.
A background in programming and logical though processes are highly recommended for this course. Completion of CSE 142 / 143.
Class assignments and grading
Homeworks will be assigned weekly and there will be two projects. A midterm and final will also be given.
Grading is done on a point basis. Assignments, projects, and tests will have a total number of possible points. This will generate a percentage of points earned for the course. A grading formula will be used to assign student's grades based upon the percentage of points earned.