How are database security and database integrity related? Briefly discuss the different levels of security measures which may be considered to protect the database.
________ ____ _______ _______ _______ ______ _____ ________ _______ _______ ______ _______.
____ ______ ___ __________ ______ ______ ___ ________ _________ ____.
__________ _____ _____ ___ ___ ______ ________ ___ ________ ____.
_________ ___ ______ __________ _______ ______ _________.
________ ____ ___ ________ ____ _______ __________ ________ ___ ______ ______.
________ _____ ____ _______ ________ _________ ______ __________ _________ ____ _______ __________.
__________ _________ _______ __________ ________ _____ ___ ______ ______ ____.
________ _________ _______ ______ ______ _____ __________ ______ ____ __________.
__________ ___ ________ ______ ___.
________ _____ ________ __________ ___ ________ _________ ______ _________ _______ _________.
___ ____ __________ _________.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
✓ Unlock up to 60% of the answer
✓ No payment required
Discuss the importance of file organisation in databases. Mention the different types of file organisations available. Discuss any one of the mentioned file organisations in detail.
List and explain the 4 basic properties of a Transaction with the help of appropriate examples.
Write SQL commands for each of the following. Also illustrate the usage of each command through suitable example.
(i) Creation of views
(ii) Creation of sequences
(iii) Outer join
(iv) To give access permission to any use
What are integrity constraints? Discuss the various types of integrity constraints that can be imposed on database.
For what reasons is 2-phase locking protocol required? Explain. Discuss the disadvantages of basic 2-phase locking protocol. List the ways and means that can be used to overcome the disadvantages.
An organization needs to provide Medical facilities to its employees and their dependents. Organization is having a list of Doctors, Hospitals and Test centres for the employees facility. An employee may get Medical facility from the list of Doctors, Hospitals and Test centres provided by the organization to them. Employee does not need to pay anything for the facilities availed. The Doctors, Hospitals and Test centres directly raise their bill to the organization.
Identify the entities, relationships, constraints and cardinality and construct an ER diagram for the above mentioned specifications. List your assumptions and clearly indicate the cardinality mappings as well as any role indicators in your ER diagram.
What is SQL? Explain its important features.
b) Consider the following schemas:
BOOK (Book_ ID, Title, Publisher_ID, Year_of Pub, Price)
AUTHOR (Author_ID, Book_ID, Author Name)
PUBLISHER (Publisher_ID, Book ID, Address, Name_of Pub, No. of Copies)