New Semester Started Get 50% OFF Study Help! --h --m --s Claim Now

Question Answers

Textbooks

Find textbooks, questions and answers

Oops, something went wrong!

Change your search query and then try again

Result Not Found

Books FREE
Study Help
Tutors
AI Study Planner NEW
Sell Books

Search
Sign In
Register

study help
business
database management systems

Modern Database Management 10th Edition Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman - Solutions

What is attribute inheritance? Why is it important?
Give an example (other than those discussed in the chapter)of a supertype/subtype relationship.
State the reason for entity clustering.
State two conditions that indicate when a database designer should consider using supertype/subtype relationships.
Contrast the following terms:a. supertype; subtypeb. generalization; specializationc. disjoint rule; overlap ruled. total specialization rule; partial specialization rulee. PARTY; PARTY ROLEf. entity; entity cluster
Define each of the following terms:a. supertypeb. subtypec. specializationd. entity clustere. completeness constraintf. enhanced entity-relationship(EER) model g. subtype discriminator h. total specialization rule i. generalization j. disjoint rule k. overlap rule l. partial specialization rule m.
Why do some vendors not supply raw materials to Pine Valley Furniture?
Why do some employees not supervise other employees, and why are they not all supervised by another employee? And, why do some employees not work in a work center?
Why do some customers not do business in one or more sales territories?
Prepare a list of questions that have arisen as a result of your E-R modeling efforts, and that need to be answered to clarify your understanding of Mountain View Community Hospital’s business rules and data requirements.
Develop a list of well-stated business rules for your E-R diagram.
Develop an E-R diagram for Mountain View Community Hospital, based on the enterprise data model you developed in Chapter 1 and the case description, questions, and exercises presented previously. Using the notation described in this chapter, clearly indicate the different types of entities,
Does your answer to Case Exercise 2 allow the same treatment to be performed more than once on the same patient by the same physician? If not, redraw your answer to Case Exercise 2 to accommodate this situation. Make any additional assumptions you consider necessary in order to represent this
Does your answer to Case Exercise 2 allow more than one physician to perform a treatment on a patient at the same time? If not, redraw your answer to Case Exercise 2 to accommodate this situation. Make any additional assumptions you consider necessary to represent this situation.
Consider your new E-R diagram for Case Exercise 4.Now, additionally assume that a care center contains many rooms, and each room may contain items that are billed to patients assigned to that room. Redraw your E-R diagram to accommodate this new assumption.
Suppose the attribute bed number were a composite attribute, composed of care center ID, room number, and individual bed number. Redraw any parts of your answer to Case Exercise 2 that would have to change to handle this composite attribute.
The case describes an entity type called Item. Given your answer to Case Exercise 2, will this entity type also be able to represent in-room TVs as a billable item to patients?Why or why not?
Develop an E-R diagram for Mountain View Community Hospital. State any assumptions you made in developing the diagram. If you have been assigned a particular data modeling tool, redraw your E-R diagram using this tool.
Study the case description very closely. What other questions would you like to ask to understand the data requirements at Mountain View Community Hospital?
What quality check(s) would you perform to determine whether the E-R model you developed can easily satisfy user requests for data and/or information?
Do you think that Items should be split into two separate entities, one for nonreusable and one for reusable items?Why or why not?
When developing an E-R diagram for Mountain View Community Hospital, what is the significance of the business rule that states that some patients are assigned to a bed, but outpatients are not assigned to a bed?
Do there appear to be any of the following in the description of the Mountain View Community Hospital data requirements? If so, what are they?a. weak entitiesb. multivalued attributesc. multiple relationships
Is Mountain View Community Hospital itself an entity type in the data model? Why or why not?
Why would Mountain View Community Hospital want to use E-R modeling to understand its data requirements?What other ways might the hospital want to model its information requirements?
Search on the Internet for products that help document and manage business rules, standards, and procedures. One such site is www.axisboulder.com. Choose a couple tools and summarize their capabilities and discuss how they would be useful in managing business rules.
For the same E-R diagram used in Field Exercise 4 or for a different database in the same or a different organization, identify any uses of time stamping or other means to model time- dependent data. Why are time-dependent data necessary for those who use this database? Would the E-R diagram be
Ask a database or systems analyst in a local company to show you an E-R diagram for one of the organization’s primary databases. Ask questions to be sure you understand what each entity, attribute, and relationship means. Does this organization use the same E-R notation used in this text? If not,
Ask a database or systems analyst to give you examples of unary, binary, and ternary relationships that the analyst has dealt with personally at his or her company. Ask which is most common and why.
Visit two local small businesses, one in the service sector (e.g., dry cleaner, auto repair shop, veterinarian, or bookstore) and one that manufactures tangible goods. Interview employees from these organizations to elicit from them the entities, attributes, and relationships that are commonly
Interview a database analyst or systems analyst and document how he or she decides on names for data objects in data models. Does the organization in which this person works have naming guidelines? If so, describe the pattern used. If there are no guidelines, ask whether your contact has ever had
Review your answer to Problem and Exercise 25; if necessary, change the names of the entities, attributes, and relationships to conform to the naming guidelines presented in this chapter. Then, using the definition guidelines, write a definition for each entity, attribute, and relationship. If
Our friend Wally Los Gatos (see Problem and Exercise 26), realizing that his wallcovering business had a few wrinkles in it, decided to pursue a law degree at night. After graduating, he has teamed up with Lyla El Pàjaro to form Peck and Paw, Attorneys at Law. Wally and Lyla have hired you to
Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers, and employees. After an initial meeting with Wally,
Draw an ERD for the following situation. (State any assumptions you believe you have to make in order to develop a complete diagram.) Also, draw a data model for this situation using the tool you have been told to use in your course: The H. I. Topi School of Business operates international business
Draw an ERD for the following situation. (State any assumptions you believe you have to make in order to develop a complete diagram.) Also, draw a data model for this situation using the tool you have been told to use in your course: Stillwater Antiques buys and sells one-of-akind antiques of all
Draw an ERD for the following situation (Batra et al., 1988).Also, develop the list of words for qualifiers and classes that you use to form attribute names. Explain why you chose the words on your list. Also, draw a data model for this situation using the tool you have been told to use in your
Obtain several common user views such as a credit card receipt, credit card statement, and annual summary, or some other common document from one organization with which you interact.a. Prepare an ERD for one of these documents. Also prepare a data model for this document, using the tool you have
After completing a course in database management, you are asked to develop a preliminary ERD for a symphony orchestra. You discover the following entity types that should be included:During further discussions you discover the following:• A concert season schedules one or more concerts. A
Prepare an ERD for a real estate firm that lists property for sale. Also prepare a definition for each entity type, attribute, and relationship on your diagram. In addition, draw a data model for this situation using the tool you have been told to use in your course. The following describes this
In the chapter, when describing Figure 2-4a, it was argued that the Received and Summarizes relationships and TREASURER entity were not necessary. Within the context of this explanation, this is true. Now, consider a slightly different situation. Suppose it is necessary, for compliance
Each semester, each student must be assigned an adviser who counsels students about degree requirements and helps students register for classes. Each student must register for classes with the help of an adviser, but if the student’s assigned adviser is not available, the student may register
Emerging Electric wishes to create a database with the following entities and attributes:• Customer, with attributes Customer ID, Name, Address(Street, City, State, Zip Code), and Telephone• Location, with attributes Location ID, Address (Street, City, State, Zip Code), and Type (values of
Assume that at Pine Valley Furniture each product(described by product number, description, and cost) comprises at least three components (described by component number, description, and unit of measure), and components are used to make one or many products. In addition, assume that components are
Review Figure 2-8 and Figure 2-22.a. Identify any attributes in Figure 2-22 that might be composite attributes but are not shown that way. Justify your suggestions. Redraw the ERD to reflect any changes you suggest.b. Identify any attributes in Figure 2-22 that might be multivalued attributes but
Modify Figure 2-11a to model the following additional information requirements: The training director decides, for each employee who completes each class, who (what employees) should be notified of the course completion.The training director needs to keep track of which employees are notified about
Figure 2-27 shows two diagrams (A and B), both of which are legitimate ways to represent that a stock has a history of many prices. Which of the two diagrams do you consider a better way to model this situation and why?
Figure 2-26 represents a situation of students who attend and work in schools and who also belong to certain clubs that are located in different schools. Study this diagram carefully to try to discern what business rules are represented.a. You will notice that cardinalities are not included on the
The Is Married To relationship in Figure 2-12a would seem to have an obvious answer in Problem and Exercise 9d—that is, until time plays a role in modeling data. Draw a data model for the PERSON entity type and the Is Married To relationship for each of the following variations by showing the
Add minimum and maximum cardinality notation to each of the following figures, as appropriate:a. Figure 2-5b. Figure 2-10ac. Figure 2-11bd. Figure 2-12 (all parts)e. Figure 2-13cf. Figure 2-14
Figure 2-25 shows a grade report that is mailed to students at the end of each semester. Prepare an ERD reflecting the data contained in the grade report. Assume that each course is taught by one instructor. Also, draw this data model using the tool you have been told to use in the course. Explain
Because Visio does not explicitly show associative entities, it is not clear in Figure 2-22 which entity types are associative.List the associative entities in this figure. Why are there so many associative entities in Figure 2-22?
Are associative entities also weak entities? Why or why not?If yes, is there anything special about their “weakness”?
The entity type STUDENT has the following attributes:Student Name, Address, Phone, Age, Activity, and No of Years. Activity represents some campus-based student activity, and No of Years represents the number of years the student has engaged in this activity. A given student may engage in more than
Consider the two E-R diagrams in Figure 2-24, which represent a database of community service agencies and volunteers in two different cities (A and B). For each of the following three questions, place a check mark under City A, City B, or Can’t Tell for the choice that is the best answer.
You may have been assigned a CASE or a drawing tool to develop conceptual data models. Using this tool, attempt to redraw all the E-R diagrams in this chapter. What difficulties did you encounter? What E-R notations did not translate well to your tool? How did you incorporate the E-R notation that
There is a bulleted list associated with Figure 2-22 that describes the entities and their relationships in Pine Valley Furniture. For each of the 10 points in the list, identify the subset of Figure 2-22 described by that point.
Answer the following questions concerning Figure 2-22:a. Where is a unary relationship, what does it mean, and for what reasons might the cardinalities on it be different in other organizations?b. Why is Includes a one-to many relationship, and why might this ever be different in some other
Why is it recommended that all ternary relationships be converted into an associative entity?
Explain the distinction between entity type and entity instance.
For the Manages relationship in Figure 2-12a, describe one or more situations that would result in different cardinalities on the two ends of this unary relationship. Based on your description for this example, do you think it is always clear simply from an E-R diagram what the business rule is
In addition to explaining what action is being taken, what else should a relationship definition explain?
What are the special guidelines for naming relationships?
State a rule that says when to extract an attribute from one entity type and place it in a linked entity type.
Give an example of the use of effective (or effectivity) dates as attributes of an entity.
Give an example of each of the following, other than those described in this chapter, and clearly explain why your example is this type of relationship and not of some other degree.a. ternary relationshipb. unary relationship
Give an example (other than those described in this chapter)for each of the following, and justify your answer:a. derived attributeb. multivalued attributec. atomic attributed. composite attributee. required attributef. optional attribute
What is the degree of a relationship? List the three types of relationship degrees described in the chapter and give an example of each.
Give an example, other than those described in this chapter, of a weak entity type. Why is it necessary to indicate an identifying relationship?
List the four types of cardinality constraints, and draw an example of each.
State three conditions that suggest the designer should model a relationship as an associative entity type.
Why must some identifiers be composite rather than simple?
State four criteria for selecting identifiers for entities.
State six general guidelines for naming data objects in a data model.
Explain where you can find business rules in an organization.
Give four reasons why a business rules approach is advocated as a new paradigm for specifying information systems requirements.
Give three reasons why many system designers believe that data modeling is the most important part of the systems development process.
Contrast the following terms:a. stored attribute; derived attributeb. simple attribute; composite attributec. entity type; relationship typed. strong entity type; weak entity typee. degree; cardinalityf. required attribute; optional attribute g. composite attribute; multivalued attribute h. ternary
Define each of the following terms:a. entity typeb. entity-relationship modelc. entity instanced. attributee. relationship typef. identifier g. multivalued attribute h. associative entity i. cardinality constraint j. weak entity k. identifying relationship l. derived attribute m. business rule
In what way might Pine Valley change the way it does business that would cause the Supplies associative entity to be eliminated and the relationships around it change?
What is the meaning of the Does Business In associative entity, and why does each Does Business In instance have to be associated with exactly one SALES TERRITORY and one CUSTOMER?
If there were a different customer contact person for each sales territory in which a customer did business, where in the data model would we place this person’s name?
Does Includes allow for a product to be represented in the database before it is assigned to a product line (e.g., while the product is in research and development)?
Why is Includes a one-to many relationship, and why might this ever be different in some other organization?
Where is a unary relationship, what does it mean, and for what reasons might the cardinalities on it be different in other organizations?
On what tier or tiers would you recommend the system and database she needs be developed? Why?
Consider again the request of the manager of risk management from Case Exercise
The manager of the risk management area, Ms. Jamieson, is anxious to receive computerized support for her activities.The hospital is increasingly facing malpractice claims and litigation, and she does not believe she can wait for improved information services until the information systems and
Earlier in this chapter, we showed an SQL query that displays information about computer desks at Pine Valley Furniture Company Following this example, create an SQL query for your PATIENT table that displays information about the outpatients.
Using a DBMS suggested by your instructor, such as Microsoft Access or SQL Server, you may begin to prototype a database for Mountain View Community Hospital. Here are some suggestions to guide you:a. Develop a metadata chart for an EMPLOYEE table similar to Table 1-1.b. What types of relationships
Using the notation introduced in this chapter, draw a single diagram that represents the following relationships in the hospital environment.• A HOSPITAL has on its staff one or more PHYSICIANs. A PHYSICIAN is on the staff of only one HOSPITAL.• A PHYSICIAN may admit one or more PATIENTs. A
One of the important outputs from the “bill patient” business function is the Patient Bill. Following is a highly simplified version of this bill (MVCH Figure 1-5).a. Using the data from MVCH Figure 1-4, add missing data that would typically appear on a patient bill.b. Using your result from
The relational databases at Mountain View Community Hospital contain a number of tables. Two of these tables, with some sample data, are shown in MVCH Figure 1-4.The PATIENT table contains data concerning current or recent patients at the hospital, whereas the PATIENT CHARGES table contains data
The case description lists 10 business rules. The study team used these rules to develop MVCH Figure 1-3. Are there any other business rules implied by or depicted in that figure? What are they?
How could the hospital use Web-based applications? What are some of the benefits and risks associated with Webbased applications for the hospital?
At present, Mountain View Community Hospital is using relational database technology. Although this technology is appropriate for structured data, such as patient or accounting data, it is less well-suited to unstructured data, such as graphical data and images. Can you think of some types of data
How critical are data quality requirements in the hospital environment? For which applications might quality requirements be more restrictive?
What are some of the costs and risks of using databases that the hospital must manage carefully?
How can database technology be used to help Mountain View Community Hospital comply with the security standards of the Health Insurance Portability and Accountability Act of 1996 (HIPAA)? HIPAA requires health-care providers to maintain reasonable and appropriate administrative, technical, and
The goal of Mountain View Community Hospital is to provide high-quality, cost-effective health-care services for the surrounding community in a compassionate, caring, and personalized manner. Give some examples of how the use of databases in the hospital might improve health-care quality or contain

Showing 2300 - 2400 of 3225

First
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Last

Step by Step Answers

Services

Sitemap
Fun
Definitions
Become Tutor
Used Textbooks
Study Help Categories
Recent Questions
Expert Questions
Campus Wear
Sell Your Books

Company Info

Security
Copyrights
Privacy Policy
Terms & Conditions
SolutionInn Fee
Scholarship
Online Quiz
Give Feedback, Get Rewards

Get In Touch

About Us
Contact Us
Career
Jobs
FAQ
Student Discount
Campus Ambassador

Secure Payment

Download Our App

© 2026 SolutionInn. All Rights Reserved