哥几个承情，关于作业，拉兄弟一把！~~
- 主题发起人 1010
- 开始时间
Controversial
新手上路
- 注册
- 2005-03-30
- 消息
- 717
- 荣誉分数
- 0
- 声望点数
- 0
他的秘密:smokin:
*My-Lotos*
〓天之禁区〓
- 注册
- 2005-01-30
- 消息
- 931
- 荣誉分数
- 0
- 声望点数
- 0
哪儿去了~？
HeroKiller
新手上路
- 注册
- 2004-10-10
- 消息
- 2,873
- 荣誉分数
- 1
- 声望点数
- 0
列出来看看
*My-Lotos*
〓天之禁区〓
- 注册
- 2005-01-30
- 消息
- 931
- 荣誉分数
- 0
- 声望点数
- 0
聪明
1010
新手上路
- 注册
- 2004-05-31
- 消息
- 5,569
- 荣誉分数
- 0
- 声望点数
- 0
COMP 1001 Winter 2005
Assignment #5
Due: March 31, 2005 (4:00 p.m.)
Part 1
Create a directory on your disk called Paradox and set it up as your Working Directory.
You are going to create a library database to keep track of students borrowers that do not return books on time, the books they borrow, and the time period that these books are overdue.
a) Create a Patrons table with the following fields:
Patron Number (e.g.. 0000000000A)
Student Number a 6 digit student number
Last Name
First Name
Date of Birth
Status (U for undergraduate or G for graduate)
Department a 2 digit department code (e.g.. 95 for Computer Science, 29 for Linguistics, 49 for Psychology)
Assign appropriate types, and, if necessary, sizes and keys. Save this table as "Patrons.db".
b) Create a Books table with the following fields:
Call Number (e.g.. RN.12345)
Title
Author
Date of publication
Type (e.g.. 95 for Computer Science books, 29 for Linguistics Books, 49 for Psychology books)
Assign appropriate types, sizes, and keys. Save as "Books.db".
c) Create a Records table with the following fields:
Patron Number
Call Number
Overdue Period 0-50 (The number of days the book is overdue)
Note that there is an Overdue Period for EVERY book that a patron borrowed. (Remember, this is the library's black book).
Assign appropriate types, sizes and keys.
Save this table as "Records.db".
d) Enter data for the above three tables following the conditions given below.
For the Patrons table there must be...
at least 10 students
at least 4 graduate students
there should be 4 people from computer science department (code 95), 2 from Linguistics (code 29) and 4 in Psychology (code 49).
For the books table there must be...
at least 30 different books
In the Records table...
the patron numbers and call numbers should be valid Patron Numbers from the Patrons table and the Call Numbers should be valid numbers from the Books table
each patron should have at least 3 book entries in the Records table for 3 different books. That is, each student must have at least 3 overdue books in order to be on this black list. Make up the number of days in the overdue period, ensuring that they are between 0 and 50.
Using a validity check, ensure that status (in Patrons table) is either U or G, and that only a two-digit number is in the department field.
--------------------------------------------------------------------------------
Part 2
In this part of the assignment, you will perform 12 different queries on the tables above.
Define a query on the Patrons table that will display the Patron Number, Student Number, Last Name, First Name and Department of all students in Linguistics. Save this query as "Linguistics.qbe".
Define a query on the Patron table to display all the fields for students who are in linguistics or computer science. Save this query as "LingComp.qbe".
Define a joined query on the Patrons, Books and Records tables that displays the Patron Number, Student Number, Last Name, First Name, book Call Numbers, book Titles and book Overdue Periods for all students. Note that each student should appear once for each book taken (hence, a student may appear many times in the query). Save this query as "Borrowers.qbe".
Define a query that retrieves all the linguistics or computers science books borrowed by all students in psychology or linguistics and displays the Patron Number, Student Number, both names, book Call Number, book Name and the Overdue Period for the book. The answer table should be sorted by the student's Family Name and by the book Call Number. Save this query as "Sort.qbe".
Define a query on the Records table that retrieves the Patron Numbers, Student Numbers, and Names of students, and calculates the overdue period average, the number of books borrowed and the minimum and maximum number of days for each borrower. Instead of displaying the first and last names in two separate fields, combine them into a single field. The name should be the first name followed by last name with a space in between. Save this as "Days.qbe". (Hint: use CALC with the AVERAGE, COUNT, MIN and MAX summary operators. There is also a SUM operator)
Define a query on the Patrons table to display all the fields for students whose family name starts with M. Save this as "Ms.qbe"
Define a query on the Patrons table that will display the Patron Number, Student Number and Last name of all graduate students in computer science. Save this as "Grad.qbe"
Define a query on the Patrons table to display all the fields for students whose given name sound like Tom (Hint: use LIKE). Save this as "Tom.qbe"
Define a query on the Patrons table to display the Patron Number, Student Number, Last name, Status, and Department of students who are undergraduate or who are in psychology. Save this as "UnderG.qbe"
Define a query on the Patron table that displays all the information for students who are born between January 1, 1962 and December 31, 1977. Save this as "BDays.qbe"
Define a query that retrieves all the books for a single Patron Number (make sure the Patron Number you choose exists in the table) and displays the Student Number, Call Number, and Title for each book borrowed by that student. Save this query as "Names.qbe". (Hint: you will need to join two tables)
Define a query to display all the student information sorted by the student's Last name in descending order. Save this as "SortLast.qbe".
Assignment #5
Due: March 31, 2005 (4:00 p.m.)
Part 1
Create a directory on your disk called Paradox and set it up as your Working Directory.
You are going to create a library database to keep track of students borrowers that do not return books on time, the books they borrow, and the time period that these books are overdue.
a) Create a Patrons table with the following fields:
Patron Number (e.g.. 0000000000A)
Student Number a 6 digit student number
Last Name
First Name
Date of Birth
Status (U for undergraduate or G for graduate)
Department a 2 digit department code (e.g.. 95 for Computer Science, 29 for Linguistics, 49 for Psychology)
Assign appropriate types, and, if necessary, sizes and keys. Save this table as "Patrons.db".
b) Create a Books table with the following fields:
Call Number (e.g.. RN.12345)
Title
Author
Date of publication
Type (e.g.. 95 for Computer Science books, 29 for Linguistics Books, 49 for Psychology books)
Assign appropriate types, sizes, and keys. Save as "Books.db".
c) Create a Records table with the following fields:
Patron Number
Call Number
Overdue Period 0-50 (The number of days the book is overdue)
Note that there is an Overdue Period for EVERY book that a patron borrowed. (Remember, this is the library's black book).
Assign appropriate types, sizes and keys.
Save this table as "Records.db".
d) Enter data for the above three tables following the conditions given below.
For the Patrons table there must be...
at least 10 students
at least 4 graduate students
there should be 4 people from computer science department (code 95), 2 from Linguistics (code 29) and 4 in Psychology (code 49).
For the books table there must be...
at least 30 different books
In the Records table...
the patron numbers and call numbers should be valid Patron Numbers from the Patrons table and the Call Numbers should be valid numbers from the Books table
each patron should have at least 3 book entries in the Records table for 3 different books. That is, each student must have at least 3 overdue books in order to be on this black list. Make up the number of days in the overdue period, ensuring that they are between 0 and 50.
Using a validity check, ensure that status (in Patrons table) is either U or G, and that only a two-digit number is in the department field.
--------------------------------------------------------------------------------
Part 2
In this part of the assignment, you will perform 12 different queries on the tables above.
Define a query on the Patrons table that will display the Patron Number, Student Number, Last Name, First Name and Department of all students in Linguistics. Save this query as "Linguistics.qbe".
Define a query on the Patron table to display all the fields for students who are in linguistics or computer science. Save this query as "LingComp.qbe".
Define a joined query on the Patrons, Books and Records tables that displays the Patron Number, Student Number, Last Name, First Name, book Call Numbers, book Titles and book Overdue Periods for all students. Note that each student should appear once for each book taken (hence, a student may appear many times in the query). Save this query as "Borrowers.qbe".
Define a query that retrieves all the linguistics or computers science books borrowed by all students in psychology or linguistics and displays the Patron Number, Student Number, both names, book Call Number, book Name and the Overdue Period for the book. The answer table should be sorted by the student's Family Name and by the book Call Number. Save this query as "Sort.qbe".
Define a query on the Records table that retrieves the Patron Numbers, Student Numbers, and Names of students, and calculates the overdue period average, the number of books borrowed and the minimum and maximum number of days for each borrower. Instead of displaying the first and last names in two separate fields, combine them into a single field. The name should be the first name followed by last name with a space in between. Save this as "Days.qbe". (Hint: use CALC with the AVERAGE, COUNT, MIN and MAX summary operators. There is also a SUM operator)
Define a query on the Patrons table to display all the fields for students whose family name starts with M. Save this as "Ms.qbe"
Define a query on the Patrons table that will display the Patron Number, Student Number and Last name of all graduate students in computer science. Save this as "Grad.qbe"
Define a query on the Patrons table to display all the fields for students whose given name sound like Tom (Hint: use LIKE). Save this as "Tom.qbe"
Define a query on the Patrons table to display the Patron Number, Student Number, Last name, Status, and Department of students who are undergraduate or who are in psychology. Save this as "UnderG.qbe"
Define a query on the Patron table that displays all the information for students who are born between January 1, 1962 and December 31, 1977. Save this as "BDays.qbe"
Define a query that retrieves all the books for a single Patron Number (make sure the Patron Number you choose exists in the table) and displays the Student Number, Call Number, and Title for each book borrowed by that student. Save this query as "Names.qbe". (Hint: you will need to join two tables)
Define a query to display all the student information sorted by the student's Last name in descending order. Save this as "SortLast.qbe".
1010
新手上路
- 注册
- 2004-05-31
- 消息
- 5,569
- 荣誉分数
- 0
- 声望点数
- 0
Economics 1000A
Winter Term 2005
Instructor: Anna V. Shkuropat
Assignment No. 1.
Note: 1) Please hand in this Assignment to your TA by the end of your second tutorial.
2) This Assignment is worth 4 % of the total (50%) grade allocated for this second half of the course.
1. Show the differences between the GDP deflator and the consumer price index. Illustrate with an example of a hypothetical economy (include the same hypothetical goods, which are produced and consumed in the economy, such as food, transportation, health services). (Hints: Assume hypothetical closed economy, suggest necessary data, perform all steps of calculation of GDP deflator and CPI, compare results, and provide explanations.) (10 points)
2. How do you think the basket of goods and services you buy differs from the basket bought by the typical Canadian household and typical Ontario household? Do you think you face a higher or lower inflation rate? Why? (You can obtain the data at the Web site of Statistics Canada.) (10 points)
3. Suppose income per person in country A in 1975 was $2000 and growth rates were 3 % per year. In 1985 a civil war destroyed some capital stock and labour resources, so country A’s average growth rate decreased in 1985-2000 to 0.5% per year. How much is the decrease in living standards (GDP per person) in 2000 because of the war, other things equal? (Provide calculations and your line of reasoning.) (10 points)
4. Suppose the government borrows $10 billion more next year than this year.
a) Using a graph representing the market for loanable funds, explain what happens to the interest rate and investment. To private saving? To public saving? To national saving? Compare the size of the changes to the $10 billion of extra government borrowing.
b) How does the elasticity of supply of loanable funds affect the size of these changes? How does the elasticity of demand for loanable funds affect the size of these changes?
c) Suppose households believe that greater government borrowing today implies higher taxes to pay off the government debt in the future. What does this belief do to private saving and the supply of loanable funds today? Does it increase or decrease the effects you discussed in part (a)? (10 points)
Total: (40 points)
Winter Term 2005
Instructor: Anna V. Shkuropat
Assignment No. 1.
Note: 1) Please hand in this Assignment to your TA by the end of your second tutorial.
2) This Assignment is worth 4 % of the total (50%) grade allocated for this second half of the course.
1. Show the differences between the GDP deflator and the consumer price index. Illustrate with an example of a hypothetical economy (include the same hypothetical goods, which are produced and consumed in the economy, such as food, transportation, health services). (Hints: Assume hypothetical closed economy, suggest necessary data, perform all steps of calculation of GDP deflator and CPI, compare results, and provide explanations.) (10 points)
2. How do you think the basket of goods and services you buy differs from the basket bought by the typical Canadian household and typical Ontario household? Do you think you face a higher or lower inflation rate? Why? (You can obtain the data at the Web site of Statistics Canada.) (10 points)
3. Suppose income per person in country A in 1975 was $2000 and growth rates were 3 % per year. In 1985 a civil war destroyed some capital stock and labour resources, so country A’s average growth rate decreased in 1985-2000 to 0.5% per year. How much is the decrease in living standards (GDP per person) in 2000 because of the war, other things equal? (Provide calculations and your line of reasoning.) (10 points)
4. Suppose the government borrows $10 billion more next year than this year.
a) Using a graph representing the market for loanable funds, explain what happens to the interest rate and investment. To private saving? To public saving? To national saving? Compare the size of the changes to the $10 billion of extra government borrowing.
b) How does the elasticity of supply of loanable funds affect the size of these changes? How does the elasticity of demand for loanable funds affect the size of these changes?
c) Suppose households believe that greater government borrowing today implies higher taxes to pay off the government debt in the future. What does this belief do to private saving and the supply of loanable funds today? Does it increase or decrease the effects you discussed in part (a)? (10 points)
Total: (40 points)
HeroKiller
新手上路
- 注册
- 2004-10-10
- 消息
- 2,873
- 荣誉分数
- 1
- 声望点数
- 0
TOO HARD for me, help ya up
