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

Welcome to Scribd!

  • 519 views

    Information Technology CLASS-12 Work Integrated Learning IT-DMA

    Uploaded by

    student of jee
    This document discusses how database management concepts can be helpful across several domains including education, banking, hospitals, government, companies, e-commerce, airlines, railways, telecommunications, and hotels. For each domain, it provides examples of the types of data that could be stored in databases, such as student information for education, customer and account details for banking, patient and staff information for hospitals, electoral and tax records for government, employee and project information for companies, product and customer data for e-commerce, flight and booking information for airlines, train schedules and reservations for railways, network and customer data for telecommunications, and guest information for hotels. It also provides examples of database schemas for patient and product tables

    Copyright:

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

    Information Technology CLASS-12 Work Integrated Learning IT-DMA

    Uploaded by

    student of jee
    519 views4 pages
    This document discusses how database management concepts can be helpful across several domains including education, banking, hospitals, government, companies, e-commerce, airlines, railways, telecommunications, and hotels. For each domain, it provides examples of the types of data that could be stored in databases, such as student information for education, customer and account details for banking, patient and staff information for hospitals, electoral and tax records for government, employee and project information for companies, product and customer data for e-commerce, flight and booking information for airlines, train schedules and reservations for railways, network and customer data for telecommunications, and guest information for hotels. It also provides examples of database schemas for patient and product tables

    Original Description:

    Original Title

    Work Integrated Learning

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document discusses how database management concepts can be helpful across several domains including education, banking, hospitals, government, companies, e-commerce, airlines, railways, telecommunications, and hotels. For each domain, it provides examples of the types of data that could be stored in databases, such as student information for education, customer and account details for banking, patient and staff information for hospitals, electoral and tax records for government, employee and project information for companies, product and customer data for e-commerce, flight and booking information for airlines, train schedules and reservations for railways, network and customer data for telecommunications, and guest information for hotels. It also provides examples of database schemas for patient and product tables

    Copyright:

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

    Information Technology CLASS-12 Work Integrated Learning IT-DMA

    Uploaded by

    student of jee
    This document discusses how database management concepts can be helpful across several domains including education, banking, hospitals, government, companies, e-commerce, airlines, railways, telecommunications, and hotels. For each domain, it provides examples of the types of data that could be stored in databases, such as student information for education, customer and account details for banking, patient and staff information for hospitals, electoral and tax records for government, employee and project information for companies, product and customer data for e-commerce, flight and booking information for airlines, train schedules and reservations for railways, network and customer data for telecommunications, and guest information for hotels. It also provides examples of database schemas for patient and product tables

    Copyright:

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

    INFORMATION TECHNOLOGY

    CLASS-12
    Work Integrated Learning IT-DMA
    1. Give few domains where database applications may be used:
    1. Education
    2. Banking
    3. Hospitals
    4. Government Sector
    5. Companies
    6. E-Commerce
    7. Airlines
    8. Railways
    9. Telecommunications
    10. Hotels

    2. How database management concepts are helpful in Education sector?


    1. For storing information such as student details, marks and result.
    2. For storing information about faculty and staff members.
    3. For storing details about school/college such as infrastructure details, department and
    offered course details

    3. How database management concepts are helpful in Banking sector?


    1. For storing information about customers. For example,
    (i) Personal details such as address, age, PAN card, occupation, contact numbers.
    (ii) Accounts and loans related information.
    (iii) Information regarding daily transactions.
    2. For storing employee details such as their personal information, salary, leaves
    3. taken, joining date, retirement year.

    4. How database management concepts are helpful in Hospitals sector?

    1. For maintaining information regarding patients such as their personal details, health
    records, hospitalization date.
    2. For storing information regarding doctors, nurses, staff members, rooms, medical
    equipment, and medicines.

    5. How database management concepts are helpful in Government sector?


    1. For storing details of electoral roll, all types of taxes (Income tax, sales tax, house tax
    etc.), criminal records.
    2. For storing details of PAN cards, AADHAR cards, vehicle registration, birth/death
    certificate registration.

    6. How database management concepts are helpful in companies?

    1. For storing information regarding employees such as name, address, contact


    number, salary, position, joining date.
    2. For maintaining information regarding the projects handled by them.
    3. For keeping track of infrastructure, sales, and investments.

    7. How database management concepts are helpful in E-commerce?

    1. For storing information regarding products such as price, quantity, quality,


    2. manufacturing date, seller.
    3. For storing information regarding customers such as name, contact number,
    4. address and their orders.

    8. How database management concepts are helpful in Airlines?

    1. For storing information about flight details such as arrival time, departure time, fares,
    2. passenger capacity, number of bookings.
    3. For keeping track of online and offline reservations.

    9. How database management concepts are helpful in Railways?


    1. For storing information about train details such as arrival time, departure time, fares,
    2. passenger capacity, number of bookings.
    3. For keeping track of online and offline reservations.

    10. How database management concepts are helpful in Telecommunications?

    1. For storing information regarding communication networks, customers, call records,


    and their bills.
    2. For storing information about the plans offered and plans subscribed by the users.

    11. How database management concepts are helpful in Telecommunications?

    1. For storing information regarding guests, their check-in and check-out times,
    duration of stay, room number allocated.
    2. For keeping track of booked and available rooms.
    3. For storing information regarding hotel staff, menu items, and infrastructure

    12. A Hospital is making database of patients and its staff. Doctor table includes Docid,
    Dname, and Department. Give details of Patient Table along with its schema.
    Patient table
    Name Type Remarks
    Pid Varchar(5) Patient unique number
    Pname Varchar(20) Patient name
    Phone Int(10) Patient phone no
    Disease Varchar(20) Disease he/she is suffering from

    Schema:- Patient (pid, pname,phone,disease)

    12. A shopping website is making database of customers and its products. Customer table s
    customer_id, password, first name, last_name, address, and email_id and contact_num. Give
    details of Product Table along with its schema.

    Schema: PRODUCT (Product_id, Name, Category_id, Price, Quantity)

    In this way, you have to imagine fields and their field type for the different tables.
    13. What are the possible functions for managing the PRODUCT table.

    In this way, you have to imagine functions for the different tables.

    You might also like