[vc_row el_class=”inner-body-content” css=”.vc_custom_1667212439778{padding-top: 30px !important;padding-bottom: 20px !important;}”][vc_column][vc_custom_heading text=”COURSE OBJECTIVES” use_theme_fonts=”yes” css=”.vc_custom_1667212430053{margin-top: 0px !important;}”][vc_column_text]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.[/vc_column_text][vc_custom_heading text=”COURSE LEARNING OUTCOMES (CLO)” font_container=”tag:h3|text_align:left” use_theme_fonts=”yes”][vc_column_text]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: 4. Build code of Structured Query Language (SQL) for database definition and manipulation using any DBMS. [P3 – Comprehension]
[/vc_column_text][vc_custom_heading text=”COURSE CONTENTS” use_theme_fonts=”yes”][vc_column_text css=”.vc_custom_1667212420233{margin-bottom: 0px !important;}”]
- Introduction to Basic Database Concepts
- The Course Outline and Objective, Database Definition, Importance of Databases, Shortcomings of Traditional File Processing System, Levels of Data, Different Types of Database Users, History of DBMSs, Advantages and Disadvantages of DBMSs
- Database Architecture
- Three Level Schema Architecture, Data Independence, Database Languages Database, Data Model and DBMS, Functions and Components of a DBMS Multi-user DBMS Architectures
- Database Planning, Design, and Administration
- The Information System Life Cycle, DBS Development Life Cycle, DB Planning System Definition, Requirements Collection and Analysis, DB Design, DBMS Selection Application Design, Prototyping, Implementation, Data Conversion and Loading Testing, Operational Maintenance, CASE Tools, Data Administration and Database Administration
- Fact-Finding Techniques
- What facts are collected, Techniques, A worked example
- Entity-Relationship Modeling
- Semantic Data Models, Introduction to Entity-Relationship Data Model Different Constructs of E-R Data Model, Abstraction Process Modeling different types of Entities and Attributes
- Entity-Relationship Modeling
- Cardinality and Degree of a Relationship, Unary, Binary and n-array Relationships
- Entity-Relationship Modeling Case Studies
- Relational Model and Languages
- Introduction to Relational Data Model, Brief History Advantages, Relational Model Terminology, Mathematical Relations, Database Relations Characteristics of Relations, Understanding tables, The Concept of Key, Different Types of Keys, Integrity Constraints Over Relations, Key Constraints, Foreign Key Constraints General Constraints, Data dictionaries, Views
- ER to RDM transformation
- Normalization
- Objectives, Functional Dependency, Inference Rules, First Normal Form, Full Functional Dependency, Second Normal Form, Transitive Dependency, Third Normal Form, Boyce-Codd Normal Form
- Data Manipulation Languages
- Relational Algebra: Unary and Binary operations, Selection, Projection, Cartesian Product Different types of Joins, Union, Intersection, Division
- Relational Algebra Practice
- SQL Quires
- Insert, Delete, Select, Update, Where, Order by
- SQL Quires with Joins
- Types of joins, Sub queries
- Indexing
- Types of SQL indexing
- Presentation of projects
[/vc_column_text][/vc_column][/vc_row]