Scribd Logo
Upload

Welcome to Scribd!

  • 26 views

    Data Dictionary

    Uploaded by

    qblhaqeem25
    This data dictionary describes the tables and attributes for the Shazlina Dental Center database. It includes tables for dentists, patients, appointments, invoices, insurance companies, and payments. Each table contains identifying attributes like primary keys as well as descriptive attributes. Data types are specified for each attribute along with any applicable ranges or requirements. Relationships between tables are defined through primary and foreign keys.

    Copyright:

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

    Data Dictionary

    Uploaded by

    qblhaqeem25
    26 views2 pages
    This data dictionary describes the tables and attributes for the Shazlina Dental Center database. It includes tables for dentists, patients, appointments, invoices, insurance companies, and payments. Each table contains identifying attributes like primary keys as well as descriptive attributes. Data types are specified for each attribute along with any applicable ranges or requirements. Relationships between tables are defined through primary and foreign keys.

    Original Description:

    Data Dictionary for database.

    Original Title

    DATA DICTIONARY

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This data dictionary describes the tables and attributes for the Shazlina Dental Center database. It includes tables for dentists, patients, appointments, invoices, insurance companies, and payments. Each table contains identifying attributes like primary keys as well as descriptive attributes. Data types are specified for each attribute along with any applicable ranges or requirements. Relationships between tables are defined through primary and foreign keys.

    Copyright:

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

    Data Dictionary

    Uploaded by

    qblhaqeem25
    This data dictionary describes the tables and attributes for the Shazlina Dental Center database. It includes tables for dentists, patients, appointments, invoices, insurance companies, and payments. Each table contains identifying attributes like primary keys as well as descriptive attributes. Data types are specified for each attribute along with any applicable ranges or requirements. Relationships between tables are defined through primary and foreign keys.

    Copyright:

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

    DATA DICTIONARY FOR SHAZLINA DENTAL CENTER

    TABLE NAME ATTRIBUTE CONTENTS TYPE FORMAT RANGE REQUIRED PK OR FK FK


    NAME REFERENCED
    TABLE
    DENTIST Den_ICNum Dentist IC VARCHAR(20) 999999-99- Y PK
    number 9999
    Den_Phone_ Dentist VARCHAR(20) 999-
    no Phone 9999999
    Number
    Den_Add Dentist VARCHAR(200) Xxxxxxxxx
    address
    Den_Room Dentist VARCHAR(10) 999 001-999
    Room
    Den_Name Dentist VARCHAR(100) Xxxxxxxxx
    name
    PATIENT Pat_ICNum Patient IC VARCHAR(20) 999999-99- Y PK
    number 9999
    Pat_Name Patient VARCHAR(50) Xxxxxxxxx
    name
    Pat_Phone_N Patient VARCHAR(20) 999-
    o phone 9999999
    number
    Pat_Add Patient VARCHAR(100) Xxxxxxxxx
    address
    APPOINTMENT App_ID Appointmen VARCHAR(10) 99999 00001 - Y PK
    t ID 99999
    Den_ICNum Dentist IC VARCHAR(20) 999999-99- FK DENTIST
    number 9999
    Pat_ICNum Patient IC VARCHAR(20) 999999-99- FK PATIENT
    number 9999
    App_Date Appointmen DATE yyyy-mm-
    t date dd
    App_Time Appointmen TIME hh:mm:ss
    t time
    INVOICE Inv_No Invoice VARCHAR(20) INVXXX Y PK
    number
    App_ID Appointmen VARCHAR(10) Xxxxx 00001 - FK APPOINTME
    t ID 10000 NT
    Inv_Total Invoice total DECIMAL(10,2) (x.x) 999999999
    9.99
    Inv_Date Invoice date DATE yyyy-mm-
    dd
    Inv_Status Invoice VARCHAR(20) Xxxxxx
    status
    INSURANCE_ Ins_ID Insurance ID VARCHAR(20) 99 01 - 10 Y PK
    COMPANY Ins_Name Insurance VARCHAR(100) Xxxxxxxx
    name
    PAYMENT Pay_No Payment VARCHAR(20) PYXXX Y PK
    number
    Inv_No Invoice VARCHAR(20) INVXXX Y PK,FK INVOICE
    number
    Pat_ICNum Patient IC VARCHAR(20) 999999-99- FK PATIENT
    number 9999
    Ins_ID Insurance ID VARCHAR(20) XXXXX 01 - 10 FK INSURANCE_
    COMPANY
    Pay_Total Payment DECIMAL(10,2) (x.x) 999999999
    total 9.99

    FK = Foreign Key
    PK = Primary Key
    VARCHAR = Variable character length data (1-2000 characters)
    DECIMAL = A fixed number of digits to the right of the decimal point.

    You might also like