Assignment Answer

In: Computers and Technology

Submitted By wjazqfezzz
Words 930
Pages 4
1. Consider the relation CLASS(Course#, Univ_Section#, InstructorName, Semester,
BuildingCode, Room#, TimePeriod, Weekdays, CreditHours). This represents classes taught in a university with unique Univ_Section#. Give what you think should be various candidate keys and write in your own words under what constraints each candidate key would be valid.
Answer: Possible candidate keys include the following (Note: We assume that the values of the Semester attribute include the year; for example "Spring/94" or "Fall/93" could be values for Semester):
• {Semester, BuildingCode, Room#, TimePeriod, Weekdays} if the same room cannot be used at the same time by more than one course during a particular semester.
• {Univ_Section#} if it is unique across all semesters.
• {InstructorName, Semester} if an instructor can teach at most one course during each semester. • If Univ_Section# is not unique, which is the case in many universities, we have to examine the rules that the university uses for section numbering. For example, if the sections of a particular course during a particular semester are numbered 1, 2, 3, ..., then a candidate key would be {Course#, Univ_Section#, Semester}. If, on the other hand, all sections (of any course) have unique numbers during a particular semester only, then the candidate key would be {Univ_Section#, Semester}.
2. Consider the following relations for a database that keeps track of student enrollment in courses and the books adopted for each course:
STUDENT (SSN, Name, Major, Bdate)
COURSE (Course#, Quarter, Grade)
ENROLL (SSN, Course#, Quarter, Grade)
BOOK_ADOPTION (Course#, Quarter, Book_ISBN)
TEXT (Book_ISBN, Book_Title, Publisher, Author)
Specify the foreign keys for this schema, stating any assumptions you make.
Answer: The schema of this question has the following four foreign keys:





the attribute SSN…...

Similar Documents

Issues in Applied Finance Financial Planning Assignment: Questions & Answers

...AFIN310 Issues in Applied Finance Financial Planning Assignment: Questions & Answers General Questions 1. Is an introduction / executive summary and conclusion required? No. You are to answer each question and keep to a total maximum of 15 pages, excluding cover page. No marks will be provided for anything written on page 16 or beyond. Students are recommended to refer to the mark allocation when answering each question. 2. Is specific formatting required? Eg The font you can use is Calibri, size 12. The document should have 1.5 spacing There are no specific formatting requirements, unless there are standard university or department formatting criteria of which students should be aware. 3rd year students are expected to submit assignments which are easy to read and look professional. 10 marks are allocated to presentation, length, references and bibliography. Question 1 3. Question 1(a) are real-life examples required or I can simply make-up an example? Personal and/or made-up examples will not be sufficient. There are numerous Australian real cases that can be referenced. The preamble to the question refers to "Australian scandals involving financial planning firms, practices and advice". You are required to limit the use of examples to publically available information about the provision of financial advice in Australia. 4. Question 1(a) How many examples will be considered sufficient? Marks are not allocated based on the number of examples provided, rather on the quality......

Words: 1116 - Pages: 5

Mgf 301 Assignment 3 Answers

...MGF 301 Assignment 3 1.a) Actual return on investment= (18*200)-(23*200) / (23*200)= -0.1696/ -17% b) (i) Dividend Yield= $1.10/23= 0.0478/ 5% (ii) Percentage capital gain= -5/23 =-0.2174/ -21% c) Real rate of return on stock= [(1+6%)/ (1+2%)] -1 = 0.039 / 4% 2. | | | | Stock Price: | $72 | | Next Year: | | | | | 10% | $10 | | | 20% | $38 | | | 30% | $73 | | | 30% | $100 | | | 10% | $150 | | | | | | (a) | | | | Actual Return | P*R | | -86.11% | | -8.61% | | -47.22% | | -9.44% | | 1.39% | | 0.42% | | 38.89% | | 11.67% | | 108.33% | | 10.83% | | Expected Return: | 4.86% | | | | | | (b) | | | | (r-E(r))^2 | | P*(r-E(r))^2 | 82.76% | | 8.28% | | 27.13% | | 5.43% | | 0.12% | | 0.04% | | 11.58% | | 3.47% | | 107.07% | | 10.71% | | Expected Variance: | 27.92% | | Expected SD: | 52.84% | | | | | | 3, a) β for AMZN = 0.9 E(r) =0.01+0.9*(0.08-0.01) = 0.073 Β for GE = 1.47 E(r) =0.01+1.47*(0.08-0.01) = 0.1129 b) Because Rf and Rm remain unchanged while we calculate expected returns, β is a key factor explaining why the expected return of one stock is higher than the others’. If Beta = 1, then the stock is exactly as volatile as the entire stock market. Beta greater than 1 means the stock is more volatile than the market and vice versa. GE has a higher expected return because it has a higher level of market risk,......

Words: 676 - Pages: 3

Assignment 2 Sample Answer

...LEGT 1710, BUSINESS AND THE LAW SAMPLE PROBLEM QUESTION AND SAMPLE ANSWER NOTE: • • • • The sample question and answer are based on a previous problem question. The sample question and answer are purely intended as a GUIDE TO THE STYLE OF WRITING answers to legal problem questions. Do NOT use the content of this answer for your assignment as the facts and issues in this problem are different to those in the assignment question. Do not try to learn the content of the sample answer as a replacement for learning and understanding the lecture, tutorial and course reading materials. 1. SAMPLE QUESTION Annie (‘A’) runs a courier service, A Pty Ltd. She reads in a newspaper that a local business, KwikCo, is looking for a courier service which they can use exclusively to deliver parcels and documents to their clients. The advertisement calls for expressions of interest, stating that "those parties wishing to be considered for the courier contract with KwikCo should submit an application in writing to be received in KwikCo's office by 5pm on Friday, 25 April, 2008." On Monday, 21 April 2008, A sends a letter to KwikCo giving information about her company and its experience as a courier service. She states that the company would be prepared to take on the work for KwikCo for a fee of between $12,000 and $20,000 per month. She further states in the letter that, rather than working exclusively for KwikCo, the company would prefer to also take on other small jobs on the......

Words: 3019 - Pages: 13

Individual Assignment: Accounting Short-Answer Questions

...BSHS 373 - Week 3 Individual Assignment: Accounting Short-Answer Questions Resource: Financial Management for Human Service Administrators Write 200- to 300-word responses to the following questions: What are the major accounting differences between nonprofit and for-profit organizations? Why are audits becoming increasingly important in the nonprofit sector? Cite at least three reasons. Complete Exercises 4.1–4.3 in Ch. 4 of Financial Management for Human Service Administrator July 1, 20XX–December 31, 20XX (a).July 1, 20XX— Received unrestricted donation check in the amount of $15,000 from the Multnomah County Department of Health and Human Services. Debited Cash $15,000 Credited Revenue $15,000 (b) July 19, 20XX—Paid Great Northwest Insurance Company $9,000 for six more months of fire and liability insurance coverage. Debited Prepaid Insurance $ 9,000 Credited Cash $ 9,000 (c) July 15, 20XX—Paid Portland Arts & Crafts Company $3,000 for additional arts and crafts supplies. Debited Arts & Crafts Supplies $ 3,000 Credited Cash $ 3,000 (d) July 15, 20XX—transferred temporarily restricted funds in the amount of $3,000 from investments to pay for additional arts and crafts supplies. Debited Investments $3,000 Credited Cash $3,000 (e) July 30, 20XX—Paid Oregon Sporting Goods $5,000 for additional recreational equipment. Debited Expense $ 5,000 Credited Cash $5...

Words: 1216 - Pages: 5

Finance 370 Chapter 20 Individual Assignment Answers

...FIN 370 - Week 5 Individual Assignment Chapter 20 Problem 1. Firm A has $10,000 in assets entirely financed with equity. Firm B also has $10,000 in assets, but these assets are financed by $5,000 in debt (with a 10 percent rate of interest) and $5,000 in equity. Both firms sell 10,000 units of output at $2.50 per unit. The variable costs of production are $1, and fixed production costs are $12,000. (To ease the calculation, assume no income tax.) a. What is the operating income (EBIT) for both firms? b. What are the earnings after interest? c. If sales increase by 10 percent to 11,000 units, by what percentage will each firm’s earnings after interest increase? To answer the question, determine the earnings after taxes and compute the percentage increase in these earnings from the answers you derived in part b. d. Why are the percentage changes different? A. What is the operating income (EBIT) for both firms? Sales Revenue = 10,000 x $2.50 = $25,000 less variable cost = 10,000 x $1 = $10,000 less fixed cost 12000 = EBIT = $3,000 B. What are the earnings after interest? FIRM A Interest = $0.   Earnings after interest = EBIT = $3,000 FIRM B EBIT = $3,000 Less interest on debt $5,000 x 10% = $500 =Earnings after interest = $2,500 C. If sales increase by 10 percent to 11,000 units, by what percentage will each firm’s earnings after interest increase? To answer the question, determine the earnings after taxes and compute the percentage increase in...

Words: 409 - Pages: 2

Assignment 1 Problem Answers

...Unit 1 Assignment 1 Problems Chapter 1: Problem 5, A-D, Page 21 Chapter 3: Problem 7, A-D, Page 68 Angela Besler Capella University MBA6008 January 12, 2014 Unit 1 Assignment 1 Problems Chapter 1: Problem 5, A-D, Page 21 A. Table and Graph: Types of Production |   | Automobiles | Forklifts | | 0 | 30 | A | Production Alternatives | 2 | 27 | B | | 4 | 21 | C | | 6 | 12 | D | | 8 | 0 | E | | A production possibility “curve displays the different combinations of goods and services that society can produce in a fully, employed economy, assuming a fixed availability of supplies of resources and fixed technology” (McConnell and Et. Al., 2012). The specific assumptions that a production possibilities curve has is that of: * Full employment: employing all available resources * Fixed resources: quantity/quality of production factors fixed * Fixed technology: methods used to produce output(state of technology) constant * Two goods: economy produce only two goods; both consumer and capital goods (McConnell and Et. Al., 2012). “Each point on the curve represents some maximum output of two products” (McConnell and Et. Al., 2012). “Gross Domestic Production (GDP is the total market value of all final goods/services produced annually within boundaries of US, whether by US or foreign supplied resources” (McConnell and Et. Al., 2012). “Net Domestic Production (NDP) is the GDP less part of the year’s output that needed to......

Words: 1236 - Pages: 5

Module 3 Short Answer Assignment

...Exploring the Motherboard and Busses Module 3 Short Answer Assignment The major components of a computer mother board are the processor, memory, chipset, expansion slots, and IO bank. The Processor is the brain of the computer. The processor is the chip where all of the computing is completed. The processor is usually removable and inserted into a socket. The processor can be attached directly to the mother board. The processor is normally protected by a heat sink which assists in removing heat and protects the processor from burning out. The memory is where the computers stores all of the information. The computer memory is usually installed on a board called a SIMMs. SIMMs stands for Single Inline Memory Module. Single Inline Memory Modules come in different sizes. These sizes include 2G, 4G, 8G, and up. You can have one memory installed on a board or you can have multiple memory installed. The amount of memory that is allowed on a board depends on various factors. These factors include the processor, the board itself, and the BIOS. The memory is usually removable. The chipset is a term that refers to a chip or a set of chips. The Chipset is a link between the processor and the outside world. The chipset controls the USB ports, keyboard, mouse, and hard drives. The Chipset generates the sound that the computer makes. The Chipset creates the images that you see in the screen. The Chipset is usually attached directly to the mother board and usually has heat sinks......

Words: 574 - Pages: 3

Answers to Personal Finance Assignment 1

...Assignment 1 (24 points) Assignment 1: Economic Basics Instructions Save this file in your course folder, and name it with Assignment, the section number, and your first initial and last name. For example, Jessie Robinson's assignment for Section 1 would be named Assignment1JRobinson. Type the answers to the assignment questions below. Use complete sentences unless the question says otherwise. You will have more than one day to complete an assignment. At the end of each day, be sure to save your progress. Review Lesson 4 of the Course Overview for instructions about turning in your assignments. Assignment Questions 1. Describe two examples of important things that financial planning skills can help you do, and explain why these things are important to you personally. (4-6 sentences. 2.0 points) Financial planning skills can help purchase items at low prices. Financial planning skills can also help you use credit cards responsibly. Learning how to purchase items at low prices helps you save money and get more for less. Learning how to use a credit card responsibly saves you from credit issues later on in life. 2. List two examples of goods you have purchased in the past or may purchase in the future. (Complete sentences are not necessary. 0.5 points) Two examples of goods I’ve purchased in the past are groceries at the store and clothes from the mall. 3. List two examples of services you have purchased in the past or may purchase in the future.......

Words: 1170 - Pages: 5

Short Answer Essay Assignment

...Ernesto Castillo Jodie Baeyens LITR220 August 14, 2015 Short Answer Essay Assignment 1. Based on the readings from weeks one and two, discuss the images of America the European writers constructed to promote colonization and settlement. What kinds of unique natural resources and environmental factors did they extol in their accounts of the New World? Relate these images to natural resources and environmental factors today. The Purposes behind coming to America was as diverse as the people living in it. America turned into the Promised Land of mankind, offering individuals a grand belief of a dream of extended opportunities and new hopes which was denied to them in the Old World. Europeans writers wrote an enormous amount of documents about America aimed during the early periods of settlement. Europeans composed portrayals of the nation, its abundant vegetation and aquatic life. They also “wrote of trading with the Indians” as numerous tribes established a peaceful exchange relation with the new settlers during the early phases of European settlement (Perkins 4). John Smith composed for future settlers when settlement started to grow. He also drew the maps for those settlers and gave them dreams that made them come to America even more. What created the drive for new settlers to come to America even more, was his adventure as “he told the story of his rescue by Pocahontas” (Smith 31). Through these stories, the readers could see the issues of Virginias......

Words: 1037 - Pages: 5

Narsee Monjee Assignment Answer Sheets - 9901366442

...WE PROVIDE NMIMS – NARSEE MONJEE - PGDSCM, PGDMM, PGDFM, DGM, DSCM, DMM, DITM, DHRM, DFM, DBM, DBFM, ASSIGNMENT ANSWERS, ASSIGNMENT SOLUTIONS aravind.banakar@gmail.com http://www.mbacasestudyanswers.com ARAVIND - 09901366442 – 09902787224 SALES MANAGEMENT 1. Suppose you are Sales Manager (priority banking) in a Bank which deals with key account holders explain how you will? a. Recruit sales force b. Prepare the Job Description and Specification c. Design training program for them. (Marks 15) 2. Suppose you are Sales Manager in life insurance Company, managing team of fifteen sales executives. How you will use sales force automation to improve efficiency and effectiveness of sales operation? (Marks 15) Corporate Finance 1. Suppose, a prospective client who wants to invest certain amount of money comes to you but does not know anything about ‘Time Value of Money’. So, please explain to the person the concept of ‘Time Value of Money’ in detail. 2. A limited company is considering investing a project requiring a capital outlay of Rs. 2, 00,000. Forecast for annual income after depreciation but before tax is as follows : Year | Rs. | 1 | 1,00,000 | 2 | 1,00,000 | 3 | 80,000 | 4 | 80,000 | 5 | 40,000 | Depreciation may be taken as 20% on original cost taxation at 50% of net income. You are required to evaluate the project according to each of the following methods: a) Pay back method b) Rate of return on original investment method ...

Words: 2065 - Pages: 9

Hrm 595 Week 1 Assignment; Personal Bargaining Inventory Answer Worksheet

...595 Week 1 Assignment; Personal Bargaining Inventory Answer Worksheet Purchase here http://devrycourse.com/hrm-595-week-1-assignment-personal-bargaining-inventory-answer-worksheet Product Description HRM 595 Week 1 Assignment; Personal Bargaining Inventory Answer Worksheet HRM 595 Week 1 Assignment; Personal Bargaining Inventory Answer Worksheet Purchase here http://devrycourse.com/hrm-595-week-1-assignment-personal-bargaining-inventory-answer-worksheet Product Description HRM 595 Week 1 Assignment; Personal Bargaining Inventory Answer Worksheet HRM 595 Week 1 Assignment; Personal Bargaining Inventory Answer Worksheet Purchase here http://devrycourse.com/hrm-595-week-1-assignment-personal-bargaining-inventory-answer-worksheet Product Description HRM 595 Week 1 Assignment; Personal Bargaining Inventory Answer Worksheet HRM 595 Week 1 Assignment; Personal Bargaining Inventory Answer Worksheet Purchase here http://devrycourse.com/hrm-595-week-1-assignment-personal-bargaining-inventory-answer-worksheet Product Description HRM 595 Week 1 Assignment; Personal Bargaining Inventory Answer Worksheet HRM 595 Week 1 Assignment; Personal Bargaining Inventory Answer Worksheet Purchase here http://devrycourse.com/hrm-595-week-1-assignment-personal-bargaining-inventory-answer-worksheet Product Description HRM 595 Week 1 Assignment; Personal Bargaining Inventory Answer......

Words: 444 - Pages: 2

Ma 105 Week 7 Assignment 20/20 Correct Answers

...MA 105 Week 7 Assignment 20/20 Correct Answers http://homeworklance.com/downloads/ma-105-week-7-assignment-2020-correct-answers/ QUESTION 1 Evaluate the function at the indicated value of x. Round your result to three decimal places. Function: f(x) = 0.5x Value: x = 1.7 -0.308 1.7 0.308 0.5 -1.7 QUESTION 2 Match the graph with its exponential function. y = 2-x – 3 y = -2x + 3 y = 2x + 3 y = 2x – 3 y = -2x – 3 QUESTION 3 Select the graph of the function. f(x) = 5x-1 QUESTION 4 Evaluate the function at the indicated value of x. Round your result to three decimal places. Function: f(x) = 500e0.05x Value: x=17 1169.823 1369.823 1569.823 1269.823 1469.823 QUESTION 5 Use the One-to-One property to solve the equation for x. e3x+5 = 36 x = –1/3 x2 = 6 x = -3 x = 1/3 x = 3 QUESTION 6 Write the logarithmic equation in exponential form. log8 64 = 2 648 = 2 82 = 16 82 = 88 82 = 64 864 = 2 QUESTION 7 Write the logarithmic equation in exponential form. log7 343 = 3 7343 = 2 73 = 77 73 = 343 73 = 14 3437 = 2 QUESTION 8 Write the exponential equation in logarithmic form. 43 = 64 log64 4 = 3 log4 64 = 3 log4 64 = -3 log4 3 = 64 log4 64 = 1/3 QUESTION 9 Use the properties of logarithms to simplify the expression. log20......

Words: 546 - Pages: 3

Econ 305 Intermediate Macroeconomics: Assignment 6 Answers

...ECON 305 Intermediate Macroeconomics: Assignment 6 Answers Follow Below Link to Download Tutorial http://homeworklance.com/downloads/econ-305-intermediate-macroeconomics-assignment-6-answers/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com QUESTION 1 – Openness in Goods and Financial Markets a) Explain the three types of trade that countries conduct. b) Define the nominal exchange rate of a country. Define the real exchange rate of a country. Why is the real exchange rate the appropriate price for thinking about decisions by consumers and firms about whether to buy domestic or foreign goods and services? c) Explain how the nominal exchange rate, and domestic and foreign price inflation affect the real exchange rate. d) If the domestic country’s real exchange rate (currency) depreciates, how would you expect this to affect the domestic country’s trade balance in goods and services? Explain. e) What do we mean by purchasing power parity (a theory of real and nominal exchange rates)? If the domestic country’s price level declines, what does purchasing power parity predict would tend to happen to the nominal exchange rate and foreign price level? Explain. f) What is the source of large differences between the GDP and GNP of oil exporting countries? In answering the question, explain carefully the difference between gross domestic product and gross national......

Words: 1320 - Pages: 6

Econ 305 Intermediate Macroeconomics: Assignment 6 Answers

...ECON 305 Intermediate Macroeconomics: Assignment 6 Answers Follow Below Link to Download Tutorial http://homeworklance.com/downloads/econ-305-intermediate-macroeconomics-assignment-6-answers/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com QUESTION 1 – Openness in Goods and Financial Markets a) Explain the three types of trade that countries conduct. b) Define the nominal exchange rate of a country. Define the real exchange rate of a country. Why is the real exchange rate the appropriate price for thinking about decisions by consumers and firms about whether to buy domestic or foreign goods and services? c) Explain how the nominal exchange rate, and domestic and foreign price inflation affect the real exchange rate. d) If the domestic country’s real exchange rate (currency) depreciates, how would you expect this to affect the domestic country’s trade balance in goods and services? Explain. e) What do we mean by purchasing power parity (a theory of real and nominal exchange rates)? If the domestic country’s price level declines, what does purchasing power parity predict would tend to happen to the nominal exchange rate and foreign price level? Explain. f) What is the source of large differences between the GDP and GNP of oil exporting countries? In answering the question, explain carefully the difference between gross domestic product and gross national......

Words: 1320 - Pages: 6

Econ 305 Intermediate Macroeconomics: Assignment 6 Answers

...ECON 305 Intermediate Macroeconomics: Assignment 6 Answers Follow Below Link to Download Tutorial http://homeworklance.com/downloads/econ-305-intermediate-macroeconomics-assignment-6-answers/ For More Information Visit Our Website ( http://homeworklance.com/ ) Email us At: Support@homeworklance.com or lancehomework@gmail.com QUESTION 1 – Openness in Goods and Financial Markets a) Explain the three types of trade that countries conduct. b) Define the nominal exchange rate of a country. Define the real exchange rate of a country. Why is the real exchange rate the appropriate price for thinking about decisions by consumers and firms about whether to buy domestic or foreign goods and services? c) Explain how the nominal exchange rate, and domestic and foreign price inflation affect the real exchange rate. d) If the domestic country’s real exchange rate (currency) depreciates, how would you expect this to affect the domestic country’s trade balance in goods and services? Explain. e) What do we mean by purchasing power parity (a theory of real and nominal exchange rates)? If the domestic country’s price level declines, what does purchasing power parity predict would tend to happen to the nominal exchange rate and foreign price level? Explain. f) What is the source of large differences between the GDP and GNP of oil exporting countries? In answering the question, explain carefully the difference between gross domestic product and gross national......

Words: 1320 - Pages: 6