Scribd
Upload
67 views3 pages

03 - Question Database - Q

The document describes a bookstore database with tables for publishers, authors, and books. It includes entity-relationship diagrams, data validation, and queries about book titles, authors, and maintaining consistency and avoiding redundancy.

Uploaded by

Pijar Lintang Yanfitrio
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
67 views3 pages

03 - Question Database - Q

The document describes a bookstore database with tables for publishers, authors, and books. It includes entity-relationship diagrams, data validation, and queries about book titles, authors, and maintaining consistency and avoiding redundancy.

Uploaded by

Pijar Lintang Yanfitrio
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 3

Name : Class :

Part 1
Marble Reading Book Stores (MRBS) is a chain of bookstores based in London. The stores want to
keep information about the books they sell, the authors of the books and the publishers they work
with. The assumptions made when the database was created were:

• a publisher can publish books from one or more authors.


• an author can write one or more books.

Three of the tables in the MRBS database are shown below:

The MRBS database undergoes many transactions.

a) Construct the entity-relationship diagram (ERD) for this scenario. [2]


b) Outline why data validation is difficult for the Book_Title attribute.[2]
c) State the result from the following query: [1]

d) Construct a query to find the titles of the books published by “Orlando Crux”.[4]
e) Outline why atomicity is important within a database.[2]
f) Outline how data consistency can be maintained in transactions in this database system.[2]
g) Some data in the MRBS database is redundant. Outline one problem caused by redundant data.
[2]
Answer Part 1:
Real EA Questions (Try Out)

You might also like