CS-06 December, 2006 Question Paper

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - DECEMBER 2006 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 
December, 2006
 CS-06:DATABASE MANAGEMENT SYSTEM
Time : 3 Hours
Max. Marks : 75


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

1. (a) A university registrar’s office maintains data about the following entities : (10)
(i) Course, including number, title, credits, syllabus and prerequisites
(ii) course offering, including course number, year, semester, section number, instructor(s), timings and class room.
(iii) students, including student-id, name and program.
(iv) Instructors, including identification number, name, department and title.

Further, the enrollment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modelled. Construct an E = R diagram for the Registrar’s office. Document all assumptions that you make about the mapping constraints.

(b) Discuss the three level architecture of DBMS. Explain how does it lead to data independence.(7)
(c) With the help of an example, explain the inverted file organization.(4)

(d) What is a view ? Explain with the help of an example. Also specify the five conditions that a view must meet in order to allow the updates.
(e) With the help of an example, explain how knowledge representation can be done through Semantic Network.(4)

2. (a) Consider the following 3 tables:
PAINTER
PTR_NUM
PTR_LASTNAME
PTR_FIRSTNAME
PTR_INITIAL
PTR_AREACODE
PTR_PHONE

GALLERY
GAL_NUM
GAL_OWNER
GAL_AREACODE
GAL_PHONE
GAL_RATE

GALLERY
GAL_NUM
GAL_OWNER
GAL_AREACODE
GAL_PHONE
GAL_RATE

PAINTING
PNTG_NUM
PNTG_TITLE
PNTG_PRICE
PTR_NUM
GAL_NUM

Write the relational algebraic expressions/queries for the following operations :

(i) Find all painters who have painted in GAL_NUM=4.
(ii) Find all paintings of Gallery whose rate is
(iii) Find the Gallery in which painter ‘Ramesh’ has ” displayed his paintings.
(iv) Find the number of paintings displayed in Gallery owned by ‘Shyam’. (8)

(b) Explain the concepts of Generalization and Specialization with examples. (7)

3. (a) Mention the features of OODBMS and give four advantages of it. (6)
(b) What are the general resistances faced by an organization while implementing DBMS tool ? Explain at least four of them.(4)
(c) What is client/server computing ? Discuss the components of client/server computing.(5)

4. (a) Given the structure:









(i) Identify the anomalies in the given structure.(3)
(ii) Normalise it ups third normal form (3NF).(6)
(b) Explain any three aggregate functions of SQL with an example for each.(6)

5. (a) Explain the structure of Index sequential file with the help of a diagram.(5)
(b) Explain briefly : (5)
(i) Dynamic Data Exchange (DDE)
(ii) Object Linking & Embedding (OLE)
(c) Illustrate the differences between hierarchical and network data models. Explain why relational data model is a better choice over the two.(5)

CS-06 December, 2007 Question Paper

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - DECEMBER 2007 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 
December, 2007
 CS-06:DATABASE MANAGEMENT SYSTEM
Time : 3 Hours
Max. Marks : 75


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

1. (a) Explain the characteristics of Relational Model. Write its two advantages and disadvantages. How is relational model different from other models ? Explain with a suitable example.(8)

(b) A marketing based organization has many branches in different states. The organization sells items in bulk to the dealers who sell them to retailers. The retailers ultimately sell it to the customers. Draw an E-R diagram for this distribution channel, clearly indicating the entities, attributes, relationships, keys and the. cardinality ratio.(8)

(c) What is data integrity? Explain the significance of data integrity in database management system, with the help of a suitable example.(7)

(d) construct a B-tree of order 5 by inserting the following data:(7)

{D,H , K , B , P, Q, E, A, S, W, T, C, L}

2. (a) Consider the following relations :

item (i_code, i_name, i_price, i_qty)
customer (c_code, c_name, c_address, c_phone)
issue (is_code, is_date, i_code, c_code, is_qty)
Write the appropriate SQL queries for the following :
(i) Find the name of the customers who have taken any item with price above Rs. 1000/-.
(ii) Find the details of the costliest item.
(iii) Find the issue code and quantity of all the items issued today.
(iv) Find the details of those customers who bought a particular item, given the i-code. (8)

(b) What are major anomalies in a database ? Explain the method to deal with these anomalies, with a suitable example.(7)

3. (a) What is a view ? Discuss the difference between a view and a base relation. Explain what happens when a user accesses a database through a view. Give an example of a. base relation and a view.(8)

(b) Explain the process of data fragmentation with suitable example. Discuss different types of data fragmentation. Compare it with data replication.(7)

4. (a) write five major steps in the process of conversion from old system to a new system. Mention two technical and administrative criteria for evaluation of a database.(7)

(b) Compare the working mechanism of virtual records with replication. Explain the method of accessing the data records in hierarchical data structure, with suitable example.(7)

5. (a) With the help of an example explain the Multilist file organization method. How is it. different from inverted file organisation ?(7)

(b) Differentiate between a knowledge base system and a database system. List any three major knowledge representation schemes. Explain the working mechanism of Frame Base Representation Scheme.(8)

CS-06 June, 2007 Question Paper

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JUNE 2007 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 
June, 2007
 CS-06:DATABASE MANAGEMENT SYSTEM
Time : 3 Hours
Max. Marks : 75


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

1. (a) A Bank maintains information about customers and their accounts. Each customer has a name, address (house number, area, city and state code) and telephone number. Account has number, type and balance. We need to record customers who own an account. Account can be operated individually or jointly.(7)
Design and draw an ER diagram, clearly indicating the attributes, keys, the cardinality ratio and participation constraints
(b) What is meant by data abstraction ? Explain the differences between physical level, conceptual level and view level of data abstraction.(6)
(c) Explain at least five important characteristics of OORDBMS.(5)
(d) For the relation R and S given below, compute natural loin and outer join.(6)
--DIAGRAM IS NOT AVAILABLE--

(e) Given the following relations :(6)
Vehicle (reg_no, colour, type)
Person (eno, name, address)
Owner (eno, reg-no)
Write expressions in the relational algebra to answer the following queries :
(i) List the reg_no of vehicles owned by “Sandeep” .
(ii) List the names of persons who own “lndica” cars.
(iii) List details of all the black coloured vehicles.

2. (a) Describe DROP TABLE command of Set- with both the options cascade and RESTRICT.(5)
(b) Explain the recovery process after system failure,using checkpoint.(5)
(c) How is the knowledge representation done through semantic network ? Give an example of semantic network.(5)

3. (a) How does data fragmentation support the distributed databases ? Explain horizontal and vertical fragmentation using an example of given relation. Project (Project-name, Emp_DO, Emp_name,Job-class, Emp-location, Salary) (6)
Note : Assume the suitable data.
(b)What is NULL ? Give an example to illustrate testing for NULL in SQL.(4)
(c)Define and differentiate between ordered indexing and hashing.(5)

4. (a) Construct a B+ tree for the following set _ of key values where the number of key values that fit in a node is 3. (8)
Key values , (1 2,2, 15, 4, I23, 45, 6,7,9,1, 3)
Show the steps involved in the deletion of key values 7 and then 6.
(b) Why is BCNF a more desirable normal form than any of the lower order normal forms ? Give an example of a relational schema that is in 3NF but not in BCNF.(7)

5. (a) Define the following with respect to SQL. Also give an example of each.(6)
(i) UNIQUE function
(ii) ORDER-BY clause
(iii) LIKE predicate

(b) Explain different methods of implementing the following data models: (6)
(i) Hierarchical Data Model
(ii) Network Data Model
(c) What is the difference between a database schema and a database state ?(3)

CS-06 June, 2006 Question Paper

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JUNE 2006 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 
June, 2006
 CS-06:DATABASE MANAGEMENT SYSTEM
Time : 3 Hours
Max. Marks : 75


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

1. (a) With the help of a suitable example, explain a hierarchical database model. (7)
(b) What are the advantages of index-sequential file organisation ? With the help of an example explain the structure of index sequential file. (5)
(c) Why are remote procedure calls used ? Why is a set of DDE maintained at application level ?(5)
(d) Design an ER diagram for any of IGNOU’s study centres. Clearly indicate the entities, attributes, relationships and the key constraints.(8)
(e) With the help of two examples for each, explain the use of multimedia databases and knowledge databases.(5)

2. (a) Consider an employee file with the details given below : -(8)


Record E#    Name         Occup.     Degree    Sex     Location     Salary
A      800     Milind          Prog.        M.E.       M       Delhi           10,000
B      510     Adwet         Analyst      B.E.        M       Mumbai      15,000
C      200     Devendra    Analyst      B.E.        M       Delhi           72,OO0
D      300     Mukesh      Prog.          M.E.       M      Chennai        9,000


(i) Make a multi list representation of this employee file.
(ii) Write a query to retrieve the record of
Salary > 12,000, Degree = M.E.,
Location = Delhi, Occupation = Analyst,
Sex = M.

(b) What are the main features of client-server model ? Explain the stages involved in the development of an application using this model. (7)

3. (a) Why is the administration of a database system required ? What are the various functions associated
with database administration ?(5)

(b) Define a data manipulation language. Write a syntax for the following and give an example for each :(10)
(i) Select statement
(ii) Update statement
(iii) Delete statement
(iv) Insert statement

4. (a) With the help of an example relation and the dependency diagram, explain the concept of functional
dependency.(8)
(b) Explain the following tools with respect to client-server environment : (7)
(i) Dynamic data exchange
(ii) Object linking and embedding
Also mention the usage of these with an example for each.

5. (a) Consider the schema given below :
Branch-scheme (Branch-name, asset, Branch-city)
Customer-scheme (Customer name, street,customer-city)
Deposit-scheme (Branch-name, account-number,customer-name, balance)
Borrow-scheme (Branch-name. loan-number,customer-name, amount)
Client-scheme (Customer-name, banker-name)

Write the SQL statements for the following : (8)
(i) Find all customers who have a balance of over Rs. 1000.
(ii) Write the query to find the clients of banker Patel, and the city they live in.
(iii) Write a statement to find all the customers who have a loan amount of more than Rs. 1200.
(iv) Write a statement to find all the customers whose name starts with “R” and who have a balance of more than Rs. 10,000.
(b) With the help of an example, explain the properties of a Balanced sort tree.(7)

CS-06 June, 2005 Question Paper

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JUNE 2005 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 
June, 2005
 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) Suppose you have been designated as a database administrator of an organization. Describe the responsibilities that may be generally assigned to you in order to maintain the centralised database efficiently. Also include at least 2 responsibilities with respect to the Database security.

(b) Create an ER diagram for the loan management system of a finance company. Loans are given on the purchase of various items with different interest rates. The company keeps track of defaulters and takes appropriate steps against them. Make, and state, suitable assumptions (if any).

(c) Explain the three-level architecture of DBMS, including the diagram. How is the mapping between these levels achieved?

(d) Explain the evolution of Client/Server Architecture. List the components and the usage in Client/Server computing. Mention any two applications of this model.

Q.2(a) What is a knowledge based system? Mention any two advantages and disadvantages of it. Give any two examples where a knowledge based system is used. Discuss the rule based knowledge representation scheme with the help of an example.

(b) What are the problems caused by data redundancies? Can data redundancies be completely eliminated when a database approach is used? Explain this with the help of an example.

Q.3(a) Write the significance of the evaluation of a database management system. List the technical and administrative issues respectively, required to be taken care of by the evaluation team.

(b) Draw a diagram to illustrate the relationship of different file organizations based on an access key. What is direct file organization? Explain the role of hashing in direct file organization with the help of an example.

Q.4(a) Consider the following schema :

employee (eno, ename, address, city, basic_sal, jobstatus)
projects (p_no, pname, pcategory)
work_in (P_no e _no p_duration)

Write appropriate SQL queries for the following :

(i) Display the names of employees who are working in a project on “DBMS".
(ii) Find the employer number of all employees who are working on at least one project.
(iii) Find the average salary of all employees working in a project “based in Delhi".

(b) Descrihe any three differences between the object oriented data model and the relational data model. In what ways is the object oriented data model similar to the hierarchical and network data models? Mention any two examples in which we can use the object oriented databases and relational databases, with the proper justification.

Q.5(a) Explain the trade-offs in distributing the database. List the issues involved in storing the relations in the distributed databases.

(b) What are the different relational operators used in relational algebra? Consider the following relations A and B, and perform A u B, A n B and A-B.

A-Flight No. Airways
IC 2715 Indian Airlines
IC 1007 Jet Airways
IC 9119 Sahara
IC 3849 Indian Airlines

B-Flight No. Airways
IC 1007 Jet Airways
IC 5187 Cathay Pacific
IC 1003 Singapore Airlines

Relational operators used in relational algebra:-

CS-06 December, 2004 Question Paper

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - DECEMBER 2004 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 
December, 2004
 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) Explain the various components of a database management system with the help of a diagram.
Below is the diagram of various components of DBMS :

(b) Define 2NF and 3NF. Normalize the following table to 3NF.

(c) Design an E-R diagram for an Airlines Reservation System consisting of flights, airports, fares, reservations, tickets, crew and passengers. Clearly indicate the entities, relationships and the key constraints.

(d) Explain three levels of architecture of a DBMS with the help of a diagram.

(e) Explain the concept of frame based representation with the help of an example showing the frames and facts/slots.

Q.2(a) Explain the evolution of client/server computing. Also describe its components.

(b) Give the structure of a distributed database system with the help of a diagram. Also give its trade-offs. List two distinct applications where we can use the distributed databases.

Q.3(a) Explain an Object Oriented Database Management System. What are its applications? Also list the alternatives OODB strategies.

(b) Discuss the Relational Model of DBMS. How is it differenl from other models? List at least two types of applications which suit this model.

Q.4(a) Consider the relations :

BRANCH (Branch_Name, City, Branch_Amount)
ACCOUNT (Branch_Name, Account_No, Balance)
CUSTOM ER (Account_No, CustomerJSame)

Write the SQL statements for the following :

(i) Find all the customers who have an account of all the branches located in “Chandigarh".
(ii) Find accounts of the “Model Town” branch having a balance greater than Rs. 50,000.
(iii) Find BranchJSame and Amount of city “Delhi".
(iv) Find AccountJVo, CustomerJSame and Balance of the branch name “Model Town".

(b) Give the step by step procedure for the implementation of Indexing through M-Way search tree with the help of an example.

Q.5(a) Explain the difference between Cartesian Product and Natural Join Operations with examples.

(b) Explain Multilist file organization and Inverted file organization with examples. Also give the comparison and trade off in the design of Multikey file.

Q.6(a) What is a view? What are the major advantages of views? Explain with an example.

(b) What are the main differences between a file processing system and a database system?

(c) What is a knowledge based system? Give at least three differences between a knowledge based system and a database system.

CS-06 June, 2004 Question Paper

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JUNE 2004 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 
June, 2004
 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). What are the advantages of DBMS over a traditional file system?

(b) What is ISAM? How are records stored in ISAM? Show this with diagrams.

(c) Define BCNF. How does it differ from 3NF? Explain them through an example.

(d) What is a knowledge-base system? Differentiate between a knowledge base system and a database system.

Q.2(a). Make an ER diagram of a warehouse. The warehouse has two type of items: low risk items and high risk items. The low risk items are issued on receipt of a simple challan but the high risk items are issued only if the challan is verified and authenticated by proper authorities. The issues are made only to a valid employee of the company. Make necessary assumptions.

(b) Briefly explain three advantages and three disadvantages of distributed database.

(c) Describe data fragmentation.

Q.3(a). Consider the relation R which has attributes that hold schedules of courses and sections at a university; R = { Course No., Section No., Offering_dept Credit hrs, Course level, Semester, Instructor SSN, year, Days_hrs, Room No No. of students)

Suppose that the following functional dependencies hold on R
{Course No.} > {Offering dept, Credit hrs, Course level}
{Course No., Section No., Semester, year} >
{Days_hrs, Room No., No. of students, Instructor SSN}
{Room No., Days hrs, semester, year} >
{Instructor SSN, Course No., Section No.}

(i)Which sets of attributes form keys of R?
(ii)Show how you would normalize the relation above. Also give the final tables.

(b) Define the two principle integrity rule for the relational model. In which situations would you need to apply these rules?

Q.4(a). Consider the following relations:

supplier (sid, sname, add)
parts (pid, pname, color)
catalog (sid, pid, cost)

(i)Find the parts supplied by Acme Widgets supplier only.
(ii)Find all the supplied who supply red or green parts.
(iii)Find the supplier who charges the most for any part.

(b) Two relations Rl and R2 are given in the tables below.

Student _ ID Course _ Code Marks
I1 c1 70
I2 Q2 50
I3 c3 40
I4 c4 20
I5 Q5 75
I6 Q6 90

Course_ID Course _Name
C1 DBMS
C2 DS
C3 DCN
les.
Use the relational algebraic operation to answer the following quer

(i) Course taken by student Ir
(ii) List all the students who have got more than 40 marks in course C.

Q.5(a)- Explain five basic functions of a database administrator.

(b) Explain, witrra suitable example, generalization and specialization.

(c) Explain briefly about distributed computing environment

Q.6(a). Discuss 4 basic features of OODBMS. Give 4 advantages of OODBMS.

(b) Explain hashing. Show how it is used in direct file organization. Give two advantages and two disadvantages of hashing.

CS-06: Introduction to DBMS December, 2003 Question Paper

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - DECEMBER 2003 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 
December, 2003
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). Construct an ER diagram (including important attributes) for a car insurance database that includes data about customer (car owners), cars accidents, drivers involved in accidents and injured drivers and/or passengers. Note that any customer can insure many cars, each car may have different drivers at different times and accidents typically involve one or more cars.

(b) Explain the 3 levels of the database architecture. Also discuss the advantages of having the 3 levels.

(c) What are functional dependencies? With a suitable example explain the importance of functional dependencies in database design and data modelling.

(d) Discuss the Boyce-Codd Normal Form (BCNF) with the help of an example.

Q.2(a). Consider the following Relational schema. An employee can work in more than one department:
Emp (Eid, Ename, Salary)
Works (Eid, did)
Dept (did, dname, managerid, floornum)

Write the following in SQL:

(i) Print the names of all employees who work on the 10th floor and earn salary less than Rs. 50,000.
(ii) Print the names of the departments that employee Santa works in.
(iii) Print the names of all managers who manage three or more departments on the same floor.
(iv) Print the names of all employees who work on floor(s) where Jane Donald works.
(v) Give every employee who works in the toys dept. a 10% raise in the salary.

(b) Compare and contrast primary key, candidate key and foreign key by giving a suitable example.

Q.3. Explain the following:

(i) Hashing
(ii) Indexing
(iii) B+ tree indexes
(iv) Specialization
(v) Generalization

Q.4(a). Discuss the features of OGDBMS. Also mention the advantages.
Four basic features of OODBMS:

(b) Discuss the following and also list the area of application:

(i) Multimedia Database
(ii) Knowledge Database

Q.5 Explain the following:

(i) Multithreaded Processes
(ii) Object Linking
(iii) Client/Server Computing

Q.6(a). Consider the relation R with 5 attributes A, B, C, D, E. You are given the following dependencies:
A->B
BC->E
ED-A

(i) List all keys of R.
(ii)IsRin3NForBCNF?
(iii) Design the normalised tables.

(b) Explain the trade offs in distributing the database in the context of Distributed database.

CS-06: Database Management System June 2003 Question Paper

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JUNE 2003 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 
June, 2003
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). XYZ Bank offers 5 types of accounts, namely Savings, Recurring, Loan, Current and Money market It operates a number of branches and a client of the Bank can have any number of accounts, can be individual and joint Identify the entities of your interest and show their attributes. What relationships exist among these entities? Draw the corresponding E-R diagram. Also design a relation data base to the relational database to the above E-R diagram.

(b) Discuss the differences between the following file organisations:
(i) Sequential
(ii) Indexed sequential
(iii) Relative file organisation
(iv) Multikey file organisation

Compare their storage and access efficiencies. Also mention what kind of application is best suited for the above file organisations.

(c) Define 3NF. Explain why the “employee” relation in the following database does not satisfy 3NF and decompose it into relations that satisfy 3NF. What ait the advantages gained by this decomposition .

Q2. Write short notes on:

(i) Updation, Insertion, Deletion anomalies

(ii) Views

(b) A view can be created for a subset of the tuples of a relation, as in this example. For assigning employees to particular jobs, the manager requires a list of the employees who have not been assigned to any jobs.

(iii) Boyce-Code Normal Form (BCNF)

Q.3(a). What is Data Replication? Explain with the help of example. Discuss the advantages/disadvantages of data replication in the distributed data base system.

(b) Discuss the different approaches to design of object oriented database system.

Q.4(a). What is client/server computing ? Why do we need it ? Discuss its advantages.

(b) Discuss the various components involved in the client/server computing.

Q.5(a). Discuss key features of B-Trees and B+ Trees. Also comment on the relative advantages and disadvantages. Mention the use of them by giving an example for each.

(b) List 4 responsibilities of Database Manager. For each responsibility, explain those problems that would arise if the responsibilities were not met.

Q.6. Discuss the following knowledge Representation Schemes:
-- This question (Q.6) is not complete --

CS-611: Computer Fundamentals and PC Software Question Papers


June 2009
CS-611: Computer Fundamentals and PC Software Questions
June 2008
June 2007
December 2007
December 2005
June 2002
June 2001
December 2001
June 2000

CS-610: Foundation Course in English for Computing Question Paper

CS-610: Foundation Course in English for Computing Papers
June 2008 June 2007
December 2007 June 2006
December 2006 December 2005
December 2003 June 2002
December 2002 June 2000

CS-06 Data Base Management System Question Paper June-2002

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JUNE 2002 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination 
June, 2002
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). Draw E-R diagram for a departmental store, after determining the entities of interest and the relationship that exist between these entities. Also construct a tabular representation of the entities and relationships. Are there any attributes (or collections of attributes) in each entity set that would uniquely identify an instance of the entity set?

(b) What problems are caused by data redundancies? Can data redundancies be completely eliminated when the database approach is used? Explain.

(c) Explain why first normal form is acceptable for data processing applications.

(d)Consider the relational database:

EMPLOYEE (ENO, EName, Skill, Pay-Rate, Date)
POSITION (Posting_No, Skill)
DUTY_ALLOCATION (PostingJVo, ENO, Shift)
Give expressions in SQL for the following:

(i) Find the names of employees who are assigned to all positions that require a clerk’s skill.
(ii) Get employees who are working either on the date 19860419 or 19860420.
(iii) Find the names and rate of pay of all employees who are not allocated a duty.

Q2. Write short notes on :
(i) Database administrator
(ii) Metadata
(iii) 3-Ievel architecture of DBMS
(iv) Data Independence
(v) Abstraction

Q.3(a). Explain with respect to Distributed Databases:
(b) List all functional dependencies satisfied by the following relation r:

Q.5(a). Compare and contrast index sequential file with B+ tree file.
(b) What is normalization? What is its purpose? Mention different types of normal forms define them.

Q.6(a). Discuss rule based representation and Frame based representation schemes.
(b) Discuss the components of client/server computing. Also mention the advantages of client/server computing.

QUESTION PAPER » CS-06 DATA BASE MANAGEMENT SYSTEM Dec 2001

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - DECEMBER 2001 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
December, 2001
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). Design a Relational database to the E- R diagram given below:

--DIAGRAM IS NOT AVAILABLE--

Tabular representation of the Relational Database for the above E-R Diagram

Entities and its Attributes :

(b) Explain the following general integrity rules of Relational Mode:
(i) Entity Integrity
(ii) Referential Integrity

(c) For the relations P and Q, perform the following operation:

(i)Find the projection of Q on the attributes (B,C)
(ii) Find the natural join of P and Q on the common attributes.

(d)Write short notes on:
(i) Object oriented databases
(ii) Specialization
(iii) Generalization
(iv) Data independence
(v) Query processor

Q.2(a). Explain the distinction between the representation of association and relationship in the network and hierarchical models.

(b) Explain why navigation is simpler in the relational model than in the hierarchical data model.

Q.3. Discuss the differences between the following file organization.

(a) Serial
(b) Index-Sequential
(c) Hashed
(d) Inverted

Comp are their storage and access efficiencies- To what type of application is each of the organisations suited?

Q.4(a). What are the advantages of normalised relations over unnormalised relations?

(b) Why is 4 NF preferable to BCNF ?

(c) Explain the design goals of a good relational database design.

Q.5(a). Explain how the knowledge representation is done through Semantic Network.

(b) Discuss the basics of Client-server computing paradigm.

(c) Explain Dynamic Data Exchange and Remote Procedure Call.

QUESTION PAPER » CS-06 JUNE 2001 QUESTION PAPER

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JUNE 2001 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
June, 2001
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). Name the major advantages of a Database Management System (DBMS) over a File Management System.

(b) Define the following concepts in the context of DBMS:
(i) Bit Map
(ii) Candidate Key
(iii) Referential integrity

(c) What does VSAM stand for? Briefly describe VSAM.

(d) Discuss briefly the possible problem with an unnormalized database.

(e)We are given the following record-types (relation types):

Express the following commands in SQL:

(i) Get P# for the parts for which weight of the part is 5 kg and colour is black,
(ii) Give the details of all suppliers from the city of Bombay and turnover of more than Rs. 50 lacs.

(f) Compare object oriented and Relational approaches to Database design.

(g) Explain briefly what do you understand by Distributed computing environment.

This also includes the following :

1. Global Dictionary
2. Two Phase Commit (2Pc)
3. Replicated Server/Table

2(a). Describe the problems that are caused by data redundancies. Can data redundancies be completely eliminated, when database approach is used? Give reasons in support of your answer.

(b) Draw E-R diagram for any one of the following two organisations: (i) University, (ii) Hospital, after determining the entities of interest and the relationships that exist between these entities.

(c) Define the following terms:

(i) Association
(ii) Relationship
(iii) Aggregation

Q.3(a). The People’s Bank others five types of accounts: loan, checking, premium savings, daily interest saving and money market It operates a number Of branches, and a client of the bank can have any number of accounts. Accounts can be joint; i.e. more than one client may be able to operate a given account Draw a diagrammatic representation of the Network model of the bank, after identifying the relevant concepts.

(b) In respect of project we are given the following record-types for the relational model of the database:
EMPLOYEE: with fields as ‘Emp#’ and ‘Name’
ASSIGNEDJTO: with fields as ‘Projects and ‘Emp#’
PROJECT: with fields and ‘Projects, ‘Project_Name’, ‘Chief_Architect’.

Where ‘Chief_Architect’ is a three-digit code and all other fields have obvious meanings. Then express the following queries in relational algebra:

(i) ‘Get Emp# of employees working on project COMP353′
(ii) ‘Get details of employees (both number and name 3) working on project COMP353′
(iii) ‘Gather details of employees working on both COMP353 and COMP354′

(c) Briefly describe the various possible problems with a (not normalised) database.

Q4(a). Is the following relation in Third Normal Form?

Roll No. Name Department Year Hostel Name
2101 Raman Physics I Ganga
2102 Krishna Chemistry I Ganga
2103 Abdul Mathematics U Kaveri
2104 John Botany S Kaveri

Justify your answer, if it is in Third Normal Form. If it is not, then bring it in Third Normal Form.

(b)Again consider the. record-types given in Question No. l(e):
Where S# and P# are keys respectively for SUPPLIER and PARTS.
Express the following in SQL:

(i) Get the part numbers that cost 20,30 or 40 rupees.
(ii) Get the supplier names who do not supply part
(iii) Get the part numbers whose cost is greater than average cost

(c) Discuss the issue of Data Replication or the issue of Data Fragmentation in respect of distributed database.

Q.6. Discuss the following with reference to File organization for conventional DBMS:
(i) List the key features of B-tree and how it is different from B+ - tree
(ii) Why do we need multilist file organisation?
(iii) Explain comparison and trade-off in the design of a multikey file.

QUESTION PAPER » CS-06 Introduction to DBMS JANUARY 2001

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - JANUARY 2001 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
January, 2001
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). Name six major components of a Data Base Management System.

(b)Define the following concepts in context of DBMS,
(i) Inverted List
(ii) Foreign Key
(iii) Referential Integrity

(c) What does ISAM stand for? Briefly describe the advantages of ISAM indexes/Indices.

(d) For the set of following two relations:

P:
B
b1
b2

And Q :
A B
a1 b1
a2 b1
a3 b1
a1 b2
a4 b2
a5 b2

Find out which of the following operation(s) are defined on this set of record types:

(e) Briefly describe the properties of a normalized relation.

(f) Write briefly about the advantages of Data distribution.
Data Sharing and Distributed Control

(g) Name the fundamental ideas underlying Object Oriented Technology (OOT)

(h) Briefly explain what do you understand by a Knowledge Base System.

Q2(a). Explain briefly the levels of an architecture of a DBMS. Viz., Internal level. Conceptual level and External level.

(b) Draw E-R diagram for any one of the following two organization viz., (i) Public Library, (ii) Hospital, after determining the entities of interest and the relationship that exist between these entities.

(c) Define the following terms:
(i) Aggregation
(ii) Specialization
(iii) Generalization

Below is the Diagrammatic Representation of Specialization and Generalization : -
--DIAGRAM IS NOT AVAILABLE--

Q.3(a). Draw diagrammatic representation of a university, which runs a number of program say Pj.....Pm ; The program P; hasnj course Cjj of Pj for each I is pursued by a set Sjj of students. The diagrammatic representation is to reflect the hierarchical structure of the university system.

(b) Given the relational schemes:

ENROLL (S#, C#, Section)
TEACH (Prof, C#, Section)
ADVISE (Prof, S#)
PRE_REQ (C#, Pre_C#)
GRADES (S#, C#, Grade, Year)
STUDENT (S#, Sname)

Where S#, C# represent respectively ’student number’ and ‘course number’: Sname is student name. Prof is thesis advisor of S# in ADVISE, Pre_C# is prerequisite course.

Express the following queries in relational algebra :

(i) List all student taking courses with Mr. Ram and Mr Abdul.
(ii) List all those professors who teach more than one section of the same course.

(c) What are the essential components of a DBMS?

Q.4(a). For the following record type, tell whether it is Third Normal From or Not: EMPLOYEE (Employee- Code, Employee-name, department, salary, project-no., Termination-date-of-project)
Where each project-no has unique Termination-Date-of-Project. Justify your answer, if it is in third normal form. It is not in third normal form, being it into third normal form through normalization.

(b)Consider the record-types given below:

SUPPLIER : S# SNAME SCITY TURNOVER

PARTS : P# WEIGHT COLOUR COST SELLING PRICE

SUPPLY PARTS : P# QUANTITY

Where S# and P# are keys respectively for SUPPLIER and PARTS. Express the following in SQL

(i) Get the part numbers weighting between 25 and 35
(ii) Get the supplier names (SJVAME) who are located in the city of Hyderabad.
(iii) Get the names of suppliers who supply at least one part of red colour
(iv) Delete all the suppliers involving red colored parts.

Q.5(a). Briefly discuss the alternative Object-Oriented Database strategies.

(b) Briefly explain, the main features of client/server computing.

(c) Explain briefly, with atleast one suitable example any one of the following knowledge representation schemes.

(i) Semantic Nets
(ii) Frame Based
(iii) Logic

Q.6(a). Discuss main difference between Relational database Management system and Object oriented database management system.

(b) Discuss the following with reference to distributed computing environment
(i) Remote Procedure Call

(ii) Object Linking and Embedding.

(c) Explain the steps required for client server application development.

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.

QUESTION PAPER » CS-06 DATA BASE MANAGEMENT SYSTEM Dec 1999

IGNOU BCA CS-06: DATA BASE MANAGEMENT SYSTEM - DECEMBER 1999 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
December, 1999
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). Construct an E-R diagram for a car insurance company that has a set of customers, each of whom owns one or more cars. Each car has associated with it zero or any number of accidents.

(b)Consider the Relational database

Employee (empname, street, city)
Works (empname, companyname, salary)
Company (companyname, city)
Manages (empname, managerjname)
Give expressions in SQL for the following:

(i) Find the names of all employees who work for First Bank Corporation

(ii) Find all employees in the database who live in the same cities as the companies for which they work.

(iii) Find all employees in the database who earn more than every employee of small Bank Corporation.

(iv) Find the names, street address and cities of residence of all employees who work for First Bank Corporation and earn more $10000.

(v) Find all employees in the databases who live in the same cities and on the same street as do their managers.

(c) Define 2NF and 3NF. Produce 3NF table structures from the table below
Enrol No. Sname Dept. Year Block Name

1024 Mathews Physics 1 G
1126 John Chemistry 1 G
1016 Bill Mathematics 2 K
1420 James Botany 2 K
1503 Charles Geology 3 L
1001 Dickens Zoology 4 M

Second Normal Form (2NF)

Q.2(a). Is it possible in general to have two primary indices on the same relation for different search keys? Explain your answer.

(b)Explain the distinction between open and closed hashing. Discuss the relative merits of each technique in database applications.

Q3(a). Compare and contrast BCNF and 3NF. Show that if a relation scheme is BCNF, then it is also in

(b) List the three design goals of relational databases and explain why each desired

Q.4(a), Discuss the design issues related to distributed database through an example,

(b) Explain the trade offs in distributing the database

Q.5(a). What are the techniques available for the knowledge representation? Explain them briefly through an example.

(b) What is the difference between declarative and procedural knowledge?

Q.6(a). Describe various Relational operators that are used in Relational Algebra, perform Union, Difference, Intersection and Cartesian Product for the following relations.

(b)Write short notes on Client-Server approach.

Study Materials » Download CS-611 Study Materials

It’s a good habit to start reading study materials as soon as you get your name enrolled to make a good start. Though IGNOU provides study materials for free, there are number of students who do not receive study materials on time and some students even don’t receive them at all but don’t worry if you did not receive study materials because you can still find it here. Well, here I have listed the study materials of CS-611: Computer Fundamentals and PC Software below. So, be smart and start reading before others find them.

Download study materials by clicking on the chapter names (a new window will open ) and then click on the more button (you can find it on the top left corner of the document) and choose save document from the drop down list, you will be asked to log in, if you are not a member join Scribd by entering your email id and your desired password, that’s all; it’s so simple, isn’t it?

Study Materials of CS-611: Computer Fundamentals and PC Software


Block-1 Computer Fundamentals: Hardware & Software

Block-2 Computer Fundamentals: Communication, Networking, Security

Block-3 A Graphical User Interface

Block-4 Sample GUI Oriented Applications

Study Materials » Download CS-610 Study Materials

It’s a good habit to start reading study materials as soon as you get your name enrolled to make a good start. Though IGNOU provides study materials for free, there are number of students who do not receive study materials on time and some students even don’t receive them at all but don’t worry if you did not receive study materials because you can still find it here. Well, here I have listed the study materials of CS-610: Foundation Course in English for Computing below. So, be smart and start reading before others find them.

Download study materials by clicking on the chapter names (a new window will open ) and then click on the more button (you can find it on the top left corner of the document) and choose save document from the drop down list, you will be asked to log in, if you are not a member join Scribd by entering your email id and your desired password, that’s all; it’s so simple, isn’t it?

Study Materials of CS-610: Foundation Course in English for Computing


Block-1 Reading, Writing, Listening & Speaking Skills


Block-2 Composition and Study Skills


Block-3 English for Science and Technology


Block-4 English for Computers

CS-05 QUESTION PAPERS » JUNE, 2007 CS-05 QUESTION PAPER

IGNOU BCA CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN - JUNE 2007 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
June, 2007
CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN
Time : 3 Hours
Max. Marks : 75


Note : Question one is compulsory. Answer any three from the rest.
1.(a) What kind of fact finding techniques would you use for investigating the information requirements for a multispeciality hospital, which is presently using the manual registrations ? Which kind of techniques do you think will be more effective ? Also, mention the problems you anticipate in conducting the investigations. (10)
(b) List and explain various parts of system design process. Illustrate this with the help of an example. (10)
(c) With the help of an example for each, explain the following tools : (10)
(i) Structured flow chart
(ii) HIPO diagrams
(iii) Warnier/Orr diagrams

2.(a) Construct a dialogue tree showing its branches for “prompting the menu items” Of your choice. Also, explain the significance of the dialogue tree. (8)
(b) List the underlying principles for a prototype design Under which conditions, will prototype design be useful ? Also, mention the steps involved in the whole process of prototype design. (7)

3.(a) With the help of an example situation for each, explain the following testing techniques : (8)
(i) Peak load test
(ii) Storage testing
(iii) Performance time testing
(iv) Recovery testing
(b) “The design of the human-computer interface (HCI) is one of the most important aspects of the system design.” Explain various factors that one needs to consider for a good and efficient HCI. (7)

4. (a) Draw a data flow diagram (DFD) depicting the various processes, data flow and data repositories for a petrol-pump retail outlet. Follow the appropriate conventions/symbols as given in your study material. (7)
(b) Explain the following types of feasibility studies : (8)
(i) Operational
(ii) Legal
(iii) Technical
(iv) Time

5. (a) What is the full form of VTOC. Explain its significance. Draw a VTOC for any system (task) of your choice. (8)
(b) List and explain at least seven considerations for the output design. (7)

CS-05 QUESTION PAPERS » JUNE, 2006 CS-05 QUESTION PAPER

IGNOU BCA CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN - JUNE 2006 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
June, 2006
CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN
Time : 3 Hours
Max. Marks : 75


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

1. (a) With the help of an example application, explain the use of a data dictionary. (3)
(b) Explain the use of requirement analysis in system design. Make an SRS document for “School Management System”.(6)
(c) Briefly describe five types of documentation technique (5)
(d) Briefly explain five components of multimedia. (5)
(e) What is an MIS ? Give four features of a typical MIS. Explain the steps followed in the development of an MIS. (8)
(f) Why is it essential to use systems analysis and design methodologies to build a system ? Give three reasons.(3)

2. (a) Design a EFD for a Banking Management System, up to level 2.(6)
(b) Explain the various types of files in which records are maintained in a system. (6)
(c) Describe three types of computer graphics software. (3)

3. (a) Define the following : (6)
(i) Peak load testing
(ii) Storage testing
(iii) Recovery testing
(b) Give two differences between DSS and KBS. (2)
(c) How will you prepare a project request form ? What are the techniques used to review these requests ? Explain with an example. (7)

4. (a) Give two symbols used in DFD, along with their purpose.(2)
(b) List four factors considered while designing a form. Also give {our characteristics and two examples of forms.(6)
(c) Give, with justification, three different events that can
be considered as computer crimes. (3)
(d) Explain two differences between unit and integration testing. What is the use of procedure testing ? (4)

5. (a) Describe the structure of a feasibility report (3)
(b) List six considerations on which output to be produced usually depends. (3)
(c) What is structured design ? Explain this with an example. (3)
(d) What is the role played by user interface of the software in system development ? Also explain four steps of GUI development. (6)

CS-05 QUESTION PAPERS » JUNE, 2005 CS-05 QUESTION PAPER

IGNOU BCA CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN - JUNE 2005 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
June, 2005
CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN
Time : 3 Hours
Max. Marks : 75


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

1. (a) Explain at least five duties that have to be carried out by a Systems Analyst. (5)

(b) Explain the sequential method for file organisation. Also explain two advantages and two disadvantages of this method vis-a-vis other methods. (5)

(c) What are the various special systems tests ? Explain at least four of them. (5)

(d) What are the three different levels of management as classified by Anthony ? Explain at least two of them. (5)

(e) Explain any five forms of software piracy seen around the world. (5)

(f) Describe five components of Multimedia in brief, with one example of each. (5)

2, (a) Explain at least two objectives of input design. (5)

(b) What does the term “feasibility” mean ? List the seven types of feasibility, and the four stages in a feasibility study. (10)

3. (a) Define a form. List the five characteristics of a form with an example for each. Also, explain at least four factors that need to be considered in form design. (8)

(b) What is a data dictionary ? Specify at least 4 symbols and 4 rules that govern the construction of data dictionary entries. (7)

4. (a) Explain the meaning of Planning, Production and Distribution of Multimedia. (6)

(b) Explain at least three different approaches for Software evaluation. (6)

(c) Define an audit trail. Who uses an audit trail ? (3)

5. (a) Develop Analysis and Design documents for a Library Information System. Make necessary assumptions. (8)

(b) What is Quality assurance ? What are the three levels of Quality assurance ? Explain. (7)

6. (a) Explain the planning and control aspects of management, Explain each of these functions at the strategic, tactical and operational levels, with the help of examples. (6)

(b) What are Warnier/Orr diagrams ? Explain them with an example. (3)

(c) What is a Green P.C. ? Explain the design of a Green P.C. (6)

CS-05 QUESTION PAPERS » DECEMBER, 2007 CS-05 QUESTION PAPER

IGNOU BCA CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN - DECEMBER 2007 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
December, 2007
CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN
Time : 3 Hours
Max. Marks : 75


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

1. (a) Differentiate between direct and indirect costs. How is it used in feasibility analysis?
(b) Differentiate between sequential and direct file organisation.
(c) List and explain any four quality factors which are critical in Quality Assurance during Software life cycle.
(d) Write any four differences between third generation languages and fourth generation languages.
(e) Write main factors which lead to a very good design of human - computer interface, with the help of an example. (5×6=30)

2. (a) Explain hierarchy view of computer base information systems with suitable diagrams.(7)
(b) Explain the following categories of information systems : (8)
(i) Transaction Processing System
(ii) Decision Support System

3. (a) Draw a data flow diagram (DFD) depicting various processes, data flow and data repositories for a Institute Management System of a computer institute (8)
(b) Explain different types of files along with their utilities. (7)

4. (a) List the conditions where the prototypes are considered, to be most useful. Also mention the steps in the prototyping process. (8)
(b) List and explain the input design guidelines. (7)

5. Differentiate between (5×3=75)
(i) Strategic data and Tactical data
(ii) Ergonomics and Environment science
(iii) Animation and Morphing
(iv) Validation and Verification
(v) Flow chart and Warnier diagrams

CS-05 QUESTION PAPERS » December, 2006 CS-05 QUESTION PAPER

IGNOU BCA CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN - DECEMBER 2006 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
December, 2006
CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN
Time : 3 Hours
Max. Marks : 75


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

1- (a) what is feasibility ? Describe any five types of feasibility study. (6)
(b) Discuss the different types of systems (8)
(c) Explain the role of a System Analyst. What are the attributes of a good analyst ? (8)
(d) What is a data dictionary and why is it used ? What are the major symbols used .in a data dictionary ? Support your answer with an example. (6)
(e) Define Tangible and Intangible Costs and Benefits. (2)

2. (a) Define System. Explain any four characteristics of a System (5).
(b) Elaborate the five parts of the system design process. (5)
(c) List the major tasks of system development. (5)

3. (a) What is testing ? Explain the various levels of testing involved in system development.(5)
(b) What is multimedia ? Explain the various components of multimedia. (6)
(c) Write a short note on “Civil Liability”. (4)

4. (a) What is the purpose of a DFD ? What are the charting forms necessary to draw a DFD ? List the rules that govern construction of a DFD. (7)
(b) Explain Preliminary Investigation as the first step in the development of a system. What are the various activities involved in this step ? Explain them briefly. (8)

5. (a) In an organization, a number of project requests are generated. What methods are adopted by the organization for selecting the requests to be pursued ? (6)
(b) What are files and why are they needed ? explain briefly any,three types of file organizations. (5)
(c) Write a short note on “Audit Trail”. (4)

CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN DEC 2005

IGNOU BCA CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN - DECEMBER 2005 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
December, 2005
CS-05: ELEMENTS OF SYSTEM ANALYSIS AND DESIGN
Time : 3 Hours
Max. Marks : 75


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

1. (a) Explain all the inter-related types of feasibility studies. (7)
(b)What are the two categories of computer graphics software ? Explain them. (5)
(c) Explain all the major types of documentation. (5)
(d) Explain all the different components of management in accordance with decision oriented view. (5)
(e) Explain all the classes of disaster recovery needs of any organization. (8)

2. (a) Define a DFD. Write the conventions that govern the construction of DFDS. Design a DFD for a study centre management system. (8)
(b) List various factors which are responsible for the quality of a system. Also explain the different levels of quality assurance. (7)

3. (a) Explain all the conversion methods. Also mention an advantage and a disadvantage of each. (8)

(b) What is the need of system testing ? Explain any five testing techniques and their basic objectives. (7)

4. (a) Develop an analysis and design document for a video library management information system. Make necessary assumptions. (10)
(b) What are the different events that can be considered as computer crimes ? List the three broad categories of computer crimes. (5)

5. (a) Explain all the components of Multimedia. (9)
(b) Explain the economic, hardware and software factors for vendor’s selection. (6)

PRACTICAL QUESTION PAPER » CS-63P SET-1 PRACTICAL JUNE 2007

IGNOU BCA CS-63P: INTRODUCTION TO SYSTEM SOFTWARE - JUNE 2007 PRACTICAL QUESTION PAPER

Set-1
BACHELOR IN COMPUTER APPLICATIONS
Term-End Practical Examination
June, 2007
CS-63P: INTRODUCTION TO SYSTEM SOFTWARE
Time allowed: 2 Hours
Max. Marks : 100
(Weightage 15%)



Note: There are 2 questions in this paper. Answer them all. They carry 70 marks. The rest 30 marks are for the Viva-voice.


1. Write a shell script to rename any file name given as a command argument. [30]

2. List and execute the following UNIX commands : [8x5=40]
(a) To change the password of a user.
(b) To display the long listing of all, the files in the current directory.
(c) To select all the file-names whose file name starts with "t" in the current directory.
(d) To run any process at background.
(e) To search for a particular pattern in a file and display its count (no. of occurrences).

PRACTICAL QUESTION PAPER » CS-63P SET-2 PRACTICAL JUNE 2007

IGNOU BCA CS-63P: INTRODUCTION TO SYSTEM SOFTWARE - JUNE 2007 PRACTICAL QUESTION PAPER

Set-2
BACHELOR IN COMPUTER APPLICATIONS
Term-End Practical Examination
June, 2007
CS-63P: INTRODUCTION TO SYSTEM SOFTWARE
Time allowed: 2 Hours
Max. Marks : 100
(Weightage 15%)



Note: There are 2 questions in this paper. Answer them all. They carry 70 marks. The rest 30 marks are for the Viva-voice.


1. Write a shell program to count the number of each article (a, an, the) in a given text file. [30]

2. List and execute the following UNIX commands : [8x5=40]
(a) To provide double space between the lines in a given file
(b) To display the contents of any file without using the editor
(c) To count the number of occurrences of any given pattern
(d) To sort the given file names alphabetically
(e) To display all lines ending with a period in a text file

PRACTICAL QUESTION PAPER » CS-63P PRACTICAL JUNE 2007 SET-3

IGNOU BCA CS-63P: INTRODUCTION TO SYSTEM SOFTWARE - JUNE 2007 PRACTICAL QUESTION PAPER

Set-3
BACHELOR IN COMPUTER APPLICATIONS
Term-End Practical Examination
June, 2007
CS-63P: INTRODUCTION TO SYSTEM SOFTWARE
Time allowed: 2 Hours
Max. Marks : 100
(Weightage 15%)



Note: There are 2 questions in this paper. Answer them all. They carry 70 marks. The rest 30 marks are for the Viva-voice.


1. Write a shell program which writes all the odd-numbered lines of a text-file into another file. [30]

2. List and execute the following UNIX commands : [8x5=40]
(a) To set the file permissions of any given file : read, write, execute permissions for the owner' and execute permission to the group, and read and execute permissions to the others.
(b) Create a file using any editor.
(c) To display various processes running.
(d) To scan directories and locate any file, given the file-name by the user.
(e) To send a message to any user who is already logged in.

CS-63P PRACTICAL QUESTION PAPER JUNE 2007 SET-4

IGNOU BCA CS-63P: INTRODUCTION TO SYSTEM SOFTWARE - JUNE 2007 PRACTICAL QUESTION PAPER

Set-4
BACHELOR IN COMPUTER APPLICATIONS
Term-End Practical Examination
June, 2007
CS-63P INTRODUCTION TO SYSTEM SOFTWARE
Time allowed: 2 Hours
Max. Marks : 100
(Weightage 15%)



Note: There are 2 questions in this paper. Answer them all. They carry 70 marks. The rest 30 marks are for the Viva-voice.


1. Write a shell program to find the largest string (in respect of its string length) among the list of 5 strings given by the user. [30]

2. List and execute the following UNIX commands : 8x5=40
(a)To copy a file.
(b) To show the reference and the name of the terminal.
(c) To suspend execution of any process for some time interval.
(d) To set the command execution priority.
(e)To print a calendar for a given year and month

CS-63 QUESTION PAPERS » DEC 2007 CS-63 QUESTION PAPER

IGNOU BCA CS-63 INTRODUCTION TO SYSTEM SOFTWARE - DECEMBER 2007 QUESTION PAPER

BACHELOR IN COMPUTER APPLICATIONS
Term-End Examination
December, 2007
CS-63: INTRODUCTION TO SYSTEM SOFTWARE
Time : 2 Hours
Max. Marks : 60


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

1. (a) Write regular expressions for I
(i) A set of strings including {d, abd, cd, abcd}
(ii) A set of strings x’s, y’s and z’s. For example {xxx, xxy, xxz …zzz}
(b) Write an algorithm that accepts as input a decimal number and converts it into octal representation and also draw the corresponding flow chart for the same.(7)

(c) Consider the following set of processes which arrive in the ready queue at the same time : Process CPU time
P1 8
P2 T2
P3 7
P4 9
P5 4
Consider the following scheduling algorithms ‘F’CFS, SJF and Round robin (quantum : 2) find the average turnaround.time.
(ii) What is waiting time of each process for each of the above scheduling algorithms ? Also, find the average waiting time I
(d) Write a shell program to find whether a given number is an Avogadro number or not 7 (e.s. 153 is Avogadro no. as 153 = 13 + 53 + g3)

2. (a) What are the important tasks performed during : (6)

i) Lexical analysis
ii) Syntax analysis
ii) Semantic analysis
(b) What is the usefulness of context free grammar? Explain with an example. (4)

3. (a) Describe how fixed records L/O and variable length (5)
(b) what are the main advantages of distributed operating systems ? How are the fire system and the protection supported in distributed operating systems ?

4. (a) write UNIX commands for the following : (5)
(i) To change the password for a given user.
(ii) concatenate the contents of 3 files into a single file.
(iii) To run a particular command at the given time.
(iv) To display hard disk space used.
(v) To display the lines that do not include the given string.
(b) Illustrate and discuss with a diagram, the address mappings in a paging system and a segmented system.(5)

5. (a)with the help of any GUl-based operating system, explain the major components of its environment.(4)
(b) Explain the following concepts : (6)
(i) Symbol Table
(ii) Case Tools
(iii) 4 GLs