i. Q4Convert the following ER-Model of Banks to relational database schema. Identify and mark all the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
i. Q4Convert the following ER-Model of Banks to relational database schema. Identify and mark all the primary keys and foreign keys. (8) ii. iii. iv. V. Name Code Address Bank Loan id Loan tyne Amount ER Diagram of a Bank Has Offer Loan Branch id Availed by Custid Branch N Q5: Consider the following Database schema: lives(person-name, street, city) works(person-name, company-name, salary) located-in(company-name, city) manages(person-name, manager-name)) Name N Maintain> N Name M Account Customer. Address Hold by Phone 000 Address Account No Acc Type Balance) For the above schema (the primary key for each relation is denoted by the underlined attribute), provide relational algebra expressions and SQL for the following queries: (10) Find all tuples in works of all persons who work for the City Bank company (which is a specific company in the database). Find the average salary given by each company. Find the name and city of all persons who work for City Bank and earn more than 50,000. Find names of all persons who live in the same city as the company they work for. Find names of all persons who do not work for City Bank. 2 to 2 -25 x 100 = 200 7 i. Q4Convert the following ER-Model of Banks to relational database schema. Identify and mark all the primary keys and foreign keys. (8) ii. iii. iv. V. Name Code Address Bank Loan id Loan tyne Amount ER Diagram of a Bank Has Offer Loan Branch id Availed by Custid Branch N Q5: Consider the following Database schema: lives(person-name, street, city) works(person-name, company-name, salary) located-in(company-name, city) manages(person-name, manager-name)) Name N Maintain> N Name M Account Customer. Address Hold by Phone 000 Address Account No Acc Type Balance) For the above schema (the primary key for each relation is denoted by the underlined attribute), provide relational algebra expressions and SQL for the following queries: (10) Find all tuples in works of all persons who work for the City Bank company (which is a specific company in the database). Find the average salary given by each company. Find the name and city of all persons who work for City Bank and earn more than 50,000. Find names of all persons who live in the same city as the company they work for. Find names of all persons who do not work for City Bank. 2 to 2 -25 x 100 = 200 7
Expert Answer:
Answer rating: 100% (QA)
Solutions Step 1 Q4 Convert the following ER model of Banks to relational database schema Identify and mark all the primary keys and foreign keys These steps are used to convert the ER diagram of bank... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these programming questions
-
You jump off of the top of your house and hope to land on a wooden deck below. Consider the following possible outcomes: i ) You hit the deck, but it isn t wood! A camouflaged trampoline slows you...
-
1. Convert the following binary numbers into decimal: a) 11010112 ?10 b) 101101112 ?10 c) 10100.11012= ?10 2. Perform the following decimal numbers into binary: a) 12510=22 b) 20910=?2 c) 13210=?2
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Investors should expect to be compensated for bearing_____ risk, but they should not expect to be compensated for bearing_____ risk. a. Unsystematic: systematic b. Unsystematic; co-movement c....
-
A brick rectangular channel, with a slope of 0.002, is designed to carry 230 ft3/s of water in uniform flow. There is an argument over whether the channel width should be 4 ft or 8 ft. Which design...
-
Show that the standard basis vectors e1, e2, e3 form an orthogonal basis with respect to the weighted inner product (v, w) = v1 w1 + 2 u2 w2 + 3 v3 w3 on R3. Find an orthonormal basis for this inner...
-
With reference to the example on page 443, suppose a third replicate is run. Analyze the experiment, using all 3 replicates, according to the visual procedure given in Section 13.3. Interpret the...
-
The circuit in Figure consists of switch S, a 12.0 V ideal battery, a 20.0 M? resistor, and an air filled capacitor. The capacitor has parallel circular plates of radius 5.00 cm, separated by 3.00...
-
Research the civil case Katz, et al. v. Panera Bread Co. and answer the following questions: Give a brief description of the lawsuit. Did Panera properly display the contents of the drink? Explain...
-
1. Using the information in the table, compute the structure of the optimal portfolio W when there are two risky assets, bond fund and stock fund, as well as one risk free asset. r=0.03. Please note...
-
Use the formula S = n(n + 1) to find the sum of 1+2+3+ ... + 765. 2 1+2+3+ ... + 765 =
-
Stevenhas cash in a savings account totaling $14250, and his monthly expenses are $2850. What is his emergency fund ratio? a. 3 b. 0.29 c. 8 d. 5
-
6. Assume A is correctly priced by CAPM. Whenever the market moves down 2%, stock A moves down, on average, by 2.5%. How does the beta of stock A compare to the beta of the market as a whole? Explain.
-
Bob comes into your office and says, "I owe Bank of Texas $65,000 in credit card debt. Can we put my band new vacation home in a trust to make sure it's preserved in case I'm sued?" Would this...
-
Calculate the coordinates of the center of gravity (miym) of the shaded area in the figure. (n=3,14) + 3a k a Ay Circle * 2a * 22 A) (1,60 a; 1,83 a) B) (1,83 a; 1,92 a) C) (1,75 a; 1,55 a) D) (1,95...
-
In 2022, can Epicurus' simple prescription for happiness work (see DeBotton's article)? Explain why or why not. Make sure to identify his prescription in your answer. Use specific examples.
-
Which of the following is not true about latent phase of labour? a) According to ACOG it starts after 3-4 cm cervical dilatation but they are planning to increase it to 5 cm b) Begins at the end of...
-
Find the APR in each of the following cases: NUMBER OF TIMES COMPOUNDED Semiannually Monthly Weekly Infinite EAR APR 10.4% 8.9 11.6 15.4
-
How are qualified dividends taxed in 2012? Please give the two rates of tax which apply to qualified dividends, and specify when each of these rates applies._________________________...
-
On February 2, 2012, Alexandra purchases a personal computer for her home. The computer cost $3,000. Alexandra uses the computer 80 percent of the time in her accounting business, 10 percent of the...
-
Deborah purchases a new $30,000 car in 2012 to use exclusively in her business. If Deborah does not elect to expense or take bonus depreciation in 2012 and holds the car until it is fully...
-
Is leadership synonymous with management, or is leading just one of the many things that a manager does? In what ways are they the same or different?
-
Explain Blake and Moutons Leadership Grid in relationship to previous leadership research.
-
Write a description of an effective manager. Write words that you would use to describe an effective leader. When you review your list, consider the differences and similarities in your adjectives....
Empires Vs Coalitions A Defining Moment For Relationships 1st Edition - ISBN: 1628570164 - Free Book
Study smarter with the SolutionInn App