Code and Name	CSE 311L Database Systems Lab
Type	Core
Credit Hours	0
Pre-requisites	CSE 225

Course Summary: This course introduces students with database management systems for the first time in their undergraduate study. Drawbacks of flat file system are demonstrated and advantages of relational database systems are introduced. The course examines the logical organization of databases: the entity-relationship model; the hierarchical, network, and relational data models and their languages. Functional dependencies and normal forms are discussed.  Design, implementation, and optimization of query languages; security and integrity; concurrency control, different level of indices, e.g., tree and hash based indices are introduced. Access costs are compared for different alternatives. This course has separate mandatory laboratory sessions every week in a separate course CSE 311L which has 0 credits, but the students (in group) use hands on SQL queries and as a culmination, they build a full fledged database system including a front end. The evaluation of the lab works is carried over to the theory part of the course.

Course Objectives: The objectives of this course are

1. to make students comprehend the advantages of using database system over flat files.
2. to get students familiar with requirement analysis specially data requirements of an organization
3. To introduce the conceptual design from requirement analysis using E-R diagrams and also mapping ER diagrams into relational schema.
4. to introduce the basics and usage of relational algebra that are the foundation of SQL.
5. to transform a relational design into physical database design using popular commercialized database, e.g., Oracle, MySQL etc.
6. to demonstrate and show the evils of redundancy by introducing the concepts of functional dependencies and their types.
7. to design full-fledged physical database systems with least redundancy and most optimized manner.
8. to build their independent projects emphasizing the data requirement.