Short Questions.(any seven) 1. Define Data and Information. 2. What do you mean by instances and schemas? 3. What is data dictionary? 4. Write functionality of DESC command in SQL. 5. Explain IN and BETWEEN Operator. 6. Explain limit clause of select statement. 7. Differentiate DROP and TRUNCATE Command. 8. ___________ can be used to retrieve data from multiple tables. A. Embedded SQL. B. Dynamic SQL. C. Joins. D. Views. 9. Define how AND & OR operator can be used with select statement.
[7 marks]Explain Database Management System (DBMS) architecture with proper diagram.
[7 marks]Attempt following : 1. Define Tuples 01 2. Explain various mapping cardinality with suitable example. 3. Explain 2-Tier, 3-Tier Architecture of Dbms.
[4 marks]Explain Relational Model, Network Model and Hierarchical Model with neat diagram and suitable example.
[7 marks]Explain Codd’s 12 Rules in detail.
[7 marks]Explain different types of Relationships. With suitable E-R Diagram And Example.
[7 marks]Attempt following : 1. What is Normalization? Explain 1NF, 2NFwith suitable example(s). 2. Explain BCNF with suitable example.
[4 marks]What is an entity? what is entity set? Explain ER Modeling with the help of database for a student management system
[7 marks]Attempt following : 1. Explain Entity Integrity, Referential Integrity, User – defined Integrity. 2. differentiate between Specialization and Generalization
[4 marks]Explain attributes and discuss types of attributes. What is a constraint in database? Explain types of constraints with a suitable example.
[4 marks]Specify E-R Symbols and their use. OR1
[7 marks]Differentiate between strong and weak entity set. Discuss aggregate functions with example(s).
[4 marks]Draw E-R Diagram for the situation given below: Auniversity consists of a number of departments. Each department offers several courses. Anumber of modules make up each course. Students enrol in a particular course and take modules towards the completion of that course. Each module is taught by a lecturer from the appropriate department, and each lecturer tutors a group of students.
[7 marks]Attempt following : 1. State the differences between COMMIT and ROLLBACK commands. 2. Write a note on two phase locking protocol.
[4 marks]Enlist SQL commands for DML. Consider following relations and write SQL queries for given statements. Assume suitable constrains. job(job-id, job-title, minimum-salary, maximum-salary) employee(emp-no, emp-name, emp-salary,dept-no) deposit(acc-no, cust-name, branch-name, amount, account-date) borrow(loan-no, cust-name, branch-name, amount) department (dept-no, dept-name) 1. Give name of depositors whose branch name starts from ‘D’. 2. Give employee name(s) whose salary is between Rs. 20000 to 30000 and department name is Finance. 3. Delete borrower details whose amount is less than 25000.
[7 marks]Attempt following : 1. Describe GRANT and REVOKE commands. 2. Explain ACID properties of transaction.
[4 marks]Enlist SQL commands for DDL. Consider following relations and write SQL queries for given statements. Assume suitable constrains. Vehicle (v_id, name, color, price, company) Customer (c_id, name, address, phoneno, email) Sell (v_id, c_id, sell_date, and amount) 1. Add new column tax in vehicle table.. 2. Display vehicle details whose name starts with ‘H’.. 3. Display customer detail sell with amount greater then 25000.
[7 marks]