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 13th Global Edition Jeff Hoffer, Ramesh Venkataraman, Heikki Topi - Solutions
Suggest four steps to represent super/subtype relationships.
How do you represent a 1:M unary relationship in a 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 the three steps to remove transitive dependencies.
Discuss how transitive dependencies in a relation can be removed when it leads to anomalies.
Outline a shortcut to describe relations in 3NF.
What do you understand by domain constraint?
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
Does normalization place any constraint on the storage of data in physical form or on its processing performance?Explain.
List four reasons why an instance of a relational schema should be created with sample data.
Briefly outline the seven steps of transforming an EER diagram into the associated relations.
Demonstrate each of the anomaly types with an example.
Describe three types of anomalies that can arise in a table and the negative consequences of each.
What is a schema? Discuss two common methods of expressing a schema.
List the three components of a relational data model.
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. natural primary key; surrogate primary key h. enterprise key;
Match the following terms to the appropriate definitions:well-structured relation anomaly functional dependency determinant composite key 1NF 2NF 3NF recursive foreign key relation transitive dependencya. constraint between two attributesb. functional dependency between the primary key and a nonkey
Define each of the following terms:a. determinantb. functional dependencyc. transitive dependencyd. recursive foreign keye. normalizationf. composite key g. candidate key h. normal form i. partial functional dependency j. enterprise key k. surrogate primary key
Create a plan for reviewing your deliverables with the appropriate stakeholders. Which stakeholders should you meet with? Would you conduct the reviews separately or together? Who do you think should sign off on your EER model before you move to the next phase of the project?
Use the narratives in Chapter 1 and above to identify the typical outputs (reports and displays) the various stakeholders might want to retrieve from your database.Now, revisit the EER diagram you created in 3-45 to ensure that your model has captured the information necessary to generate the
Document your thought process around what changes you made to the model developed in Chapter 2, 2-60, to accommodate the new information. Pay particular attention to what changes you had to make to the original model to accommodate the need for supertype/subtype relationships that emerged from the
Create an EER diagram for FAME that extends the E-R diagram you developed in Chapter 2, 2-60, but accommodates the information gleaned from the e-mails from Pat Smith and Shannon Howard.
Interview a DB analyst or systems administrator in your university or at a local company that has adopted a packaged data model. Discuss how they adopted the model.What was the process of customization or mapping involved? Was the process complex? What challenges did they face during customization?
There are other extensions to ER notation than just supertype/subtype relationships. Use the Internet to search for such extensions. One mentioned in the text is aggregation. Look for its examples on the Internet.Report your findings and state the extensions, what they are intended for, some
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 your local library and observe the library users and librarians at work. Ask a librarian how the library records and stores its information about its borrowers, books, and loans. Based on this information, determine whether the library’s business rules and which of this chapter’s concepts
Observe the kind of people who work in your college or university. Interview an official who collects data on these people. Ask about the attributes on which data is collected. Is there a supertype/subtype relationship in this scenario? Apply generalization/specialization rules to construct an ER
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 assigned
Draw an EER diagram for the following problem: A university is looking to more effectively manage lecture and student appointments. It is currently unable to determine how much time lecturers are devoting to student appointments and consultation and would therefore like a system through which this
Refer to your answer to Problem and Exercise 2-51 in Chapter 2. The description for DocIT explained that there were to be data in the database about people who are not patients but are related to patients. Also, it is possible for some staff members to be patients or to be related to patients. And,
Based on the EER diagram constructed for Problem and Exercise 3-34, develop a sample definition for each entity type, attribute, and relationship in the diagram.
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:Wally Los Gatos and his partner Henry Chordate have formed a new limited partnership, Fin and Finicky Security
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:An international school of technology has hired you to create a database management system to assist in scheduling
Draw an EER diagram for the following problem:AmazingMemories, a travel agency, specializes in holidays to Southeast Asia. It provides bespoke holidays that are set up and handled by an agency rep. Each rep creates a new booking, which has an ID, hotel, hotel room, check-in dates, and number of
Draw an EER diagram for the following problem:MoneyBags Bank customers can access over 10,000 ATMs worldwide. These are a combination of the Bank’s own machines and those provided through the Visa network.Customers using the Bank’s own machines can check their balance and withdraw money in
Draw an EER diagram for the following problem: A company posts job openings online. Job seekers must apply for these jobs online as well. The company will process the applications and call eligible job seekers for an interview. Upon successful completion of the interview, a job seeker may be hired,
Draw an EER diagram for the following problem using this text’s EER notation, the Visio notation, or the subtypes inside supertypes notation, as specified by your instructor:In a typical university, people occupy one or more roles.There are students, either undergraduates or postgraduates, each
Refer to your answer to Problem and Exercise 3-24.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 2-44 in Chapter 2. Develop entity clusters for the final version of this E-R diagram and redraw the diagram using the entity clusters. Explain why you chose the entity clusters you used.
An institute’s students participate in three types of sports events: long jump, discus throw, and the 100-meter race.The following attributes are recorded for each event:Long Jump: Student Roll Number, Name, House, Age, Recorded Jump Discus Throw: Student Roll Number, Name, House, Age, Distance
An electronics goods store has devices such as mobile phones, laptops, televisions, and refrigerators for sale.a. Is it possible to apply a supertype/subtype hierarchy to this situation? How?b. Construct an EER diagram. Which specialization rule(completeness constraint) does it satisfy?c. In which
Refer to Problem and Exercise 2-44 in Chapter 2, Part f.Redraw the ERD for your answer to this exercise using appropriate supertypes and subtypes.
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,
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?
In Figure 3-5b, why must the minimum cardinality next to SUPPLIES from PURCHASED PART be one yet the minimum cardinality next to SUPPLIES from SUPPLIER may be zero?
Discuss how it is decided which subtype will be inserted with a new instance of a supertype.
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?
Purchasing a packaged data model involves mapping.What is mapping? What are the points you need to consider in mapping?
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?
How are the attributes assigned in a supertype/subtype hierarchy?
Give an example of generalization not discussed in the text.
What types of business rules are normally captured in an EER diagram?
What is a completeness constraint, and what are the total and partial specialization rules?
What is attribute inheritance? Why is it important?
Explain how specialization and generalization assist in the development of supertype/subtype relationships.
Explain the need for EER modeling.
Discuss the notations used to represent EER models.Which notation is the most widely used?
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
Match the following terms and definitions:supertype entity cluster subtype specialization subtype discriminator attribute inheritance generalizationa. subset of supertypeb. creating a supertype for entity typesc. subtype gets supertype attributesd. generalized entity typee. creating subtypes for an
Define each of the following terms:a. supertypeb. subtypec. specializationd. entity clustere. completeness constraintf. enhanced entity-relationship (EER) model g. supertype/subtype hierarchy h. total specialization rule i. generalization j. disjoint rule k. overlap rule l. partial specialization
Prepare a list of questions that you have as a result of your E-R modeling efforts and that need to be answered to clarify your understanding of FAME’s business rules and data requirements.
Use the narratives in Chapter 1 and above to identify the typical outputs (reports and displays) the various stakeholders might want to retrieve from your database. Now, revisit the E-R diagram you created in 2-60 to ensure that your model has captured the information necessary to generate the
Create an E-R diagram for FAME based on the enterprise data model you developed in 1-60. Clearly state any assumptions you made in developing the diagram.
Redo the enterprise data model you created in Chapter 1 to accommodate the information gleaned from Alex Martin’s, Dale Dylan’s, and Sandy Wallis’s e-mails.
Research various graphics and drawing packages, such as Microsoft Office and SmartDraw, and compare the E-R diagramming capabilities of each. Is each package capable of using the notation found in this text? Is it possible to draw a ternary or higher-order relationship with each package?
For the same E-R diagram used in Field Exercise 2-56 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. Ask them if they ever model weak or dependent entities and, if so, what they use for the identifier
Interview a database analyst or a systems analyst. How do they extract business rules for ER modeling? Ask for specific sources. Are they all listed in the text? Did they purchase an ER model and customize it or design it on their own? How did they decide on naming entity types? Ask the analyst or
Interview a database analyst and ask how they go about identifying business rules in the data modeling process.How do they decide to document what business rules they will gather, utilize, manage, and consider while developing an E-R model? How do they decide what falls under the scope of business
Review your answer to Problem and Exercise 2-49; 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
Doctors Information Technology (DocIT) is an IT services company supporting medical practices with a variety of computer technologies to make medical offices more efficient and less costly to run. Medical offices are rapidly becoming automated with electronic medical records, automated insurance
Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, Etc., has hired you as a consultant to design a database management system for his new online marketplace for wallpaper, draperies, and home decorating accessories. He would like to track sales, prospective sales, and customers.
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 A. M. Honka School of Business operates international
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 oneof-a-kind antiques of all
Draw an ERD diagram for the following situation: The Sensing Building Company (SBC) installs wireless microsensors throughout buildings and building campuses to give building managers, maintenance personnel, and others real-time data about the status of almost any part of a building. Sensors can be
Draw an ERD for the following situation, which is based on Lapowsky (2016): The Miami-Dade County, Florida, court system believes that jail populations can be reduced, reincarceration rates lowered, and court system costs lessened and, most important, that better outcomes can occur for people in
After completing a course in database management, you are asked to develop a preliminary ERD for a gym database. The entity types that should be included are as shown in Table 2-3. During further discussions you discover the following:• The employees can be staff or trainers. The Employee type
Virtual Campus (VC) is a social media firm that specializes in creating virtual meeting places for students, faculty, staff, and others associated with different college campuses. VC was started as a student project in a database class at Cyber University, an online polytechnic college, with
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 purposes
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
The management department at Scholars University holds workshops annually in collaboration with two other universities.The department wishes to create a database with the following entities and attributes:• Faculty delivering the workshop: FacultyID, Name, Email, Address (street, city, state, zip
Star Hoist is owned by Darth and his wife Ella Vader. The company has had its ups and downs since Darth and Ella built it from the ground up several years ago. The company had some initial difficulties when Darth’s brother, Tacksi, was their accountant and got in trouble with the IRS. Finally,
Draw an ERD for each of the following situations. (If you believe that you need to make additional assumptions, clearly state them for each situation.) Draw the same situation using the tool you have been told to use in the course.a. A company has a number of employees. The attributes of EMPLOYEE
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-11b to model the following additional information requirements: The training director decides for each employee who completes each class, what course, if any, that employee should take next. The training director needs to keep track of a suggested date by when the employee should
Figure 2-28 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-27 represents members of a library issuing books and returning them to the library. The members can be students, staff, or faculty, and their details are stored in the Member entity. A member can issue no more than 10 books. All the details on books are stored in the Books entity.a. State
The Is Married To relationship in Figure 2-12a would seem to have an obvious answer in Problem and Exercise 2-33d—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-12 (all parts)d. Figure 2-13ce. Figure 2-14
Figure 2-26 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?
Consider this situation: The faculty at a university (FACULTY entity) can also be part of Board of Studies (BOARD entity). Is there a weak entity here? Why?
Showing 1400 - 1500
of 3225
First
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Last
Step by Step Answers