Showing posts with label 2000. Show all posts

QUESTION PAPER » CS-06 QUESTION PAPER OF JUNE 2000

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JUNE 2000 QUESTION PAPER
BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
June, 2000
 CS-06:DATABASE MANAGEMENT SYSTEM
Time : 3 Hours
Max. Marks : 75

Note : Question one is compulsory. Answer any three from the rest.

Q.1(a). List all functional dependencies and multi-valued dependencies satisfied by the relation of the figure below:

A B C D
a1 b1 c1 d1
a1 b2 c1 d1
a2 b2 c2 d2
a2 b3 c2 d3
a3 b3 c2 d4

(b) When designing an E-R diagram for a particular enterprise, there exist several alternative designs.
(i) What criteria should you consider in deciding on the appropriate choice?

(ii) Come up with several alternative E-R diagrams to represent an enterprise. [jst the merits of each alternative and argue in favour of one of the alternatives.

(c) Given the EMPLOYEE and SALARY relations.
Find the natural Join(EMPLOYEE[X] SALARY)

Q.2(a) (i). Explain how each view is defined by a schema. Discuss the different views. Views by Schema:

(ii) Discuss levels of architecture for a DBMS.

(b)Design a Relational Database corresponding to the E-R diagram given below:
--DIAGRAM IS NOT AVAILABLE--

Q.3(a). Compare and contrast Sequential and Indexed Sequential file organisations

(b)Why is a B tree a better structure than a B-tree for implementation of an indexed sequential file? Discuss

Q.4. Consider the following tables A, B and AB in which S# is supplier code. P# is product code and QTY is quantity and ethers carry their respective meaning.

A
S# SNAME SCITY TURNOVER
110 XXX BHOPAL 50
111 YYY MUMBAI 100
112 ZZZ DEHRADUN 70
113 sss HYDERABAD 20

B
P# WEIGHT COLOUR COST SELLING PRICE
1 25 VIOLET 10 30
2 30 BROWN 15 55
3 35 VIOLET 17 55

AB
S# P# QTY
100 1 100
11 1 15
110 2 50
111 2 30
110 3 10
112 3 100
113 1 20

Write appropriate SQL statements for the following:

(i) Get the part numbers for the parts being supplied with no duplicates.

(ii) Get the supplier number and part number in ascending order of supplier number and descending order for the part supplied for each supplier.

(iii) Get the details of suppliers who operate from MUMBAI with turnover > 50.

(iv) Get the part numbers weighing between 25 and 35.

(v) Get the names and cities of suppliers whose names begin with XXX.

Q.5(a). Describe HISAM as the internal access methods for a hierarchical data base illustrating their features and implications thereof in database performance.

(b) Discuss the 3 most important Code’s commandments through examples.

Q.6(a). Compare and contrast knowledge database and DBMS. Give any two examples of knowledge database applications and explain.

(b)Compare and contrast production rule system and frame base representation with appropriate examples.
Read More

JUNE 2000 CS-611 QUESTION PAPER

IGNOU BCA CS-611: COMPUTER FUNDAMENTALS AND PC SOFTWARE - JUNE 2000 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
June, 2000
CS-611: COMPUTER FUNDAMENTALS AND PC SOFTWARE
Time : 2 Hours
Max. Marks : 60

Note: Question number 1 is compulsory.Attempt any three questions from the rest.

1. (a) What are the components of von-Neumann architecture ? How do you construct a von-Neumann machine using Integrated Circuit chips ? Propose mechanisms to overcome the von-Neumann bottleneck.
(b) (i) Why do you need external interfaces in computers ?
(ii) Compare and contrast the features of Random Access Memories and Read
Only Memories.
(iii) what is a Supercomputer ? Where can it be used?
(c) What is Graphical User Interface ? What are the advantages /disadvantages of Windows based systems ?
(d) What is meant by the term "Communication Channels" ? What are the factors that affect the choice of right communication media ? Describe a popular communication media used for local area networks.
(e) What is cryptography? Describe the Data Encryption Standard (DES) for
cryptography. What are the drawbacks of DES ? Is there any better method existing than DES ?
(f) Describe the use of basic elements of a programming language with the help of an example.

2. Compare and contrast the following :
(a) Direct Access versus Random Access
(b) Assembly Language versus High-level languages
(c) Input/Output Module versus Input/Output processor
(d) Laser printer versus Inkjet printer.
(e) Reduced Instruction Set Computers versus Complex Instruction Set Computers

3. (a) Compare and contrast the characteristics and advantages/disadvantages of SPOOLING and BUFFERING.
(b) What is a distributed operating system ? What are the advantages of distributed operating system ? Compare and contrast the characteristics of distributed operating system with network operating system.
(c) What are the ways by which a user can interact with the operating system ? Explain with the help of example/s.

4. (a) What is the need of having a Local Area Network (LAN) ? Describe the various
characteristics of LAN. Why do you need WANs ? Do WANs have same characteristics as LANs ? Justify your answer.
(b) Describe the following terms in the context of Computer Networks :
(i) PSTN
(ii) EDI
(iii) Co-axial Cable
(iv) ISDN
(v) CSMA/CD

5. (a) Describe the need of mail merge in a word processor with the help of an example.
(b) What are macros ? What are their applications ?
(c) What are the security threats to a computer if it is on a wide area network ?
(d) "DOS viruses cannot infect Windows 95 or Windows NT". IS the above statement true ? Justify your answer.
Read More

JUNE 2000 CS-610 QUESTION PAPER

IGNOU BCA CS-610: FOUNDATION COURSE IN ENGLISH FOR COMPUTING - JUNE 2000 QUESTION PAPER

CS - 610 FOUNDATION COURSE IN ENGLISH FOR COMPUTING
JUN 2000
Time : 2 Hours Max. Marks : 50
Note : Answer all questions:

1. Read the passage given below and then answer the questions which are based on what is stated or implied in the passage :

It seems distance has ceased to bother mankind. You can exchange letters and your thoughts with someone, despite thousands of miles separating you, in a matter of few seconds, if you so desire. The wonders of today's communications, or means of it, have taken enormous proportions, not to mention those of information technology. Whoever said that the world is shrinking day by day couldn't have been more true. As the twilight years of the last century came to an end, it became a more confirmed assertion.

Communication is making that happen. As always, necessity is the cornerstone of all newer discoveries and inventions. The latest in the electronic media being the much talked about and advocated INTERNET. If you've heard the word, its only natural. Special features on Internet dailies, magazines and the overall media have made it virtually impossible to get off the mark upheld as a phenomenon. Internet is being referred to as the ultimate in electronic democracy.
All you need to tap this marvelous reservoir of information sounds incredible - a telephone line, a modem computer and an Internet connection. And what can you do ? Well, exchange letters and thoughts is just the tip of the iceberg. Much more ! You can scan scientific articles, see advertisements at your will, do shopping, select tourist spots in Australia with ideal boarding and lodging places, information on travel guides sitting here in India, enjoy jokes, movies, in this no holds barred means of communication. Time is not far when Internet access will be available through cable network.

(i) Why does distance not bother mankind today ?
(ii) What does the word 'that' refer to in paragraph 2 ?
(iii) What two things would you like to do with Internet ?
(iv) Give another word similar in meaning to :
(a) Wonders
(b) enormous
(v) Give a word opposite in meaning to :
(a) incredible
(b) shrinking

2. Fill in the blanks with the correct form of the verb given in brackets :
(a) She _________________ (go) abroad every year .
(b) He __________________ (drink) coffee every morning.
(c) He __________________ (work) for an hour.
(d) He __________________ (return) before I left the shop.
(e) The quality of the onions _____________ (be) not good.
(f) Either Mohan or Ram _______________ (have) stolen the watch.

3. Do as directed :
(a) ______________ girl in red dress is my daughter (insert an article )
(b) He is _____________ honorable man. (insert an article)
(c) The work was done ________________ haste (insert a preposition)
(d) She said ," We were thinking of selling the house but we have decided not to ".
(change into reported speech)
(e) "You'd better not drink the water till it has been boiled, "she said.
(change into reported speech)
(f) If I lived near the office ___________________. (complete the sentence)
(g) He is very weak. He cannot walk. (combine the two sentences into one simple
sentence)
(h) I bought a book yesterday. It has been stolen. (combine the two sentences into one complex sentence)

4. Rewrite the following in passive voice :
(a) I remember my father taking me to the circus.
(b) They threw away all the old magazines.
(c) Who broke this vase ?
(d) I have warned you of the danger.
(e) He made us work.
(f) She will keep her jewellery in the safe.

5. Write a paragraph not exceeding 150 words on any one of the following topics :
(i) Importance of Discipline in Life
(ii) The Telephone
(iii) Fast Food Culture
(iv) Leisure

6. Write a composition in about 350-400 words on any one of the following topics :
(i) The Advantages of Distance Learning
(ii) Science in the Service of Mankind.
(iii) Books : An Investment
(iv) Environment Pollution

Read More