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

Books Book_ID Book Title Author Win007 Cloud Street Tim Winton Win008 Cloud Street Gri001 Grimm's Fairytales Tim Winton Brothers Grimm Borrowers Borrower_ID Lastname Phone Adam0098 Adamson 9567 9999 Albe0076 Alberti 9567 1234 Asto0034 Aston 9568 4567 Loans Loan_ID Book_ID Borrower_ID 00000123 Win007 Albe0076 00000124 Gri001 Albe0076 00000125 Win008 Adam0098