St. Joseph’s College of Arts & Science (Autonomous) St. Joseph’s College Road, Cuddalore – 607001 CS509- Relational Database Management System Time : 3 hrs Max Marks :75
U
U
SECTION – A (5X5=25) Answer any FIVE Questions 1.
What are the five main functions of a database administrator?
2.
With necessary examples, explain various categories of attributes used in ER model.
3.
Explain Tuple relational calculus.
4.
Briefly explain 4NF.
5.
Differentiate inner join and outer join. Explain with an example.
6.
Explain how grant and revoke privileges given to the function or procedure with examples.
7.
Explain three levels of data abstraction.
8.
Consider the following: stud (rollno, sname, class, sex, mark1, mark2, mark3, mark4, mark5, and total).Create a table with the given information. Calculate total from all marks and display maximum total mark in each class. SECTION – B (5X10=50) Answer any FIVE Questions
9.
Discuss in detail about database system architecture.
~1~
Q5/10L/11-13 10. Construct an ER diagram for Employee Payroll system. 11. With relevant examples, discuss various operations of relational algebra. 12. Consider the following relational database employee (employee-name, eno, street, city,pnone_no) works ( eno, employee-name, company-name, salary) company (eno, company-name, city) manages (eno, employee-name, manager-name) Give an expression in SQL to express each of the following queries : a. Modify the database such that now Raja lives in Chennai b. Find the company with smallest payroll. c. Assume the companies located in several cities. Find companies located in every city in which Bank of India is located d. Find the company with most employees. 13. What is meant by functional dependencies? Explain BCNF in detail. (2+8) 14. Explain Integrity Constraints in SQL. 15. What is aggregation in an ER model? Develop an ER diagram using aggregation that captures the following information : Employees work for projects. An employee working for a particular project uses various machinery systems. Assume necessary attributes. State any assumptions you make. Also discuss about the ER diagram you have designed. (3+7) 16. What is nested sub query and correlated subquery? Why it has been used? Give relevant examples to insert and update using nested sub query. (3+2+ 5)
What is nested sub query and correlated subquery? Why it has. been used? Give relevant examples to insert and update using. nested sub query. (3+2+ 5).
Page 2 of 2. Q5/10J/11-14. ~ 2 ~. 11. What is nested sub query and correlated subquery? Why it has. been used? Give relevant examples to select and update ...
Create an employee table and write the SUBQUERY for the. following. a. ... Discuss about the Join operations used in SQL. 16. Write short notes on the following ...
Page 1 of 4. Page 1 of 4. Page 2 of 4. Page 2 of 4. Page 3 of 4. Page 3 of 4. Main menu. Displaying Relational Database Management System.pdf. Page 1 of 4.
... attributes are covered in 8. some query. - o 0 o -. CST-203P/ S1 1 1,000. Page 1 of 1. Main menu. Displaying Relational Database Management Systems.pdf.
The management of data in telecommunications system has many aspects whereof some, but .... initialize a database schema, start Mnesia, and create tables.
There was a problem previewing this document. Retrying... Download. Connect more apps... Try one of the apps below to open or edit this item. pdf database ...
QLC, can be used as a database programming language for Mnesia. ... Mnesia Session enables access to the Mnesia DBMS from foreign programming languages ( ...... -mnesia no table loaders NUMBER specifies the number of parallel table ...
[Read PDF] Relational Database Design and ... administration, this book provides practical information necessary to develop a design and management scheme ...
seema kedar pdf free download. Download now ... database management system by seema kedar pdf free download. Open. Extract. Open with. Sign In. Details.
2Department of Computer Science, Cornell University, Ithaca, NY 14853, USA. {lantova ... a Web-based application that offers NBA-related informa- tion based on what-if analysis of team ... MayBMS has been released and is available for download at ...