Solapur University Question Paper
M.B.A. (Part – II) (Semester – IV) Examination, 2014
Group – D : SYSTEM MANAGEMENT (New)
Paper – III : Relational Database Management System
Day and Date : Wednesday, 18-6-2014 Max. Marks : 70
Time : 11.00 a.m. to 2.00 p.m.
Instructions : 1) Q. 1 is compulsory.
2) Solve any two from Q. 2, 3 and 4 and any two from 5, 6 and 7.
1. Case Study. 14
Normalize the following up to 3NF
Application Serial No., First Name, Surname, Middle Name,
Address, City, Pin Code, Phone No., E-mail, Course Name,
Application date, Academic year, Form Fee Receipt No,
form fee receipt date, Form fee amount, Payment mode,
DD/Cheque number.
2. Write short notes on (Solve any two) : 14
i) Primary Key and Foreign Key
ii) Data functions
iii) Users of RDBMS.
3. Write short notes on (Solve any two) : 14
i) Advantages and disadvantages of Normalization
ii) abs and ceil
iii) to_char and to_date.
4. Write short notes on (Solve any two) : 14
i) Drop and Truncate
ii) Hierarchical Data model
iii) Joins.
SLR-XY – 86
5. Explain Report Writing in details. 14
6. Write a queries for following : 14
i) Create a unique listing of all jobs that are in department 80. Include the
location of the department in the output.
ii) Write a query that displays the employee’s last names with the first letter
capitalized and all other letters lowercase and the length of the name for all
employees.
iii) Write a query to display the current date. Label the column Date.
iv) Display the last name of all employees who have an a and an e in their last
name.
v) Display the last name and hire date of every employee who was hired in
1994.
vi) Display the last name and salary for all employees whose salary is not in the
range of $ 5,000 and $ 12,000
vii) Create a query to display unique job codes from the EMPLOYEES table.
7. Explain Entity Relationship Diagrams with example in details. 14
M.B.A. (Part – II) (Semester – IV) Examination, 2014
Group – D : SYSTEM MANAGEMENT (New)
Paper – III : Relational Database Management System
Day and Date : Wednesday, 18-6-2014 Max. Marks : 70
Time : 11.00 a.m. to 2.00 p.m.
Instructions : 1) Q. 1 is compulsory.
2) Solve any two from Q. 2, 3 and 4 and any two from 5, 6 and 7.
1. Case Study. 14
Normalize the following up to 3NF
Application Serial No., First Name, Surname, Middle Name,
Address, City, Pin Code, Phone No., E-mail, Course Name,
Application date, Academic year, Form Fee Receipt No,
form fee receipt date, Form fee amount, Payment mode,
DD/Cheque number.
2. Write short notes on (Solve any two) : 14
i) Primary Key and Foreign Key
ii) Data functions
iii) Users of RDBMS.
3. Write short notes on (Solve any two) : 14
i) Advantages and disadvantages of Normalization
ii) abs and ceil
iii) to_char and to_date.
4. Write short notes on (Solve any two) : 14
i) Drop and Truncate
ii) Hierarchical Data model
iii) Joins.
SLR-XY – 86
5. Explain Report Writing in details. 14
6. Write a queries for following : 14
i) Create a unique listing of all jobs that are in department 80. Include the
location of the department in the output.
ii) Write a query that displays the employee’s last names with the first letter
capitalized and all other letters lowercase and the length of the name for all
employees.
iii) Write a query to display the current date. Label the column Date.
iv) Display the last name of all employees who have an a and an e in their last
name.
v) Display the last name and hire date of every employee who was hired in
1994.
vi) Display the last name and salary for all employees whose salary is not in the
range of $ 5,000 and $ 12,000
vii) Create a query to display unique job codes from the EMPLOYEES table.
7. Explain Entity Relationship Diagrams with example in details. 14
0 comments:
Pen down your valuable important comments below