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
S
Books
FREE
Study Help
Expert Questions
Accounting
General Management
Mathematics
Finance
Organizational Behaviour
Law
Physics
Operating System
Management Leadership
Sociology
Programming
Marketing
Database
Computer Network
Economics
Textbooks Solutions
Accounting
Managerial Accounting
Management Leadership
Cost Accounting
Statistics
Business Law
Corporate Finance
Finance
Economics
Auditing
Tutors
Online Tutors
Find a Tutor
Hire a Tutor
Become a Tutor
AI Tutor
AI Study Planner
NEW
Sell Books
Search
Search
Sign In
Register
study help
business
database management systems
Modern Database Management 10th Edition Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman - Solutions
Using Appendix B as a resource, interview a database analyst/designer to determine whether he or she normalizes relations to higher than 3NF. Why or why not does he or she use normal forms beyond 3NF?
Obtain a common document such as a sales slip, customer invoice from an auto repair shop, credit card statement, etc.Use the normalization steps (steps 0 through 4) described in this chapter to convert this user view to a set of relations in third normal form. Also draw a relational schema. List
Interview system designers and database designers at several organizations. Ask them to describe the process they use for logical design. How do they transform their conceptual data models (e.g., E-R diagrams) to relational schema?What is the role of CASE tools in this process? Do they use
The following attributes represent data about a movie copy at a video rental store. Each movie is identified by a movie number and has a title and information about the director and the studio that produced the movie. Each movie has one or several characters, and there is exactly one actor playing
The following attributes form a relation that includes information about individual computers, their vendors, software packages running on the computers, computer users, and user authorizations. Users are authorized to use a specific software package on a specific computer during a specific
Figure 4-38 shows an EER diagram for a university dining service organization that provides dining services to a major university.a. Transform the EER diagram to a set of relations and develop a relational schema.b. Diagram the functional dependencies and determine the normal form for each
How would Problems and Exercises 21 and 22 change if a type of fish could be supplied by multiple suppliers?
For Problem and Exercise 21, draw the ER diagram based on the normalized relations.
A pet store currently uses a legacy flat file system to store all of its information. The owner of the store, Peter Corona, wants to implement a Web-enabled database application.This would enable branch stores to enter data regarding inventory levels, ordering, and so on. Presently, the data for
Examine the set of relations in Figure 4-37. What normal form are these in? How do you know this? If they are in 3NF, convert the relations into an EER diagram. What assumptions did you have to make to answer these questions?
Figure 4-36 includes an EER diagram for a medium-size software vendor. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are in 3NF.
Figure 4-35 includes an EER diagram describing a car racing league. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema). In addition, verify that the resulting relations are in 3NF.
For your answers to Problem and Exercise 16 from Chapter 3, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form.
Figure 4-34 shows an EER diagram for Vacation Property Rentals. This organization rents preferred properties in several states. As shown in the figure, there are two basic types of properties: beach properties and mountain properties.a. Transform the EER diagram to a set of relations and develop a
Table 4-8 shows a portion of a shipment table for a large manufacturing company. Each shipment (identified by Shipment#)uniquely identifies the shipment Origin, Destination, and Distance. The shipment Origin and Destination pair also uniquely identifies the Distance.a. Develop a diagram that shows
The materials manager at Pine Valley Furniture Company maintains a list of suppliers for each of the material items purchased by the company from outside vendors. Table 4-7 shows the essential data required for this application.a. Draw a dependency diagram for this data. You may assume the
The Public Safety office at Millennium College maintains a list of parking tickets issued to vehicles parked illegally on the campus. Table 4-6 shows a portion of this list for the fall semester. (Attribute names are abbreviated to conserve space.)a. Convert this table to a relation in first normal
Transform Figure 2-15b, attribute version, to 3NF relations. Transform Figure 2-15b, relationship version, to 3NF relations. Compare these two sets of 3NF relations with those in Figure 4-10. What observations and conclusions do you reach by comparing these different sets of 3NF relations?
For your answers to the following Problems and Exercises from prior chapters, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form.a. Chapter 3, Problem and Exercise 15b. Chapter 3, Problem and Exercise
Transform the relational schema developed in Problem and Exercise 9 into an EER diagram. State any assumptions that you have made.
Table 4-5 shows a shipping manifest. Your assignment is as follows:a. Draw a relational schema and diagram the functional dependencies in the relation.b. In what normal form is this relation?c. Decompose MANIFEST into a set of 3NF relations.d. Draw a relational schema for your 3NF relations and
Table 4-4 shows a relation called GRADE REPORT for a university. Your assignment is as follows:a. Draw a relational schema and diagram the functional dependencies in the relation.b. In what normal form is this relation?c. Decompose GRADE REPORT into a set of 3NF relations.d. Draw a relational
Table 4-3 (page 196) contains sample data for parts and for vendors who supply those parts. In discussing these data with users, we find that part numbers (but not descriptions)uniquely identify parts and that vendor names uniquely identify vendors.a. Convert this table to a relation (named PART
Figure 4-33 (page 196) shows an EER diagram for a simplified credit card environment. There are two types of card accounts: debit cards and credit cards. Credit card accounts accumulate charges with merchants. Each charge is identified by the date and time of the charge as well as the primary keys
Figure 4-32 shows a class list for Millennium College.Convert this user view to a set of 3NF relations using an enterprise key. Assume the following:• An instructor has a unique location.• A student has a unique major.• A course has a unique title.
For your answers to the following Problems and Exercises from prior chapters, transform the EER diagrams into a set of relational schemas, diagram the functional dependencies, and convert all the relations to third normal form:a. Chapter 2, Problem and Exercise 15bb. Chapter 2, Problem and Exercise
For each of the following relations, indicate the normal form for that relation. If the relation is not in third normal form, decompose it into 3NF relations. Functional dependencies(other than those implied by the primary key) are shown where appropriate.a. CLASS(CourseNo, SectionNo)b.
For each of the following EER diagrams from Chapter 3:I. Transform the diagram into a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema).II. For each relation, diagram the functional dependencies(see Figure 4-23 for an example).III. If
For each of the following E-R diagrams from Chapter 2:I. Transform the diagram to a relational schema that shows referential integrity constraints (see Figure 4-5 for an example of such a schema).II. For each relation, diagram the functional dependencies(see Figure 4-23 for an example).III. If any
Explain three conditions that suggest a surrogate key should be created for the primary key of a relation.
Describe the difference between how a 1:M unary relationship and an M:N unary relationship are implemented in a relational data model.
Explain what can be done with primary keys to eliminate key ripple effects as a database evolves.
Under what conditions must a foreign key not be null?
What is the relationship between the primary key of a relation and the functional dependencies among all attributes within that relation?
How do you represent an associative entity in a relational data model?
How do you represent an M:N ternary relationship in a relational data model?
How do you represent a 1:M unary relationship in a relational data model?
How are relationships between entities represented in the relational data model?
What are the benefits of enforcing the integrity constraints as part of the database design and implementation process(instead of doing it in application design)?
Explain how each of the following types of integrity constraints is enforced in the SQL CREATE TABLE commands:a. entity integrityb. referential integrity
List three conditions that you can apply to determine whether a relation that is in first normal form is also in second normal form.
Briefly describe four typical problems that often arise in merging relations and common techniques for addressing those problems.
What is the primary purpose of normalization?
Describe how the following components of an E-R diagram are transformed into relations:a. regular entity typeb. relationship (1:M)c. relationship (M:N)d. relationship (supertype/subtype)e. multivalued attributef. weak entity g. composite attribute
Describe the primary way in which relationships in an E-R diagram are expressed in a corresponding relational data model.
What is a well-structured relation? Why are well-structured relations important in logical database design?
Fill in the blanks in each of the following statements:a. A relation that has no partial functional dependencies is in _____ normal form.b. A relation that has no transitive dependencies is in _____ normal form.c. A relation that has no multivalued attributes is in _____ normal form.
Describe three types of anomalies that can arise in a table and the negative consequences of each.
Describe two properties that each candidate key must satisfy.
Summarize six important properties of relations.
Describe the primary differences between the conceptual and logical data models.
Contrast the following terms:a. normal form; normalizationb. candidate key; primary keyc. partial dependency; transitive dependencyd. composite key; recursive foreign keye. determinant; candidate keyf. foreign key; primary key g. enterprise key; surrogate key
Define each of the following terms:a. determinantb. functional dependencyc. transitive dependencyd. recursive foreign keye. normalizationf. composite key g. relation h. normal form i. partial functional dependency j. enterprise key k. surrogate primary key
Document and explain the decisions you made during merging.
Following the notation from this chapter, merge your Chapter 2 E-R diagram with the EER diagram you developed for Case Exercises 1 and 2 to represent the data requirements for MVCH’s new system.
Revise the list of business rules you developed in Chapter 2 in light of the information provided in this case segment and your insights from the Case Exercises.
Compare the EER diagram that you developed in this chapter with the E-R diagram you developed in Chapter 2.What are the differences between these two diagrams?Why are there differences?
Derive and clearly state the business rules that are implicit in the volunteer application form shown in MVCH Figure 3-1.
Figure 3-17 shows the following entity types in a universal data model: PARTY, PARTY ROLE, PARTY RELATIONSHIP,EVENT, PRIORITY TYPE, STATUS TYPE, EVENT ROLE, and ROLE TYPE. How would these apply to the MVCH case? Give examples of each entity type based on the information provided in the case
Consult with some member of the hospital or health-care community (if one is available); do some research on the Internet, or otherwise make reasonable assumptions based on your own knowledge and experience.a. Entity typesb. Attributesc. Relationships
Develop definitions for each of the following types of objects in your EER diagram from Case Exercise
Suppose each care center had two nurses-in-charge, one for the day shift, and another one for the evening shift. How would that change the diagram you developed in Case Exercise 1?
Draw an EER diagram to represent the requirements described in this case segment carefully following the notation from this chapter.
Are there any universal data models that can be reused as a starting point for modeling MVCH’s data requirements?Would you recommend using such as model for the MVCH project? Why or why not?
Can you think of any other business rules (other than the one explicitly described in the case) that are likely to be used in a hospital environment? Can these be represented on an EER diagram for MVCH?
Are there any weak entities, multivalued attributes, or multiple relationships in the description of the data requirements in this case segment? If so, what are they?
Is the ability to model supertype/subtype relationships important in a hospital environment such as MVCH? Why or why not?
Research universal data models. Find articles on universal(or packaged, industry, or functional area) data models, or find information on some commercial offerings. Identify common features across these models as well as different ways to model the same concepts. Discuss what you think are the
Read the summary of business rules published by the GUIDE Business Rules Project (1997) and the article by Gottesdiener (1997). Search the Web for additional information on business rules. Then write a three-page executive summary of current directions in business rules and their potential impact
Ask a database administrator or database or system analyst in a local company to show you an EER (or E-R) diagram for one of the organization’s primary databases. Does this organization model have supertype/subtype relationships?If so, what notation is used, and does the CASE tool the company
Visit two local small businesses, one in the service sector and one in manufacturing. Interview employees from these organizations to obtain examples of both supertype/subtype relationships and business rules (such as “A customer can return merchandise only with a valid sales slip”). In which
Interview a friend or family member to elicit common examples of supertype/subtype relationships they may come into contact with at work. You will have to explain the meaning of this term to the person you are interviewing and provide a common example, such as PROPERTY: RESIDENTIAL, COMMERCIAL or
Add the following to Figure 3-16: an EMPLOYMENT party relationship is further explained by the positions and assignments to positions during the time a person is employed. A position is defined by an organization unit, and a unit may define many positions over time. Over time, positions are
Draw an EER diagram for the following situation:TomKat Entertainment is a chain of theaters owned by former husband and wife actors/entertainers who, for some reason, can’t get a job performing anymore. The owners want a database to track what is playing or has played on each screen in each
You are working for a large country club. This country club wants to keep a database on its members and their guests. For each member, the club keeps mail and telephone contact information, name, and membership number. When you join this club, you can join as a social member (which allows you two
Based on the EER diagram constructed for Problem and Exercise 17, develop a sample definition for each entity type, attribute, and relationship in the diagram.
Draw an EER diagram for the following description of a law firm:Each case handled by the firm has a unique case number; a date opened, date closed, and judgment description are also kept on each case. A case is brought by one or more plaintiffs, and the same plaintiff may be involved in many cases.
Develop an EER model for the following situation, using the traditional EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor:A person may be employed by one or more organizations, and each organization may be the employer of one or more
Add a subtype discriminator (named Person Type) to the diagram you created in Problem and Exercise 12.
Refer to your answer to Problem and Exercise 23 in Chapter 2.Develop entity clusters for this E-R diagram and redraw the diagram using the entity clusters. Explain why you chose the entity clusters you used.
Refer to your answer to Problem and Exercise 20 in Chapter 2.Develop entity clusters for this E-R diagram and redraw the diagram using the entity clusters. Explain why you chose the entity clusters you used.
A bank has three types of accounts: checking, savings, and loan. Following are the attributes for each type of account:CHECKING: Acct No, Date Opened, Balance, Service Charge SAVINGS: Acct No, Date Opened, Balance, Interest Rate LOAN: Acct No, Date Opened, Balance, Interest Rate, Payment Assume
At a weekend retreat, the entity type PERSON has three subtypes: CAMPER, BIKER, and RUNNER. Draw a separate EER diagram segment for each of the following situations:a. At a given time, a person must be exactly one of these subtypes.b. A person may or may not be one of these subtypes.However, a
A rental car agency classifies the vehicles it rents into four categories: compact, midsize, full-size, and sport utility. The agency wants to record the following data for all vehicles:Vehicle ID, Make, Model, Year, and Color. There are no unique attributes for any of the four classes of vehicle.
Figure 3-13 shows the development of entity clusters for the Pine Valley Furniture E-R diagram. In Figure 3-13b, explain the following:a. Why is the minimum cardinality next to the DOES BUSINESS IN associative entity coming from CUSTOMER zero?b. What would be the attributes of ITEM (refer to Figure
Refer to the EER diagram for patients in Figure 3-3. Make any assumptions you believe are necessary. Develop sample definitions for each entity type, attribute, and relationship in the diagram.
Refer to the employee EER diagram in Figure 3-2. Make any assumptions that you believe are necessary. Develop a sample definition for each entity type, attribute, and relationship in the diagram.
For simplicity, subtype discriminators were left off many figures in this chapter. Add subtype discriminator notation in each figure listed below. If necessary, create a new attribute for the discriminator.a. Figure 3-2b. Figure 3-3c. Figure 3-4bd. Figure 3-7ae. Figure 3-7b
Add a subtype discriminator for each of the supertypes shown in Figure 3-10. Show the discriminator values that assign instances to each subtype. Use the following subtype discriminator names and values:a. PERSON: Person Type (Employee? Alumnus?Student?)b. EMPLOYEE: Employee Type (Faculty, Staff)c.
Examine the hierarchy for the university EER diagram(Figure 3-10). As a student, you are an instance of one of the subtypes: either UNDERGRAD STUDENT or GRADUATE STUDENT. List the names of all the attributes that apply to you. For each attribute, record the data value that applies to you.
When is a member of a supertype always a member of at least one subtype?
When might a supertype/subtype hierarchy be useful?
What do you purchase when you acquire a packaged data model?
Does a data modeling project using a packaged data model require less or greater skill than a project not using a packaged data model? Why or why not?
How can data profiling be used during a data modeling project, especially one using a packaged data model?
In what ways is starting a data modeling project with a packaged data model different from starting a data modeling project with a clean sheet of paper?
When would a packaged data model be useful?
What is the purpose of a subtype discriminator?
What types of business rules are normally captured in an EER diagram?
Give an example of each of the following:a. a supertype/subtype relationship where the disjoint rule appliesb. a supertype/subtype relationship where the overlap rule applies
Showing 2200 - 2300
of 3225
First
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
Last
Step by Step Answers