Download PTU B.Sc CS-IT 2020 March 3rd Sem 71778 Database Management Systems Question Paper

FirstRanker.com
Firstranker's choice
FirstRanker.com

--- Content provided by​ FirstRanker.com ---

Roll No. [ ] Total No. of Pages : 02
Total No. of Questions : 07
B.Sc.(CS) (2013 & Onwards) (Sem.-3)
DATABASE MANAGEMENT SYSTEMS
Subject Code : BCS-306

--- Content provided by​ FirstRanker.com ---

Time : 3 Hrs. Max. Marks : 60

INSTRUCTIONS TO CANDIDATES :

1. SECTION-A is COMPULSORY consisting of TEN questions carrying TWO marks each.

--- Content provided by⁠ FirstRanker.com ---

2. SECTION-B contains SIX questions carrying TEN marks each and a student has to attempt any FOUR questions.

SECTION-A

1. Answer briefly :
   1. What is the difference between Data and Information?
   2. Explain Null Attribute along with one example.
   3. Define Cardinality and Degree.

   --- Content provided by⁠ FirstRanker.com ---

   4. Explain Primary Key and Alternate Key.
   5. What is the purpose of DROP TABLE command? How is it different from DELETE command?
   6. Explain Referential Integrity.
   7. Give the definition of Functional Dependency.
   8. How Union operation is applied on two relations say R1 and R2?

   --- Content provided by FirstRanker.com ---

   9. What is the meaning of a Transaction?
   10. What is Heterogeneous DDBMS?

FirstRanker.com

FirstRanker.com

--- Content provided by‌ FirstRanker.com ---

SECTION-B

2. 1. Define Database Management System. What are the advantages of DBMS over traditional file processing system? Explain.
   2. Explain three level architecture of Database System.

   --- Content provided by⁠ FirstRanker.com ---

3. What are data models? Compare and contrast hierarchical, network and relational data model.
4. 1. What is an ER diagram? Which symbols are used to create ER diagram? Illustrate with an example.
   2. Explain Physical and Logical Independence.

--- Content provided by⁠ FirstRanker.com ---

5. 1. What is normalization? What are its objectives? Explain various normal forms.
   2. What is the use of Inner join and outer join? List out the type of these joins with the notations used in Relational Algebra.
6. 1. What are the problems arising out of concurrent data access? How concurrency is managed?
   2. What are the various threats to data security? Explain how will you protect them?

   --- Content provided by‌ FirstRanker.com ---

7. Express in SQL queries :
   Consider relation :
   SALESMAN Table (SID, SNAME, LOCATION) where SID is the Primary Key.
   PRODUCT Table (PID, PNAME, COLOR, WEIGHT) where PID is the Primary Key.
   

   --- Content provided by​ FirstRanker.com ---

   SALES_PRODUCT Table (SID, PID, QUANTITY) where (SID, PID) is the Primary Key and SID and PID are foreign keys to SALESMAN and PRODUCT tables respectively.
   1. Get the total quantity of product P1 sold by salesman S1.
   2. List all salesmen whose name start from ‘B’ and whose location ends with ‘E’.
   3. List information of all products.
   4. Display the total quantity of all products sold whose color is WHITE.
   5. Get the total quantity sold by each salesman.

   --- Content provided by​ FirstRanker.com ---

NOTE : Disclosure of Identity by writing Mobile No. or Making of passing request on any page of Answer Sheet will lead to UMC against the Student.

FirstRanker.com