Homework Help is Here – Start Your Trial Now!
Engineering
Computer Engineering
simple database application for the following Case Scenario CASE SCENARIO an E/R diagram for the following situation about books, authors, book publishers, book sellers, and book stores. Books have an ISBN number (the key), a name, ant ty dcover or soft cover). A book can be written by many authors and one author can write many books. Authors have an NSSF number (key) and a name. Publishers are

simple database application for the following Case Scenario CASE SCENARIO an E/R diagram for the following situation about books, authors, book publishers, book sellers, and book stores. Books have an ISBN number (the key), a name, ant ty dcover or soft cover). A book can be written by many authors and one author can write many books. Authors have an NSSF number (key) and a name. Publishers are

Computer Networking: A Top-Down Approach (7th Edition)
Computer Networking: A Top-Down Approach (7th Edition)
7th Edition
ISBN:9780133594140
Author:James Kurose, Keith Ross
Publisher:James Kurose, Keith Ross
Chapter1: Computer Networks And The Internet
Section: Chapter Questions
Problem R1RQ: What is the difference between a host and an end system? List several different types of end...
See similar textbooks
icon
Related questions
Question

Write a simpledatabase appplication for the following case scenerio

CASE SCENARIO

United Bookstore

Desing an E/R diagram for the following situation about books, authors, book publishers,, book sellers............ 

Write a simple database application for the following Case Scenario CASE SCENARIO Design an E/R diagram for the following situation about books, authors, book publishers, book sellers, and book stores. Books have an ISBN number (the key), a name, ant type of printing (e.g. hardcover or soft cover). A book can be written by many authors and one author can write many books. Authors have an NSSF number (key) and a name. Publishers are the companies that manage the printing and production of books (e.g. 'Prentice hall'). Publishers have a name (key), year of inception, and address. A given book has a unique publisher. Book sellers maintain book stores to sell books, a given book seller can have many stores (and must have at least one store, to qualify as a book seller). A book store is one of two types - 'brick, or 'web- based' (and cannot be both) For instance, the book seller 'African bookshop' maintains many web-based stores (three in Nairobi, one in Kampala, and so on) as well as web-based stores (e.g. bookshop.co.ug. borders.co.ke). The bookseller 'Amazon' on the other hand has only web-based stores. The bookseller 'Kampala bookstore' has only one single brick store (in Kampala), and so on. Brick book stores have a name (key) and address. Web-based book stores have a name (key) and a URL. Some book stores sell books made by many publishers but some book stores are dedicated to selling books made by only one publisher. Try to model as much as you can, and write notes if necessary. Failing to write notes implies that your diagram is exact. TASKS: i. Identify all the relevant Entities and Attributes and draw an ER diagram that captures the information about this case scenario. Indicate the Primary keys, Foreign Keys, the Relationships, and Participation Constraints ii. Based on the ER diagram that you designed. Write SQL statement to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why.
Transcribed Image Text:Write a simple database application for the following Case Scenario CASE SCENARIO Design an E/R diagram for the following situation about books, authors, book publishers, book sellers, and book stores. Books have an ISBN number (the key), a name, ant type of printing (e.g. hardcover or soft cover). A book can be written by many authors and one author can write many books. Authors have an NSSF number (key) and a name. Publishers are the companies that manage the printing and production of books (e.g. 'Prentice hall'). Publishers have a name (key), year of inception, and address. A given book has a unique publisher. Book sellers maintain book stores to sell books, a given book seller can have many stores (and must have at least one store, to qualify as a book seller). A book store is one of two types - 'brick, or 'web- based' (and cannot be both) For instance, the book seller 'African bookshop' maintains many web-based stores (three in Nairobi, one in Kampala, and so on) as well as web-based stores (e.g. bookshop.co.ug. borders.co.ke). The bookseller 'Amazon' on the other hand has only web-based stores. The bookseller 'Kampala bookstore' has only one single brick store (in Kampala), and so on. Brick book stores have a name (key) and address. Web-based book stores have a name (key) and a URL. Some book stores sell books made by many publishers but some book stores are dedicated to selling books made by only one publisher. Try to model as much as you can, and write notes if necessary. Failing to write notes implies that your diagram is exact. TASKS: i. Identify all the relevant Entities and Attributes and draw an ER diagram that captures the information about this case scenario. Indicate the Primary keys, Foreign Keys, the Relationships, and Participation Constraints ii. Based on the ER diagram that you designed. Write SQL statement to create the corresponding relations and capture as many of the constraints as possible. If you cannot capture some constraints, explain why.
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Recommended textbooks for you
Computer Networking: A Top-Down Approach (7th Edi…
Computer Networking: A Top-Down Approach (7th Edi…
Computer Engineering
ISBN:
9780133594140
Author:
James Kurose, Keith Ross
Publisher:
PEARSON
Computer Organization and Design MIPS Edition, Fi…
Computer Organization and Design MIPS Edition, Fi…
Computer Engineering
ISBN:
9780124077263
Author:
David A. Patterson, John L. Hennessy
Publisher:
Elsevier Science
Network+ Guide to Networks (MindTap Course List)
Network+ Guide to Networks (MindTap Course List)
Computer Engineering
ISBN:
9781337569330
Author:
Jill West, Tamara Dean, Jean Andrews
Publisher:
Cengage Learning
Concepts of Database Management
Concepts of Database Management
Computer Engineering
ISBN:
9781337093422
Author:
Joy L. Starks, Philip J. Pratt, Mary Z. Last
Publisher:
Cengage Learning
Prelude to Programming
Prelude to Programming
Computer Engineering
ISBN:
9780133750423
Author:
VENIT, Stewart
Publisher:
Pearson Education
Sc Business Data Communications and Networking, T…
Sc Business Data Communications and Networking, T…
Computer Engineering
ISBN:
9781119368830
Author:
FITZGERALD
Publisher:
WILEY
SEE MORE TEXTBOOKS