Computer Science Engineering > Database

Database

Learn the Concepts of Database and test your knowledge

job

CHOOSE YOUR TOPIC

Introduction to Database

In this topic, we learn about The Evolution of Database Systems, Overview of a Database Management System, Outline of Database-System Studies, Database Programming, Information Integration Overview

The Entity-Relationship Data Model

In this topic, we learn about Elements of the E/R SIodel, Entity-Relationship Diagrams, Multiway Relationships, Design Principles, The Modeling of Constraints, WeakEntity Set 

The Relational Data Model

In this topic, we learn about The Basics of the Relational Model, From E/R Diagrams to Relational Designs, Converting Subclass Structures to Relations, Functional Dependencies, Multivalued Dependencie etc

The Database Language SQL

In this topic, we learn about Simple Queries in SQL, Queries Involving More Than One Relation, Subqueries, Full-Relation operations, Database Modifications, Defining a Relation Schema in SQ etc

Constraints and Triggers

In this topic, we learn about Keys and Foreign keys, Constraints on Attributes and Tuples, Modification of Constraints, Schema-Level Constraints and Triggers, Event-Condition- Action Rule, Instead-Of Triggers

Logical Query Languages

In this topic, we learn about A Logic for Relations, From Relational Algebra to Datalog, Recursive Programming in Datalog, Recursion in SQL, Problematic Expressions in Recursive SQL

Data Storage

In this topic, we learn about The “Megatron 2002” Database System, The Memory Hierarchy, Disks, Using Secondary Storage Effectively, Accelerating Access to Secondary Storage, Disk Failures, Recovery from Disk Crashes

Representing Data Elements

In this topic, we learn about Representing Data Elements, Records, Representing Block and Record Addresses, Variable-Length Data and Records, Record Modifications 

Other Data Models

In this topic, we learn about Review of Object-Oriented Concepts, Introduction to ODL, Additional ODL Concepts, From ODL Designs to Relational Design, The Object-Relational Model, Semistructured Data XML and Its Data Mode

Relational Algebra

In this topic, we learn about An Example Database Schema, Relational Operations on Bags, Extended Operators of Relational Algebra, Constraints on Relations, Relational Algebra as a Constraint Language

Test Your Knowledge

0%

You must be logged-in before attempting the quiz.

0%

You must be logged-in before attempting the quiz.

  • Create an Account and Earn 1000 Coins
  • Pass a Quiz and Earn 20 Coins
  • Earn 10 Coins for Daily Visit 
  • Earn 5 Coins for Favorite any activity post
  • Earn 10 Coins if you get a Favorite on your activity post
  • Earn 50 Coins for invite someone to join a group
  • Earn 100 Coins for finishing a course

DON'T MISS OUT

Career and Employment updates, Global Networking with Engineers and Skill Development Roadmap