CS409 Assignment 1 Solution and Discussion


  • Cyberian's Gold

    Assignment No. 01 
    

    SEMESTER Fall 2019
    CS409- Database Administration
    Total Marks: 20

    Due Date: 15/11/2019

    Instructions
    Please read the following instructions carefully before solving & submitting assignment:
    It should be clear that your assignment will not get any credit if:
    o The assignment is submitted after due date.
    o The submitted assignment does not open or file corrupt.
    o The assignment is fully or partially copied from (other student or ditto copy from handouts or internet).
    o Student ID is not mentioned in the assignment File or name of file is other than student ID.
    o The assignment is not submitted in .doc/docx format.
    Uploading instructions
    Your submission must include:

    • Assignment should be in .doc/docx format.
    • Save your assignment with your ID (e.g bx020200786.doc/docx).
    Assignment submission through email is NOT acceptable
    Objective
    The objective of this assignment is
    o To give some important knowledge about the database environment of organization

    Lectures Covered: This assignment covers Lecture # 01 – 03

    Deadline

    Your assignment must be uploaded/submitted at or before 15/11/2019.

    Question# 01:

    Scenario
    In today’s era of intelligence and mobility where every thing is shifted on mobile like mobile commerce, and mobile computing. Suppose you are working as DBA in a multinational company which works on mobile system and your company decided to change the database structure to embedded database, and as a DBA you suggest your company to used SQLite. State the reasons by which you will convince your company seniors to use SQL Lite?
    Question # 02: Write any ten situations in which using SQLite will give best results?
    For any query about the assignment, contact at [email protected]
    Good Luck


  • Cyberian's Gold

    Q.1 Solution: SQLite is file based and embeddable relational database management system. As it is lite and due to its support to relational database management system it is best to use in mobile applications. So, SQLite is very appropriate to construct an embedded database system. It is light database, and it is direct file system engine that uses SQL syntax, also doesn’t require a special database server or anything.
    Similarly, SQLite can easily adjust with the requirements of embedded system as it has small core, open source and database is a file which is very easy to apprehend the copy, move and cross platform sharing of database files. Now a days, SQLite use is increasing in embedded systems due to its advantages. SQLite will be more widely used in the embedded field, such as the remote control, intelligent mobile terminal, information appliances control, home medical equipment, mobile devices etc. In a multiplatform architecture SQLite having wide scope.

    Q. 2 Solution:

    1. Embedded devices or applications
    2. Replacement for ad hoc disk files
    3. Stand-in for an enterprise database during testing or demos
    4. Multi-user applications
    5. Data analysis
    6. Application file format
    7. Server-side database
    8. Data transfer format
    9. Cache for enterprise data
    10. Internal or temporary database
    11. Websites
    12. File archive/ data container
    13. Education and Training
    14. Experimental SQL language extensions

  • Cyberian's Gold

    Q.1 Solution: SQLite is file based and embeddable relational database management system. As it is lite and due to its support to relational database management system it is best to use in mobile applications. So, SQLite is very appropriate to construct an embedded database system. It is light database, and it is direct file system engine that uses SQL syntax, also doesn’t require a special database server or anything.
    Similarly, SQLite can easily adjust with the requirements of embedded system as it has small core, open source and database is a file which is very easy to apprehend the copy, move and cross platform sharing of database files. Now a days, SQLite use is increasing in embedded systems due to its advantages. SQLite will be more widely used in the embedded field, such as the remote control, intelligent mobile terminal, information appliances control, home medical equipment, mobile devices etc. In a multiplatform architecture SQLite having wide scope.

    Q. 2 Solution:

    1. Embedded devices or applications
    2. Replacement for ad hoc disk files
    3. Stand-in for an enterprise database during testing or demos
    4. Multi-user applications
    5. Data analysis
    6. Application file format
    7. Server-side database
    8. Data transfer format
    9. Cache for enterprise data
    10. Internal or temporary database
    11. Websites
    12. File archive/ data container
    13. Education and Training
    14. Experimental SQL language extensions


    Recent Topics


| DMCA.com Protection Status