CS409 - Introduction to Database Administration

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. [image: kxWIiOy.png] For any query about the assignment, contact at CS409@vu.edu.pk GOOD LUCK

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 CS409@vu.edu.pk Good Luck

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; [image: U1DZCPN.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 CS409@vu.edu.pk GOOD LUCK

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 CS409@vu.edu.pk Good Luck

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 CS409@vu.edu.pk Good Luck

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