Modern Database Management
13th Edition
ISBN: 9780134773650
Author: Hoffer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 3.29PAE
Program Plan Intro
An ERR diagram, the Visio notation or the subtypes inside supertypes notation.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
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. A nonprofit organization depends on a number of different types of persons for its successful operation. The organization is interested in the following attributes for all of these persons: SSN, Name, Address, City /State/Zip, and Telephone. Three types of persons are of greatest interest: employees, volunteers, and donors. Employees have only a Date Hired attribute, and volunteers have only a Skill attribute. Donors have only a relationship (named Donates) with an Iten1 entity type. A donor must have donated one or more items, and an item may have no donors or one or more donors. There are persons other than employees, volunteers, and donors who are of interest to the organization so that a person need not belong to any of these three groups. On the other hand, at a given time a person may belong to two or more…
Would you look if i got ER diagram right ?
I am asked to design a conceptual data model using ER /EER diagramming for the business functions of a group of dental offices from the natural language description given below. Be sure to consider the cardinality of, and participation in, each relationship. Also, be sure to identify all key attributes. Document any assumptions you make due to the imprecise nature of the problem specification.
"Each office employs one or more dentists, hygienists, and receptionists each of whom have an employee number. Patients are free to use any dental office but, naturally, must make appointments in advance. A record of all such appointments is kept which specifies the patient’s name, the date and time of the appointment and a list of services performed. Adult patients have a SIN (Social Insurance Number) but their children typically do not. Each office provides specific services (e.g. cleaning, filling, X-rays, extraction, etc.) to the patients and bills…
B. Draw a data model for the following entities, considering the entities as representing a system for a patient billing system and including only the attributes that would be appropriate for this context:
Patient (age, name, hobbies, blood type, occupation, insurance carrier, address, phone)
Insurance carrier (name, number of patients on a plan, address, contact name, phone)
Doctor (specialty, provider identification number, golf handicap, age, phone, name)
Chapter 3 Solutions
Modern Database Management
Ch. 3 - Define each of the following terms: supertype...Ch. 3 - Match the following terms and definitions:...Ch. 3 - Contrast the following terms: supertype; subtype...Ch. 3 - State two conditions that indicate when a database...Ch. 3 - Prob. 3.5RQCh. 3 - Give an example (other than those discussed in the...Ch. 3 - What is the attribute inheritance? Why is it...Ch. 3 - Give an example of each of the following: a...Ch. 3 - What types of business rules are normally captured...Ch. 3 - What is the purpose of a subtype discriminator?
Ch. 3 - Prob. 3.11RQCh. 3 - In what ways is starting a data modeling project...Ch. 3 - Prob. 3.13RQCh. 3 - Prob. 3.14RQCh. 3 - What do you purchase when you acquire a packaged...Ch. 3 - In Figure 3-5b, why must the minimum cardinality...Ch. 3 - When is a member of a supertype always a member of...Ch. 3 - Examine the hierarchy for the university EER...Ch. 3 - Add a subtype discriminator for each of the...Ch. 3 - For simplicity, subtype discriminators were left...Ch. 3 - Refer to the employee EER diagram in Figure 3-2....Ch. 3 - Refer to the EER diagram for patients in Figure...Ch. 3 - Figure 3-13 shows the development Of entity...Ch. 3 - Refer to Problem and Exercise 2-44 in Chapter 2...Ch. 3 - For a library, the entity type HOLDING has four...Ch. 3 - A bank has three types of accounts: checking,...Ch. 3 - Refer to your answer to Problem and Exercise 2-4...Ch. 3 - Refer to your answer to Problem and Exercise 3-24...Ch. 3 - Prob. 3.29PAECh. 3 - Draw an EER diagram for the following situation:...Ch. 3 - Develop an EER model for the following situation,...Ch. 3 - Prob. 3.32PAECh. 3 - Prob. 3.33PAECh. 3 - Prob. 3.34PAECh. 3 - Based on the EER diagram constructed for Problem...Ch. 3 - Prob. 3.36PAECh. 3 - Prob. 3.37PAECh. 3 - Add the following to Figure 3-16: An EMPLOYMENT...
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Use ER Assistant to draw your diagram. Draw a self-referencing entity type for the Employee entity type for which an employee is supervised by a maximum of one other employee and doesn’t have to be supervised by any employee at all. Conversely, an employee can supervise zero or many other employees. The attributes of the Employee entity are as follows: EmpNo (primary key), EmpName, EmpAddress.arrow_forwardAssuming that appropriate names are supplied for entity types, reference modes, and predicates and that appropriate constraints are added, which of the following conceptual schema diagrams are legal? Where illegal, briefly explain the error.arrow_forwardThe property X can be found in two different entity sets A and B, but their names are unimportant for this discussion. How may the design be improved if the two Xs are unrelated?arrow_forward
- Create Entity-Relationship (E-R) model for the internal view of gym membership system including all workers and organization units affected by processing gym memberships. When members join the gym, they pay a fee for a certain length of time. Most memberships are for one year, but memberships as short as two months are available. Throughout the year, the gym offers a variety of discounts on their regular membership prices (e.g., two memberships for the price of one for Valentine's day). It is common for members to pay different amounts for the same length of membership. The gym wants to mail out reminder letters to members asking them to renew their memberships one month before their memberships expire. Some members have become angry when asked to renew at a much higher rate than their original membership contract, so the club wants to track the prices paid so that the manager can override the regular prices with special prices when members are asked to renew. The system must track…arrow_forwardThis is a continuation to the question above. The directions continue as follows: Also, create a Use Case diagram. Make sure to identify the entities as actors and show the interaction between each of the actors. Be sure to identify at least two processes and show all the actions between them. Don't forget to include a system boundary so we can determine which actions occur within the system and which are external to SIM. With the creation of the use case diagram, you should be able to create a model (or table) showing each object. For each object, be sure to outline associated attributes and methods. Hopefully, the use case diagram and the DFD will make this process fairly straightforward. The developers need 3 instance examples for each of the entities. I suggest that you use the data library and previously developed organizational chart to find examples.arrow_forwardDraw an EER diagram to represent the following situation: When appropriate, model an associative entity. A rental property would like to store information about TENANT, DEPENDENTs and Payment. The property would like to store information about Tenant: Unique Tenant Id, Tenant Name(first and last) , Address(Street, City, State) , Phonenumbers (country, Area, local), Email Address and House Type. A housetype can be a Townhouse, Apartment or Individual house. For a Apartment, we will store Unique Apart number, number of rooms; for an Individual house, we will store Unique House number, size of house. We will not store any additional information about Townhouse. Dependents are depended on the tenants. Dependent can be uniquely identified by their name. For PAYMENTs, the following information will be stored: a unique payment id, the Bank name associated with the form of payment used, and the account holder name. There are three different types of PAYMENTs: Card Payment, Cheque Payment, Bank…arrow_forward
- Draw an ER diagram on any application for a student information system with 4 entities:-entity class:classID,department-entity department:deptID,Dept_name-entity student:studentID,firstname,last name,gender,birthdate,address,hobby,class,mother name,father name,student code-entity parents:parentID,parent name,occupation,address,town,parent type,gender,telephone,email addressarrow_forwardProduce a Class Diagram and a Use case diagram for the State Patrol case. You should list assumptions and questions that are relevant and functionally determine your model Things to help: When you create the Use Diagram, you should start with the basis that there are 3 roles: Officer (because the Officer is entering the ticket online directly from the patrol car) Motor Vehicles clerk Court clerk (Note the "Driver" is not a role since her/his pleas (or payment) are probably being entered by a clerk) If you have already defined an ERD solution for this case (in class), converting this to a class diagram should be relatively easy.arrow_forwardCreate a conceptual model In your conceptual diagram, you need to show all the relationships and data types apply (include all the entities from the case study above)arrow_forward
- In a three-page analysis of the subject, the differences between attributes and variables must be clarified.arrow_forwardI have a HW that is asking me to draw on ERD diagram for a simple purchasing system that has order with order id, customer id, and date; order consists of one or more items; items consist of item id, description and price, and customers list customer id, name, and address. Can you help?arrow_forwardProvide a separate ER diagram representing each of the following situations. 1.A is an entity. It has an attribute, “a_id” as its identifier. B is a weak entity that depends on A. It has “b_id” as its discriminator. Many instances of B may belong to the same instance of A. 2. A, B, and C are entities. There is a relationship between all three, called D. For each A and B there is one C. For each B and C there can be many A’s. For each A and C, there is one B. Every time the relationship, D, is satisfied, a single value, “Note”, will be stored.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase 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 Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
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