Offered:
Pre-requisite: CSE221
This course is designed as an introduction to relational database management systems (RDBMS) focusing on the efficient design, implementation and optimization of an RDBMS. Topics covered will include the advantages and disadvantages of DBMS, database architecture, data modeling using ER and EER models, relational integrity constraints, relational schema mapping from ER/EER, indexing, hashing and normalization. SQL Query formulation will be extensively practiced in both the theoretical and laboratory components of the course. The course includes a compulsory 3 hour laboratory work each week as CSE370L. Students must complete several hands-on SQL assignments and a group project for the laboratory work. The group project will involve the design and implementation of a complete database system including a user interface
The objectives of this course are to:
explain the advantages and disadvantages of using a DBMS over a file-based system
explain the process of data modeling using ER and EER models
discuss the relational integrity constraints and how they are enforced in a database system
teach the process of mapping an ER/EER model to a relational schema
introduce indexing and hashing and discuss their role in efficient data retrieval
explain the concepts of functional dependencies (FD) and normalization, and how they are used to optimize database design
teach students the methods for storing, manipulating and retrieving data using structured query language (SQL)
expose students to the process of implementing a complete database system project in a team using software tools, programming languages and SQL
1. Fundamentals of Database Systems, Ramez Elmasri, Shamkant B. Navathe, 2015, 7th ed., Pearson, ISBN-13: 978-0133970777
2. Database systems : a practical approach to design, implementation, and management, Thomas M. Connolly, Carolyn E. Begg, 2014, 6th ed., Pearson, ISBN-13: 978-0132943260
3. Database Systems Concept, Silberschatz, Korth, Sudarshan, 2011, 6th ed., McGraw-Hill, ISBN: 978-0-07-352332-3
Text and Reference Books, Lecture slides, Lab handouts, Command Line tool (MySQL Mini Server)
| # | Description | Weight | Edit |
|---|---|---|---|
|
CO1 |
Explain fundamental concepts related to database management and Identify different database concepts discussed in a given scenario. |
15 |
|
|
CO2 |
Apply Entity-Relationship (ER) and Enhanced Entity-Relationship (EER) models, schema design principles, and normalization techniques to represent and optimize complex data requirements of an organization or system. |
35 |
|
|
CO3 |
Apply appropriate indexing and hashing techniques to optimize database performance. |
12 |
|
|
CO4 |
Implement standard queries using Structured Query Languages (SQL) to store, retrieve, and manipulate data. |
22 |
|
|
CO5 |
Develop a database application as a group project using SQL and other effective programming languages to solve a complex data management problem. |
16 |
