Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1) Attempt the following :

(a) Differentiate between Floppy Disk and Hard Disk.

(b) Describe briefly the following output devices :

(i) Monitor

(ii) Dot Matrix Printer

(c) describe briefly the major parts of Central Processing Unit.

(d) Describe Structure of HTML Program.

(e) What do you understand by Primary Key and Foreign Key? Describe with ex.

problem 2) Attempt the following:

(a) Distinguish between Impact and Non-impact Printer.

(b) Function of Computer in Manufacturing and Medicine.

(c) What are the various types of Computers?

(d) What are the various services provided on Internet?

(e) What is Application Software? Describe with ex.

problem 3) Attempt the following:

(a) How does Primary Storage differs from Secondary Storage in terms of Speed, Cost, Capacity.

(b) What is Normalization? Why it is essential?

(c) prepare down various steps involved in Creating Website.

(d) Describe the following:

(i) Group by

(ii) Grouping functions

(e) Define the term Intranet and discuss how Intranets are used in business.

problem 4) Attempt the following:

(a) Describe briefly SQL Commands:

(i) Create Table

(ii) Update

(iii) Alter Table

(b) Differentiate between RAM and ROM.

(c) What is the use of Plotter and what are different types of Plotters ?

(d) Compare between Internet and Intranet.

(e) “The CPU is the brain of the Computer, the place where data is manipulated.” Comment.

problem 5) Attempt the following:

(a) What is World Wide Web ? describe use of Internet in various fields.

(b) describe structure and working of Magnetic Hard Disk.

(c) prepare notes:

(i) Input Devices

(ii) Joins

(iii) DDL and DML

(iv) Printers

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M95873

Have any Question?


Related Questions in DBMS

Suppose that we have a table of house prices and a table of

Suppose that we have a table of house prices and a table of zip codes: • hprices(hid (PK),address,bedrooms,price,zipcode) • zipcodes(zipcode (PK),state) Write a SQL query that finds the average, maximum, and minimum pric ...

This assignment is a continuation of this solution the case

This assignment is a continuation of this solution The case study company has received the first report from its enterprise content management (ECM) consultant and now has a documented list of major content requirements ...

Systems analysis project scenic routes operates a bus

Systems analysis project Scenic Routes operates a bus company that specializes in travelling on secondary roads, rather than Interstate highways. Their slogan is: "It Takes a Little Longer, But It's Scenic." The firm nee ...

Question 1 what isdata-manipulation language dml there are

Question: 1. What isData-Manipulation Language (DML)? There are four types of access in DML, explain each one. 2. Assume we have a Library Database consists of the following relations: author(author_id, first_name, last_ ...

Question 1 a- consider that you are asked to design an

Question: 1. (a)- Consider that you are asked to design an entity relationship diagram based on the below scenario: A university consists of a number of departments (id, d_name) and each department offers some courses. A ...

The groceries datasetimagine 10000 receipts sitting on your

The groceries Dataset Imagine 10000 receipts sitting on your table. Each receipt represents a transaction with items that were purchased. The receipt is a representation of stuff that went into a customer's basket. That ...

Question find at least two academic sources that describe

Question: Find at least two academic sources that describe the movement of Enterprise resource planning (ERP) activities to the cloud. Discuss the types of ERP activities that can be conducted in the cloud and the pros a ...

Assignmenta restaurant is designing a database to keep

Assignment A restaurant is designing a database to keep track of customer services. A customer is defined as a customer ID, name, address and a telephone number. Customers are served by employees. Each employee is define ...

Students will select a situation or problem from their

Students will select a situation or problem from their company as a course project that can be solved using a database system. Using MS Access, or MS SQL Server Express, students will create a relational database model o ...

Q1 given the following file for assignment workercom

Q1. Given the following file for assignment worker.com, identify data anomalies that must be removed before data can be loaded in data warehouse. Worker_assignment ← -----------------on course web site File is available ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As