How are bridge tables delivered to classify groups of dimension records associated to
简述桥接表是如何将维度表和事实表进行关联的?
简述桥接表是如何将维度表和事实表进行关联的?
假设你在管理一座营运成本基本上为零的收费桥。过桥需求的Q由P=15-(1/2)Q给出。
(1)画出过桥服务的需求曲线。
(2)如果不收费,会有多少人通过该桥?
(3)如果过桥费是5美元,相对应的消费者剩余的损失是多少?
(4)该收费桥的运营方打算把价格上升至7美元。在这一相对较高的价格上,会有多少人通过该桥?该收费桥的收益是上升还是下降了?从你的答案出发,你对需求弹性有何判断?
(5)求与价格从5美元上升到7美元相对应的消费者剩余的损失。
Suppose you are in charge of a toll bridge that costs essentially nothing to operate. The demand for bridge crossing Q is given by P=15-(1/2)Q.
a. Draw the demand curve for bridge crossings.
b, How many people would cross the bridge if there were no toll?
C. What is the loss of consumer surplus associated with a bridge toll of $ 5?
d. The toll - bridge operator is considering an increase in the toll to $7. Al this higher price ,how many people would cross the bridge? Would the toll bridge revenue increase or decrease? What does your answer tell you about the elasticity of demand?
e. Find the lost consumer surplus associated with the increase in the price of the toll from $5to $7.
Question8: How can I list all California authors regardless of
whether they have written a book?
In database pubs, have a table authors and titleauthor , table authors has a
column state, and titleauhtor have books each author written.
CA behalf of california in table authors.
Question9: How can I get a list of the stores that have bought both
'bussiness' and 'mod_cook' type books?
In database pubs, use three table stores,sales and titles to implement this
equestment.
ow I want to get the result as below:
stor_id stor_name
------- ----------------------------------------
...
7896 Fricative Bookshop
...
...
...
Why we use index in database? How many indexes is the maximum in one
table as your suggestion?
Question10: How can I list non-contignous data?
In database pubs, I create a table test using statement as below, and I
insert several row as below
create table test
(id int primary key )
go
insert into test values (1 )
insert into test values (2 )
insert into test values (3 )
insert into test values (4 )
insert into test values (5 )
insert into test values (6 )
insert into test values (8 )
insert into test values (9 )
insert into test values (11)
insert into test values (12)
insert into test values (13)
insert into test values (14)
insert into test values (18)
insert into test values (19)
go
Now I want to list the result of the non-contignous row as below,how can I
do it?
Missing after Missing before
------------- --------------
6 8
9 11
...
Question6: How can I add row numbers to my result set?
In database pubs, have a table titles , now I want the result shown as
below,each row have a row number, how can you do that?
Result:
line-no title_id
----------- --------
1 BU1032
2 BU1111
3 BU2075
4 BU7832
5 MC2222
6 MC3021
7 MC3026
8 PC1035
9 PC8888
10 PC9999
11 PS1372
12 PS2091
13 PS2106
14 PS3333
15 PS7777
16 TC3218
17 TC4203
18 TC7777
Question11: How can I list all book with prices greather than the
average price of books of the same type?
In database pubs, have a table named titles , its column named price mean
the price of the book, and another named type mean the type of books.
Now I want to get the result as below:
type title price
------------
--------------------------------------------------------------------------------
---------------------
business The Busy Executive's Database
Guide 19.9900
...
...
...
...
Question3:Can you use a SQL statement to finding duplicate
values!
How can I find authors with the same last name?
You can use the table authors in datatabase pubs. I want to get the result as
below:
Output:
au_lname number_dups
---------------------------------------- -----------
Ringer 2
(1 row(s) affected)
Question4:Can you create a cross-tab report in my SQL Server!
How can I get the report about sale quality for each store and each quarter
and the total sale quality for each quarter at year 1993?
You can use the table sales and stores in datatabase pubs.
Table Sales record all sale detail item for each store. Column store_id is the id of
each store, ord_date is the order date of each sale item, and column qty is the
sale qulity. Table stores record all store information.
I want to get the result look like as below:
Output:
stor_name Total Qtr1 Qtr2 Qtr3 Qtr
4
---------------------------------------- ----------- ----------- ----------- -----------
-----------
Barnum's 50 0 50 0 0
Bookbeat 55 25 30 0 0
Doc-U-Mat: Quality Laundry and
Books 85 0 85 0 0
Fricative Bookshop 60 35 0 0 25
Total 250 60 165 0 25
Tom is (21) little brother, he is only five and (22) know how to read (23)write.
One day Mary sees her little brother at the table with (24)pen(25)his hand , and a big piece of paper in front of him.
" (26) are you doing Tom ? "she (27). " I'm (28)a letter to my friend, Mike." Says Tom.
" But how can you?" says Mary. " You even don't know how to (29)" " Well, '' says Tom, " It doesn't matter, because Mike doesn't (30) how to read.
()21.A.Mary’s B.Marys C.Marys’ D.Maries
()22.A.not B.don’t C.doesn’t D.isn’t
()23.and B.or C.to D./
()24.a B.an C.the D./
()25.on B.of C.at D.in
()26.Whose B.How C.What D.Who
()27.asks B.ask C.toask D.asking
()28.write B.writing C.writing D.writes
()29.write B.writing C.read D.reading
()30.knows B.know C.writes D.write