A publishing company produces books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not necessarily being specialists in a particular area, each take sole responsibility for editing one or more book publications. Every book require some items for publication. These items supplied by suppliers. One supplier can supply many items. Shop owner buys books from the publisher. Shop owner can buy many books but one book can be bougbht by one shop owner only. Books are uniquely identified by book ID. Propose EER diagram to this system?

A publishing company produces books on various subjects. The books are written by authors who specialize in one particular subject. The company employs editors who, not necessarily being specialists in a particular area, each take sole responsibility for editing one or more book publications. Every book require some items for publication. These items supplied by suppliers. One supplier can supply many items. Shop owner buys books from the publisher. Shop owner can buy many books but one book can be bougbht by one shop owner only. Books are uniquely identified by book ID. Propose EER diagram to this system?

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: Read carefully the following case: Imagine that you work as an internal auditor for a company that…

A: The process begins with the assistant manager preparing the cash registers with petty cash and…

Q: Create a Use Case Diagram Based on the following scenario: A parking deck system manages an…

A: In this question we have to understand and Design a use case diagram for use cases of a parking deck…

Q: For this system Write scenario for a borrow book(for students) and design the corresponding Sequence…

A: Below we draw simple sequence diagram for given scenario. ================================== Figure…

Q: or below given Scenario draw the following UML Diagrams CLASS DIAGRAM SEQUENCE DIAGRAM WEB BASED…

A: The given problem details a scenario for web based auction scenario and the requirement is to…

Q: The participation of the entity Employee in the following ERD is: type your answer.... Employee…

A: Its a many-to-one relationship.Explanation:In a database model, relationships are represented by…

Q: A library wants to build a simple online recommendation system for a summer reading programme. The…

A: a simple online recommendation system it contains actors which are given below 1) user 2) book 3)…

Q: Bike with Us is a bicycle rental company which has several offices in different neighborhoods of…

Q: James River Jewelry is a small jewelry shop. While James River Jewelry does sell typical jewelry…

A: A. Functional dependencies : LastName, FirstName -> Phone InvoiceDate ->-> InvoiceItem,…

Q: Draw a partitioned activity diagram for the rent car use case of Rent-A-Car. Rent-A-Car company has…

A: A graphical representation of the activity flow within a system, process, or workflow is called an…

Q: and taken to the cashier by the customer. To complete the order, the cashier scans each book with…

A: Below a UML Sequence Diagram for the following book shop checkout system:

Q: draw the er diagram and label

A: To create an ER diagram based on the provided scenario for reserving baseball tickets, here's a…

Q: Write scenario for a borrow book(for student) and design the corresponding Sequence Diagram ( for a…

A: The current scenario here is to draw the sequence diagram for a student to borrow a book from the…

Q: Event-Driven Approach Write a program (in any programming language) to simulate Event-driven…

A: Event-driven programming is a programming paradigm in which the flow of the program is determined by…

Q: Event-Driven Approach Write a program (in any programming language) to simulate Event-driven…

A: Event-driven programming is a programming paradigm in which the flow of the program is determined by…

Q: Draw an ER diagram for the following scenarios:

A: The question asks to create an Entity-Relationship (ER) diagram for a library system at Stanford…

Question

A publishing company produces books on various subjects. The books are written
by authors who specialize in one particular subject. The company employs editors
who, not necessarily being specialists in a particular area, each take sole
responsibility for editing one or more book publications. Every book require some
items for publication. These items supplied by suppliers. One supplier can supply
many items. Shop owner buys books from the publisher. Shop owner can buy
many books but one book can be bought by one shop owner only. Books are
uniquely identified by book ID.
Propose EER diagram to this system?

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

Activity: Interaction Models Consider the university system. Departments offer courses. Professors teach courses. Students can declare majors and are admitted to university departments if they meet minimum requirements. Students and professors have schedules based on courses they take/teach. Courses have rosters, scheduled times, and instructors. Courses may get full. Students can request to sign up for courses, and if the course is not full and they meet pre-requisites, the course is added to their schedule and the course will have them as a student in that course. Students can also drop courses. Students should be informed of the consequences such as change of status from full-time to part-time, loss of scholarships, and delays in graduation. Perform the following: 1. Create a use-case diagram for this university. Make your use-case diagram as complete as you can. 2. Pick two use cases from your use case diagram, CourseAdd and CourseDrop, and describe these use cases in the standard…
Many of Hoosier Burger’s customers work in the downtown area, so Bob and Thelma think a noon delivery service will offer additional convenience to their customers. Until a new system is implemented, the delivery service will be operated manually. Bob envisions the delivery system operating as follows. When a customer calls and places a delivery order, a Hoosier Burger employee records the order on a multiform order ticket. The employee captures such details as customer name, business or home address, phone number, order placement time, items ordered, and amount of sale. The multiform document is sent to the kitchen, where it is separated when the order is ready for delivery. Two copies accompany the order; a third copy is placed in a reconciliation box. When the order is prepared, the delivery person delivers the order to the customer, removes one order ticket from the food bag, collects payment for the order, and returns it to Hoosier Burger. Upon arriving at Hoosier Burger, the…
Draw a diagram for use case for vending machine. 1. Actors: • User: Interacts with the vending machine to make a purchase. • Maintenance Personnel: Responsible for restocking the vending machine and performing maintenance tasks. 2. Use Cases: • Select Product: The user selects a product they want to purchase. • Insert Payment: The user inserts the required payment (e.g., coins, bills, or cards). • Validate Payment: The vending machine verifies the payment provided by the user. • Dispense Product: If the payment is validated, the vending machine dispenses the selected product. • Provide Change: If the user's payment exceeds the product's price, the vending machine provides change. • Refill Stock: Maintenance personnel refills the vending machine with products when they run out. • Perform Maintenance: Maintenance personnel performs routine maintenance tasks on the vending machine. 3. Relationships: • User interacts with the vending machine to perform use cases such as selecting a…
Draw a Use Case Diagram for Patient management system Vic’s hospital has a patient management system. A patient must register with the hospital before start of the treatment. Once registered, a doctor is assigned to the patient. The patient must be provided with an appointment date based on the urgency. A doctor meets the patient and request tests to be performed by labs. When the lab results are ready, a new appointment is set with doctor. Doctor meets the patient again and prescribe medicines and treatments/rehabilitation.
Event-Driven Approach Write a program (in any programming language) to simulate Event-driven approach. inputs: Arrival Times, and Departure times for entities. OR TBAI and STi for entities Output: Time Calculations, System Status, Instructions executed in each iteration needed statistics
Draw an activity diagram that models the following employee reimbursement process: Employees of a university have to follow a specific procedure to get reimbursed for travel they undertake on behalf of the university. First, in order to prepare a reimbursement request, they have to do the following activities at the same time: gather all of the receipts the university requires for reimbursement and complete the official reimbursement form. They then submit both the receipts and the form to their departmental secretary for checking purpose. If something on the form is incorrect, the secretary returns the form to the employee and ask for correction. If the form is correct, the employee is asked to review the reimbursement amounts, which are determined by an analysis of the reimbursement request. If the amount shown is not correct, the employee must indicate that this is the case. If the amount shown is correct, then the employee": responsibilities for reimbursement are complete.
Accounting Information Systems Read carefully the following case:Imagine that you work as an internal auditor for a company that owns several pharmacies throughout the city. Based on your audit plan, the first cycle to audit will be revenue. The first thing you do is document the processes related to receiving and processing the various sources of income. On your initial visit, you were able to observe the following:Once customers have the items to purchase, they head to the register, where a clerk processes the sale. The pharmacy has three cash registers, but does not have an employee who specifically works as a cashier at each one. This provides flexibility in the operation because, of the three employees that the business has, one can collect at any of the cashiers when available. By not having to leave a single person as a cashier, the cashier can focus on providing more direct customer service, refilling merchandise on the shelves, and even assisting in receiving or dispatching…
Fact-Finding Summary• A typical center has 300–500 members, with two membership levels: full and limited.Full members have access to all activities. Limited members are restricted to activitiesthey have selected, but they can participate in other activities by paying a usage fee. Allmembers have charge privileges. Charges for merchandise and services are recorded on acharge slip, which is signed by the member.• At the end of each day, cash sales and charges are entered into the BumbleBee accounting software, which runs on a computer workstation at each location. Daily cash receiptsare deposited in a local bank and credited to the corporate Personal Trainer account. TheBumbleBee program produces a daily activity report with a listing of all sales transactions.• At the end of the month, the local manager uses BumbleBee to transmit an accounts receivable summary to the Personal Trainer headquarters in Chicago, where member statements are prepared and mailed. Members mail their payments to…
Draw an activity diagram for ticket vending process. A vending machine is used to dispense ticket. System will request for trip info and commuter will provide the info such as the destination. System then will process the trip info and request for payment. Commuter then provides payment. System then will analyze whether payment is being made by cash or card. If card been used, it will request for authorize from bank before it dispense the ticket. While if cash been used, it will direct dispense the ticket to commuter. If there is available balance, system will dispense the change to commuter. System then shows the "thank you" message before it ends the session.
Solve the system using Design the Use Case Diagram (contains at least 10 use cases) (Example)
Because a top-down approach is better than a bottom-up one.