A school library keeps track of book loans using a relational database which has tables called Books,
Fantastic news! We've Found the answer you've been seeking!
Question:
A school library keeps track of book loans using a relational database which has tables called Books, Borrowers and Loans. Parts of these tables are shown below.
i) There are three level of database architecture, use the Books table above as an example to describe and differentiate all of them. Show clearly the views for each level in a diagram.
ii) How these three levels are related to the three database languages (DDL, DML and DCL)?
iii) Provide the correct use of DDL and DML in order to create & manipulate all the three tables above in a DBMS
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date: