Your browser does not seem to support JavaScript. As a result, your viewing experience will be diminished, and you have been placed in read-only mode.

Please download a browser that supports JavaScript, or enable it if it's disabled (i.e. NoScript).

CS409 Assignment 3 Solution and Discussion

CS409 - Introduction to Database Administration

zareen Cyberian's Gold last edited by
```
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:
1. The assignment is submitted after the due date.
2. The submitted assignment does not open or the file is corrupt.
3. The assignment is fully or partially copied from (other student or ditto copy from the handouts or internet).
4. Student ID is not mentioned in the assignment File or name of file is other than the student ID.
5. The assignment is not submitted in .doc/docx format.
  Uploading instructions
  Your submission must include:
6. Assignment should be in .doc/docx format.
7. 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
Discussion is right way to get Solution of the every assignment, Quiz and GDB.
We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
NOTE: Don't copy or replicating idea solutions.
Quiz Copy Solution
Mid and Final Past Papers
Live Chat
1 Reply Last reply
Reply Quote 0

CS409 Assignment 2 Solution and Discussion
CS409 - Introduction to Database Administration • cs409 assignment 2 solution discussion spring 2020 • • zaasmi

9

0
Votes

9
Posts

86
Views

@zareen said in CS409 Assignment 2 Solution and Discussion:

Consider the given below the ERD

b715a3fa-af52-42a4-ac14-a1726d7469d4-image.png
MCD503 GDB 1 Solution and Discussion
MCD503 - TV News and Current Affairs • mcd503 gdb 1 solution discussion spring 2020 • • zareen

1

0
Votes

1
Posts

25
Views

No one has replied
BIF731 Assignment 1 Solution and Discussion
BIF731 - Advanced Bioinformatics • bif731 assignment 1 solution discussionf fall 2019 • • zareen

1

0
Votes

1
Posts

18
Views

No one has replied
UNSOLVED CS409 Quiz 2 Solution and Discussion
CS409 - Introduction to Database Administration • introduction to database administra cs409 quiz 2 solution discussion • • zareen

11

0
Votes

11
Posts

222
Views

__________________ is typically fast compared to other migration technology.

fd0bf4d6-de74-4104-b642-24d8284e7d7e-image.png
CS602 Assignment 2 Solution and Discussion Spring 2020
CS602 - Computer Graphics • cs602 assignment 2 solution discussion spring 2020 • • zaasmi

3

0
Votes

3
Posts

101
Views

Graphics library for 64 bit Dev CPP.rar
SOLVED CS409 Assignment 2 Solution and Discussion
CS409 - Introduction to Database Administration • cs409 assignment 2 solution discussion fall 2019 • • zareen

2

0
Votes

2
Posts

56
Views

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
SOLVED CS301 Assignment 1 Solution and Discussion
CS301 – Data Structures • cs301 assignment 1 solution discussion spring 2020 • • zaasmi

4

0
Votes

4
Posts

294
Views

@zareen
100% Solution Code
#include <iostream> using namespace std; /* The Student class */ class Student { private: string firstname, lastname, VUID; int marks; Student *nextStudent; public: // constructor of Student class to initialize data members of class Student(){ VUID = ""; marks = 0; firstname = ""; lastname = ""; nextStudent = NULL; } // Student class method to set VU ID of Student void setVUID(string val){ VUID = val; }; //Student class method to get VU ID of Student string getVUID(){ return VUID; }; // Student class method to set first name of Student void setFirstName(string val){ firstname = val; }; //Student class method to get first name of Student string getFirstName(){ return firstname; }; // Student class method to set last name of Student void setLastName(string val){ lastname = val; }; //Student class method to get last name of Student string getLastName(){ return lastname; }; //Student class method to set the Marks of Student void setMarks(int val) { marks = val; }; // Student class method to get the Marks of Student int getMarks() { return marks; } //Student class method to point current Student to next Student void setNext(Student *nextStudent) { this->nextStudent = nextStudent; } // Student class method to get memory address where pointer is pointing Student *getNext() { return nextStudent; } }; /* The List class */ class List { private: Student * head; Student * current; public: // constructor of list class to initialize data members of class List() { head = new Student(); head->setNext(NULL); current = NULL; } // list class method to add Students into list void add() { Student *newStudent = new Student(); int loc_marks = 0; string loc_vuid = "", loc_fname = "", loc_lname = ""; cout<<"\nEnter VU ID: "; cin>>loc_vuid; newStudent->setVUID(loc_vuid); cout<<"Enter Marks: "; cin>>loc_marks; newStudent->setMarks(loc_marks); cout<<"Enter First Name: "; cin>>loc_fname; newStudent->setFirstName(loc_fname); cout<<"Enter Last Name: "; cin>>loc_lname; newStudent->setLastName(loc_lname); if(head->getNext() == NULL){ newStudent->setNext(NULL); head->setNext(newStudent); current = newStudent; } else{ Student *temp = head; while(temp->getNext() != NULL && temp->getNext()->getMarks() >= loc_marks){ temp = temp->getNext(); } current = temp; newStudent->setNext(current->getNext()); current->setNext( newStudent ); current = newStudent; } }; // list class method to get the information of Student void getInfo() { if (current != NULL){ cout<<"VU ID: "<<current->getVUID()<<endl; cout<<"Marks: "<<current->getMarks()<<endl; cout<<"First Name: "<<current->getFirstName()<<endl; cout<<"Last Name: "<<current->getLastName()<<endl<<endl; } }; // list class method to move current to next Student bool next() { if (current == NULL){ return false; } current = current->getNext(); }; // frient function to list class to show all students in the list friend void showStudents(List list){ Student* savedCurrent = list.current; list.current = list.head; for(int i = 1; list.next(); i++){ list.getInfo(); } list.current = savedCurrent; }; }; main() { int input = 0; List lst; while(input != -1) { cout<<"1. To Add New Student in Ranking"<<endl; cout<<"2. To Display Ranking"<<endl; cout<<"3. To Close"<<endl<<endl; cout<<"Enter Your Choice: (1, 2 or 3) "; cin>> input; if(input == 1) { lst.add(); cout<<"Student's information saved successfully.\n"; } else if(input == 2) { cout<<"\nRanking Chart"<<endl; showStudents(lst); return 0; } else { return 0; } } }
SOLVED CS409 Assignment 1 Solution and Discussion
CS409 - Introduction to Database Administration • cs409 assignment 1 solution discussion fall 2019 • • zareen

2

0
Votes

2
Posts

36
Views

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

100% Off on Your FEE Join US! Ask Me How?

If you want to know how you can join us and get 100% Discount on your FEE ask Cyberian in Chat Room!

solution1255 discussion1206 fall 2019813 assignment 1433 assignment 2297 spring 2020265 gdb 1248 assignment 382 crw10174 spring 201955

| |

Live Chat

1 / 1

CS409 Assignment 3 Solution and Discussion

CS409 Assignment 2 Solution and Discussion CS409 - Introduction to Database Administration • cs409 assignment 2 solution discussion spring 2020 • • zaasmi

MCD503 GDB 1 Solution and Discussion MCD503 - TV News and Current Affairs • mcd503 gdb 1 solution discussion spring 2020 • • zareen

BIF731 Assignment 1 Solution and Discussion BIF731 - Advanced Bioinformatics • bif731 assignment 1 solution discussionf fall 2019 • • zareen

UNSOLVED CS409 Quiz 2 Solution and Discussion CS409 - Introduction to Database Administration • introduction to database administra cs409 quiz 2 solution discussion • • zareen

CS602 Assignment 2 Solution and Discussion Spring 2020 CS602 - Computer Graphics • cs602 assignment 2 solution discussion spring 2020 • • zaasmi

SOLVED CS409 Assignment 2 Solution and Discussion CS409 - Introduction to Database Administration • cs409 assignment 2 solution discussion fall 2019 • • zareen

SOLVED CS301 Assignment 1 Solution and Discussion CS301 – Data Structures • cs301 assignment 1 solution discussion spring 2020 • • zaasmi

SOLVED CS409 Assignment 1 Solution and Discussion CS409 - Introduction to Database Administration • cs409 assignment 1 solution discussion fall 2019 • • zareen

100% Off on Your FEE Join US! Ask Me How?

CS409 Assignment 2 Solution and Discussion
CS409 - Introduction to Database Administration • cs409 assignment 2 solution discussion spring 2020 • • zaasmi

MCD503 GDB 1 Solution and Discussion
MCD503 - TV News and Current Affairs • mcd503 gdb 1 solution discussion spring 2020 • • zareen

BIF731 Assignment 1 Solution and Discussion
BIF731 - Advanced Bioinformatics • bif731 assignment 1 solution discussionf fall 2019 • • zareen

UNSOLVED CS409 Quiz 2 Solution and Discussion
CS409 - Introduction to Database Administration • introduction to database administra cs409 quiz 2 solution discussion • • zareen

CS602 Assignment 2 Solution and Discussion Spring 2020
CS602 - Computer Graphics • cs602 assignment 2 solution discussion spring 2020 • • zaasmi

SOLVED CS409 Assignment 2 Solution and Discussion
CS409 - Introduction to Database Administration • cs409 assignment 2 solution discussion fall 2019 • • zareen

SOLVED CS301 Assignment 1 Solution and Discussion
CS301 – Data Structures • cs301 assignment 1 solution discussion spring 2020 • • zaasmi

SOLVED CS409 Assignment 1 Solution and Discussion
CS409 - Introduction to Database Administration • cs409 assignment 1 solution discussion fall 2019 • • zareen