Skip to content

CS409 - Introduction to Database Administration

6 Topics 27 Posts
  • 0 Votes
    9 Posts
    187 Views
    zareenZ

    @zareen said in CS409 Assignment 2 Solution and Discussion:

    Consider the given below the ERD

    b715a3fa-af52-42a4-ac14-a1726d7469d4-image.png

  • 0 Votes
    2 Posts
    755 Views
    zaasmiZ

    @zaasmi said in CS409 Assignment 1 Solution and Discussion:

    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?

    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.

    Question # 02: Write any ten situations in which using SQLite will give best results?

    Solution:

    Embedded devices or applications Replacement for ad hoc disk files Stand-in for an enterprise database during testing or demos Multi-user applications Data analysis Application file format Server-side database Data transfer format Cache for enterprise data Internal or temporary database Websites File archive/ data container Education and Training Experimental SQL language extensions
  • 0 Votes
    2 Posts
    417 Views
    zareenZ

    This Assignment is related to Development phase and in this assignment you will focus only on the tasks given below:
    Consider the following ER Diagram and perform the given tasks;
    97ecee5b-8090-44e8-abbb-d4792f9d1d85-image.png
    Tasks: Solution

    Creating Database
    b975f726-020f-4c1d-b30c-6c41227dae97-image.png ab7e294c-1143-4720-8da5-9627ab0f1984-image.png

    Creating Tables

    1. Client Table
    36537b81-d04c-457a-b541-812ff1083377-image.png
    2c334d37-c5dd-42a0-a989-75b0eb90410f-image.png

    2. Event Table
    365d56ba-6d4b-4dae-9aca-cb6fae482c1f-image.png aee523b1-86c0-4ada-a24a-286247fc3ece-image.png

    3. Venue Table
    4191e19d-4f86-429e-80ca-d8c18b6639ef-image.png 91c55585-fcfb-4ba1-9165-669f871562d3-image.png b46ac29e-9b67-4695-b774-2c75d4d4f488-image.png

  • 0 Votes
    2 Posts
    117 Views
    zareenZ

    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:

    Embedded devices or applications Replacement for ad hoc disk files Stand-in for an enterprise database during testing or demos Multi-user applications Data analysis Application file format Server-side database Data transfer format Cache for enterprise data Internal or temporary database Websites File archive/ data container Education and Training Experimental SQL language extensions
  • 0 Votes
    1 Posts
    63 Views
    No one has replied
  • 0 Votes
    11 Posts
    734 Views
    zareenZ

    __________________ is typically fast compared to other migration technology.

    fd0bf4d6-de74-4104-b642-24d8284e7d7e-image.png