Exam Details
| Subject | database management system (dbms) | |
| Paper | ||
| Exam / Course | mca | |
| Department | ||
| Organization | Gujarat Technological University | |
| Position | ||
| Exam Date | June, 2017 | |
| City, State | gujarat, ahmedabad |
Question Paper
1
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER-II • EXAMINATION SUMMER 2017
Subject Code: 2620003 Date:07/06/2017
Subject Name: Database Management System (DBMS)
Time: 10:30 am 01:00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
Which are the users of DBMS? Draw a diagram of generalize architecture of Database management System.
7
Define following.
1. DBMS 2.Schema 3. Logical data independence 4.Strong Entity set
5. Functional dependency 6. Super key 7. Normalization
7
Q.2
Explain Select, Projection, Natural Join and Cartesian product operation on relations in context with Relational Algebra.
7
Draw an E-R diagram of online purchase of electronics Items and its billing. Make necessary assumptions add at least one multivalued attribute and derived attribute.
7
OR
With real time examples explain concept of generalization and specialization.
7
Q.3
What is weak entity? Using an E-R Diagram explain its concept .
7
Write short note on requirements of 1 NF,2NF and 3NF.
7
OR
Define Transaction. Explain properties of transactions.
7
What are the advantages of concurrent schedule? Explain with example conflict serializability.
7
Q.4
What is Phantom Problem? Explain with respect to Delete and Insert operation.
7
Which condition is called deadlock? Explain any one technique of deadlock prevention.
7
OR
Define deadlock. Which are the modes of lock Explain any one schedule which shows use of lock.
7
How do we perform delete operation using locking protocol?
7
Q.5
Write short not on log-based Recovery.
7
List all the person's name and Id who are having Hobby stamps or coins collection using relational algebra
ii) Rename the column Name with P_name using relational algebra.
Person:
Id
Name
Address
Hobby
1123
John
123 Main
stamps
1123
John
123 Main
coins
5556
Mary
5 Lake Dr.
hiking
9876
Bart
10Pine St.
stamps
7
2
OR
Write short note on BCNF.
7
Give classification of failure and storage.
7
Seat No.: Enrolment
GUJARAT TECHNOLOGICAL UNIVERSITY
MCA SEMESTER-II • EXAMINATION SUMMER 2017
Subject Code: 2620003 Date:07/06/2017
Subject Name: Database Management System (DBMS)
Time: 10:30 am 01:00 pm Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.
Q.1
Which are the users of DBMS? Draw a diagram of generalize architecture of Database management System.
7
Define following.
1. DBMS 2.Schema 3. Logical data independence 4.Strong Entity set
5. Functional dependency 6. Super key 7. Normalization
7
Q.2
Explain Select, Projection, Natural Join and Cartesian product operation on relations in context with Relational Algebra.
7
Draw an E-R diagram of online purchase of electronics Items and its billing. Make necessary assumptions add at least one multivalued attribute and derived attribute.
7
OR
With real time examples explain concept of generalization and specialization.
7
Q.3
What is weak entity? Using an E-R Diagram explain its concept .
7
Write short note on requirements of 1 NF,2NF and 3NF.
7
OR
Define Transaction. Explain properties of transactions.
7
What are the advantages of concurrent schedule? Explain with example conflict serializability.
7
Q.4
What is Phantom Problem? Explain with respect to Delete and Insert operation.
7
Which condition is called deadlock? Explain any one technique of deadlock prevention.
7
OR
Define deadlock. Which are the modes of lock Explain any one schedule which shows use of lock.
7
How do we perform delete operation using locking protocol?
7
Q.5
Write short not on log-based Recovery.
7
List all the person's name and Id who are having Hobby stamps or coins collection using relational algebra
ii) Rename the column Name with P_name using relational algebra.
Person:
Id
Name
Address
Hobby
1123
John
123 Main
stamps
1123
John
123 Main
coins
5556
Mary
5 Lake Dr.
hiking
9876
Bart
10Pine St.
stamps
7
2
OR
Write short note on BCNF.
7
Give classification of failure and storage.
7
Other Question Papers
Subjects
- advance database management system
- advanced biopharmaceutics & pharmacokinetics
- advanced medicinal chemistry
- advanced networking (an)
- advanced organic chemistry -i
- advanced pharmaceutical analysis
- advanced pharmacognosy-1
- advanced python
- android programming
- artificial intelligence (ai)
- basic computer science-1(applications of data structures and applications of sql)
- basic computer science-2(applications of operating systems and applications of systems software)
- basic computer science-3(computer networking)
- basic computer science-4(software engineering)
- basic mathematics
- basic statistics
- big data analytics (bda)
- big data tools (bdt)
- chemistry of natural products
- cloud computing (cc)
- communications skills (cs)
- computer aided drug delivery system
- computer graphics (cg)
- computer-oriented numerical methods (conm)
- cyber security & forensics (csf)
- data analytics with r
- data mining
- data structures (ds)
- data visualization (dv)
- data warehousing
- data warehousing & data mining
- database administration
- database management system (dbms)
- design & analysis of algorithms(daa)
- digital technology trends ( dtt)
- discrete mathematics for computer science (dmcs)
- distributed computing (dc1)
- drug delivery system
- dynamic html
- enterprise resource planning (erp)
- food analysis
- function programming with java
- fundamentals of computer organization (fco)
- fundamentals of java programming
- fundamentals of networking
- fundamentals of programming (fop)
- geographical information system
- image processing
- industrial pharmacognostical technology
- information retrieving (ir)
- information security
- java web technologies (jwt)
- language processing (lp)
- machine learning (ml)
- management information systems (mis)
- mobile computing
- molecular pharmaceutics(nano tech and targeted dds)
- network security
- object-oriented programming concepts & programmingoocp)
- object-oriented unified modelling
- operating systems
- operation research
- operations research (or)
- pharmaceutical validation
- phytochemistry
- procedure programming in sql
- programming skills-i (ps-i-fop)
- programming skills-ii (ps-oocp)
- programming with c++
- programming with java
- programming with linux, apache,mysql, and php (lamp)
- programming with python
- search engine techniques (set)
- soft computing
- software development for embedded systems
- software engineering
- software lab (dbms: sql & pl/sql)
- software project in c (sp-c)
- software project in c++ (sp-cpp)
- software quality and assurance (sqa)
- statistical methods
- structured & object oriented analysis& design methodology
- system software
- virtualization and application of cloud
- web commerce (wc)
- web data management (wdm)
- web searching technology and search engine optimization
- web technology & application development
- wireless communication & mobile computing (wcmc)
- wireless sensor network (wsn)