Modern Database Management (12th Edition)
12th Edition
ISBN: 9780133544619
Author: Jeffrey A. Hoffer, Ramesh Venkataraman, Heikki Topi
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Question
Chapter 11, Problem 11.39PAE
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
Study the details below and create ERD diagram for each question below.
Drone / Video: a Drone may take many Videos; a Video is taken by one Drone.
A Video instance is optional for a Drone; a Drone instance is required for a Video.
A Facility may be recorded by many Videos; a Video records one Facility.
A Video instance is optional for a Facility; a Facility instance is required for a Video.
A Video may be the basis of many Analyses; an Analysis is based on one Video.
An Analysis instance is optional for a Video; a Video instance is required for an Analysis
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…
Chapter 11 Solutions
Modern Database Management (12th Edition)
Ch. 11 - Prob. 11.1RQCh. 11 - Prob. 11.2RQCh. 11 - Prob. 11.3RQCh. 11 - Prob. 11.4RQCh. 11 - Prob. 11.5RQCh. 11 - What are the two main categories of technologies...Ch. 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 - Prob. 11.17RQCh. 11 - Prob. 11.18RQCh. 11 - Prob. 11.19RQCh. 11 - Prob. 11.20RQCh. 11 - Prob. 11.21RQCh. 11 - Prob. 11.22RQCh. 11 - Prob. 11.23RQCh. 11 - Prob. 11.24RQCh. 11 - Prob. 11.25RQCh. 11 - Prob. 11.26RQCh. 11 - Prob. 11.27RQCh. 11 - Prob. 11.28RQCh. 11 - Describe the core idea underlying in-database...Ch. 11 - Prob. 11.30RQCh. 11 - Prob. 11.31RQCh. 11 - Prob. 11.32PAECh. 11 - Prob. 11.33PAECh. 11 - Prob. 11.34PAECh. 11 - Prob. 11.35PAECh. 11 - Prob. 11.36PAECh. 11 - Prob. 11.37PAECh. 11 - Prob. 11.38PAECh. 11 - Prob. 11.39PAECh. 11 - Prob. 11.40PAECh. 11 - Prob. 11.41PAECh. 11 - Prob. 11.42PAECh. 11 - Prob. 11.43PAECh. 11 - Prob. 11.44PAECh. 11 - Problems and Exercises 11-22 through 11-28 are...Ch. 11 - Prob. 11.46PAECh. 11 - Prob. 11.47PAE
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_forwarddraw an er diagram with rhe informtion provided. Entities: Beach Coffee Carts Coffee Shops Products (Iced coffee, flavors, creamers, breakfast items, etc.) Sales Supplies Warehouse Employees Attributes could include: For Beach Coffee Carts and Coffee Shops: Location, Street, Shop Name, etc. For Products: Product ID, Name, Type, Price, etc. For Sales: Transaction ID, Date and Time, Product(s) Sold, Quantity, Employee ID, etc. For Supplies: Supply ID, Name, Quantity, Location, Supplier, etc. For Warehouse: Warehouse ID, Location, Storage capacity, etc. For Employees: Employee ID, Name, Role, Sales Performance, etc. Relationships Beach Coffee Carts and Coffee Shops have a "Location" relationship with Sales. Products are sold in Sales transactions. Supplies are stored in the Warehouse. Employees have a "Role" relationship with the type of work they do. Employees are associated with Sales transactionsarrow_forwardGiven the following ERD. ID name salary Instructor Grades teaches ID name salary Student 1) What is the descriptive attribute of the relationship between instructor and student? 2) Is this relationship a one-to-one, a one-to-many, or a many-to-many relationship?arrow_forward
- 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) :arrow_forwardCreate an ER model to represent the data used by the library.The library provides books to borrowers. Each book is described by title, edition, and year of publication, and is uniquely identified using the ISBN. Each borrower is described by his or her name and address and is uniquely identified using a borrower number. The library provides one or more copies of each book and each copy is uniquely identified using a copy number, status indicating if the book is available for loan, and the allowable loan period for a given copy. A borrower may loan one or many books, and the date each book is loaned out and is returned is recorded. Loan number uniquely identifies each book loan.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_forward
- PLZ help with the following: Create a Crow’s Foot ERD. Draw YOUR entity relationship diagram (ERD) to indicate entities, relationships, connectives, and resolve M:N relationships. For the following: The faculty and students (we refer to them in our system as clients) can electronically check out any book at any time. A book must have at least one author but can have more authors. An author must have written at least one book or more to be included in the system. A book may have neverbeen checked out, but can be checked out many times by the same client or different clients over time. A client may have never checked out a book or they may have checked out many books over time. To simplify determining which client currently has a given book checked out, a M:N relationship between BOOK and CLIENT should be maintained. The information recorded for each book is book number, book title, book subject, and year of publication. For each author, the library records the author ID,…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_forwardDefine the terms "entity," "attribute," and "relationship" in the context of entity-relationship diagrams (ERDs). How are they used in data modeling?arrow_forward
- Define the terms "entity," "attribute," and "relationship" in the context of data modeling. How are these concepts used in entity-relationship diagrams (ERDs)?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_forwardIf wrong would dislike.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