Page 43 - DCAP402_DCAO204_DATABASE MANAGEMENT SYSTEM_MANAGING DATABASE

Database Management Systems/Managing Database

Notes (b) Find the names of sailors who have reserved at least two boats.
(c) Find the sids of sailors with age over 20 who have not reserved a red boat.
(d) Find the names of sailors who have reserved all boats. The use of the word all (or
every) is a good indication that the division operation might be applicable.
(e) Find the names of sailors who have reserved all boats called Interlake.
2. Describe the relational model concept of DBMS.
3. What do you mean by alternatives to the relational model?

4. Describe NULL concept in database.
5 Describe various expressions of relational algebra.
6. Write short note on UNION and INTERSECTION.

Answers: Self Assessment

1. Relational model 2. logical schema

3. heading 4. table
5. Attribute 6. Outer joins
7. Data 8. binary relationships
9. header H 10. Intersection

2.7 Further Readings

Books C.J. Date, Introduction to Database Systems, Pearson Education.

Elmasri Navrate, Fundamentals of Database Systems, Pearson Education.
Martin Gruber, Understanding SQL, BPB Publication, New Delhi
Peter Rob & Carlos Coronel, Database Systems Design, Implementation and
Management, 7th Edition.
Raghurama Krishnan, Johannes Gehrke, Database Management Systems, 3rd Edition,
Tata McGraw Hill.

Silberschatz, Korth, Database System Concepts, 5th Edition, McGraw Hill.
SIlberschatz-Korth-Sudarshan, Database System Concepts, 4th Edition, Tata
McGraw Hill

Vai Occardi, Relational Database: Theory & Practice, BPB Publication, New Delhi

Online links www.en.wikipedia.org
www.webopedia.com

www.web-source.net

36 LOVELY PROFESSIONAL UNIVERSITY