Answered step by step
Verified Expert Solution
Question
1 Approved Answer
stion 1 A school library keeps track of book loans using a re lational database which has tables called Books, Borrowers and Loans. Parts of
stion 1 A school library keeps track of book loans using a re lational database which has tables called Books, Borrowers and Loans. Parts of these tables are shown below Books Book ID Book Title Author Cioud Street Cloud Street Grimms Fairytaies Tim Wmn Tim imon Brothers Grimm Bormower ID Phone Asto0034 Aston Loans -Loan ID Book II Bomomer ID 00000123 AJDe0076 a) There are three level of database architecture, use the Books table above as arn example to describe and differentiate all of them. Show clearly the views for each level in a diagram. b) How these three levels are related to the three database languages (DDL, DML and DCL)? c) Write the correct DDL and DML statements in order to create and manipulate all the three tables above in a DBMS. d) Describe View by giving a simple ex ample from above scenario. What are the advantages of using the views? 25 Marks]
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started