DBMS TUTORIALS

DBMS TUTORIALS


This tutorial will helpful for the students who wants to understand each and every topic of particular subject 


INDEX

1. INTRODUCTION OF DATABASE

2. DATA MODEL

  • What is data model? Types of Data models.
  • what is E-R Model? what is E-R Diagram and how to draw it.

3. DR.CODD'S 12 RULES
  • Which are Dr. Codd's rules?
4. RELATIONAL DATABASE DESIGN

  • What is relational database design?
  • Relational Database design part-2
  • What is Database joins and types of join?

5. TRANSACTION AND CONCURRENCY

  • What is Database Key? Which type of database key.
  • What is Database Transaction?
  • What is Database concurrency control?
  • What is Database lock concurrency control? which type of lock lock concurrency control.

FINAL QUIZ


Comments

  1. Pinki rajbharJanuary 10, 2021 at 1:26 AM

    It's very important information... ๐Ÿ‘Good work...

    ReplyDelete
  2. UnknownJanuary 11, 2021 at 8:27 PM

    Good work ๐Ÿ‘๐Ÿ‘ I support uh ๐Ÿ‘๐Ÿ‘๐Ÿ‘

    ReplyDelete
    Replies
    1. SANGITA RAJBHARJanuary 12, 2021 at 8:41 AM

      thanks for appreciation ..
      can i know yr name please?...

      Delete
  3. Jitendra chauhanJanuary 11, 2021 at 8:29 PM

    Good work �� sir ji

    ReplyDelete
    Replies
    1. SANGITA RAJBHARJanuary 12, 2021 at 8:42 AM

      thank you so much .. visit see my another blogs they are really interesting...

      Delete

Post a Comment

Popular posts from this blog

WHAT IS DBMS?

Image
 WHAT IS DBMS? WHAT IS DBMS? DBMS STANDS FOR DATABASE MANAGEMENT SYSTEM. (DBMS เค•ा เคฎเคคเคฒเคฌ เคนै  เคกेเคŸाเคฌेเคธ เคฎैเคจेเคœเคฎेंเคŸ เคธिเคธ्เคŸเคฎ ) WE CAN REPRESNET IT AS MATHEMATICAL EXPRESSION LIKE... DBMS= DATABASE + MANAGEMENT + SYSTEM NOW WE WILL LEARN ABOUT THESE WHOLE WORD... DATABASE Database is a place where related peace of information is stored and various operations can be performed on it. เคกेเคŸाเคฌेเคธ เคเค• เคเคธी เคœเค—เคน เคนै เคœเคนाँ เคชเคฐ เคกाเคŸा เค•ो เคธंเค—ृเคนीเคค เค•िเคฏा เคœाเคคा เคนै เค”เคฐ เค‰เคธเคชे เค•เคˆ เคคเคฐเคน เค•े เค“เคชเคฐेเคถเคจ เคชเคฐเคซोเคฐ्เคฎ เค•िเคฏे เคœाเคคे เคนै | Database means collection of interrelated data where data can be easily access, managed and updated. เคกेเคŸाเคฌेเคธ เค•ा เคฎเคคเคฒเคฌ เคนै  เคกाเคŸा เค•ा เคธंเค—्เคฐเคน เค•เคฐเคจा เคœเคนाँ เคธे เค‰เคธे เคเค•्เคธेเคธ เคฎैเคจेเคœ เค”เคฐ เค…เคชเคกेเคŸ เค•िเคฏा เคœा เคธเค•े | (example:- student details) #2.MANAGEMENT A database management system is Software that provide user to stores data. เคกेเคŸाเคฌेเคธ เคฎैเคจेเคœเคฎेंเคŸ เคธिเคธ्เคŸเคฎ  เคเค• เคเคธा เคธॉเคซ्เคŸเคตेเคฐ เคนै เคœो เคฏूเคœเคฐ เค•ो เคธॉเคซ्เคŸเคตेเคฐ เค•े เคœเคฐिเคฏे  เคกाเคŸा  เคธंเค—्เคฐเคน เค•เคฐเคคा เคนै. It becomes easier to retrieve, manipulate and produce information for user. SYSTEM It ...
Read more

What is Database

Image
  What is Database? - The design of a DBMS depends on its architecture. -Database Architecture done through polices, rules and standards. -Architecture control that how to store data and how to use data. -Database Architecture is logically divided into three types. ONE TIER ARCHITECTURE :   (simple and easy presentation layer) All in one computer application data  presentation example: MS Office (word, Excel )  TWO TIER ARCHITECTURE : (client server architecture) Used for Application program that runs of client side clients are direct communication faster communication done by ODBC(OPEN DATABASE CONNECTIVITY) example: college/ organization THREE TIER ARCHITECTURE : (used for WEB APPLICATION) (internet) example: Facebook client-web server-Database server here, we can see that user is using a social media like Facebook so he will become client and now he will register himself and enter his details then that data will be pass to the web server. This data will be v...
Read more