1. Identify primary keys, foreign keys, NULL and other constraints exist with the tables. Documentthe identified constraints.Table 1. Identified Primary Key, Foreign key, Not null ConstraintsTable Name Primary Key Foreign Key ( referencestable A)Nott Nullcolumns2. Create all the tables with identified constraints on Oracle. (e.g. primary keys, foreign keys, NULLand other)NOTE: When you create tables you should decide the appropriate types for the attributes. Andalso you should add the screenshots of CREATE TABLE statements in the project Report3. Insert all the given values. You are feel free to insert new values to the tables.NOTE: You should add all INSERT INTO statements and screenshots in the project report.4. Write following queries on the tables.a. Print employee’s first name, last name, address and department number.b. Print employee full name and department and employee’s supervisors full name.c. Print employee information who works for project 3. (i.e. ProductZ).d. Print the employee and the number of dependant for an employee.e. Print information about employees working more than one project.f. Find the manager who earns the highest salary.g. Print for all the employees number of hours in total they have worked in the projects.h. Print project information of the projects which are managed by department 5 (i.e.research).i. Print the total number of projects controlled by the different departments and themanager of the project. (department manager is the project manager)j. Identify and print information about employees who have children less than 15 yearsold.k. Print details of mangers who have worked more than 20 years of the companyl. Create your own query. It must include a nested query. Submit the following:i. question your query is answeringii. the SQL queryiii. the mark for this question will depend on the complexity of the query.iv. higher marks will be given for queries that are more complex and/or innovative.v. if you do not provide a description of what question the query is answering, youwill get zero for this query.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
1 Identify Primary Keys Foreign Keys Null And Other Constraints Exist With The Table 2763251
/in Uncategorized /by developer1. Identify primary keys, foreign keys, NULL and other constraints exist with the tables. Documentthe identified constraints.Table 1. Identified Primary Key, Foreign key, Not null ConstraintsTable Name Primary Key Foreign Key ( referencestable A)Nott Nullcolumns2. Create all the tables with identified constraints on Oracle. (e.g. primary keys, foreign keys, NULLand other)NOTE: When you create tables you should decide the appropriate types for the attributes. Andalso you should add the screenshots of CREATE TABLE statements in the project Report3. Insert all the given values. You are feel free to insert new values to the tables.NOTE: You should add all INSERT INTO statements and screenshots in the project report.4. Write following queries on the tables.a. Print employee’s first name, last name, address and department number.b. Print employee full name and department and employee’s supervisors full name.c. Print employee information who works for project 3. (i.e. ProductZ).d. Print the employee and the number of dependant for an employee.e. Print information about employees working more than one project.f. Find the manager who earns the highest salary.g. Print for all the employees number of hours in total they have worked in the projects.h. Print project information of the projects which are managed by department 5 (i.e.research).i. Print the total number of projects controlled by the different departments and themanager of the project. (department manager is the project manager)j. Identify and print information about employees who have children less than 15 yearsold.k. Print details of mangers who have worked more than 20 years of the companyl. Create your own query. It must include a nested query. Submit the following:i. question your query is answeringii. the SQL queryiii. the mark for this question will depend on the complexity of the query.iv. higher marks will be given for queries that are more complex and/or innovative.v. if you do not provide a description of what question the query is answering, youwill get zero for this query.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
1 If All Companies Had An Objective Of Maximizing Shareholder Wealth Would People Ov 2728241
/in Uncategorized /by developer1. If all companies had an objective of maximizing shareholder wealth, would people overalltend to be better or worse off ?2. Contrast the objective of maximizing earnings with that of maximizing wealth.3. What is financial management all about?4. Is the goal of zero profits for some finite period (three to five years, for example) everconsistent with the maximization-of-wealth objective?5. Explain why judging the efficiency of any financial decision requires the existence of a goal.6. What are the three major functions of the financial manager? How are they related?7. Should the managers of a company own sizable amounts of common stock in the company?What are the pros and cons?8. During the last few decades, a number of environmental, hiring, and other regulationshave been imposed on businesses. In view of these regulatory changes, is maximization ofshareholder wealth any longer a realistic objective?9. As an investor, do you think that some managers are paid too much? Do their rewardscome at your expense?10. How does the notion of risk and reward govern the behavior of financial managers?11. What is corporate governance? What role does a corporation’s board of directors play incorporate governance?12. Compare and contrast the roles that a firm’s treasurer and controller have in the operationof the firm.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
1 If B K Are Events Such That 2 If F Is A Distribution Function Then F Has At Most C 2008131
/in Uncategorized /by developer1. If {Bk} are events such that
2. If F is a distribution function, then F has at most countably many discontinuities
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
1 If In A Single Contiguous Memory Management System The Program Is Loaded At Addres 2801898
/in Uncategorized /by developer1- If, in a single contiguous memory management system, the program is loaded at address 5000, compute the physical addresses (in decimal) that correspond to the following logical addresses:
A. 103
B. 455
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
1 If Inflation Is Expected To Steadily Decrease In The Future The Term Structure Of 1893615
/in Uncategorized /by developer1. If inflation is expected to steadily decrease in the future, the term structure of interest rates will most likely be:
upward-sloping.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
1 If The Bank Of Canada Leans Against The Wind Which Means Increasing Interest Rates 1697117
/in Uncategorized /by developer1. If the Bank of Canada ‘‘leans against the wind,’’ which means increasing interest rates when the Canadian dollar depreciates and lowering interest rates when the Canadian dollar appreciates, what would this mean for the exposure of
a Canadian residents holding Canadian dollar-denominated bonds?
b US residents holding Canadian-dollar bonds?
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
1 If Possible In Your Computational Tool Revise The Code Of Random Walk Points To Re 2068931
/in Uncategorized /by developer1. If possible in your computational tool, revise the code of random Walk Points to replace the loop with a call to a function to formulate lst.
2. Revise the code of random Walk Points or Exercise 1 to have the entity go with equal probability in a N, S, E, or W direction.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
1 If The Currency Exchange Rate As Of Today Is 1 U S Equals 65 British Pounds And Th 1312811
/in Uncategorized /by developer1. If the currency exchange rate as of today is $1 U.S. equals .65 British pounds, and the XYZ Corp. signs a contract with a British company to exchange 6,450 pounds in 30 days for a cost of $10,000, what is the spot exchange rate?
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
1 If The Trial Balance Only Lets One Know If Debits Credits Why Would It Be Benefici 2840313
/in Uncategorized /by developer1)If the trial balance only lets one know if debits = credits why would it be beneficial to review this report? Especially if you are using an automated system that requires debits and credits are equal before posting a general journal entry?
Please include one reference.
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
1 If The Ricardian Equivalence Theorem Holds Then The Timing Of Taxes Do Not Matter 1873332
/in Uncategorized /by developer1. If the Ricardian Equivalence Theorem holds, then the timing of taxes ‘do not matter’ in the sense that there is no effect on consumer demand, desired national saving, the current account and (in a closed economy) the real rate of interest. However, the timing of taxes does have implications for the composition of desired national saving (between the private and public sectors). Explain how.
2. True, False or Uncertain and Explain. The Ricardian Equivalence Theorem states that government spending ‘does not matter.’
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"