Consider the two sets of business rules shown in the table below. SET OF BUSINESS RULES...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Consider the two sets of business rules shown in the table below. SET OF BUSINESS RULES #1 Cardinality A CLIENT owns many ACCOUNTS. An ACCOUNT is owned by many CLIENTS. Participation Every CLIENT owns an ACCOUNT. Every ACCOUNT is owned by a CLIENT. SET OF BUSINESS RULES #2 Cardinality A CLIENT owns exactly one ACCOUNT. An ACCOUNT is owned by many CLIENTS. Participation Not every CLIENT owns an ACCOUNT. Not every ACCOUNT is owned by a CLIENT. a) Draw an E-R schema diagram that complies with the first set of business rules using Chen's notation. You must use proper E-R constructs including entity types and relationship types (you do not need to add attributes). b) Draw an E-R schema diagram that complies with the second set of business rules using Chen's notation. You must use proper E-R constructs including entity types and relationship types (you do not need to add attributes). Consider the two sets of business rules shown in the table below. SET OF BUSINESS RULES #1 Cardinality A CLIENT owns many ACCOUNTS. An ACCOUNT is owned by many CLIENTS. Participation Every CLIENT owns an ACCOUNT. Every ACCOUNT is owned by a CLIENT. SET OF BUSINESS RULES #2 Cardinality A CLIENT owns exactly one ACCOUNT. An ACCOUNT is owned by many CLIENTS. Participation Not every CLIENT owns an ACCOUNT. Not every ACCOUNT is owned by a CLIENT. a) Draw an E-R schema diagram that complies with the first set of business rules using Chen's notation. You must use proper E-R constructs including entity types and relationship types (you do not need to add attributes). b) Draw an E-R schema diagram that complies with the second set of business rules using Chen's notation. You must use proper E-R constructs including entity types and relationship types (you do not need to add attributes).
Expert Answer:
Answer rating: 100% (QA)
According to the instruction given Ill explain how to create an EntityRelationship ER schema diagram based on Chens notation for both sets of business ... View the full answer
Related Book For
Auditing A Practical Approach
ISBN: 9780730382645
4th Edition
Authors: Robyn Moroney, Fiona Campbell, Jane Hamilton
Posted Date:
Students also viewed these general management questions
-
Draw an ERD for the below scenario with cardinality: The ERD is for a database about families. The entities provided are Person (primary key is PersonID), Car (primary key is CarRegoNo), and Dog...
-
I was given the following scenario and told to build a CHEN Entity Relational diagram based off of it: Richmond Alternative Family Therapy is a small family counseling practice. It needs an...
-
An investor creates an investment portfolio from stock A and stock B where she invests 0.5 of her wealth in stock A and 0.5 of her wealth in stock B. Stock A has a beta of 1.39 and stock B has a beta...
-
Find an article on "Intellectual property" from newspaper, magazine, internet, or similar source and write a summary of the article. Write your reaction to the article's content. Discuss.
-
Cougar, Inc., is a calendar year S corporation. Cougars Form 1120S shows nonseparately stated ordinary income of $80,000 for the year. Johnny owns 40% of the Cougar stock throughout the year. The...
-
Describe how human genetics and stem cell research can have an impact on end-of-life issues.
-
Qamar, Inc., did not pay dividends in 2009 or 2010, even though 50,000 shares of its 6.5%, $50 par value cumulative preferred stock were outstanding during those years. The company has 800,000 shares...
-
Madox Max Ltd pay a dividend of $3.3 per share next year. After that the dividend is forecast to grow at 15% for 1 year. From year three onwards dividends are expected to grow by 6% indefinitely....
-
Peyton Smith enjoys listening to all types of music and owns countless CDs. Over the years, Peyton has gained a local reputation for knowledge of music from classical to rap and the ability to put...
-
An organisation is most likely to achieve its goals: Question 1 Answer a. When the employer and employees work towards the same goals b. When business organisations develop effective communication...
-
A weather balloon can rise to an altitude of \(80,000 \mathrm{ft}\) above sea level. What is this distance in miles? In meters?
-
A human heart beats 72 times every minute. How many times, on average, does a heart beat during a healthy 70 -year lifespan?
-
(a) Prove that the repulsive electric force between two charged particles is a maximum when each particle carries charge \(q / 2\), where \(q\) is the sum of the charges carried by the two particles....
-
The world record for the \(100 \mathrm{~m}\) dash was set at 9.58 seconds a few years ago. What is this speed in kilometers per hour? In miles per hour?
-
How many water molecules are there in an Olympic swimming pool that is \(50 \mathrm{~m}\) long, \(25 \mathrm{~m}\) wide and \(3.0 \mathrm{~m}\) deep?
-
Researchers have been studying p-loading in Jones Lake for many years. It is known that mean water clarity (using a Secchi disk) is normally distributed with a population standard deviation of o =...
-
14. In testing the existence assertion, an auditor ordinarily works from the a. Financial statements to the accounting records. b. General journal to the general ledger. c. Supporting evidence to the...
-
Pringle and Partners Chartered Accounting firm has built up its audit work over the last five years. It has obtained new clients each year and many of its existing clients have grown in size. It has...
-
All companies are required to disclose in their annual reports the amounts paid to their auditors for both the financial report audit and any other services performed for the company. Required Obtain...
-
Lucy Huang has just finished her first audit assignment. She is now assisting her audit manager, Tom Lucas, in wrapping up the engagement. He has asked Lucy to make a list of all un cleared review...
-
Consider the financial system of a country like Japan for example and discuss which ingredients we may have to include in a model that can address the reason for the observed recurrent financial...
-
Discuss how one decides whether a model is too simple or unnecessarily complicated.
-
Imagine that the EU flagship Human Brain Project has succeeded in producing a highperformance computer that can simulate the entire network of 8.61010 neurones and their 1015 connections. (a) Will it...
Study smarter with the SolutionInn App