COURSE OBJECTIVES
After the completion of this course the students will be quite familiar with the importance of databases, core concepts, database design and its refinement and moderate level of expertise in SQL. Students should be able to design the database schema for at least a small sized real life application.
COURSE LEARNING OUTCOMES (CLO)
CLO: 1. Acquire the basic concepts and uses of databases with different applications/Systems. [C1 – Knowledge]
CLO: 2. Describe and apply different stages of database development using different data models [C3 – Application]
CLO: 3. Identify function dependencies and resolve database anomalies by normalizing database tables. [C2 – Comprehension]
CLO: 3. Build code of Structured Query Language (SQL) for database definition and manipulation using any DBMS. [P3 – Comprehension]
COURSE CONTENTS
\1. Introduction to Basic Database Concepts
2. Database Architecture
3. Database Planning, Design, and Fact-Finding Techniques
4. Entity-Relationship Modeling
5. Entity-Relationship Modeling Case Studies
6. Relational Model and Languages
7. Relational Keys
9. ER to RDM Transformation Rules
10. Normalization
11. Normalization Continued
12. Relational Algebra
13. SQL Queries with Joins
14. Sub Queries
15. Transaction Support