EBK MODERN DATABASE MANAGEMENT,
13th Edition
ISBN: 9780134792279
Author: TOPI
Publisher: YUZU
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
A derived attribute can be stored in a table or calculated on each occasion that it is required. An example of a derived attribute is your Grade Point Average which is calculated by adding together a score for each unit (e.g., HD=4, D=3, C=2, P=1, N=0) and dividing that by the number of units you have completed. Explain how the decision as to whether the Grade Point Average would be stored in a table or calculated would be made.
You are administering a database in a large retail company that records sales at each of the company’s stores. Tuning the database to improve performance by adding indexes and optimising query execution is an important ongoing aspect of the physical database design.
Which attributes in a database such as this (apart from the primary key) are likely to BENEFIT from being indexed?
Which attributes would you generally avoid indexing, and why?
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
EBK 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_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
- Create 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_forwardMultiplicity is the same as what concept for an ERD? a. Relationship b. Attribute c. Entity d. Cardinalityarrow_forwardDefine the terms "entity," "attribute," and "relationship" in the context of entity-relationship diagrams (ERDs). How are they used in data modeling?arrow_forward
- WEEK 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_forwardDefine the terms "entity," "attribute," and "relationship" in the context of data modeling. How are these concepts used in entity-relationship diagrams (ERDs)?arrow_forward
- When building a data model, why is it sometimes preferable to leave out certain information?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
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