BANK Code Name Addr 1 N BRANCHES 1 ACCTS N Acct_no Balance ACCOUNT M A_C BANK_BRANCH Addr 1 LOANS Branch_no N Loan_no Amount Type LOAN Type M N Ssn Name Phone CUSTOMER Addr L_C N
Added by Andrea W.
Close
Step 1
The first step is to identify the entities in the ER diagram and their attributes. Entities: Show more…
Show all steps
Your feedback will help us improve your experience
Dave Kratz and 61 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
Make up at least three $n$ -ary relations with artificial data that might be used in a medical database. Illustrate how your database would be used by posing and answering two queries. Also, write a sequence of operations that could be used to answer the queries.
Functions, Sequences, and Relations
Relational Databases
Please help me answer this the topic is for information management Note: When naming all entities and attributes add your initials as suffix: For example, in my case - SVS (Samantha V Smith), I would name my Employee entity as Employee_SVS and my ssn attribute as ssn_SVS. A company database needs to store information about employees (identified by ssn, with salary and phone as attributes), departments (identified by dno, with dname and budget as attributes), and children of employees (with name and age as attributes). Employees work in departments; each department is managed by an employee; a child must be identified uniquely by name when the parent (who is an employee; assume that only one parent works for the company) is known. We are not interested in information about a child once the parent leaves the company. Draw an ER diagram that captures this information.
Jeff V.
The 5 -tuples in a 5 -ary relation represent these attributes of all people in the United States: name, Social Security number, street address, city, state. a) Determine a primary key for this relation. b) Under what conditions would (name, street address) be a composite key? c) Under what conditions would (name, street address, city) be a composite key?
Relations
n-ary Relations and Their Applications
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Watch the video solution with this free unlock.
EMAIL
PASSWORD