Navigation

    Cyberian
    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular
    • Pro Blog
    • Users
    • Groups
    • Unsolved
    • Solved
    Quiz 100% Result
    • CS409 Assignment 2 Solution and Discussion

      zaasmi

      Re: CS409 Assignment 2 Solution and Discussion

      Assignment No. 02

      SEMESTER SPRING 2020
      CS409- Introduction to Database Administration
      Total Marks: 20
      Due Date: 23/06/2020

      The objectives of this assignment are,

      • To give students the idea of the most commonly used RDBMS for designing logical data model.
      • To learn how to convert entities and attributes into tables and columns.
      • To make relationship between them.

      Lectures Covered: This assignment covers topics discussed in Week # 04-05

      Task Description:

      Scenario:

      CarMatch is a franchising company that is being set up to promote car sharing. CarMatch seeks to promote car sharing and to provide a service to potential car sharers by matching up people who both live and work near one another. . People who join up will pay a small membership fee, which will be refunded if the local CarMatch franchise is unable to match them up with one or more other people who require or are offering transport. The CarMatch franchise will draw up model agreements between the participants, to prevent the money that changes hands to cover fuel costs being treated as taxable income, and advice on the insurance implications of car sharing. It will act as an agent for companies that sell insurance policies that specifically cover car sharing.

      Consider the given below the ERD of a scenario given here. You are required to convert it into its logical model.

      94714c89-e8e0-428b-ac0e-2ffe14902053-image.png

      For any query about the assignment, contact at [email protected]

      GOOD LUCK

      CS409 - Introduction to Database Administration
    • CS409 Assignment 1 Solution and Discussion

      zaasmi

      Re: CS409 Assignment 1 Solution and Discussion

      Assignment No. 01
      SEMESTER Spring 2020
      CS409- Database Administration
      Total Marks: 20

      Due Date: 01/06/2020
      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 on or before 01/06/2020.

      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

      CS409 - Introduction to Database Administration
    • CS409 Assignment 2 Solution and Discussion

      zareen
      Assignment No. 02

      SEMESTER FALL 2019
      CS409- Introduction to Database Administration
      Total Marks: 20

      Due Date: 29/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 the due date.
      o The submitted assignment does not open or the file is corrupt.
      o The assignment is fully or partially copied from (other student or ditto copy from handouts or internet).
      o The 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 objectives of this assignment are,

      • To give students the idea of the most commonly used RDBMS for designing physical database systems i.e. SQL Server.
      • To build and manage tables in SQL Server.
      • To apply constraints e.g. Primary Key and Foreign Key on attributes.

      Lectures Covered: This assignment covers topics discussed in Week # 04-05

      Deadline
      Your assignment must be uploaded/submitted on or before 29/11/2019.

      Task Description:

      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:

      Follow the procedure explained in audio lectures to open the SQL Server and create a database with the name “Events”. You are required to transform all entities into tables by using design view method. You have to transform all entity attributes into columns. Define appropriate data types of each attribute. Apply necessary constraints on attributes. Take screenshots of every step and paste them in your solution file (.doc/docx file).

      For any query about the assignment, contact at [email protected]

      GOOD LUCK

      CS409 - Introduction to Database Administration
    • CS409 Assignment 1 Solution and Discussion

      zareen
      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

      CS409 - Introduction to Database Administration
    • CS409 Assignment 3 Solution and Discussion

      zareen
      Assignment No. 03

      SEMESTER Fall 2019
      CS409- Database Administration
      Total Marks: 20

      Due Date: 21/01/2020

      Instructions
      Please read the following instructions carefully before solving & submitting assignment:
      It should be clear that your assignment will not get any credit if:

      The assignment is submitted after the due date.

      The submitted assignment does not open or the file is corrupt.

      The assignment is fully or partially copied from (other student or ditto copy from the handouts or internet).

      Student ID is not mentioned in the assignment File or name of file is other than the student ID.

      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
      To give some important knowledge about the database environment of organization

      Lectures Covered: This assignment covers Lecture # 08 – 11

      Deadline

      Your assignment must be uploaded/submitted on or before 21/1/2020.

      Question # 01:

      Suppose you have the database titles as “SchoolManagement” and you are asked to create its backup. Write down all steps of creating full backup using Microsoft Management Studio and write T-SQL query of creating backup code also.

      For any query about the assignment, contact at [email protected]
      Good Luck

      CS409 - Introduction to Database Administration
    • CS409 Quiz 2 Solution and Discussion

      zareen

      Quiz # 2 Total Questions : 10
      Please read the following instructions carefully!
      Quiz will be based upon Multiple Choice Questions (MCQs).

      You have to attempt the quiz online. You can start attempting the quiz any time within given date(s) of a particular subject by clicking the link for Quiz in VULMS.

      Each question has a fixed time of 90 seconds. So you have to save your answer before 90 seconds. But due to unstable internet speeds, it is recommended that you should save your answer within 60 seconds. While attempting a question, keep an eye on the remaining time.

      Attempting quiz is unidirectional. Once you move forward to the next question, you can not go back to the previous one. Therefore before moving to the next question, make sure that you have selected the best option.

      DO NOT press Back Button / Backspace Button while attempting a question, otherwise you will lose that question.

      DO NOT refresh the page unnecessarily, specially when following messages appear
      Saving…
      Question Timeout: Now loading next question…

      Javascript MUST be enabled in your browser; otherwise you will not be able to attempt the quiz.

      If for any reason, you lose access to internet (like power failure or disconnection of internet), you will be able to attempt the quiz again from the question next to the last shown question. But remember that you have to complete the quiz before expiry of the deadline.

      If any student failed to attempt the quiz in given time then no re-take or offline quiz will be held.

      Start Quiz

      CS409 - Introduction to Database Administration

    SOLVED CS409 Assignment 1 Solution and Discussion

    CS409 - Introduction to Database Administration
    assignment 1 cs409 discussion fall 2019 solution
    1
    2
    8
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • zareen
      zareen Cyberian's Gold last edited by

      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

      1 Reply Last reply Reply Quote 0
      • zareen
        zareen Cyberian's Gold last edited by

        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
        1 Reply Last reply Reply Quote 0
        • zareen
          zareen Cyberian's Gold last edited by

          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
          1 Reply Last reply Reply Quote 0
          • First post
            Last post

          50% Off on Your FEE Join US!

          Quiz 100% Result If you want to know how you can join us and get 50% Discout on your FEE ask Cyberian in Chat Room! Quiz 100% Result Quiz 100% Result
          solution1241 discussion1193 fall 2019813 assignment 1425 assignment 2295 spring 2020265 gdb 1246 assignment 382 crw10174 spring 201955
          | |
          Copyright © 2021 Cyberian Inc. Pakistan | Contributors
          Live Chat