System Analysis And Design Question Paper of 3rd Semester CSE(D) Download Previous Years Question Paper 2

S.B. Roll No. __________

SYSTEM ANALYSIS AND DESIGN

3rd Exam/Comp/6245/May’08

Duration 3 Hrs

Section A

1.     Define the following

a.     Bottom up design

b.     Top down design

c.      File density

d.     File volatility

e.      Flow chart

f.       Decision table

g.     Database

h.     Data dictionary

i.       Sampling

j.       Operational feasibility

Section –B

Note: Attempt any five questions

2.      

a.     Explain the various design objective in brief

b.     Explain the various criteria used for project selection.

c.      What are the major function of DBMS?

d.     Differentiate between information oriented system flow chart and process oriented system flow chart.

e.      Why are decision table used by system analysis as well as by programmers?

f.       What are the elements of project control that aid in the management of an initial investigation?

g.     Differentiate between open and closed system with examples.

Section –C

Note: Attempt any three questions

3.     Describe the steps of file design with example.

4.     Discuss the various unit and integration testing techniques.

5.     Explain technical and economic feasibility analysis.

6.     Write short note on

a.     Data dictionaries

b.     Quality factor  

Read More

System Analysis And Design Question Paper of 3rd Semester CSE(D) Download Previous Years Question Paper 1

S.B. Roll No. __________

SYSTEM ANALYSIS AND DESIGN

3rd Exam/Comp/6245/0062/0621/0261/Dec’11

Duration 3 Hrs

Section A

Q1. Do as directed:

a. Input, processing and output are three components of every system. (T/F)

b. SDLC stands for __________.

c. The main goal of __________is not solve the problem but to achieve the scope.

d. The real code is written in __________ phase of SDLC.

e. __________ is the phase in software testing in which individual software modules are combined and tested as a group.

f. Cocomo stands for __________.

g. Decision trees are simple to understand and interpret (T/F).

h. __________ is a process of executing a program with the intending of finding an error.

i. ROI stands for __________.

j. Coding is not step in system development lift cycle (T/F)

k. System analysis and design are the same phase of system development life cycle (T/F)

l. In parallel run computerized and __________ system are executed in parallel.

m. Structure design is a blue print of a computer system. (T/F)

n. In __________ run the new system installed in parts.

o. Testing is an important phase of a successful system. (T/F)

Section B

Note: Attempt any six questions 5x6

Q2 i. What are major objectives of system analysis.

ii. Explain goal of feasibility study.

iii. Define a system. What are basic complements of system.

iv. Explain importance of system analysis and design in development of a system.

v. What do you mean by fact finding technique?

vi. What do you understand by data dicitonaries?

vii. What is open and closed system?

viii. Explain role of decision tree in requirement specifications and analysis.

ix. Explain static and dynamic system with examples.

x. Write short note on integration testing.

Section C

Note: Attempt any two questions 15x2

Q3. Explain various phases in SDLC.

Q4. What do you mean by techinical, economic and operational feasibility.

Q5. Explain various testing techniques.

Q6. The system analysis and design is backbone of application software development? Explain.

Read More

Relational Database Management System Question Paper of 3rd Semester CSE(D) Download Previous Years Question Paper 3

S.B. Roll No.

RELATIONAL DATABASE MANAGEMENT SYSTEM

4^th Exam/Comp/IT/6268/May’08

Duration : 3 Hrs.

          Note : There are questions in all.

·        Question 1 is compulsory and carries 15 marks.

·        Attempt any five question form section B and three question form section C.

·        Any required data not explicitly given , may be suitably assumed and stated.

1.     Choose the correct or best alternative in the following:

a.     The property /properties of a database is/ are:

b.     It is an intergrated collection of logically related records.

c.      It consolidates separate files into a common pool of data records.

d.     All of the above.

e.      The DBMS language component which can be embedded in a program is

                                                             i.      The data definition language (DDL) 

                                                           ii.      The data manipulation language (DML)

                                                        iii.      The database administrator (DBA)

                                                        iv.      A query language.

f.       A relational database developer refers to a record as

                                                             i.      A criteria

                                                           ii.      A relation

                                                        iii.      A tuple.

                                                        iv.      An attribute.

g.     The relational model feature is that there

                                                             i.      Is no need for primary key data

                                                           ii.      Is much more data independence than some other database models.

                                                        iii.      Are explicit relationships among records.

                                                        iv.      Are tables with many dimensions

h.     Conceptual design

                                                             i.      Is a documentation technique

Needs data volume and processing frequencies to determine the size of the database

Involves modeling independent of the DBMS

Is designing the relational model  .

i.       The method in which records are physically stored in a specified order according to a key field in each record is

                                                             i.      Hash

                                                           ii.      Direct

                                                        iii.      Sequential

                                                        iv.      All of the above

j.       A subschema expresses

                                                             i.      The logical view

                                                           ii.      The physical view.

                                                        iii.      The external

                                                        iv.      All of the above

k.     Count function in SQL returns the number of

                                                             i.      Values.

                                                           ii.      Distinct values.

                                                        iii.      Groups.

                                                        iv.      Columns.

Section –B

2.     Discus the main advantages of using a DBMS.

3.     What are the different types of database and user? Discuss the main activates of each

4.     Describe the three-schema architecture

5.     Discuss the typical user friendly interfaces and the types of users who use each.

6.     Differentiate between    

Procedural and non procedural languages

Key and super key.

  Primary and secondary storage.

7.     With the help of an example show how records can be deleted and updated in QBE

8.      

a.     Describe cardinality ratios and participation constraints for relationship types.

b.     Information about a bank is about customers and their account. Customer has a name, address which consists of house number , area and city , and one more phone numbers, account has number, type and balance. We need to record customers who own an account , Account can be held individually or jointly . an account cannot exist without a customer.

Arrive at an E-R diagram. Clearly indicate attributes, keys, the carnality ratios and participation constraints.

9.      

a.     Describe the static hash file with buckets and changing and show how insertion, deletion and modification of a record can be performed. 

b.     What are the reasons for having variable length records? What types of separator characters are needed for each?

10.                        Define the following terms

Derived and stored attribute.

Distributed system.

Interlock gap

Degree of a relation

Catalog

Conceptual schema

11.                          

a.     Define a relation

b.     Describe entity integrity and  referential integrity. Give an example of each

c.      Consider the two relations given below

R S

A	B	C
A1 Null A1	B1 B2 B3	C1 Null C1

D	A	F
D1 D1	A1 A2	F1 Null

Given that A is the primary key of R, D is the primary key of S and there is a referential integrity between S.A and R.A, discuss all integrity constraints that are violated. 

Read More

Relational Database Management System Question Paper of 3rd Semester CSE(D) Download Previous Years Question Paper 2

S.B. Roll No.

RELATIONAL DATABASE MANAGEMENT SYSTEM

4^th Exam/Comp/IT/6268/Dec’10

Duration : 3 Hrs.

1.     Do as directed:

a.     DBMS stands for _________

b.     Association between two records is named as _______

c.      Relational algebra is a non procedural language (T/F)

d.     BCNF deals with multiple _______ key.

e.      Outer join operator is _________

f.       DCL sands for ___________

g.     Write syntax of DESCRIBE statement.

h.     Statement used to partially commit the current transaction and put a save point at that position  is _______

i.       Record with a unique identifier is called______

j.       __________ is the association among several entities.

k.     A single attribute or a set of attributes of a relation which can uniquely identify a record with in the relation is called________

l.       Mainly thee types of files are used in database system (T/F)

m.  Entity set having any key attributes are known as ________ sets.

n.     Symbol -  having the meaning _________

o.     Data dictionaries are of two types as – active data dictionary and ______

Section –B

Note Attempt any six questions

2.       

a.     Explain data independence and its types.

b.     Explain the meaning of following with suitable examples.

                                                             i.      Primary key

                                                           ii.      Super key

                                                        iii.      Candidate key

                                                        iv.      Foreign key

c.      List two advantages and two disadvantages of indexed – sequential file organization.

d.     Give at least five differences between DBMS and RDBMS.

e.      Define normalization. Give the properties of normalization. Give the various types of normal forms.

f.       Define functional and transitive dependency.

g.     Explain the CREATE command with syntax and example.

Section –C

Note: Attempt any three questions.

3.     Explain the term DBMS. Discuss the responsibilities of DBA. Also explain the three level architecture of DBMS.

4.     Explain Codd’s 12 rules of relational Model. 

5.     Construct on E-R diagram for a hospital with a set of patients and set of medical doctor. Associate with each patient, a log of various tests and examinations conducted. Construct the appropriate tales for the E-R diagram.

6.     Define

a.     Data

b.     Database

c.      DBMS

d.     Entity

e.      Record 

Read More

Relational Database Management System Question Paper of 3rd Semester CSE(D) Download Previous Years Question Paper 1

S.B. Roll No.

RELATIONAL DATABASE MANAGEMENT SYSTEM

3^rd Exam/Comp/IT/0090/Dec’08

Duration : 3 Hrs.

Note: Any required data not explicitly given , may be suitably assumed and stated.

1.     Chose the correct or best alternative in the following

a.     Which of the following is a reason to model data?

                                                             i.      Understand each user’s perspective of data

                                                           ii.      Understand the data itself irrespective of the physical representation

                                                        iii.      Understand the use of data across application areas

                                                        iv.      All of the above

b.     If an entity can belong to only one lower level entity then the constraint is

                                                             i.      Disjoint

                                                           ii.      Partial

                                                        iii.      Overlapping

                                                        iv.      Single

c.      The common column is eliminated in

                                                             i.      Theta join

                                                           ii.      Outer join

                                                        iii.      Natural join

                                                        iv.      Composed join

d.     In SQL. Testing whether a sub query is empty is done using

                                                             i.      Distinct

                                                           ii.      Unique

                                                        iii.       Null

                                                        iv.      Exists

e.      Use of UNIQUE while defining an attribute of a table in SQL means that the attribute value are

                                                             i.      Distinct values

                                                           ii.      Cannot have NULL

                                                        iii.      Both (a) and (b)

                                                        iv.      Same is primary key

f.       The cost of reading and writing temporary files while evaluating a query can be reduced by

                                                             i.      Building indices

                                                           ii.      Pipelining

                                                        iii.      Join ordering

                                                        iv.      None of the above

g.     A transaction is in _________ state after the final statement has been executed.

                                                             i.      Partially committed

                                                           ii.      Active

                                                        iii.      Committed

                                                        iv.      None of the above

h.     In multiple granularity of locks SIX lock is compatible with

                                                             i.      IX

                                                           ii.      IS

                                                        iii.      S

                                                        iv.      SIX

i.       The statement that is executed automatically  by the system as a side effect of the modification of the database is

                                                             i.      Backup

                                                           ii.      Assertion

                                                        iii.      Recovery

                                                        iv.      Trigger

j.        The normal form that is not necessarily dependency preserving is

                                                             i.      2NF

                                                           ii.      3NF

                                                        iii.      BCNF

                                                        iv.      4NF

Section –B

Note: Answer all questions. Each question carries 6 marks.

2.       

a.     Briefly describe the different kinds of users of a DBMS.

b.     Explain the following. Give an example.

                                                             i.      Superkey

                                                           ii.      Weak entity set

                                                        iii.      Attribute inheritance

c.       

                                                             i.      Define the concept of aggregation. Give two example where this concept is useful.

                                                           ii.      Define the following

1.     A relation.

2.     Atom of domain relational calculus.

d.     Derive the union rule, decomposition rule and the pseudo transitivity rule using the three Armstrong’s  axioms.

e.      Define multi valued dependency. What do understand by trivial multivalve dependency?

f.       Given R(A, B, C, D,E ) and  M the set of multi valued dependencies

                                                             i.      A →→ BC

                                                           ii.      B→→CD

                                                        iii.      E→→AD

Is R in 4NF? Justify your answer. If is not, decompose R into 4NF

Section –C

Note: Attempt any two questions

3.     Given the relations R(A, B, C) and S (C,D,E,F) given an expression in tuple relational calculus that is equivalent to each of the following.

a.     II _ABC (R)

b.     σ _E=10(S)

c.      R∞ S

d.     R S 

4.     Given the relations Staff (staff No, position, salary) and property ( number , rent, staff No) given below. The staff looks after a given property.

Staff

staff No                position                salary

                             manager               50000.00

                             assistant               15000.00

                             supervisor            25000.00

                             manager               45000.00

          Property

          Number                rent                                staffno

          PA14                    5000.00                         SL21

          PG4                      6000.00                         SG5

          PL94                    10000.00                       SL21

Give the result table for the following SQL          queries

i.                   SELECT          position, COUNT(Staff NO) AS POS, my count

FROM             Staff

ii.                 SELECT          staff no

FROM             staff

WHERE          salary>(SELECT AVG(salary) FROM staff)

iii.              SELECT          staff no

FROM             property

GROUP BY    staff no

HAVING         COUNT(*)>1

iv.              INSERT INTO          staff no

VALUES         (‘SG33, assistant’)

5.       

a.     Describe the four main ways of optimizing disk block access.

b.     Describe the algorithm for updating indices for a single level index when a record is

                                                             i.      Inserted

                                                           ii.      Delected

What will be the modification if there are multilevel indices.

Read More