Lehigh University

CSE 241 Data Base Systems (3)

Instructor: Hank Korth

Current Catalog Description
Design of large databases: Integration of databases and applications using SQL and JDBC; transaction processing; performance tuning; data mining and data warehouses. Not available to students who have credit for CSE 341 or IE 224. Prerequisite: CSE 15 or CSE 17 or consent of the instructor.

Textbook
Silberschatz, Korth, Sudarshan, Database System Concepts, 6th edition, McGraw Hill 2011. http://www.db-book.com

Course Outcomes

Students will have:

1. Fluency in writing code in SQL for data definition, queries, updates, and online analytic processing (OLAP)

2. Ability to use JDBC to embed SQL database accesses in Java code

3. Ability to the entity-relationship model for database design.

4. Ability to apply the principles of normalization to relational database design.

5. Ability to use the results of database optimizer plans analyze and tune database system performance by appropriate selection of indices.

6. Understanding of the concept of a database transaction, including atomicity, concurrency, and recovery

7. Ability to select appropriate transaction isolation levels

8. Understanding of SQL authorization and its relationship to broader issues in database security

9. Understanding of the issues and design choices in distributed databases, including cloud-based databases.

Relationship between Course Outcomes and Program Outcomes

CSE 241 substantially supports the following program outcomes:

C. An ability to design, implement, and evaluate a computer-based system

I. An ability to use current techniques, skills, and tools necessary for computing practices

K. An ability to apply design and development principles in the construction of software systems of varying complexity

CSE 241 provides modest support to the following program outcomes:

B. An ability to analyze a problem and identify and define the computing requirements appropriate to its solution

Prerequisites by Topic

1. Java programming

2. Basic data structures (in-memory)

3. General experience in computing and high-level understanding of concepts of computing systems

Major Topics Covered in the Course

1. Data Modeling

2. SQL queries

3. OLAP

4. SQL data definition

5. SQL updates

6. JBDC

7. Integrity constraints

8. Triggers

9. Entity-Relationship model

10. Relational Design

11. Indexing

12. Query performance tuning

13. Transactions: concurrency and recovery

14. Distributed databases

15. Security and authorization

16. Current topics in databases

Assessment Plan for the Course

The students are given several short homework assignments (8 to 10), a major project, one or two mid-term quizes, and a final examination. Each homework covers a single topic. The project is an end-to-end design and implementation project in which students model part of an enterprises database (e.g. product and sales data for a retailer), create the database using SQL (on Oracle or PostgreSQL), populate it with data, and use JDBC to implement several simple user interfaces to the database (due to the set of prerequisite courses, I accept command-line interfaces, but often get Web-based ones). The quizzes and exams have a varying number of questions many of which are aimed at a specific topic but others of which test the student�s understanding of the relationship among the various components of a database system and its interaction with the rest of a computing environment. Ethical and social issues are discussed in the course and an exam question ties those issues to some aspect of the course I track the performance of the students on each homework assignment, various project checkpoints, and each question on the tests and final examination.

How Data in the Course are Used to Assess Program Outcomes: (unless adequately covered already in the assessment discussion under Criterion 4)

Each semester I include the above data from the assessment plan for the course in my self-assessment of the course. This report is reviewed, in turn, by the Curriculum Committee.

		CSE 241 Data Base Systems (3) Instructor: Hank Korth Current Catalog Description Design of large databases: Integration of databases and applications using SQL and JDBC; transaction processing; performance tuning; data mining and data warehouses. Not available to students who have credit for CSE 341 or IE 224. Prerequisite: CSE 15 or CSE 17 or consent of the instructor. Textbook Silberschatz, Korth, Sudarshan, Database System Concepts, 6th edition, McGraw Hill 2011. http://www.db-book.com Course Outcomes Students will have: 1. Fluency in writing code in SQL for data definition, queries, updates, and online analytic processing (OLAP) 2. Ability to use JDBC to embed SQL database accesses in Java code 3. Ability to the entity-relationship model for database design. 4. Ability to apply the principles of normalization to relational database design. 5. Ability to use the results of database optimizer plans analyze and tune database system performance by appropriate selection of indices. 6. Understanding of the concept of a database transaction, including atomicity, concurrency, and recovery 7. Ability to select appropriate transaction isolation levels 8. Understanding of SQL authorization and its relationship to broader issues in database security 9. Understanding of the issues and design choices in distributed databases, including cloud-based databases. Relationship between Course Outcomes and Program Outcomes CSE 241 substantially supports the following program outcomes: C. An ability to design, implement, and evaluate a computer-based system I. An ability to use current techniques, skills, and tools necessary for computing practices K. An ability to apply design and development principles in the construction of software systems of varying complexity CSE 241 provides modest support to the following program outcomes: B. An ability to analyze a problem and identify and define the computing requirements appropriate to its solution Prerequisites by Topic 1. Java programming 2. Basic data structures (in-memory) 3. General experience in computing and high-level understanding of concepts of computing systems Major Topics Covered in the Course 1. Data Modeling 2. SQL queries 3. OLAP 4. SQL data definition 5. SQL updates 6. JBDC 7. Integrity constraints 8. Triggers 9. Entity-Relationship model 10. Relational Design 11. Indexing 12. Query performance tuning 13. Transactions: concurrency and recovery 14. Distributed databases 15. Security and authorization 16. Current topics in databases Assessment Plan for the Course The students are given several short homework assignments (8 to 10), a major project, one or two mid-term quizes, and a final examination. Each homework covers a single topic. The project is an end-to-end design and implementation project in which students model part of an enterprises database (e.g. product and sales data for a retailer), create the database using SQL (on Oracle or PostgreSQL), populate it with data, and use JDBC to implement several simple user interfaces to the database (due to the set of prerequisite courses, I accept command-line interfaces, but often get Web-based ones). The quizzes and exams have a varying number of questions many of which are aimed at a specific topic but others of which test the student�s understanding of the relationship among the various components of a database system and its interaction with the rest of a computing environment. Ethical and social issues are discussed in the course and an exam question ties those issues to some aspect of the course I track the performance of the students on each homework assignment, various project checkpoints, and each question on the tests and final examination. How Data in the Course are Used to Assess Program Outcomes: (unless adequately covered already in the assessment discussion under Criterion 4) Each semester I include the above data from the assessment plan for the course in my self-assessment of the course. This report is reviewed, in turn, by the Curriculum Committee.