(8 )
1. . 10-8-2-16-10. 10 =102.
2. . 10-8-2-16-10. 10 =103.
3. . 10-8-2-16-10. 10 =104.
4. . 10-8-2-16-10. 10 =105.
5. . 10-8-2-16-10. 10 =106.
6. . 10-8-2-16-10. 10 =107.
7. . 10-8-2-16-10. 10 =108.
8. . 10-8-2-16-10. 10 =109.
9. . 10-8-2-16-10. 10 =110.
10. . 10-8-2-16-10. 10 =111.
11. . 10-8-2-16-10. 10 =112.
12. . 10-8-2-16-10. 10 =113.
13. . 10-8-2-16-10. 10 =114.
- . 10-8-2-16-10. 10 =115.
(8 )
1. a, b, c d , ?
2. a, b, c d
, ? .
3. a, b, c d
, ? .
4. a, b, c d
, ? .
5. a, b, c d
, ? .
6. a, b, c d
, ? .
|
|
7. a, b, c d
, ? .
8. a, b, c d
, ? .
9. a, b, c d
, ? .
10. a, b, c d
, ? .
11. a, b, c d
, ? .
12. a, b, c d
, ? .
13. a, b, c d
, ? .
14. a, b, c d
, ? .
(8 )
1:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
ORDERS (OrdersDate) , 31 2014 . .
2:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
, . .
3:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
|
|
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
, 15 2015 . .
4:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
CUSTOMER_GOLUTVIN CUSTOMER_GOLUTVIN (ID, CompanyName, LastName, FirstName, Phone Fax), , .
5:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
CUSTOMER_ ORDERS CUSTOMER_ ORDERS (ID, IDcustomer, Status), , .
6:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
ORDERS_ITEM ORDERS_ITEM (IDorders, ID.item), .
7:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
|
|
(ID, , , , ) }.
CUSTOMER_COMPANY CUSTOMER_COMPANY (CompanyName, LastName, FirstName, ID), , . .
8:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
, - _. .
9:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
(ID, Description, OnHand, Reoder), , . .
10:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
STOCK_REODER STOCK_REODER (ID, Description, OnHand, Reoder), , . Description.
11:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
|
|
(ID, , , , ) }.
(, , ), _ 10000 . .
12:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
(, , ), _ 30000 . .
13:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
(, , ), -, __. .
14:
:
CUSTOMER (ID, CompanyName, LastName, FirstName, Address, City, Phone, Fax);
ORDERS (ID, IDcustomer, OrdersDate, ShipDate, PaidDate, Status);
ITEM (ID, IDorders, IDstock, Quantity, Total);
STOCK (ID, UnitPrice, OnHand, Reoder, Description).
{ (ID, , , , , , , );
(ID, ID, , , , );
(ID, ID, ID, , );
(ID, , , , ) }.
(, , ) Id 145 207. .
(8 )
1.
IP- IP-: 192.168.1.64/26
2.
IP-: 192.168.10.192/26. 4 . IP- .
3.
LAN1, LAN2 LAN3 1, 2 3 . IP-: LAN1 192.168.35.197/28, LAN2 - 192.168.35.213/28, LAN 3 192.168.35.230/28. IP- .
4.
LAN1, LAN2 LAN3 1, 2 3 . IP-: LAN1 192.168.35.197/28, LAN2- 192.168.35.213/28, LAN 3 192.168.35.230/28. IP- .
5.
IP-: 192.168.10.192/26. 2 . IP- .
6.
LAN1, LAN2 LAN3 1, 2 3 . IP-: LAN1 192.168.135.67/28, LAN2- 192.168.135.90/28, LAN 3 192.168.135.102/28. IP- .
7.
IP- IP-: 192.168.1.64/28
8.
IP- IP-: 192.168.168.252/30.
|
|
9.
LAN1, LAN2 1 2 . IP- : LAN1 192.168.135.67/28, LAN2- 192.168.135.213/26. IP- .
10.
IP- IP-: 192.168.1.64/27
11.
IP- IP-: 192.168.168.200/29.
12.
IP- 192.168.19.98 192.168.19.132. , , 255.255.255.240.
13.
192.168.1.0/24. 8 . .
14.
IP- 192.168.19.198/26 192.168.19.232/26. , .
(8 )
1. A B. | |
2. . | |
3. 100- 220 . , 2,93 . 1 -. | |
4. 220 1 2 . , ? | |
5. - , . R, 0,2 . | |
6. , . | |
7. (U = 12 , r = 1 ) (U = 12 , r = 1 ) . . | |
8. (36 , 60 ) 220 50 . | |
9. . ( 220 ). | |
10. 220 , . . | |
11. , , . | |
12. , : , , . | |
13. 1000 , 200 . R, . | |
14. , ( ) t = 0 L 1 L 2. . |