Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 2012 Proceedings Part 2 Lnai 7197

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284892, 978-3642284892

More Books

Students also viewed these Databases questions

Question

What do you think is this persons attitude toward you?

Answered: 1 week ago

Question

Identify conflict triggers in yourself and others

Answered: 1 week ago