Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 91 views

    Data Dictionary

    Uploaded by

    Sujan Shrestha
    The document discusses different types of data dictionaries: - An active data dictionary is automatically managed by the database management system software and is integrated into the relational database management system (RDMS). - A passive data dictionary requires manual updates since the data is not automatically updated in the database system. - An example data dictionary table is provided that defines the fields, data types, primary keys, and foreign key relationships for various tables in a game database including user info, heroes, skins, hero profiles, game modes, game histories, team info, and game stats.

    Copyright:

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

    Data Dictionary

    Uploaded by

    Sujan Shrestha
    91 views2 pages
    The document discusses different types of data dictionaries: - An active data dictionary is automatically managed by the database management system software and is integrated into the relational database management system (RDMS). - A passive data dictionary requires manual updates since the data is not automatically updated in the database system. - An example data dictionary table is provided that defines the fields, data types, primary keys, and foreign key relationships for various tables in a game database including user info, heroes, skins, hero profiles, game modes, game histories, team info, and game stats.

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document discusses different types of data dictionaries: - An active data dictionary is automatically managed by the database management system software and is integrated into the relational database management system (RDMS). - A passive data dictionary requires manual updates since the data is not automatically updated in the database system. - An example data dictionary table is provided that defines the fields, data types, primary keys, and foreign key relationships for various tables in a game database including user info, heroes, skins, hero profiles, game modes, game histories, team info, and game stats.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    91 views2 pages

    Data Dictionary

    Uploaded by

    Sujan Shrestha
    The document discusses different types of data dictionaries: - An active data dictionary is automatically managed by the database management system software and is integrated into the relational database management system (RDMS). - A passive data dictionary requires manual updates since the data is not automatically updated in the database system. - An example data dictionary table is provided that defines the fields, data types, primary keys, and foreign key relationships for various tables in a game database including user info, heroes, skins, hero profiles, game modes, game histories, team info, and game stats.

    Copyright:

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

    a.1.

    Data Dictionary
    Database dictionary is the set of files which contains the metadata of database system. Being the crucial
    part of the relational database, it provides additional information about relationships between the
    entities and columns, helps to organize data in neat form by removing the redundancy (Singh, 2009).

    b) Active Data Dictionary


    The database management system software manages active data automatically and in a systematic way
    which is done mostly in RDMS as the active data dictionary. It is also called as integrated data dictionary.

    c) Passive Data Dictionary


    The data in the database system are not automatically updated so we need to have manual
    manipulation to keep the record as updated. It is very difficult to update the data in the system
    manually. That is why it is also called as non-integrated data dictionary.
    The data dictionary that is used to complete the database management system is given below;

    Table7: Data Dictionary.

    Table Field Name Data Type Format Primary Key or Foreign Key
    Foreign Key Reference
    User_Info email VARCHAR(50) Sujan22@gmail.com
    username VARCHAR(40) Sujan
    userID INT 100 Primary Key
    currentstatus NVARCHAR(20) ON
    battlepoints INT 20
    diamonds INT 780
    global_level INT 5
    game_played INT 8
    hero_details hero_name VARCHAR(20) FLASHER
    hero_id INT 1 Primary key
    hero_role VARCHAR(50) ASSASIN
    specialability VARCHAR(50) REGEN
    hero_price INT 1500
    skins hero_id INT 1 Foreign key hero_details
    skin_name VARCHAR(50) PURE GOLD
    skin_id INT 1000 Primary key
    price_skin INT 1200
    Hero_profiles userID INT 100 PK and FK User_Info
    heroID INT 2 Foreign key hero_deetails
    skinID INT 1004 Foreign key skins
    hero_level INT 12
    gamemode modeID INT 1 Primary key
    modename VARCHAR Brawl mode
    gamehistories gameID INT 1 Foreign key GAMESTAT
    userID INT 100 Foreign key User_Info
    modeID
    gamedate INT 2 Foreign key gamemode
    hero_id DATE 2021-02-14
    INT 2 Foreign key hero_details
    TEAMINFO TEAMID INT 1 Primary Key
    PLAYER1 INT 100 Foreign Key User_Info
    PLAYER2 INT 102 Foreign Key User_Info
    PLAYER3 INT 105 Foreign Key User_Info
    PLAYER4 INT 107 Foreign Key User_Info
    PLAYER5 INT 101 Foreign Key User_Info
    GAMESTAT GameID INT 1 Primary key
    userID INT 100 Foreign key User_Info
    modeID INT 2 Foreign key gamemode
    gamedate DATE 2021-02-14
    winner INT 1 Foreign key TEAMINFO
    loser INT 2 Foreign key TEAMINFO

    You might also like