Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 11, Problem 11.22PAE
Program Plan Intro
To determine the type of tools used for drill down online reporting for Fitch wood management and the additional tables that might need to be added to the data mart.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use the ER Diagram shown on Figure 1 to answer question 9:
9. According to the ER diagram on Figure 1, which of the following is true?
A) For each employee, we will keep track of either the employee name or the unique
employee ID.
B) For each department, we will keep track of either the unique department ID or the
department location.
C) Each employee reports to exactly one department. A department may have many
employees reporting to it, but it does not have to have any.
D) None of the above.
Answer:
EmpID
EmpName
EMPLOYEE
Reports To
Figure 1
DeptID
DeptLocation
DEPARTMENT
need diagram
Design an ER schema for prescription monitoring based on the given data:
Patients are defined by an identity number, a first name and a last name, and by a birth-date.
Doctors are defined as well by an identity number, a first name, a last name, and a birth-date, while additionally they will be characterized by a work start date and a specialty.
Pharmaceutical companies will be defined by a name, and a telephone number.
Medicines will be defined by a commercial name, their manufacturer, and their active ingredient.
Pharmacies will be defined by a name, an address and a telephone number.
Each patient has one doctor and each doctor has at least one patient.
A doctor can prescribe certain medicines to his patients.
Each pharmacy sells several medicines, each at a specific price.
Each medicine can be sold by several pharmacies possibly at a different price.
Pharmaceutical companies have contracts with pharmacies.
Each pharmaceutical company may have contracts with several…
I need help building an ERD in Crow's Foot notation with the following (If possible show me any many-many and optional/mandatory relationship) :
Chapter 11 Solutions
Modern Database Management
Ch. 11 - Prob. 11.1RQCh. 11 - Prob. 11.2RQCh. 11 - Prob. 11.3RQCh. 11 - Prob. 11.4RQCh. 11 - Prob. 11.5RQCh. 11 - Prob. 11.6RQCh. 11 - Prob. 11.7RQCh. 11 - Prob. 11.8RQCh. 11 - Prob. 11.9RQCh. 11 - Prob. 11.10RQ
Ch. 11 - Prob. 11.11RQCh. 11 - Prob. 11.12RQCh. 11 - Prob. 11.13RQCh. 11 - Prob. 11.14RQCh. 11 - Prob. 11.15RQCh. 11 - Prob. 11.16RQCh. 11 - Describe the core idea underlying in-database...Ch. 11 - Prob. 11.18RQCh. 11 - Prob. 11.19RQCh. 11 - Prob. 11.20PAECh. 11 - Prob. 11.21PAECh. 11 - Prob. 11.22PAECh. 11 - Prob. 11.23PAECh. 11 - Prob. 11.24PAECh. 11 - Prob. 11.25PAECh. 11 - Prob. 11.26PAECh. 11 - Prob. 11.27PAECh. 11 - Problems and Exercises 11-22 through 11-28 are...Ch. 11 - Prob. 11.29PAECh. 11 - Prob. 11.30PAE
Knowledge Booster
Similar questions
- The ______________ model is a simple but highly useful way to organize data into collections of two-dimensional tables called relations.arrow_forwardWEEK 8 ASSIGNMENT create a star schema for the Bob's Fixit Group Case Study . The star schema needs to support the analysis or measurement of material price by suppliers, date, and jobs. Case Study Bob owns a small company called Bob’s Home repairs. He does the small home repair jobs that the large companies pass by. Need some woodwork or wood furniture fixed? Call Bob. Here is how the business works: Someone calls Bob and asks him to bid on a job. He drives over, looks at the situation, and gives them a bid. Sometimes it is an official looking bid by mail, and sometimes it is scribbled on notebook paper. He decides how long it will take to do the job (he bills by the hour), how much wood will be needed, any odds and ends that are unique to the job, and an overall price. He moves from job to job and bills customers as he finishes the work. Bob buys items and supplies from a variety of places, but he buys stuff only when it is needed for a particular project. A potential problem:…arrow_forwardYou are given an E-R diagram with two entities Orders and Customers. What does the lone between the Customers entity and the Place relationship represent?arrow_forward
- Draw an E-R diagram for the ordering system in Figure 13.24. Based your E-R diagram, draw a data flow diagram.arrow_forwardDRAW AN ER DIAGRAM FOR THE GIVEN SITUATION The video rental company has several branches throughout the USA. The data held on each branch is the branch address made up of street, city, state, and zip code, and the telephone number. Each branch is given a branch number, which is unique throughout the company. Each branch has allocated staff which includes a Manager. The manager is responsible for the day to day running of the given branch. The data held on a member of staff is his or her name, position, and salary. Each member of staff is given a staff number, which is unique throughout the company.Each branch has a stock of videos. The data held on a video is the catalog number, video number, title, category, daily rental, cost status, and the names of the main actors, and the director. The catalog number uniquely identifies each video. However, in most cases, there are several copies of each video at a branch, and the individual copies are identified using the video number. A video…arrow_forwardDraw the ER/EER model for the given scenario. Manufacturer have unique name, an address, and a phone number. Products have a product_id, a name and price. Products may be classified into electronics and grocery. Electronic products have description, type attributes. Groceries have fssai_number, date_of manufacture, date_of_expiry. Each product is made by one manufacturer, and different manufacturers may produce different products.. Customers are identified by their unique social security number. They have email addresses, and physical addresses. Several customers may live at the same (physical) address, but we assume that no two customers have the same email address. An order has a unique order number, and a date. An order is placed by one customer. For each order, there are one or more products ordered, and there is a quantity for each product on the orderarrow_forward
- If wrong would dislike.arrow_forwardTranslate the E-R diagram on page 1 (diagram) to database schema using MySQL Workbench (export as png or pdf). You can ignore the cardinalities on the ternary (Grant) relationship. Interpret the database schema on slide 4. Draw the E-R diagram underlying this schema. No need to draw the attributes.arrow_forwardQuestion: a) Draw the entity relationship diagram for each of the following Scenario. i) The company has over 100 employees. Each employee is identified by their Employee_ID. Other attributes are Employee_Name, EmployeeAddress, and Skills. An employee may have more than one skill. And each skill can be mastered by many employees or none. ii) A customer can submit orders to buy products. Each order is identified by Order_ID, and Order_Date. A customer may submit any number of orders. Each order is submitted by exactly one customer. The identifier for a customer is Customer_ID. Other attributes include Customer_Name and Customer_Addressarrow_forward
- Please create an ERD diagram (do not hand draw) with the provided informationarrow_forwardDraw the Enhanced Entity–Relationship (EER) model and the relational schema for the case study below: This case study describes a company called HomeCinema, which rents out videos to its members. The first branch of HomeCinema was established in 1982 in Jeddah but the company has now grown and has many branches throughout the country. As HomeCinema has grown, so has the difficulties in managing the increasing amount of data used and generated by the company. To ensure the continued success of the company, the Director of HomeCinema has urgently requested that a database application be built to help solve the increasing problems of data management. The data held on a branch of HomeCinema is the branch address made up of street, city, state, and zip code, and the telephone numbers (maximum of 3 lines). Each branch is given a branch number, which is unique throughout the company. Each branch of HomeCinema has staff, which includes a Manager, one or more Supervisors, and a number of other…arrow_forwardI have this system, ERD (Entity-Relationship Diagram) Explanation: The ERD is a high-level representation of the data relationships in the ConfPlus Conference Management System. It shows the main entities, their attributes, and the relationships between them. Entities: User: Represents a user in the system, including authors, reviewers, and organizers. Attributes include UserID, Name, Email, Password, Affiliation, and Role. Paper: Represents an academic paper submitted to the conference. Attributes include PaperID, Title, Abstract, PDF, and SubmissionDate. Authorship: Represents the relationship between a User (author) and a Paper. Attributes include AuthorshipID, UserID, PaperID, and IsPresenter (to indicate if the author is the presenter of the paper). Review: Represents a review assigned to a paper by a User (reviewer). Attributes include ReviewID, UserID, PaperID, OverallEvaluation, Contribution, Strengths, Weaknesses, and ReviewDate. Conference: Represents the conference…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage LearningPrinciples of Information Systems (MindTap Course...Computer ScienceISBN:9781305971776Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
- COMPREHENSIVE MICROSOFT OFFICE 365 EXCEComputer ScienceISBN:9780357392676Author:FREUND, StevenPublisher:CENGAGE L
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
COMPREHENSIVE MICROSOFT OFFICE 365 EXCE
Computer Science
ISBN:9780357392676
Author:FREUND, Steven
Publisher:CENGAGE L