Scribd Logo
Upload

Welcome to Scribd!

  • 15 views

    DBMS-1 PDF Hwifrb

    Uploaded by

    harshitg8218

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    DBMS-1 PDF Hwifrb

    Uploaded by

    harshitg8218
    15 views6 pages

    Original Title

    DBMS-1.pdf.hwifrb

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    15 views6 pages

    DBMS-1 PDF Hwifrb

    Uploaded by

    harshitg8218

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 6

    Introduction to DBMS

    database management system

    data
    a Base
    data refers to raw facts
    information about something

    Algoprep

    student employees Payment batch

    social media ads how its work

    analytical data

    Military Base
    A Place where military equipments are stored

    database
    A place where related data is stored

    lollection of related data


    database management system
    it is software system that enables user to

    detina create and maintain data base

    DB

    in
    P80d Payment
    Ulername UsntvAdd

    file system can behave like DBMS

    were LIE.at
    file
    system employees

    DBMS
    Produit

    it stored data in hierarishal form

    retrival of data is tough

    monit.aba gmail.com
    Akhilesh xyr gmail.com
    searching 0
    linear search

    I
    I
    fast searching

    heapalgy
    50,090

    data redancacy and inconsistance

    jutomar Payment

    cut Id pod Id
    lust name lust Id
    cult address transaction no

    Security and Access control

    personal information
    users

    file
    system employees

    DBMS
    Produit

    Payments banking device

    concurrency control

    dBMs t manages loncurrent access to data

    by multiple users or transaction


    types of databases

    Relational data Base MySQL SQL


    n struttered
    customer table database Query
    1 119 columns field Attributed language

    suit Id int name my t Address

    P1 1 magus 9788
    P2 2 Roasted 2943 92 sow records tuples

    P3 3 Amrendra 8797 axy

    break till 9 20

    Relation table
    Attributes columns characteristics of the entities

    typies rows it represents individual instance


    of data of entity
    number of attributes lolumne
    degree
    cardinality 1 number of tuples
    Properties rules of relation table

    each row is unique


    at most one attribute should be distinct

    suit Id int name my t Address

    I magus 9788 are


    2 Roasted 2943 92
    3 Amrendra 8797 axy
    4 magus 9788 are
    F
    G

    each cell can only contain a single value


    tell ian't contain any list collation of data

    suit Id int name my t Address

    1 magus 9788 are


    2 Roasted 92943 3497 7953 92
    3 Amrendra 8797 9345 2387 axy
    4 magus 9788 are
    F
    G

    mobile ne

    int ID mobile no

    2 29 47
    2 34 92
    2 7453
    3 8792

    4 9788

    order of the columns shouldn't matter


    list customer selent a from cut_take
    select last name int adds

    order of the rows shouldn't matter

    2 4 17 5,84 5 8,17 4,24

    You might also like