Reference no: EM131245206 , Length:
ASSIGNMENT 1
Question 1: What are the drawbacks of using file system over database management system?
Explain the distinctions among the terms primary key, candidate key, and super key.
Consider the bank database.
branch(branch name, branch city, assets)
customer (customer name, customer street, customer city) loan (loan number, branch name, amount)
borrower (customer name, loan number)
account (account number, branch name, balance) depositor (customer name, account number)
Give an expression in the relational algebra for each of the following queries:
a. Find all loan numbers with a loan value greater than $50,000.
b. Find the names of all depositors who have an account with a value greater than $9,000.
c. Find the names of all depositors who have an account with a value greater than $8,000 at the "Uptown" branch.
Question 2: Consider the advisor relation shown in Figure 2, with s_id as the primary key of advisor. Suppose a student can have more than one advisor. Then, would s_id still be a primary key of the advisor relation? If not, what should the primary key of advisor be?
Schema Diagram for University Database
|
Why is this an ethical dilemma
: Does this situation meet the standards set by the duty to protect statue? How might whether or not Dr. Yeung's state includes researchers under such a statute influence Dr. Yeung's ethical decision making? How might the fact that Dr. Yeung is a re..
|
|
Compute the npv of the investment
: Compute the NPV of the investment. -On investigation, you discover that no adjustments have been made for inflation or price-level changes. - Reevaluate the NPV of the project in light of this information.
|
|
Describe the difference between a call and a put
: What is an option security? Describe the difference between a call and a put. Discuss the EMH. Describe the ‘strong’, ‘semi-strong’, and ‘weak’ forms of the EMH. Discuss what factors contribute the price of common stocks.
|
|
How the wage can adjust to balance the supply and demand
: Explain how the wage can adjust to balance the supply and demand for labor while simultaneously equaling the value of the marginal product of labor.
|
|
Find all loan numbers with a loan value
: Fundamentals of Databases (IT403) - What are the drawbacks of using file system over database management system and Explain the distinctions among the terms primary key, candidate key, and super key.
|
|
Which job offers the best start for mary
: The job pays $40,000 and includes annual raises for good performance. The benefits package includes company paid insurance and tuition reimbursement. Employees receive one week vacation the first year and three weeks' vacation thereafter. In addi..
|
|
Calculate equilibrium quantity of employment and wage rate
: Calculate the equilibrium quantity of employment and wage rate in this labor market. What is the principle-agent problem between employers and employees in a labor market?
|
|
First mover is dominating market
: A first mover is dominating a market, with revenues of $40 million annually. The average total cost of the firm is #02 million, of which $19 million is fixed. How can the first move keep others from entering the market?
|
|
Draw the skip list after each insert
: State the greatest possible lower bound that you can for the all-pairs shortest paths problem, and justify your answer.
|