Answered step by step
Verified Expert Solution
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
(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
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