Question: Consider a database for a Library Management System that stores the data in five tables named Member, Book, Publisher, Loan and Reservation. Prepare a security

Consider a database for a Library Management System that stores the data in five tables named Member, Book, Publisher, Loan and Reservation. Prepare a security model for this database by filling the given table. You can include database operations such as Insert, Update, Delete, Query, Modify structure, Grant and Revoke etc. to complete this table. One cell is filled for an idea: (6 marks)

Role / Table

Member

 Book

Publisher

 Loan Reservation

Library Member

Management

Administration Staff

Insert, Update, Delete, Query

System Administrator

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

Consider a database for a Library Management System that stores the data in five tables named Member, Book, Publisher, Loan and Reservation. Prepare a security model for this database by filling the...

Q:

The relational schema of the database, which is about the Library Management System, is provided below: BOOK BookID, Title, Author, Publisher, PublishDate, ISBN, Category, Language, TotalCopies,...

Q:

Consider a database for a business organisation that stores the data in five tables named Product, Order, Orderltem, Inventory and Supplier. Prepare a security model for this database by filling the...

Q:

Consider a database for a business organisation that stores the data in five tables named Product, Order, OrderItem, Inventory and Supplier. Prepare a security model for this database by filling the...

Q:

Consider a database for an academic institute that stores the data in five tables named Student, Staff, Course, Enrolment and Department. Prepare a security model for this database by filling the...

Q:

Consider a database for an academic institute that stores the data in five tables named Student, Staff, Course, Enrolment and Department. Prepare a security model for this database by filling the...

Q:

Consider a database for a business organisation that stores the data in five tables named Product, Order, OrderItem, Inventory and Supplier. Prepare a security model for this database by filling the...

Q:

Consider a database for an academic institute that stores the data in five tables named Student, Staff, Course, Enrolment and Department. Prepare a security model for this database by filling the...

Q:

\f\f\fChapter 2 Service Strategy Learning Objectives After completing this chapter, you should be able to: 1. Formulate a strategic service vision. 2. Describe how a service competes using the three...

Q:

He want us to identify the 18 vulnerabilities. template is attach. Case No. 2000-02: Recreation, Inc. 1 AICPA Case Development Program RECREATION, INC. AN INFORMATION TECHNOLOGY RISK ASSESSMENT CASE...

Q:

Marlys Consolidated has several divisions, two of which transfer their products to other divisions. The Mining division refines toldine, which it then transfers to the Metals division. The Metals...

Q:

In order to have effective intercultural communication, you should not assume that things about another people will be similar or different. True False

Q:

A client asks his accountant to ignore a mistake which overstated the accounts receivable account which stage of the kohlberg stages of moral development is the accounting reasoning

Q:

you have titrated potentiometrically both Aspirin and Fe3+ in aqueous solutions. Draw the structures of the active ingredients of Aspirin and iron (Fe3+). How many titratable functional groups are...

Q:

How would redundant storage of values in columns in a Table be eliminated?

Q:

What do Primary Keys, along with Third Normal Form Design in a Database Model, achieve?

Q:

Describe Table Structures in RDMSs.