Chapter 1
Database Management Systems
Purpose of Database Systems
Data Abstraction
Data Models
o Object-based Logical Models
The E-R Model
The Object-Oriented Model
o Record-based Logical Models
The Relational Model
The Network Model
The Hierarchical Model
o Physical Data Models
Instances and Schemes
Data Independence
Data Definition Language (DDL)
Data Manipulation Language (DML)
Database Manager
Database Administrator
Database Users
Overall System Structure
Chapter 2
Entities and Entity Sets
Relationships & Relationship Sets
Attributes
Mapping Constraints
Keys
Primary Keys for Relationship Sets
The Entity Relationship Diagram
Other Styles of E-R Diagram
Reducing E-R Diagrams to Tables
o Representation of Strong Entity Sets
o Representation of Weak Entity Sets
o Representation of Relationship Sets
Generalization
Aggregation
Design of an E-R Database Scheme
o Mapping Cardinalities
o Use of Entity or Relationship Sets
o Use of Extended E-R Features
Chapter 3
Structure of Relational Database
o Basic Structure
o Database Scheme
o Keys
o Query Languages
The Relational Algebra
o Fundamental Operations
o Formal Definition of Relational Algebra
o Additional Operations
The Tuple Relational Calculus
o Example Queries
o Formal Definitions
o Safety of Expressions
o Expressive Power of Languages
The Domain Relational Calculus
o Formal Definitions
o Example Queries
o Safety of Expressions
o Expressive Power of Languages
Modifying the Database
o Deletion
o Insertions
o Updating
Views
o View Definition
o Updates Through Views and Null Values
You'll get remaining part in our digital library
https://www.travelescape.in/feed/
0 Comments:
Post a Comment
If you have any doubts . Please let me know.