Scribd Logo
Upload

Welcome to Scribd!

  • 22 views

    Database معاوية مسلماني

    Uploaded by

    Memo Ner
    1. The document outlines the development of several database tables including accounting, employees, transactions, and inventory base data. 2. The accounting table includes account codes, names, currencies, departments, and project codes and names. 3. The employees table includes staff codes, names, departments, dates of birth, titles, and manager names. 4. The transactions table includes transaction codes, titles, currencies, exchange rates. 5. The inventory table includes item codes, names, measurements, quantities in and out, and balances.

    Copyright:

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

    Database معاوية مسلماني

    Uploaded by

    Memo Ner
    22 views5 pages
    1. The document outlines the development of several database tables including accounting, employees, transactions, and inventory base data. 2. The accounting table includes account codes, names, currencies, departments, and project codes and names. 3. The employees table includes staff codes, names, departments, dates of birth, titles, and manager names. 4. The transactions table includes transaction codes, titles, currencies, exchange rates. 5. The inventory table includes item codes, names, measurements, quantities in and out, and balances.

    Original Description:

    finance

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    1. The document outlines the development of several database tables including accounting, employees, transactions, and inventory base data. 2. The accounting table includes account codes, names, currencies, departments, and project codes and names. 3. The employees table includes staff codes, names, departments, dates of birth, titles, and manager names. 4. The transactions table includes transaction codes, titles, currencies, exchange rates. 5. The inventory table includes item codes, names, measurements, quantities in and out, and balances.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    22 views5 pages

    Database معاوية مسلماني

    Uploaded by

    Memo Ner
    1. The document outlines the development of several database tables including accounting, employees, transactions, and inventory base data. 2. The accounting table includes account codes, names, currencies, departments, and project codes and names. 3. The employees table includes staff codes, names, departments, dates of birth, titles, and manager names. 4. The transactions table includes transaction codes, titles, currencies, exchange rates. 5. The inventory table includes item codes, names, measurements, quantities in and out, and balances.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 5

    1- 

        Developing the accounting base data that includes:


    1 2 3
    PK FK FK FK
    Account Account Currency Department
    Currency name Project code Project name
    code name code code

    1 2
    PK PK
    Currency Currency
    Project name
    code name Project code

    2- Developing the employees base data that includes:

    3
    PK FK
    date of berth o
    day
    department department Manager
    staff code staff name o month Title
    code name name
    o year

    3- Developing the transaction base data that includes:

    1
    PK FK
    Transaction Transaction Currency
    Currency name Exchange rate
    code title code

    4-   Developing the inventory base data that includes:


    6
    PK FK
    Measureme Measurement
    Item code Item name Quantity in Quantity out Balance
    nt code name

    6
    PK
    Measureme Measureme
    nt code nt name
    4 5
    FK FK
    Department Production Production
    Staff code Staff name Amount Description
    name line code line name

    3 4 5
    PK PK PK
    Department Department Production Production line
    Staff code Staff name
    code name line code name
    Description
    ‫اعداد الطالب ‪ -‬معاوية مسلماني ‪11714675‬‬

    You might also like