Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

(a) Describe three types of Database Management System users. (b) (c) 6 marksE With the aid of an example in each case, distinguish between

image text in transcribed

(a) Describe three types of Database Management System users. (b) (c) 6 marksE With the aid of an example in each case, distinguish between physical and logical data independence as used in database design. (4 marks) Table 1 shows information from a booksDetails relation in a relational database. Use it to answer the questions that follow. Table 1 Book Id Book Title BookAuthor B2233 The Worlds Deity Maxwell B2234 Making Money Online Havi B2235 Database Made Easy Charles Write a Structured Query Language statement that would: (i) display the authors of books from the books Details relation whose Book_Id is greater than or equal to B2235, (2 marks) (ii) add a new record; B2236, Database Applications, Peter into the relation, (2 marks) (iii) remove the book titled The Worlds Deity from the relation; (2 marks) (iv) sort the table by Book_Id in descending order. (2 marks) (v) display the total number of books authored by Havi in the relation. (2 marks

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Financial Accounting and Reporting a Global Perspective

Authors: Michel Lebas, Herve Stolowy, Yuan Ding

4th edition

978-1408076866

Students also viewed these Databases questions