3) In the following example, a bank customer can have many accounts with a bank, and an account can be associated with one or more customers. An account can have associated with it one or more "Terms and Conditions" and a single "term and condition" can be associated with more then one account. A customer can have different accounts associate with different branches of the bank. However, a single account can only be associated with one branch. Assuming that Branch is a separate entity on the ER diagram, add it to the appropriate place in the ER and the relational models. Draw any needed relationships. 3.a) For the above problem, draw an entity relationship diagram with appropriate cardinalities (including lower and upper bounds) associated with the relationships. (15 points) 3.b) Based on the entity relationship diagram, create a relational model (in 3rd normal form). Identify any needed primary and foreign keys and draw the relationship lines between the specific attributes in each entity that are associated with the relationship. (20 points)
Added by Zachary R.
Close
Step 1
First, let's identify the entities in the problem statement: Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 57 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Scenario: The African Union (AU), at its headquarters in Addis Ababa, Ethiopia, wants to design a database system for the people who reside on its continent. As you are aware, Africa is made up of many countries, and, in general, each country has many languages. It is also a known fact that many people in Africa are multilingual. For the purpose of this scenario, we will consider individuals as residents of a single country (their primary residence), although in reality, people may be residents or citizens of more than one country. 1. Draw an entity relationship diagram (ERD) for this scenario. The ERD should not contain any many-to-many relationships. Do not include entities that are not in the scope of the scenario provided above. No attributes/fields are required in this section. (10)
Supreeta N.
Design an ER diagram for a company database: The company consists of many departments, and each department has a unique name, a location, a manager, and lots of employees. Each employee works for one specific department, and each employee has a unique id, a name, a position, and a salary. A department manager is also an employee, and an employee can lead at most one department. A project is hosted by one department (referred to as the host department), and other departments can collaborate on the same project (referred to as collaborating departments). Each project has a unique project number, a start date, and a deadline. Besides, the company has also set up several interest groups for many employees to join, and we keep track of the date when each employee joins it. Each interest group has a unique name, a capacity, and a single team leader who is also an employee. Each employee can join no or many interest groups but can lead at most one. Each interest group organizes several events. We keep track of the event location and event date for each event. Events from different interest groups may be conducted on the same day and at the same location. Draw the ER diagram and state any assumptions you make. But you should not add extra entities, attributes, or relationships beyond the above description.
5. Here is a diagram for a relation R on a set A. Write the sets A and R. 6. Congruence modulo 5 is a relation on the set A = ℤ. In this relation xRy means x ≡ y (mod 5). Write out the set R in set-builder notation. 7. Write the relation < on the set A = ℤ as a subset R of ℤ % ℤ. This is an infinite set, so you will have to use set-builder notation. 8. Let A = {1, 2, 3, 4, 5, 6}. Observe that ∅ ⊆ A % A, so R = ∅ is a relation on A. Draw a diagram for this relation. 9. Let A = {1, 2, 3, 4, 5, 6}. How many different relations are there on the set A? 10. Consider the subset R = (ℝ % ℝ) – {(x, x) : x ∈ ℝ} ⊆ ℝ % ℝ. What familiar relation on ℝ is this? Explain. 11. Given a finite set A, how many different relations are there on A?
Sri K.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
Watch the video solution with this free unlock.
EMAIL
PASSWORD