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 SECTION – A (5X5=25) Answer any FIVE Questions
1.
What are the four main differences between a file processing system and a DBMS?
2.
Explain the distinctions among primary key, candidate key and super key. Give relevant examples.
3.
Explain about database schema.
4. Briefly explain 3NF. 5.
How the user roles are managed with Oracle?
6.
How the SQL view is updated? Explain with example.
7.
Explain aggregation.
8.
Consider the following relation: EMP (ENO, NAME, DATE_OF_BIRTH, SEX, DATE_OF_JOINING, BASIC_PAY, and DEPT). Develop an SQL query that will find and display the average BASIC_PAY in each DEPT. SECTION – B (5X10=50) Answer any FIVE Questions
9.
Construct an ER diagram for Banking enterprise.
10. Explain in detail relational calculus.
~1~
Q5/10J/11-14 11. What is nested sub query and correlated subquery? Why it has been used? Give relevant examples to select and update using nested sub query. (3+2+ 5) 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. Find the names and cities of residence of all employees who work for XYZ Bank. b. Find the names, street address, and cities of residence of all employees who work for XYZ Bank and earn more than Rs. 10,000 per annum. c. Find the names of all employees in this database who live in the same city as the company for which they work. d. Find the names of all employees who live in the same city and on the same street as do their managers. 13. What is meant by multivalued dependencies? Explain 4NF in detail. (2+8) 14. Discuss in detail about various data models. 15. Explain various pseudo column instructions with examples. 16. Explain Integrity Constraints in SQL.
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 ...
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).
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 ...