Database Management System - Syllabus

Introduction to databases, including examples and basic concepts.

Introduction to Database Management Systems (DBMS), including advantages and examples.

Types of database users, including actors on the scene and workers behind the scene.

Advantages and benefits of using databases.

Types of data models, including hierarchical, network, ER, relational, and object models.

Introduction to databases, including examples and basic concepts.

Introduction to Database Management Systems (DBMS), including advantages and examples.

Types of database users, including actors on the scene and workers behind the scene.

Advantages and benefits of using databases.

Types of data models, including hierarchical, network, ER, relational, and object models.

Three-schema architecture, including internal, conceptual, and external views.

Introduction to databases, including examples and basic concepts.

Introduction to Database Management Systems (DBMS), including advantages and examples.

Types of database users, including actors on the scene and workers behind the scene.

Advantages and benefits of using databases.

Types of data models, including hierarchical, network, ER, relational, and object models.

Three-schema architecture, including internal, conceptual, and external views.

Data independence, including logical and physical independence.

Types of database languages, including DDL, DML, SDL, and VDL.

Types of database interfaces, including menu-based, mobile apps, form-based, and GUI.

The database system environment, including DBMS component modules, utilities, tools, and communications facilities.

This topic covers the fundamental concepts of the relational model, including domains, attributes, tuples, and relations, as well as the characteristics of relations.

This topic explores the different types of constraints in the relational model, including domain constraints, key constraints, and constraints on null values.

This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.

This topic covers update operations, transactions, and how to deal with constraint violations, including insert, delete, and update operations, as well as restrict, cascade, set null, and set default.

This topic introduces basic relational algebra operations, including unary operations (select, project, rename) and binary operations (set theory, Cartesian product, join, and outer join).

Defining the structure and constraints of XML documents using XML Schema.

This topic covers the fundamental concepts of the relational model, including domains, attributes, tuples, and relations, as well as the characteristics of relations.

This topic explores the different types of constraints in the relational model, including domain constraints, key constraints, and constraints on null values.

This topic discusses the concept of relational database schemas, including relational database state, entity integrity, referential integrity, and foreign keys.

This topic covers update operations, transactions, and how to deal with constraint violations, including insert, delete, and update operations, as well as restrict, cascade, set null, and set default.

This topic introduces basic relational algebra operations, including unary operations (select, project, rename) and binary operations (set theory, Cartesian product, join, and outer join).

Defining the structure and constraints of XML documents using XML Schema.

This topic covers the basics of data definition and data types in SQL, including attribute data types and domains, creating databases and tables, and dropping constraints and databases.

This topic explains how to specify constraints in SQL, including attribute constraints, attribute defaults, key and referential integrity constraints, and naming constraints using CHECK.

This topic covers the basics of retrieval queries in SQL, including the SELECT-FROM-WHERE structure, ambiguous attribute names, aliasing, renaming, and tuple variables, as well as unspecified WHERE clauses and the use of * in Select.

This topic explores advanced retrieval queries in SQL, including the use of IS NULL, logical connectives, nested queries, correlated nested queries, and aggregate functions, as well as JOIN, Natural JOIN, OUTER JOIN, and GROUP BY and HAVING clauses.

This topic covers data manipulation statements in SQL, including INSERT, DELETE, and UPDATE statements.

This topic explains how to create and drop views in SQL.

Learn how to design relational databases using ER-to-relational mapping, including mapping of regular entities, weak entities, relationship types, multivalued attributes, and N-ary relationships.

Understand informal design guidelines for relational schemas, including semantics of attributes in relations, redundant information in tuples and update anomalies, NULL values in tuples, and generation of spurious tuples.

Study functional dependencies, including definition, inference rules, Armstrong's axioms, attribute closure, equivalence of functional dependencies, and minimal sets of functional dependencies.

Explore normal forms based on primary keys, including First Normal Form, Second Normal Form, Third Normal Form, and their general definitions.

Learn about Boyce-Codd Normal Form, a higher normal form that ensures a relational schema is in a good structure.

Understand multivalued dependency and Fourth Normal Form, which eliminates multivalued dependencies in a relational schema.

Study properties of relational decomposition, including attribute preservation, dependency preservation, and loss-less/non-additive join.

This topic explores the various applications of recursion in problem-solving, including tree traversals and dynamic programming.

Overview of E-commerce and its significance in the digital age.

Understanding the differences between E-business and E-commerce.

Key characteristics and benefits of E-commerce.

Types of E-commerce models and their applications.

Evolution and development of E-commerce over time.

The internship work should be relevant to the field of computer science and information technology, with a minimum duration of 180 hours or ten weeks.

The internship evaluation consists of three phases: Proposal Submission, Mid-Term Submission, and Final Submission.

A regular faculty member of the college is assigned as a supervisor to supervise the students throughout the internship period.

A regular employee of the intern providing organization is assigned as a mentor to guide the students throughout the internship period.

The evaluation scheme consists of Proposal Defense, Midterm, and Final Defense, with a total of 200 marks.

Introduction to databases, including examples and basic concepts.

Introduction to Database Management Systems (DBMS), including advantages and examples.

Types of database users, including actors on the scene and workers behind the scene.

Advantages and benefits of using databases.

Types of data models, including hierarchical, network, ER, relational, and object models.