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

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

311
Views

__________________ is typically fast compared to other migration technology.

fd0bf4d6-de74-4104-b642-24d8284e7d7e-image.png
SOLVED MCD403 Assignment 1 Solution and Discussion
MCD403 - Music Production • mcd403 assignment 1 solution discussion fall 2019 • • zareen

2

0
Votes

2
Posts

230
Views

Q.1 Solution:
Camera Jib:
Device that’s come into wide use in the last decade is the camera jib, essentially a long, highly maneuverable boom or crane-like device with a mounted camera at the end. You frequently see them in action swinging overhead at concerts and major events. A jib allows sweeping camera movements from ground level to nine meters (thirty feet) or more in the air.
Camera Copters/ Drone Cameras
Since remotely-controlled, helicopter-type drones can move into places inaccessible by individuals or fixed-wing aircraft, they can provide coverage of events otherwise unattainable. Plus, helicopter type drones can hover above news scenes for extended periods of time. The video signal is relayed (live) to a receiver on the ground.

Q.2 Differentiate the below given camera movements while giving an example of each.
・ Dolly
・ Trucking
Answer:
We refer to moving (rolling) the entire camera toward or away from the subject as a dolly (“dolly in” for a close shot or “dolly back” for a wide-shot).
A lateral move (rolling the camera to the left or right on the pedestal) is trucking, as in “truck left” or “truck right.”
ca18df05-0b55-4e1d-a7a0-2514460ef2e8-image.png
Do you recommend the pharmaceutical companies in Pakistan to replace the conventional health literacy campaigns with the online health literacy campaigns? Write four logical arguments to prove your point.
MGT602 - Entrepreneurship • solution • • Awais Hafeez

2

0
Votes

2
Posts

57
Views

@Awais-Hafeez Topic already posted please follow the link
FINI619 Assignment 2 Solution and Discussion
FINI619 - Internship Report-Finance • fini619 assignment 2 solution discussion fall 2019 • • zareen

1

0
Votes

1
Posts

48
Views

No one has replied
CS408 Assignment 2 Solution and Discussion Spring 2020
CS408 - Human Computer Interaction • assignment 2 cs408 discussion solution spring 2020 • • zaasmi

3

0
Votes

3
Posts

243
Views

@zaasmi said in CS408 Assignment 2 Solution and Discussion Spring 2020:

Question No. 2 05 Marks
Following table consists some scenarios related to Design principles. You are required to write down the design principle related to the particular scenario.

S.No.
Scenario Design
Principle

In older version of a work processor, one problem often encounters, when needed to set the properties of a word document, the option of properties should be in the File menu, and often seen it there. But once, file menu opened, it could not show there, it was so confusing. However, when a click on a small arrow at the bottom of file menu, it shows properties option again.

In a website or any app. graphical elements like button, icon, links, and scroll bars are talked about obvious use like as icons should be designed to clicking, scroll bars to moving up and down, buttons to pushing.

A common design practice in graphical user interfaces is to deactivate certain menu options by shading them, thereby restricting the user to only actions permissible at that stage of the activity.

On a computer keyboard, the up and down arrows used to represent the up and down movement of the cursor, respectively.

In a graphical user interface, the same input action always done to highlight any graphical object at the interfaces, such as always clicking the left mouse button to select the icons.

5be67f1d-c397-4ded-83de-d61affefc5a2-image.png c227de35-3164-42a3-b82c-f164f3bd1e02-image.png
SOLVED CS409 Assignment 1 Solution and Discussion
CS409 - Introduction to Database Administration • cs409 assignment 1 solution discussion spring 2020 • • zaasmi

2

0
Votes

2
Posts

289
Views

@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
EDU602 Assignment 1 Solution and Discussion
EDU602 - Educational Leadership and Management • edu602 assignment 1 solution discussion fall 2019 • • zareen

1

0
Votes

1
Posts

436
Views

No one has replied
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

186
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

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

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

SOLVED MCD403 Assignment 1 Solution and Discussion MCD403 - Music Production • mcd403 assignment 1 solution discussion fall 2019 • • zareen

Do you recommend the pharmaceutical companies in Pakistan to replace the conventional health literacy campaigns with the online health literacy campaigns? Write four logical arguments to prove your point. MGT602 - Entrepreneurship • solution • • Awais Hafeez

FINI619 Assignment 2 Solution and Discussion FINI619 - Internship Report-Finance • fini619 assignment 2 solution discussion fall 2019 • • zareen

CS408 Assignment 2 Solution and Discussion Spring 2020 CS408 - Human Computer Interaction • assignment 2 cs408 discussion solution spring 2020 • • zaasmi

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

EDU602 Assignment 1 Solution and Discussion EDU602 - Educational Leadership and Management • edu602 assignment 1 solution discussion fall 2019 • • zareen

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

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

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

SOLVED MCD403 Assignment 1 Solution and Discussion
MCD403 - Music Production • mcd403 assignment 1 solution discussion fall 2019 • • zareen

Do you recommend the pharmaceutical companies in Pakistan to replace the conventional health literacy campaigns with the online health literacy campaigns? Write four logical arguments to prove your point.
MGT602 - Entrepreneurship • solution • • Awais Hafeez

FINI619 Assignment 2 Solution and Discussion
FINI619 - Internship Report-Finance • fini619 assignment 2 solution discussion fall 2019 • • zareen

CS408 Assignment 2 Solution and Discussion Spring 2020
CS408 - Human Computer Interaction • assignment 2 cs408 discussion solution spring 2020 • • zaasmi

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

EDU602 Assignment 1 Solution and Discussion
EDU602 - Educational Leadership and Management • edu602 assignment 1 solution discussion fall 2019 • • zareen

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