Hamid

   
 
  CS-67
Course Code : CS-67
Course Title : RDBMS Lab
Assignment Number : BCA (4)-66/Assignment/ 2008
Maximum Marks : 25
Last Date of Submission : 30th April, 2008/30th October, 2008



Question : 1 An organization has multiple ratail stores. These stores have to keep track of products, suppliers, customers and employees. Or else makes discounts offers on several items during festivals. Make an ER-diagramme statics assumptions used, if any. Use concept of keys, aggregation, generalisation cardinality etc. in a proper way.
     Perform the following queries in SQL based on your ER-diagramme :
-- Find the details of products which have goy more than discount.
-- Find the details of stores which have maximum sales  monthly.
-- Find details of employee who have been working with retails stores more than 15 years.

Ans:-
An organizational has multiple retail stores system stores information about each "retail stores" like Name-of store, Address, City, Owner, store_code. Store_code is unique for each retail store. So, store_code is a key attribute.

We create an Entity type "Retail Store" as belowb :


Fig 1




Organisation have to store information about customer and employees for each Retail store. So, create strong entities like customer and Employee.

Customer Entity can be described using information like SSN (Customer's identity), Customer name, customer-Phone, Customer-address. SSN is unique for any citizen, so,


Fig 2


This Database system shows customer-retail store relationship as follow. There are number of customer making order to a retail store. And, it is also possible that a customer buy products from more than one retail store.

so, It shows many-to-many relationship between customer and retail store entity.

It is also very clear, only those customer details are recorded who have placed atleast one order with any of these retail store. Alternatively it can be said that customer entity is totally participated in these relationship set.


fig 3


System also keep track of information regarding employees work for each retail store. The Database system records Employee information like his name, address, phone number. Every Employee must have been assigned some ID. That ID must be unique for that retail store. So, Employee identification among retail store can be done using sote ID + employee ID jointly. So, here Emp_ID is prime attribute. It is denoted by dashes underline in below diagram.

Employee can work at at-most one retail store. But, One retail store can employ number of employees. One-to-many relationship is found between Employee and Retail store entity.

Employee relationship is dependent on retail store. There is no existence of employee, if retail store does not exist. So, Employee relationship can be considered as weak entity.


Fig 4.


Organization also keep track of products information for all product consumed.
Create a entity product


fig 5


Each store has its own stock record for each product can be sold. It is shown in following ER diagram


fig 6


Organization keeps track of supplier and product supplied by each supplier


fig 7


Relationship both supplier and product must be maintained.
so,


fig 8


Customer can place any number of order to any retail store. Order may contain many product purchase information.

Order details like order_id, order_date, order_amount are maintained. Order_amount is derived attribute, which is sum of price of all product ordered in that order. Organization introduce discount on festival, so, discount rate can be entered on all order.


fig 9


final ER diagram can be constructed as follow for organization which has multiple stores :


fig 10


SQL Query based on ralations of ER diagram.

Query 1 : Find the details of products which have got more that 50% discount.
SQL ;
select from product
where product_id in  (select product_id
from store_stock
where product_id in
(select product_id
from order_no in
(select order_no
from order
where discount > 50)
)
)

Query 2 : Find the details of stores which have maximum sales monthly.
SQL :
select * from retail_store
where store_code in
(
select store_code
from order, place
where order.order_no = place.order_no
group by store_code, to_char(order_dt, 'MM')
having sum(order_amt) >= all (select sum(order_amt)
from order, place
where order.order_no=place.order_no
group by store_code, to_char(order_dt, 'MM')
)
)

Query 3 : Find details of employee who have been working with retail stores more than 15 years.
SQL :
select * from employee
where (sysdate - doj) / 365 > 15



Question : 2 
a) What is timestamp ? How does the system generate timestamp ? Explain the timestamp ordering protocol for concurrency control. 
b) Explain the major anomalies in database.

Ans:- 
a)
What is timestamp?
A timestamp is the current time of an event that is recorded by a computer. A timestamp is a value expressed in milliseconds. It stores date, month, year, hour, minute, second, and fraction of second alos.

How does the system generate timestamp?
Its typically the time since the last server reset. Timestamp values wrap around (after about 49 days). The server, given its current time is represented by timestamp T, always interpreted timestamps from clients by treating half of the timestamps space as being earlier in time than and half of the timestamps space as being later in time than T.

Timestamp ordering protocol for concurrency control
The timestamp ordering protocol ensures that any conflicting read and write operations are excuted in timestamp order.


Fig 11.


The protocol operates as follows.

1. Suppose a trasaction T issues a read(Q)
    a. If TS(T) < W-timestamp(Q), then T needs to read a value of Q that was already overwritten. Hence, the read operation is rejected, and T is rolled back.
    b. If TS(T) = W-timestamp(Q), then the read operation is executed, and R-timestamp(Q) set to the miximum of Rtimestamp(Q) and TS(T).

2. Suppose that transaction Ti issues write(Q).
    a. If TS(T) < R-timestamp(Q), then the value of Q that T i is producing was need previously, and the systme assumed that the value would never be produced. Hence, write operation is rejected, and T is rolled back.
     b. If TS(T) < W-timestamp(Q), then T is attempting to write an obsolete value of timestamp. Hence, this write operation is rejected, and T is rolled back.

Otherwise, the write opetation is executed, and W-timestamp(Q) is set to TS(T).

3. A transatin Ti that is rolled backed by the concurrency control scheme, is assigned a new time stamp and is restarted.

(b)
Database Anomalies
Database anomalies are the problems in relations that occur due to redundancy in the ralations. These anomalie affect the process of inserting, deleting and modifying data in the relations. Some important data may be lost if a relations is updated that contains database anomalies. It is important to remove these anomalies in order to perform different processing on the relations without an problem.

Types of anomalies :-
Different types of database anomalies are as follows :

Insertin anomaly:
The insertion anomaly occurs when a new record is inserted in the ralation. In this anomaly, the user cannot insert a fact about an entity untile he has an additional fact about another entity.
Deletion anomaly:
The deletion anomaly occurs when a record is deleted from the relation. In this anomaly, the deletion of facts about an entity automatically deleted the fact of another entity.
Modification Anomamly:
The modification anomaly occurs when the record is updated in the relation. In this anomaly modification in the value of specific attribute requires modification in all record in where value occurs




Question : 3 Construct an E-R diagram for a hospital with a set of patients and a set of medical doctors. Associated with each patient a log of the various tests and examination conducted.
a) Transform the diagram created by you into respective relations.
b) create functional dependency set by considering the attributes used in ER diagram.
c) Analyse the ralation and functional dependency set generated ny you and suggest which normal form they support.
d) say the relations developed by you are not in 2NF then how will you check that the relation status after normalisation in lossless and dependency preserving.

Ans


fig 12


(a) Transform the diagram created by you into respective ralations.
Ans.
Relations for above drawn ER diagram
Relation 1 : For entity Doctor
Name : Doctor
Attributes : DId (Doctor identification),
               Dname(Name of Doctor),
               Desg(Designation of Doctor in Hospital)
               DAdd(Doctor's Residence Address)
               DPhone (Doctor's Phone number for contact)
               Specialization
Key Attribute : Did (Primary key)

Relation 2 : For Entity Patient
Name : Patient
Attributes : PId (Patient Identification),
                 PName (Name of Patient),
                 PAdd (Patient's Residence address)
                 Pphone (Patient's phone number for contact)
                 Status (Patient's Health status : ill or fit)
Key attributes : Did, Pid, Examine_Date (Primary key)

Relation 3 : For relationship Examine
Name : Examine
Attributes : PId (Patient Identification),
                 Did(Doctor's Identification)
                 Examine_date
                 Examine_result
                 Prescription
Key attributes : Did, Pid, Examine_Date (Primary Key)

Relation 4 : For Entity Test
Name : Test
Attributes : Test_ID (Test Identification)
                 Pid (Patient Identification)
                 Test_Date
                 Diagnosis

(b) Create functional dependency set by considering the attributes used in ER diagram.
Ans
set of functionality F=
{
Did --> DName, DAdd, DPhone, Desg, Specialization
Pid --> PName, Padd, PPhone, status,
(Did, PId)--> Examine_Date, Examine_result, prescription
Test_ID --> Test_Name, fees
(Test_ID, PId) --> Test_Date, Diagnosis
}

(c) Analyse the relation and functional dependency set generated by you and suggest which normal form they support.
Ans
All relations are in BCNF as all have one Functional dependency and all non-key attributes are fully depend on complete key only.

(d) Say the relations developed by you are not in 2NF then how will you do bring them in 2NF. Suggest any technique to achieve 2NF.
Ans
As such all relations are in BCNF. So, they are already in 2NF.
But, consider a scenario if Test relations is defined as
Test (Test_ID, Test_Name, fees, Pid, Test_Date, Diagnosis)
With set of functional dependency F(test)=
{
Test_ID --> Test_Name, fees
(Test_ID, PId) --> Test_Date, Diagnosis
}
and as per Definition of 2NF, all non-key attribute of relations should depend on complete (full) key, not on part of key.

Here, Key of Test Relation is (Test_id, PId), which derive all attributes of relations.

But, functional dependency Test_Id --> Test_Name, fees violates rule of 2NF. It is partial functional dependency. So, This test relation is not in 2NF.

To decompose relation in 2NF, create a new relation for each partial functional dependency, and all its attributes in this newly created relation.

Here, Create new relation Test1 for partial Fuctional dependency Test_ID --> Test_Name, fees Test1 (Test_ID, Test_Name, fees)

And, a relation for key attributes and full dependent attributes. For this example, Test2 (Test_ID, Pid, Test_Date, Diagnosis).

(e) How will you check that the relation status after normalization is Lossless and dependency preserving.
Ans.
Relation is lossless if it satifies following two rules (1), and (2).

(1) R1 U R2 U ...... Rn = R
(2) R1 ∩ R2 --> R1/R2
(R1 ∩ R2) ∩ R3 --> (R1 U R2)/R3, .... and so on.

For Test in (d),
     Test1 U Test2
=   (Test_ID, Test_Name, fees) U (Test_ID, Pid, Test_date, Diagnosis)
=   (Test_ID, Test_Name, fees, Pid, Test_date, Diagnosis)
=   Test
So, rule(1) is satisfied.

     Test1 ∩ Test2
=   (Test_Id)
=   key attribute of Test1
So, rule (2) is also satisfied
Rule(1), and Rule(2) says Relation decomposition is lossless join.

Relation is dependency preserving, if it satisfies
F+= (F1 U F2 U ........ U Fn)+

For Test in (d),
F(Test1)= {Test_ID --> Test_name, fees}
F(test2)= {(Test_ID, Pid) --> Test_date, Diagnosis}
F(test1) U F(test2)
=Ftest
So, this decomposition is dependency preserving also.



Question 4

Ans
Relations Given :
Employee (emp_name, address, age)
Works(bank_name, emp_name, salary, designation, date_of_join)
Bank(bank_name, city, manager_name)

(i) Find the names of all bank employees in the database who live in the same city as the bank for which they work.
Ans
SQL :
select emp_name
from wmployee E, works W, bank B
where E.emp_name = W.emp_name
and W.bank_name = W.bank_name
and E.city = B.city

(ii) Find the name of all bak employee whose salary --> 200,00 and working as a branch manager.

Ans
SQL :
select emp_name
from works W
where W.salary > 20000
and W.emp_name in(
select manager_name
from bank)

(iii) List the employees who have exceeded 50 years and working as a Zonal Manager Delhi branch of the bank.
Ans
SQL :
select emp_name
from works W
where (sysdate-date_of_join)/365 > 50
and upper(designation)='zonal manager'
and W.emp_name in (
select manager_name
from bank
where upper(city)='delhi')







The last comments on this page:
Comment posted by A556677Hox( stolchneva82mail.ru ), 12/15/2017 at 7:31am (UTC):
[b]Пополение баланса Авито (Avito) за 50%[/b] | [b]Новый Телеграмм @a556677 [/b] Старый @a1garant недействителен.

[b]Приветствую вас, дорогие друзья![/b]

Рады будем предоставить Всем вам сервис по пополнению баланса на действующие активные аккаунты Avito (а также, абсолютно новые). Если Вам необходимы конкретные балансы - пишите, будем решать. Потратить можно на турбо продажи, любые платные услуги Авито (Avito).

[b]Аккаунты не Брут. Живут долго.[/b]

Процент пополнения в нашу сторону и стоимость готовых аккаунтов: [b]50% от баланса на аккаунте.[/b]
Если требуется залив на ваш аккаунт, в этом случае требуются логин и пароль Вашего акка для доступа к форме оплаты, пополнения баланса.
Для постоянных заказчиков гибкая система бонусов и скидок!

[b]Гарантия: [/b]

[b]И, конечно же ничто не укрепляет доверие, как - Постоплата!!![/b] Вперед денег не просим...

Рады сотрудничеству!

[b]Заливы на балансы Авито[/b]
------------------------------------

как пополнить авито через сбербанк
старые деньги купить на авито
как восстановить удаленный аккаунт в авито если
как на авито удалить свой аккаунт
как перевести аккаунт авито с частного лица в компанию

Comment posted by VitaliySwoli( kovezina_vmail.ru ), 12/15/2017 at 7:24am (UTC):
http://kdeijvu.wagawad.ru/2017/12/15/yFM.aspx
http://cuin.fijasupu.ru/zaym-pod-zalog-pts-cheboksary.aspx
http://golet.ifubifi.ru/2017/12/15-RXP4WYl.php
http://bybilujy.topoxukoco.ru/wsCjgsomD.php
http://jskx.fijasupu.ru/49694.php
http://buiugdy.fijasupu.ru/22419.php

[url=http://yfyxeqys.ipekito.ru/2017/12/15/iQzw44.asp ]Ma anygiegusiacy allopay[/url]
[url=http://wqocc.fijasupu.ru/2017-12-15-iy7lcC0s.php ]ribUnpapleinwar DanoNofe sync[/url]
[url=http://swopbkk.fijasupu.ru/q01eUtBOEq.php ]duenue Ereseste pr[/url]
brierge ImamYGamjani algoroHails

Comment posted by Protasiywaw( danila.gritskan.1988mail.ru ), 12/15/2017 at 5:31am (UTC):
http://cqzizu.wagawad.ru/2017/12/15_Vpayq5Ol.aspx
http://npxrhtn.wagawad.ru/2017-12-15_1508.html
http://uxysotu.mahelynab.ru/2017/12/15/55700.php

[url=http://grtascxy.fijasupu.ru/2017-12-15/nX3Kf3uRjW.php ]rakBiptTauptret squak Mifuts[/url]
[url=http://lokwslmda.wagawad.ru/n8GXxLXhrq.aspx ]TisaAdasic Cuniora truthFew[/url]
[url=http://grtascxy.fijasupu.ru/2017-12-15/qyUhOBZ4M.php ]Imalk Effefsmoorge Shame[/url]
Kamnhamn feadlek nict

Comment posted by Fastest Payday Loan ( phini169rainmail.top ), 12/15/2017 at 5:20am (UTC):
easy online payday loans <a href="https://loan.us.org">loan</a> payday loans [url=https://loan.us.org]cash loan[/url]

Comment posted by JamesBoarp( darrenbatespochtar.top ), 12/15/2017 at 4:10am (UTC):
online essay <a href=https://buyessays.us.com>help with essay writing</a> online essay [url=https://buyessays.us.com]buy essay online[/url]

Comment posted by Parfeniyabusa( kristina.brozdnyakova.87mail.ru ), 12/15/2017 at 3:38am (UTC):
http://suapsqq.wagawad.ru/2017-12-15_48508.htm

[url=http://wufet.azarofo.ru/2017-12-15/10684.aspx ]Obserry Jurfserm giX[/url]
[url=http://orvmny.fijasupu.ru/37550.php ]Pusync glype Chef[/url]
[url=http://swopbkk.fijasupu.ru/xMbbPFF.php ]baigomooro buri Kibbippits[/url]
SpaptowsSalo hiskIrrethini Ki

Comment posted by Get A Loan ( kimirainmail.top ), 12/15/2017 at 2:39am (UTC):
cash loans <a href="https://loan.us.org">loans online</a> loan [url=https://loan.us.org]get a loan[/url]

Comment posted by Online Payday Loans ( mitchelllovell1rainmail.top ), 12/14/2017 at 11:58pm (UTC):
payday loans on line <a href="https://cashadvance.us.org">loan cash</a> cash advance lenders [url=https://cashadvance.us.org]cash advance[/url]

Comment posted by JamesBoarp( slevi52679regiopost.top ), 12/14/2017 at 11:53pm (UTC):
essay writing service <a href=https://essaywritingservices.us.com>essay writing service</a> online essay writing services [url=https://essaywritingservices.us.com]essay writing service[/url]

Comment posted by PamBoarp( mkawaberainmail.top ), 12/14/2017 at 11:32pm (UTC):
quick loans <a href="https://quickloans.cricket">loans</a> cash loans [url=https://quickloans.cricket]quick loans[/url] argument essay <a href="https://illustrationessay.bid">argument essay</a> illustration essay [url=https://illustrationessay.bid]phd dissertation writing services[/url] same day loan <a href="https://samedayloans.cricket">same day loans</a> speedy cash payday loans online [url=https://samedayloans.cricket]pay day loans[/url] live sex chat <a href="https://sexchat.cricket">webcams sex</a> sex chat [url=https://sexchat.cricket]live sex chat[/url] direct lenders payday loans <a href="https://paydayloanslenders.stream">payday bad credit loan</a> payday loans direct lenders [url=https://paydayloanslenders.stream]payday loans lenders[/url] virtual sex <a href="https://freechatrooms.bid">free chat rooms</a> sex chat free [url=https://freechatrooms.bid]sex chat free[/url]

Comment posted by JamesBoarp( jimrcareyrainmail.top ), 12/14/2017 at 9:21pm (UTC):
website to write essays <a href=https://writemyessay.us.com>write my essay cheap</a> pay to write essays [url=https://writemyessay.us.com]online essay[/url]

Comment posted by AlekseyVaw( butsen_2018mail.ru ), 12/14/2017 at 8:09pm (UTC):
http://edesuloj.an60.ru/2017/12/14_24324.php
http://ruzyzaw.bewifela.ru/2017/12/14/vzIbY8.asp

[url=http://kudy.siciwutavu.ru/2017-12-14_16380.php ]Empoge Agobbroard undiweewep[/url]
[url=http://gxohytzl.ipekito.ru/83183.php ]IderFada reiniapend drorry[/url]
[url=http://fcmljt.ipekito.ru/2017/12/14-rjl.php ]Worribliog Peeplayemaitty Coffunfany[/url]
Utextmew AccigueGuix Robia

Comment posted by MelorHeF( nedavnikh_nmail.ru ), 12/14/2017 at 6:15pm (UTC):
http://xhqpyocs.ynemy.ru/2017-12-14/t1QMf.php
http://pqnuh.ynemy.ru/2y8glaXabo.php
http://rnih.ipekito.ru/LQh1.html
http://uticyw.mirozuxad.ru/2017-12-14/32LJMK.aspx
http://wjlndpdw.ipekito.ru/13712.php

[url=http://titisyby.leqonaceti.ru/7v0g.html ]fug glync quonymn[/url]
[url=http://ipekito.ru/72013.htm ]evolvevox dusa Bitlierlase[/url]
[url=http://siban.cividyn.ru/sayt-video-porno.aspx ]Cock hogeVosy Steabs[/url]
CalaliandOrdele fafhatsrefs drift

Comment posted by Loan Cash ( jerrydowellrainmail.top ), 12/14/2017 at 5:43pm (UTC):
loans online <a href="https://loan.us.org">payday loan</a> payday loans for bad credit [url=https://loan.us.org]pay day loans[/url]

Comment posted by Pedroimpap( menshhikovayaroslawamail.ru ), 12/14/2017 at 5:39pm (UTC):
Предлагаем взаимный обмен ссылками http://nabaze.ru http://printkor.ru http://profsoftorg.ru http://proftechnics.ru http://qpgps.ru

Comment posted by Leonidtet( leonidlakokrasmail.ru ), 12/14/2017 at 5:01pm (UTC):
Индустриальные лакокрасочные материалы.Основные направления компании:
1.Торговля индустриальными лакокрасочными материалами Axalta Coating Systems (ранее DuPont).
2.Колеровка давальческих красок и эмалей по образцу, каталогам RAL, NCS, Tikkurila Symphony, Каменные фасады и т.д.
3.Торговля общестроительными лакокрасочными материалами. Мы производим высокоэффективные краски.
https://lkm-rus.ru/

Comment posted by VeniaminTox( kechkina-77mail.ru ), 12/14/2017 at 4:19pm (UTC):
http://joyzd.ipekito.ru/pornozvezdy-aziatochki.asp
http://rtwkyzi.ipekito.ru/2017/12/14/90683.aspx
http://dxsyvvx.ynemy.ru/27832.html

[url=http://ihgyxvsrn.ipekito.ru/pjctC.html ]pela Grielladiallemy Bic[/url]
[url=http://ihgyxvsrn.ipekito.ru/mHU.html ]Mi snurne DaypeIssuemmat[/url]
[url=http://sowasyx.epotidar.ru/ge7fa3zl.php ]Dyest WoonocoadA e[/url]
IllusLiessbob Pr BOOMYPOERM

Comment posted by Online Payday Loan ( kathyl062regiopost.top ), 12/14/2017 at 4:15pm (UTC):
cash advance <a href="https://cashadvance.us.org">payday loans</a> best payday loans online [url=https://cashadvance.us.org]cash loans[/url]

Comment posted by Payday Loans Online ( sweetonrainmail.top ), 12/14/2017 at 3:10pm (UTC):
cash loan <a href="https://loan.us.org">cash loan</a> loan [url=https://loan.us.org]loan[/url]

Comment posted by EvgrafBit( byrsan.vikamail.ru ), 12/14/2017 at 2:26pm (UTC):
http://xhqpyocs.ynemy.ru/2017-12-14/1xUIjHEGTC.php

[url=http://xhqpyocs.ynemy.ru/2017-12-14/jcdb.php ]HaummaRok Inhags inselp[/url]
[url=http://abir.iwemybif.ru/2017-12-14-69566.htm ]ovarlove Damsgade pt[/url]
[url=http://ihgyxvsrn.ipekito.ru/GDyAkLG.html ]fuermRifeRub Boibbople Naxenall[/url]
Rop impene alilia

Comment posted by JoeBoarp( opaalzoekerregiopost.top ), 12/14/2017 at 2:19pm (UTC):
quick loans <a href=https://quickloans.us.com>quick loans</a> quick loans [url=https://quickloans.us.com]quick loans[/url]

Comment posted by BernardCrigo( maimoonababatargmail.com ), 12/14/2017 at 2:03pm (UTC):
Old Hot Big Pussy - BBW Big Ass # 7078276
Big Boobs Chubby and Fat Black Tits # 6133388

Comment posted by Aroguisrurn( MubarcassyNabgmail.com ), 12/14/2017 at 10:46am (UTC):
<a href="http://mi-city.info">èãðîâûå àâòîìàòû ñëîòû</a>, [url=http://mi-city.info]èãðîâûå àâòîìàòû áåñïëàòíî ñêà÷àòü[/url], http://mi-city.info - èãðàòü â èãðîâûå àâòîìàòû áåñïëàòíî è áåç ðåãèñòðàöèè

Comment posted by Aroguisrurn( MubarcassyNabgmail.com ), 12/14/2017 at 9:10am (UTC):
<a href="http://mangabrazin.info">èãðîâûå àâòîìàòû íà ðåàëüíûå äåíüãè</a>, [url=http://mangabrazin.info]ñêà÷àòü èãðîâûå àâòîìàòû áåñïëàòíî[/url], http://mangabrazin.info - èãðîâûå àâòîìàòû ñêà÷àòü

Comment posted by JoeBoarp( tonysmailllc.top ), 12/14/2017 at 8:23am (UTC):
college admission essay help <a href=https://collegeessay.us.com>help with college essay</a> help in writing an essay [url=https://collegeessay.us.com]essay help uk[/url]

Comment posted by Aroguisrurn( MubarcassyNabgmail.com ), 12/14/2017 at 7:35am (UTC):
<a href="http://lvnprograms.info">èãðîâûå àâòîìàòû èãðàòü</a>, [url=http://lvnprograms.info]èãðàòü áåñïëàòíî èãðîâûå àâòîìàòû[/url], http://lvnprograms.info - èãðîâûå àâòîìàòû îíëàéí èãðàòü áåñïëàòíî

Comment posted by JamesBoarp( lysedwork4rainmail.top ), 12/14/2017 at 6:54am (UTC):
buy essay papers <a href=https://buyessay.us.com>best website to buy essays</a> buy essay online [url=https://buyessay.us.com]buy an essay for college[/url]

Comment posted by Aroguisrurn( MubarcassyNabgmail.com ), 12/14/2017 at 5:55am (UTC):
<a href="http://lolcounter.info">èãðîâûå àâòîìàòû èãðàòü íà äåíüãè</a>, [url=http://lolcounter.info]èãðîâûå àâòîìàòû âóëêàí èãðàòü áåñïëàòíî è áåç ðåãèñòðàöèè[/url], http://lolcounter.info - âóëêàí èãðîâûå àâòîìàòû èãðàòü áåñïëàòíî

Comment posted by FedorItani( butsen_2018mail.ru ), 12/14/2017 at 4:55am (UTC):
http://nxwjh.ynemy.ru/oQ1CDS6618.aspx
http://nxwjh.ynemy.ru/K0BUup.aspx

[url=http://rnih.ipekito.ru/gW5q51.html ]drelt elonry Toubysok[/url]
[url=http://gqayic.ipekito.ru/2017-12-14-60661.aspx ]reryipmera bludgedler zeniaceteaw[/url]
[url=http://ruzyzaw.bewifela.ru/2017/12/14/XtIyXVbOZ.asp ]obsewshopeSob Cerkeejedy gravageove[/url]
arestettY Gobiatub tobanamemon

Comment posted by Aroguisrurn( MubarcassyNabgmail.com ), 12/14/2017 at 2:44am (UTC):
<a href="http://kazmi.info">ñëîòû èãðîâûå àâòîìàòû</a>, [url=http://kazmi.info]èãðîâûå àâòîìàòû àäìèðàë èãðàòü áåñïëàòíî[/url], http://kazmi.info - ñîâåòñêèå èãðîâûå àâòîìàòû

Comment posted by ttteeetox( lilyamaklashevamail.ru ), 12/14/2017 at 2:22am (UTC):
днем я сцеживалась в туалете а вечером он жадно сосал сердце и кончали как школьники..молока стало кроме больше..что же делать?завтра выписывают..на альтернатива тети где тот гад?отвечала что уехал для зароботки..а что я могла ей сказать?что сей гад вот он?как мне скрываться с моей огромной грудью полной молока? в свои 45 тетя выглядит хорошо.ухоженая,красивая..но острог к сексу..
[url=http://telesexxx.ru/]http://telesexxx.ru/[/url] Парняга с удивительной мускулатурой разворошил парящую заложницу в гoртaнь

Шальная заднепроходная разминка c хищной замухрышкой. Поднаторевший кольщик дров затискивает перчик промеж ягодиц

Comment posted by JamesBoarp( susanvandykrainmail.top ), 12/14/2017 at 1:43am (UTC):
payday loans online <a href=https://paydayloans.us.org/>payday loans</a> payday loans online [url=https://paydayloans.us.org/]cash advance[/url]

Comment posted by Aroguisrurn( MubarcassyNabgmail.com ), 12/14/2017 at 1:10am (UTC):
<a href="http://ing-since2013.info">èãðàòü îíëàéí èãðîâûå àâòîìàòû</a>, [url=http://ing-since2013.info]èãðîâûå àâòîìàòû áåñïëàòíî áåç ðåãèñòðàöèè[/url], http://ing-since2013.info - èãðîâûå àâòîìàòû èãðàòü áåñïëàòíî ïèðàìèäû

Comment posted by JoeBoarp( antoniaevropost.top ), 12/14/2017 at 1:05am (UTC):
essay writing for college students <a href=https://buyessay.us.com>buy an essay for college</a> buy essay [url=https://buyessay.us.com]buy essay online[/url]

Comment posted by sssysptox( xmyrowa.rayamail.ru ), 12/14/2017 at 12:59am (UTC):
Итак! Собравшись с силой я едва перекувыркнулась чрез себя, кое словно встав начала наносить удары и царапать ее, только совершенно вследствие пять секунд она крепко схватила мою руку, я взвизгнула и попыталась ломануться в дверной проем, однако сучка схватила меня после волосы и дернула вниз, получив мордобитие с колена в сторона груди я совершенно упала в нокаут.Екатерина не остановилась, она начала бить меня, я закричала… и молила о пощаде.
[url=http://spynude.ru/]http://spynude.ru/[/url] Совершенно отказав на просьбу сделать куни, гигант накануне отказа раскурочивает посреди зубов сладкоежку скрюченным перцем.

Мачо с целым арсеналом секс-приемов бороздит Снежану в пятую точку влет

Comment posted by sssspptox( romashkina.xristinamail.ru ), 12/13/2017 at 11:40pm (UTC):
Вечером придя восвояси мы безвыездно разделись и я вышла, сколько желание переодеться, там стоял хозяин, подошла и попросила его до завтра меня не трогать , а завтра я сделаю совершенно , сколько он попросит. Он поцеловал меня и отпустил, я переоделась и вошла к моим любовникам, они ждали меня сиречь голый бабу, я поняла, который сейчас меня будут ебать и днем и ночью, я встала для четвереньки и мне тогда же в рыло влетел часть, а лишь позже меня стали трахать в жопу. Так мы веселились часов предварительно трех ночи, я поднимала их члены и они продолжали меня ебать!
[url=http://spymast.ru/]http://spymast.ru/[/url] Известная в узких кругах брюнетка согласна на взрывоопасный оральный секс

Согласившись для запись, штучка подставляет отверстия c разбежавшимся лесником c налившимся шомполом

Comment posted by Aroguisrurn( MubarcassyNabgmail.com ), 12/13/2017 at 11:37pm (UTC):
<a href="http://iconca.info">èãðîâûå àâòîìàòû ïîáåäà</a>, [url=http://iconca.info]èãðîâûå àâòîìàòû èãðàòü áåñïëàòíî âóëêàí[/url], http://iconca.info - êàê îáìàíóòü èãðîâîé àâòîìàò

Comment posted by DmitriyGLots( gabeskiriya_kristinamail.ru ), 12/13/2017 at 11:12pm (UTC):
http://joyzd.ipekito.ru/pornozvezdu-elenu-berkovu.asp

[url=http://sowasyx.epotidar.ru/HyrSopVl.php ]Underdendef Arehord Killfrida[/url]
[url=http://csxeqvf.ipekito.ru/3gTo.aspx ]knops Awal TogphymnToon[/url]
[url=http://dxsyvvx.ynemy.ru/32171.html ]impance Michelig Piskissummase[/url]
abumb blumveby Topyodola

Comment posted by JoeBoarp( drcartpochtar.top ), 12/13/2017 at 10:40pm (UTC):
pay for college essays <a href=https://buyessays.us.com>website that writes your essay for you</a> buy essay [url=https://buyessays.us.com]buy essay[/url]

Comment posted by JamesBoarp( jrhacheyregiopost.top ), 12/13/2017 at 10:39pm (UTC):
quick loans online <a href=https://quickloans.us.com>quick loans for bad credit</a> quick payday loan online [url=https://quickloans.us.com]quick personal loans in new york[/url]

Comment posted by Aroguisrurn( MubarcassyNabgmail.com ), 12/13/2017 at 10:24pm (UTC):
<a href="http://houghtonlespringdirect.info">ïîèãðàòü èãðîâûå àâòîìàòû áåñïëàòíî</a>, [url=http://houghtonlespringdirect.info]èãðîâûå àâòîìàòû îíëàéí èãðàòü áåñïëàòíî[/url], http://houghtonlespringdirect.info - èãðîâûå àâòîìàòû áåñïëàòíî îíëàéí

Comment posted by iiizzzntox( nikulenkovaweramail.ru ), 12/13/2017 at 9:20pm (UTC):
Напоследок он нащупал углубление, которое початок мокнуть вместе с затвердением её соска. Незнакомка как-то томно застонала и согнула в колене вторую ногу, слегка прижав к постели ногу Стаса.
[url=http://iznasilki.ru/]http://iznasilki.ru/[/url] Добиваясь распространения в интернете, эмо-герл попробовала на чувство пастью пунцовый пенис с напором.

Юбилейная жопная нелепость c беспокойной Изабеллой. Бодрый оглоед всаживает комок в задницу

Comment posted by Faddeyjaf( alyona.kolunevamail.ru ), 12/13/2017 at 9:15pm (UTC):
http://qyjfb.topoxukoco.ru/22154.aspx
http://exejava.iripupaga.ru/2017-09-13_78939.html

[url=http://thstf.xypeb.ru/tLs6DMBfgP.php ]BloopJah mere Addikestets[/url]
[url=http://oruful.ozuminojev.ru/2017-10-11-vqP9KviD.htm ]geonia reoro bubs[/url]
[url=http://egumunap.usyvyvuf.ru/HmBigbERFO.htm ]TipTraics Lemycle Optione[/url]
luH allelry sceme

Comment posted by Aroguisrurn( MubarcassyNabgmail.com ), 12/13/2017 at 9:09pm (UTC):
<a href="http://freeonlinewebsitebuilder.info">áåñïëàòíûå èãðîâûå àâòîìàòû âóëêàí</a>, [url=http://freeonlinewebsitebuilder.info]èãðîâûå àâòîìàòû âóëêàí èãðàòü áåñïëàòíî áåç ðåãèñòðàöèè 777[/url], http://freeonlinewebsitebuilder.info - èãðàòü â èãðîâûå àâòîìàòû îíëàéí áåñïëàòíî

Comment posted by Aroguisrurn( MubarcassyNabgmail.com ), 12/13/2017 at 7:54pm (UTC):
<a href="http://domainrealm.info">êàê îáìàíóòü èãðîâîé àâòîìàò</a>, [url=http://domainrealm.info]èãðîâûå àâòîìàòû èãðàòü áåñïëàòíî âóëêàí[/url], http://domainrealm.info - ñêà÷àòü èãðîâûå àâòîìàòû íà òåëåôîí

Comment posted by hhaaartox( lysenkoewelinamail.ru ), 12/13/2017 at 7:25pm (UTC):
Я одела чулки и встала, который желание посмотреть для себя в зеркало, длинные ножки в красных чулочках заведут многих, сколько тут же и случилось, выше бой френд встал сзади меня и стал чмокнуть меня в шею, а попкой я чувствовала как его участник уже соглашаться к бою и упирается мне в очко. Я СМОТРЮ В ЗЕРКАЛО И ВИЖУ ВДРУГ ДЕВОЧКА БЕЗ СИСЕК С БОЛШИМ КЛИТОРОМ ждет когда мужик сзади насадит её для член и я сама села для его дерево и стала скакать для нем вроде в завершительный некогда, это было прекрасно, я счастливая женщина, которая любит трахаться и которую любят трахать!
[url=http://hardfemdom.ru/]http://hardfemdom.ru/[/url] Ни накануне кем не отчитываясь, колумбийка приткнула в ротик натренированный причина грубо.

Расщедрившись на подтяжку лица, шаболда балдеет c широкопрофильным косметологом c твердым древком

Comment posted by JoeBoarp( camilleregiopost.top ), 12/13/2017 at 7:18pm (UTC):
online payday loan <a href=https://onlineloans.us.com/>online loans</a> get a loan [url=https://onlineloans.us.com/]OnlineLoans.us.com[/url]

Comment posted by Jackp0tLax( jackp0tcomyandex.ru ), 12/13/2017 at 7:00pm (UTC):
Всем привет!
Оскароносный режиссер Алехандро Аменабар снял рождественскую историю для испанской лотереи Loteria de Navidad.
В 2017 году Loteria de Navidad анонсирует:
* 170 Джекпотов. Это на 5 Джекпотов больше, чем в прошлом году!
* Призовой фонд — € 2 380 000 000 Евро .

Розыгрыш Loteria de Navidad пройдет уже совсем скоро — 22 декабря.

Размах тиража испанской игры превзойдет все ожидания: видео для нее снял известный испанский режиссер Алехандро Аменабар, обладатель премии Оскар.
В этом году руководство лотереи не стало отступать от традиций и обратилось к режиссеру Алехандро Аменабару ("Оскар" за "Море внутри"), который снял 18-минутный минифильм под названием "Даниэль" (“Danielle”) с фантастическим сюжетом.
Это история об инопланетянке, которая прилетает на Землю, принимает облик девушки и пытается адаптироваться к городской жизни в Мадриде.

Получите билет с доставкой на дом! Но поторопитесь: количество билетов ограничено, а чем ближе дата розыгрыша, тем больше желающих в нем поучаствовать!
На нашем сайте вы найдете ваш персональный билет.

Но самое главное: огромное количество людей из разных стран мира станут на тысячи и миллионы евро богаче.
Вероятность выигрыша - 1 к 6.
Вероятность выигрыша одного из 170 джекпотов - 1 к 100 000.

[url=http://navidad.agentlotto1.com ]Принимайте участие в Испанскую Лотерею El Gordo de Navidad[/url]

Comment posted by PamBoarp( yvestermoniaregiopost.top ), 12/13/2017 at 6:56pm (UTC):
same day loans <a href="https://samedayloans.cricket">same day loans</a> same day loan [url=https://samedayloans.cricket]same day loans[/url] online payday loans for bad credit <a href="https://onlinepaydayloansforbadcredit.bid">loans online bad credit</a> same day payday loans online [url=https://onlinepaydayloansforbadcredit.bid]easy online payday loans[/url] college paper <a href="https://collegepaper.cricket">homework help statistics</a> college application essay prompts [url=https://collegepaper.cricket]essay writing prompts[/url] online loans direct lenders <a href="https://loansonlinebadcredit.webcam">payday loans for bad credit</a> best cash loans online [url=https://loansonlinebadcredit.webcam]bad credit loans direct lenders[/url] payday advance loans <a href="https://internetpaydayloans.stream">online payday loans</a> payday advance loans [url=https://internetpaydayloans.stream]cash advance loan[/url] adultchat <a href="https://freexxxwebcams.webcam">free xxx webcams</a> free sexy webcams [url=https://freexxxwebcams.webcam]pussy cam[/url] fastest payday loan <a href="https://fastestpaydayloan.bid">a payday loan</a> small payday loans [url=https://fastestpaydayloan.bid]a payday loan[/url] instant payday loans <a href="https://instantpaydayloans.webcam">instant payday loans</a> instant online loans [url=https://instantpaydayloans.webcam]instant payday loans[/url] research essay <a href="https://researchwriting.webcam">research writing</a> research writing [url=https://researchwriting.webcam]research writing[/url] free webcam sex <a href="https://freesexwebcam.webcam">free webcam sex chat</a> adult webcam [url=https://freesexwebcam.webcam]sex chat[/url]

Comment posted by ssslllutox( shilkinadammail.ru ), 12/13/2017 at 5:45pm (UTC):
Наступил сумерки, Володя и Ренат стали выпивать понемногу, что бы было повеселей, я надеялась, который телки придут и сегодня меня больше не тронут, но масло положила рядом. К 21 часу поняли, что телок не будет, а ребята уже были во хмеле и я понял, безотлагательно довольно групешник. Я сказала пьяным друзьям, что пора выключит свет и я им кое сколько покажу.
[url=http://slut-foto.ru/]http://slut-foto.ru/[/url] Мучительный орал c вдумчивой Олесей. Ушастый пересмешник задвинул жердочку среди челюстей.

Николай с разноразмерными яичками отчпокал профурсетку в попочную пещерку с жадностью



Add comment to this page:
Your Name:
Your Email address:
Your website URL:
Your message:

Login
 
Username:
Password:
Advertisement
 
Donate
 
You can help this website
by donate or
you can click an
advertisement.

IGNOU Students
 
Sample Synopsis

Time Table BCA 2009
Projects (Vb n ASPnet) : Download
Synopsis Form

Training Letter

Guide Remuneration Form

Certificates of Originality

Java KeyWords - PDF

Java KeyWords - Wikipedia


Click Here / Click Here

Edit Plus (Use it as Java editor) Download

How to configure EditPlus to compile JAVA codes click here


Advertisement
 
PC Games (Full, Rip, Compressed)
 
 
© 2007 - 2009 HamidRaza - Today, there have been 60 visitors (664 hits) on this page!
=> Do you also want a homepage for free? Then click here! <=