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. Discuss about the advantages of database system. 2. Describe the levels of abstraction in a database. 3. Explain the mapping cardinalities with suitable example. 4. Compare generalization with aggregation. 5. Write short notes on fundamental operations of relational algebra. 6. What is Normalization? Explain Boyce codd normal form. 7. Explain Group by and Order by clauses with suitable example. 8. Write short notes on DDL and DML commands. SECTION – B (5X10=50) Answer any FIVE Questions 9. Draw an E-R diagram for a university consisting of 4 entities. i) Student ii) Department iii) Class iv) Faculty • A student has a unique id, the student can enroll from multiple classes and has at- most one major. • Faculty must belong to department and can take multiple classes. • Every student will get a grade for the class he/she has enrolled.
~1~
Q5/10B/03-14
10. Discuss in brief about the data models with an example. 11. Write short notes on tuple relational calculus with suitable example. 12. Discuss the domain relational calculus. 13. Discuss in brief about 2NF with 3NF with suitable example. 14. Create an employee table and write the SUBQUERY for the following a. Select statement b. Insert statement c. Update statement d. Delete statement 15. Discuss about the Join operations used in SQL. 16. Write short notes on the following: a. String Functions b. Grant and Revoke privileges.
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 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).
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 ...