(i) Course, including number, title, credits, syllabus and prerequisites
(ii) Course offering, including course number, year, semester, section
number, instructor(s), timings and classroom.
(iii) Students, including student-id, name and program.
(iv) Instructors, including identification number, name, department
and title.
Further, the enrolment of students in courses and grades awarded to students in each course they are enrolled for must be appropriately modelled.
Construct an E - R diagram for the Registrar's office. Document all assumptions that you make about the mapping constraints.
(b) Discuss the three level architecture of DBMS. Explain how does it lead to data independence.
(c) With the help of an example, explain the inverted file organization.
(d) What is a view ? Explain with the help of an example. Also specify the five conditions that a view must meet in order to allow the updates.
(e) With the help of an example, explain how knowledge representation can be done through Semantic Network.
Q.2. (a) Consider the following 3 tables
PAINTER
| PTR_NUM |
| PTR LASTNAME |
| PTR-FIRSTNAME |
| PTR INITIAL |
| PTR AREACODE |
| PTR PHONE |
GALLERY
| GAL_NUM |
| GAL_OWNER |
| GAL_AREACODE |
| GAL PHONE |
| GAL-RATE |
PAINTING
| PNTG_NUM |
| PNTG_TITLE |
| PNTG-PRICE |
| PTR NUM |
| GAL-NUM |
Write the relational algebraic expressions/queries for the following operations:
(i) Find all painters who have painted in GAL_NUM=4.
(ii) Find all paintings of Gallery whose rate is > 1000
(iii) Find the Gallery in which painter 'Ramesh' has displayed his
paintings.
(iv) Find the number of paintings displayed in Gallery owned by 'Shyam'.
(b) Explain the concepts of Generalization and Specialization with examples.
Q.3. (a) Mention the features of OODBMS and give four advantages of it.
(b) What are the general resistances faced by an organization while implementing DBMS tool ? Explain at least four of them
(c) What is client/server computing ? Discuss the components of client/server computing.
Q.4. (a) Given the structure
| Proj Num |
Project Name |
Emp No |
Emp Name |
Job Class |
Chg/Hr |
HRS Billed |
Total Charge |
| 13 |
Banking |
103 |
Ramesh |
System |
500 |
8 |
4000 |
| 26 |
Telecom |
115 |
Amit |
Business |
100 |
10 |
1000 |
| 39 |
Finance |
113 |
Gopal |
Team |
1000 |
4 |
4000 |
(i) Identify the anomalies in the given structure.
(ii) Normalise it upto third normal form (3NF).
(b) Explain any three aggregate functions of SQL with an example for each.