Content will be published soon
How useful was this post?
5 star mean very useful & 1 star means not useful at all.
Average rating 0 / 5. Vote count: 0
No votes so far! Be the first to rate this post.
Unit 4: Structured Query Language (SQL)
Content will be published soon
Tags: Database Management Systems | DBMS
Syllabus
Unit 1: Introduction to Databases
- Purpose of database system
- Characteristics of database approach
- Data models
- Database management system
- Database system architecture
- Three-schema architecture
- Components of DBMS
- Data independence
- File system approach vs database system approach
Unit 2: Entity Relationship Modeling
- Conceptual data modelling – motivation
- Entities and Types of Entities
- Attributes and Types of Attributes
- Relationships and Types of Relationship
- Constraints on relationship
- Entity Relationship diagram notation
Unit 3: Relation data model
- Anomalies in DBMS
- Relational Data Model – Concept of relations
- Schema-instance distinction
- Types of Keys in DBMS
- Relational integrity constraints
- Referential integrity and foreign keys
- Relational algebra operators and queries
Unit 4: Structured Query Language (SQL)
- Querying in SQL
- DDL to create database and tables
- Table constraints
- Update database-update behaviors
- Data Manipulation Language
- Aggregation functions group by and having clauses
- How to retrieve data from the database
- Generate and query views
- Access and manipulate databases using ODBC
- Basic Database administration SQL commands
Unit 5: Database design
- Mapping an Entity Relationship model to relational database
- Functional dependencies and Normal forms
- First Normal Form (1NF)
- Second Normal Form (2NF)
- Third Normal Form (3NF)
- Boyce Codd Normal Form (BCNF)