entity relationship model of this problem please - diagram thanks for help !! We need to develop a management system for information that supports some of the services involved in an online bookstore (type Amazon.com). The bookstore has customers registered to sell books, it also contains information on the publishers, the publisher has a name, address, phone and URL and publishes several books, but a book can only be published by one publisher and a customer can place the book they want to buy in a cart and can have multiple shopping carts, each cart of purchase belongs to a customer and can contain multiple books, a client has an email, name, phone and address. A book has ISBN, year, title and price, an author has name and direction and can write multiple books. Books can be written by a single author and are stored in many warehouses and a warehouse has many books.

entity relationship model of this problem please - diagram thanks for help !! We need to develop a management system for information that supports some of the services involved in an online bookstore (type Amazon.com). The bookstore has customers registered to sell books, it also contains information on the publishers, the publisher has a name, address, phone and URL and publishes several books, but a book can only be published by one publisher and a customer can place the book they want to buy in a cart and can have multiple shopping carts, each cart of purchase belongs to a customer and can contain multiple books, a client has an email, name, phone and address. A book has ISBN, year, title and price, an author has name and direction and can write multiple books. Books can be written by a single author and are stored in many warehouses and a warehouse has many books.

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 4RQ

See similar textbooks

Similar questions

Read the following scenario and draw a data flow logical diagram that includes both the context diagram and the '0' level diagram (0 diagram) on a piece of paper, take a clear picture and upload it as the solution to this question. ABC Video Shop plans to develop a video rental system. This system allows Video Shop employees to enter and store details of all videos / movies in the video file. The system enables members to enter required videos / movies and rent videos / movies, if available in store. All the videos / movie rental details will be stored in the rental file. Then the system calculates the invoice amount for the rental video / movies and sends the invoice amount details to print the invoice / receipt. Now the system will print the invoice and issue it to the member, and the members will pay the invoice amount and settle the transactions.
(Enhanced) Entity Relationship Diagramming LVS, Inc. – a local video store – keeps information on employees, customers, inventory (videos), and rentals. There are two types of employees at the video store, managers and clerks. The following information is needed about all employees (EmpID, Birth Date, Address (Street, City, State, and Zip), and Hire Date). Additionally Managers are paid a yearly Salary and have a Job Level. Clerks have an Hourly Rate and the store would like to know if they have a High School Degree or not. An employee must be a manager or a clerk, not both. Only clerks can rent videos. The video store would like to keep the following information about its customers: A unique CustomerID, Name (First and Last), Phone, and Email. Assume that there are no dependent accounts. The Inventory of the video store is Video Cassettes (VHS) and Digital Video Discs (DVD). Inventory information needed is: a unique ID, Title, Copy Number, Length, and Type (vhs or dvd). Each…
Create an Entity-Relationship (E-R) model for a new company that recently started a business where they buy highly discounted items in bulk from different companies who are going out of business or need to get rid of additional items to save warehouse space. This new company has retail stores in big cities across the country where they sell the items to individuals. They also do business as wholesalers where they sell items in bulk to local retailers in small cities. Therefore, they have two types of customers: individuals and small retailers. The company has four departments: purchase, warehouse, sales (retail and wholesale) and accounting. They employ five different types of employees: managers, accounting staffs, warehouse staffs, retail associates, and purchase agents. Each staff, agent and associate works under a manager of the respective department. Purchase agents hunt for discount items, and they get a commission based on the items they are successfully able to buy. You have…
It is requested to draw an entity relationship diagram (ERD) for a hospital management system.Information about the subject are given below.• The patients contain ID, name, and surname. Doctors have name, surname, and department.Rooms have number and capacity.• Each doctor may supervise zero or more patients.• Each patient should be supervised by one doctor.• Each room may host zero or more patients.• Each patient should be hosted in one room.
Page of 2 ZOOM Draw an EER diagram to represent the following situation: When appropriate, model an associative entity. A rental property would like to store information about TENANT, DEPENDENTs and Payment. The property would like to store information about Tenant: Unique Tenant Id, Tenant Name(first and last) , Address(Street, City, State) , Phonenumbers (country, Area, local), Email Address and House Type. A housetype can be a Townhouse, Apartment or Individual house. For a Apartment, we will store Unique Apart number, number of rooms; for an Individual house, we will store Unique House number, size of house. We will not store any additional information about Townhouse. Dependents are depended on the tenants. Dependent can be uniquely identified by their name. For PAYMENTs, the following information will be stored: a unique payment id, the Bank name associated with the form of payment used, and the account holder name. There are three different…
Develop an activity diagram based on the following narrative. Note any ambiguities or questions that you have as you develop the model. If you need to make assumptions, also note them. The purpose of the Open Access Insurance System is to provide automotive insurance to car owners. Initially, prospective customers fill out an insurance application, which provides information about the customer and his or her vehicles. This information is sent to an agent, who sends it to various insurance companies to get quotes for insurance. When the responses return, the agent then determines the best policy for the type and level of coverage desired and gives the customer a copy of the insurance policy proposal and quote.
Draw an ER Diagram for the following Business Situation: A bank has a phone call system in which the costumer can call and talk to one employee and inquire of their existing account. Costumer can have two type of accounts, checking account or savings account, client can own both type of accounts. One of the assumptions which is being made with this project is all interactions will be over the phone. Clients would call in to the business’ account representatives who will have to search the client in internal database. Once the client has been searched in the database, representative will go forth and verify the client via personal information displayed through the database. Personal Information would include, full name, address, last 4 of social security, and account number. The project will assume that the business is domestic, and all clients are in the United States. Once the client is verified, representative can discuss business related queries, including transactional questions…
Computer Science You are appointed as web developer to develop a system to support organizing different types of seminars including students' seminars, faculty seminars, instructors' seminars, and employees seminars. You will design and develop a seminar management system for KOI that allows seminar organizers to create seminars and registrations. The application should store seminar details, organizer details for each seminar, attendee details and their seminar registration. Specific requirements: Model Design Requirements: o Design your own entity relationship diagram (ERD) for the classes based on your understanding about complex entity relationships including one-to-one, one-to-many, and many-to-many relationships. Please make ER diagram in computer. Thanks
Create an Activity Diagram for the “Order Item(s)” or “Purchase Item(s)” use case (or chain of use cases). The name that you have given this Use Case or group of Use Cases may differ, but it should be quite a comprehensive Use Case(s) that should encapsulate the following: Customers buying non-prescription items. Customers buying prescription items. Customers buying any number of items at once (i.e. 1 or more). Order fulfillment by warehouse staff. Order fulfillment by pharmacists. This Use Case does NOT need to encapsulate: Customers browsing or searching for items. Customers logging into or creating accounts. Customer payment.Attached will be more information on the Pharm@Home System
Draw EER diagram based on these business rules Customers can only make a reservation for themself and their invited guests. A customer may not make a reservation for other people including such as reselling rooms. A customer cannot use Park Hyatt website to reserve room related to any commercial activity. A customer need to provide the ID card or passport. A customer must check-in after 4 p.m. A customer must check-out before 12 p.m. A customer may select room before do the reservation. A customer can do online payment by credit card or pay while during check-in. A staff must check the customer ID card or passport.
(1) Draw a sequence diagram for the “Apply for Leave” use case: Employers need to login into thesystem using correct username and password, input the start and end date of the asking for leave,and then submit the request to the leader of the department. The leader approve the request or not. Ifthe leader approve the request, the request will be submitted to the HR to process. HR will decidewhether to approve the request according to the regulation of the company, and then send the finaldecision to employers and Accounting staffs. (2) Build an activity diagram to describe the “Apply for Leave” in question (1).
Design an E/R Diagram for an online video rental company The company has data about movies, customers, rentals, reviewers, reviews. A Movie has a Title (key), Year, and Duration. A Customer has Name, Email (key), and Credit. Customers rent movies; customers may rent many movies, and a movie may be rented by many customers; each Rental has a Date. A Reviewer is a Customer, and has a Reputation attribute A Review has a Rating, a Date, and Text (content). Each review is uniquely identified by the movie it is reviewing, and by the reviewer who wrote it.