CS403 Mid Term Paper 2009
Question No: 1 ( M a r k s: 1 )
A relation (from the relational database model) consists of a set of tuples, which implies that
► all tuples in a relation must be distinct.
► relational model supports multi-valued attributes whose values can be represented in sets.
► for any two tuples, the values associated with all of their attributes may be the same.
all tuples in a particular relation may have different attributes.
Question No: 2 ( M a r k s: 1 )
Identify the constraint that limits the values that can be placed in a column.
NOT NULL
CHECK
FOREIGN KEY
UNIQUE
Question No: 3 ( M a r k s: 1 )
A database system allows the following EXCEPT
management and control of data towards an efficient working of an organisation.
more critical functions in organisations to be computerised and the need to keep a large
volume of data available in an up to the minute current state increased.
any user to access all its data.
integration of data across multiple applications into a single application.
Question No: 4 ( M a r k s: 1 )
Which of the following is true regarding relations?
Every attribute value is non-atomic.
Attributes in tables may not have unique names
The order of the columns is relevant.
The order of the rows is irrelevant.
Question No: 5 ( M a r k s: 1 )
Which of the following concept is applicable with respect to 2NF?
Non-transitive dependency
Full functional dependency
Partial dependency
Transitive dependency
Question No: 6 ( M a r k s: 1 )
Consider the following relation and its sample data. (Consider that these are the only tuples for the given relation)
Which of the following statements is NOT correct?
The functional dependency (EmpNo, DeptNo) -> ProjNo holds over R.
The functional dependency EmpNo -> DeptNo holds over R.
The functional dependency ProjNo -> DeptNo holds over R.
The functional dependency (EmpNo, ProjNo) -> DeptNo holds over R.
Question No: 7 ( M a r k s: 1 )
Which of the following enforces a relation into 1st normal form?
The domain of attribute must include only atomic values.
Every non-key attribute is fully functionally dependent on primary key
non-key attribute is non-transitively dependent on primary key.
Every non-key attribute is partially dependent on super key
Question No: 8 ( M a r k s: 1 )
Which of the following concepts is applicable with respect to 3NF?
Full functional dependency
Any kind of dependency
Transitive dependency
Partial functional dependency
Question No: 9 ( M a r k s: 1 ) http://vuzs.net
If W, X, Y and Z are attributes of a relation, which of the following inference rules for functional dependencies is correct?
If (X, Z) -> Y then X -> Y and Z -> Y.
If X -> Y and X -> Z then X -> (Y, Z).
If X Y then Y -> X
If X -> Y then (X, Z) -> (Y,W).
Question No: 10 ( M a r k s: 1 ) http://vuzs.net
Which of the following is correct regarding Dataflow diagram?
Single DFD is required to represent a system
The dataflow must be bidirectional
Created at increasing levels of detail
Used to represent the relationships among the external entities
Question No: 11 ( M a r k s: 1 ) http://vuzs.net
Which of the following is NOT a component of a DFD?
Dataflow
Datastore
External entities
Relationship between external entities
Question No: 12 ( M a r k s: 1 ) http://vuzs.net
Consider the relations given below. The relations given in (i) and (ii) respectively have been
achieved by normalising the relation Person(NID, {Car_Lic#}, {Phone#})
(i) Person(NID, Car_Lic#, Phone#)
(ii) Person1(NID, Car_Lic#) ; Person2(NID, Phone#)
Which of the following statements is correct with respect to solutions (i) and (ii)?
Solution (i) is considered as the better solution since solution (ii) introduces new relations.
Solution (ii) is considered as the better solution since solution (i) results in an all-key
relation.
Solution (ii) suffers from redundancy.
Only solution (i) holds dependency preservation property.
Question No: 13 ( M a r k s: 1 ) http://vuzs.net
Which of the following statements is correct with respect to entity integrity?
Entity integrity constraints specify that primary key values can be composite.
Entity integrity constraints specify that no primary key value can be null.
Entity integrity constraints are specified between weak entities.
When entity integrity rules are enforced, a tuple in one relation that refers to another relation must refer to an existing tuple.
Question No: 14 ( M a r k s: 1 ) http://vuzs.net
Consider the following diagram depicting a kind of a relationship type where X and Z are entities and Y is a relationship type:
Select the correct statement among the following on the above diagram.
The relationship type Y is of cardinality ratio 1 : N.
The diagram depicts existence dependencies.
The participation of X in the Y relationship type is total.
The participation of Z in the Y relationship type is partial.
Question No: 15 ( M a r k s: 1 ) http://vuzs.net
Identify the factor which enforces a relation in 3NF?
Every non-key attribute is fully functionally dependent on primary key
Every non-key attribute is partially dependent on super key
The domain of attribute must include only atomic values.
Every non-key attribute is non-transitively dependent on primary key.
Question No: 16 ( M a r k s: 1 ) http://vuzs.net
Consider the given relations Student and Instructor as given below. Please note that
Fname and Lname also denote the First Name and Last Name respectively.
Which of the following statements is correct with respect to the two relations given above?
The two relations are not union-compatible since their attribute names differ.
cs 615 midterm
Question No: 1 ( M a r k s: 1 ) http://vuzs.net
________ identifying which quality standards are relevant to the project and determining how to satisfy them.
► Quality Planning
► Communications Planning
► Organization Planning
► Staff Acquisition
Question No: 2 ( M a r k s: 1 ) http://vuzs.net
These all are outputs of Initiating Process except
► Project Manager Assignments
► Constraints
► Selection Criteria
► Assumptions
Question No: 3 ( M a r k s: 1 ) http://vuzs.net
Project management processes can be organized into _____________ groups
► Four
► Five
► Six
► Seven
Question No: 4 ( M a r k s: 1 ) http://vuzs.net
Product quality depends on its conformance to ______
► Software requirements
► Development standards
► Implicit requirements
► All of given
Question No: 5 ( M a r k s: 1 ) http://vuzs.net
_______is the technical kernel of software engineering
► Design
► Implementation
► Requirements analysis
► Testing
Question No: 6 ( M a r k s: 1 ) http://vuzs.net
Mode of specification has a great impact on quality of solution. Forcing SWE to work with incomplete, inconsistence, or misleading specifications result in frustration and confusion affecting:
► Quality
► Timeliness and
► Completeness of SW product
► All of given
Question No: 7 ( M a r k s: 1 ) http://vuzs.net
Finally, the specification includes a ________
► Bibliography
► Appendix
► Both Bibliography and Appendix
► Reference
Question No: 8 ( M a r k s: 1 ) http://vuzs.net
Cognitive model describes a system as perceived by its _________
► User community
► Developer
► Top level management
► Manager
Question No: 9 ( M a r k s: 1 ) http://vuzs.net
A review of the Software Requirements Specification is conducted by ________
► Software developer
► Customer
► Both the software developer and the customer
► Top level management
Question No: 10 ( M a r k s: 1 ) http://vuzs.net
A meeting is conducted at a _________ and attended by both software engineers and customers.
► Software engineer site
► Neutral site
► Customer site
► Company site
Question No: 11 ( M a r k s: 1 ) http://vuzs.net
The model serves as the basis for the creation of ________ for the Software.
► Design
► Maintenance
► Testing
► Specifications
Question No: 12 ( M a r k s: 1 ) http://vuzs.net
Throughout evaluation and solution synthesis, the analyst's primary focus is on
► "What, not "how."
► Model
► Evaluation and Synthesis
► Specification
Question No: 13 ( M a r k s: 1 ) http://vuzs.net
In problem evaluation area of effort, once problems have been identified, the ___________determines what information is to be produced by the new system and what data will be provided to the system.
► Analyst
► Designer
► Coder
► Manager
Question No: 14 ( M a r k s: 1 ) http://vuzs.net
Requirements are refined and analyzed to assess their clarity, completeness, and_______
► Correctness
► Consistency
► Concurrency
► None of given
Question No: 15 ( M a r k s: 1 ) http://vuzs.net
A software project that meets all the stated objectives is a success of _________
► Project quality
► Project fundamental purpose
► Project management myth
► Project requirement
Question No: 16 ( M a r k s: 1 ) http://vuzs.net
All of the following describe the activity list except:
► It’s an extension of the WBS
► It include all activities of the project
► It describe the WBS update
► It include a description of project activities
Question No: 17 ( M a r k s: 1 ) http://vuzs.net
Software project are carried out sequentially and that each phase is completed before the next is taken up.
► The Prototyping Model
► The Incremental Model
► The Waterfall model
► The Spiral model
Question No: 18 ( M a r k s: 1 ) http://vuzs.net
Project management is a _________of constant communication and negotiation.
► Process
► Concept
► Practice
► None of given
Question No: 19 ( M a r k s: 1 ) http://vuzs.net
These all are design phase activities except
► Output Design
► Input Design
► The software test plan
► Software Selection
Question No: 20 ( M a r k s: 1 ) http://vuzs.net
Which organization has set the de facto standards for project management techniques?
► PMBOK
► PMI
► PMA
► PMO
PMA
Question No: 21 ( M a r k s: 2 )
Give the name of configuration control tools?
Question No: 22 ( M a r k s: 3 )
Software requirements analysis a bridge between system engineering and software design, show it by diagram.
Question No: 23 ( M a r k s: 5 )
Write down the software process player’s names and their roles in projects.
Question No: 24 ( M a r k s: 10 )
Explain the following terms regarding project characteristics and project dimensions.
· Temporary,
· Unique,
· Aims,
· People,
· Process
