Microsoft SQL server 2008 T-SQL fundamentals

Terms and Conditions of Purchase from Bookbot

1. General provisions
   1.1 These Terms and Conditions of Purchase (the ‘Terms and Conditions’) of Knihobot s.r.o. (english website Bookbot), Company ID No.: 054 00 651, with its registered office at Dukelských hrdinů 359/21, Holešovice, 170 00 Prague 7, registered in the Commercial Register maintained by the Municipal Court in Prague, Section C, Entry 289573 (‘Bookbot’), regulate mutual rights and obligations arising from a purchase contract entered into in compliance with Section 2079 et seq. of Act No. 89/2012 Coll., the Civil Code (‘Purchase Contract’).

1.2 The provisions hereof are an integral part of the Purchase Contract.

1. Goods and their price
   2.1 Under the Purchase Contract, Bookbot as the seller undertakes to hand over to the buyer an item that is the subject of purchase and to allow the buyer to acquire the ownership title to the item, and the buyer undertakes to take over the item and pay the purchase price to Bookbot as the seller.

2.2 The item to be purchased shall be understood to be, in particular, books, magazines and other items that Bookbot normally trades (‘Goods’), and which are displayed in the offer of Bookbot’s e-shop available at www.bookbot.com (‘e-shop’).

2.3 All the Goods offered in the e-shop are used, for that reason, they are subject to Section 2167 et seq. of the Act No. 89/2012 Coll., the Civil Code.

2.4 The price of the Goods displayed in the e-shop is inclusive of VAT. The price of the Goods does not include the cost of postage or any cash on delivery or payment costs charged by the external providers of such services.

1. Non-binding reservation and personal collection at Bookbot/Knihobot branch
   3.1 The buyer can reserve the Goods offered in the e-shop without incurring any obligations and collect them in person at a selected Bookbot branch after Bookbot confirms the reservation. The buyer is obliged to properly inspect the Goods when collecting them and check them for any defects. The buyer acquires the ownership title to the Goods at the moment they take over the Goods in person and pay the purchase price.

3.2 The Purchase Contract entered into under Article 3.1 hereof cannot be withdrawn from within the meaning of Article 5 hereof.

1. Ordering Goods and carriage of Goods
   4.1 The buyer can have the Goods offered in the e-shop transported to their destination by a carrier. In such an event, the Purchase Contract is entered into once Bookbot confirms the order of Goods.

4.2 The Purchase Contract entered into pursuant to Article 4.1 hereof may be withdrawn from within the meaning of Article 5 hereof.

4.3 The cost of carriage of the Goods to the buyer shall be borne by the buyer unless otherwise decided by Bookbot. The current price list for postage and cash-on-delivery is available on Bookbot’s website HERE.

1. Withdrawal from the Purchase Contract
   5.1 If the Purchase Contract is entered into remotely, i.e., in the manner defined in Article 4 hereof, the buyer shall be entitled to withdraw from the Contract within fourteen days even without giving a reason.

5.2 The buyer shall inform Bookbot of the withdrawal from the Purchase Contract by email to info@bookbot.com before the expiry of the fourteen-day period from the date of the Goods takeover.

5.3 Following a call from Bookbot, the buyer shall be obliged to send or hand over to Bookbot the Goods received from Bookbot within fourteen days of the call from Bookbot. The time limit shall be deemed to have been met if the buyer hands over the Goods to a carrier no later than on the last day of the time limit referred to in the previous sentence. The costs associated with the return of the Goods shall be borne by the buyer.

5.4 If the buyer withdraws from the Purchase Contract, Bookbot shall refund the buyer without undue delay, however, no later than within fourteen days of the withdrawal from the Purchase Contract, all funds received from the buyer under the Purchase Contract, including the costs of delivery. Bookbot will only refund the buyer in a different way than their payment method to Bookbot if the buyer consents to it and if Bookbot does not incur any other costs.

5.5 The buyer shall be held liable for any reduction in value of the Goods as a result of handling the Goods in a manner different from the one that is necessary to familiarise oneself with the nature and properties of the Goods, including their functions.

1. Rights from defective performance
   6.1 Goods shall be considered defective if they are not delivered in the agreed quantity, quality and design.

6.2 The buyer shall inspect the Goods upon takeover and check the quality and quantity of the Goods.

6.3 The buyer’s right from defective performance arises out of a defect that the Goods have at the moment the liability for damage passes onto the buyer even if it demonstrates itself later. The buyer shall not have rights from defective performance in the event they should have identified the defect as early as during the Contract conclusion if they had paid usual attention to the Goods. In addition, the buyer shall not have rights from defective performance in the event of usual wear and tear or defects and damage clearly documented during the sale of the Goods.

6.4 Once the buyer discovers a defect in the Goods, they shall be obliged to inform Bookbot by email without undue delay. If the buyer does not report the defect in the Goods in due time, they shall lose the right to withdraw from the Contract.

6.5 Bookbot shall be obliged to issue to the buyer at their request a written confirmation of its obligations from defective performance to the scope defined in Section 2166 of Act No. 89/2012 Coll., the Civil Code.

6.6 If Bookbot deems it necessary, the buyer is obliged to present the claimed Goods for assessment of the claim. Bookbot shall assess the claim within 14 days of receipt of the claimed Goods and inform the buyer of the claim settlement within this time limit.

6.7. The buyer is entitled to exercise its rights from defective performance in respect of used Goods within 12 months of the sale of the Goods.

1. Receipt
   7.1 Bookbot will send the receipt to the buyer’s email address that the buyer provided when completing the order. By placing an order, the buyer expressly agrees to this form of issuing a receipt.

7.2 Bookbot will inform the buyer about the order processing, availability and unavailability of the Goods to the email address and mobile number provided by the buyer when completing the order.

1. Out-of-court settlement of consumer disputes
   8.1 In the event of a consumer dispute under the Purchase Contract between Bookbot and the buyer who is a consumer, and if the dispute cannot be settled by agreement, the buyer may file a motion to out-of-court settlement of the dispute with a designated entity for out-of-court settlement of consumer disputes, which is the Czech Trade Inspection Authority, Central Inspectorate – ADR Department, Štěpánská 15, 120 00 Prague 2, email: adr@coi.cz, web: https://www.coi.cz/informace-o-adr.

8.2 Consumers can also use the online dispute resolution platform set up by the European Commission at http://ec.europa.eu/consumers/odr/.

1. Final provisions
   9.1 All arrangements between Bookbot and the buyer are governed by the laws of the Czech Republic. If the relationship established by the Contract contains an international element, the parties agree that the relationship shall be governed by the laws of the Czech Republic.

9.2 Bookbot may amend the Terms and Conditions.

9.3 Customer support contact details are indicated in the e-shop bookbot.com

The address for delivery by email is: info@bookbot.com

phone number: +49 78 195 633 044 (daily from 8 a.m. to 8 p.m.). Available in English, German and Czech

Any questions, suggestions, comments or complaints can be handled at info@bookbot.com.

These Terms and Conditions take effect on 10 March 2023.

If you are a consumer you can withdraw from the contract in accordance with the following. Consumer means any natural person who is acting for purposes which are outside his trade, business, craft or profession.

Information regarding the right of withdrawal

Statutory right to withdraw

You have the right to withdraw from this contract within 14 days without giving any reason.

The withdrawal period will expire after 14 days from the day on which you acquire, or a third party other than the carrier and indicated by you acquires, physical possession of the last good or the last lot or piece.

To exercise the right of withdrawal, electronically fill in and submit a clear statement on our website, under "My Purchases" in "My Account". We will communicate to you an acknowledgement of receipt of such a withdrawal on a durable medium (e.g. by e-mail) without delay.

To meet the withdrawal deadline, it is sufficient for you to send your communication concerning your exercise of the right of withdrawal before the withdrawal period has expired.

Effects of withdrawal

If you withdraw from this contract, we will reimburse to you all payments received from you, including the costs of delivery (except for the supplementary costs arising if you chose a type of delivery other than the least expensive type of standard delivery offered by us).

We may make a deduction from the reimbursement for loss in value of any goods supplied, if the loss is the result of unnecessary handling by you.

We will make the reimbursement without undue delay, and not later than 14 days after the day on which we are informed about your decision to withdraw from this contract.

We will make the reimbursement using the same means of payment as you used for the initial transaction, unless you have expressly agreed otherwise; in any event, you will not incur any fees as a result of such reimbursement.

We may withhold reimbursement until we have received the goods back, or you have supplied evidence of having sent back the goods, whichever is the earliest.

You shall send back the goods or hand them over to Bookbot, K Pérovně 1677/9, Areál Logicor, 10200, Praha, Czech Republic, without undue delay and in any event not later than 14 days from the day on which you communicate your withdrawal from this contract to us. The deadline is met if you send back the goods before the period of 14 days has expired. You will have to bear the direct cost of returning the goods. You are only liable for any diminished value of the goods resulting from the handling other than what is necessary to establish the nature, characteristics and functioning of the goods.

Exceptions to the right of withdrawal

The right of withdrawal does not apply to:

1. The delivery of newspapers, journals or magazines with the exception of subscription contracts; and
2. The supply of digital content which is not supplied on a tangible medium (e.g. on a CD or DVD) if you accepted when you placed your order that we could start to deliver it, and that you could not withdraw once delivery had started.

Shipping costs fully cover all US customs tariffs and charges. No additional payment will be required by the US authorities.

Privacy Policy

1. General provisions
   1.1 This privacy policy (the ‘Policy’) explains how Knihobot s.r.o. (english website: Bookbot), Company ID No.: 054 00 651, with its registered office at Dukelských hrdinů 359/21, Holešovice, 170 00 Prague 7, registered in the Commercial Register maintained by the Municipal Court in Prague, Section C, Entry 289573 (‘Bookbot’ or ‘We’) collects and treats the personal data of users of the portal available at www.bookbot.com (the ‘e-shop’) and/or of individuals interested in the mediation of sale by Bookbot via the e-shop.

1.2 This Policy describes what personal data Bookbot processes, how and what it uses it for, and how it keeps your personal data secure. This Policy constitutes information within the meaning of Article 13 of Regulation (EU) 2016/679 of the European Parliament and of the Council on the protection of natural persons with regard to the processing of personal data and on the free movement of such data (the ‘GDPR’).

1.3 Under this Policy, personal data is processed in the form of any information that can identify a specific natural person or information that directly relates to such an identified person. The data processed by Bookbot under this Policy may include other information (e.g. anonymised) that is not personal data.

1. Who is the controller of your personal data?
   2.1 The controller of your personal data is Knihobot s.r.o. (Bookbot) If you have any comments regarding the processing of your personal data or if you wish to exercise your rights, you can contact us by email at info@bookbot.com.

2.2 Bookbot has not appointed a data protection officer.

1. Why do we process your personal data?
   3.1 We mainly process your personal data because the processing of your personal data is necessary for the performance of a contract concluded between us (in particular a purchase contract or a commissioning contract under which we arrange the sale of your goods). Without the provision of the necessary data, the contract cannot be concluded and properly performed.

3.2 In other cases, we only process your personal data for the purposes for which you have given us consent, typically in a web form or within communication with us. The provision of personal data is voluntary, however, without the provision of personal data we cannot deal with requirements and inform you of the measures taken.

1. What personal data do we process?
   4.1 We process personal data that you provide to us by filling in order forms or requests for mediation of sale. We process your email, name, surname, telephone number, bank account, information about the condition of books and other goods you give to use for resale, or your company name, VAT number, registered office address or other information you provide to us.

4.2 When you visit the e-shop, we also passively process technical information such as IP address, type of internet browser, operating system or other technical metadata such as time zone settings. Information about your behaviour in the e-shop may be stored in an anonymised form for analysis in order to improve the functionality of the e-shop.

4.3 We also use information about your activity in the e-shop and the offers you have viewed to ensure better e-shop operation and marketing. This data is collected automatically by means of tools using so-called cookies. If you have cookies enabled on your device, this data is also collected via these files. If you do not agree with the processing of cookies, please disable them in your browser settings. Please note that disabling cookies will deactivate some basic functions, such as adding items to your basket.

4.4 Aggregated data and passively collected information can be used to produce general statistical summaries. These summaries are anonymised and do not contain your personal data within the meaning of the GDPR.

1. For what purposes do we process personal data?
   5.1 The processing of your personal data is necessary for the performance of a contractual relationship based on a purchase, commissioning or other contract and the exercise of the rights and obligations arising from them; without the provision of this data, the contract cannot be concluded and performed by us.

5.2 We also process your personal data for the purpose of keeping records of e-shop customers and records of goods sold, administration of the user account of a registered e-shop customer, customer care (handling complaints or claims, handling queries regarding the e-shop, etc.), customer evaluation of the e-shop (if you provide it), the performance of marketing activities (e.g. displaying advertisements, remarketing, conducting analyses, etc.) and, in specified cases, direct marketing. We also use information about your activity in the e-shop to ensure better functionality of the e-shop.

5.3 We may also process your personal data for the purpose of check by public authorities.

1. What about automated decision-making and profiling?
   6.1 Your personal data is not subject to automated decision-making, including profiling within the meaning of Article 22(1) and (4) of the GDPR.

2. Who do we pass your personal data to?
   7.1 We mainly use your personal data for our internal purposes.

7.2 However, we are unable to provide all the necessary services ourselves, so we also use the services of specialised companies (e.g. carriage of goods, analytics, accounting, etc.). We only provide these companies with the information they need to perform their specific duties, which may include, but in most situations does not include, your personal information. These service providers are only entitled to use this information as necessary to provide their services to us and they do so on the basis of a duly concluded contract for the processing of personal data.

7.3 We are currently cooperating with the following companies:

Česká pošta, s.p., Politických vězňů 909/4, 225 99 Praha 1 Česká republika;
Zásilkovna s.r.o., Lihovarská 1060/12, 190 00 Praha 9;
General Logistics Systems Czech Republic, s.r.o., Průmyslová 5619/1, CZ-58601 Jihlava;
Facebook Ireland Limited, 4 Grand Canal Square, Grand Canal Harbour Dublin 2, Ireland;
Google Ireland Limited, Gordon House, Barrow Street, Dublin, D04 E5W5, Dublin; https://business.safety.google/privacy/
Mailgun Technologies, Inc., 535 Mission St., San Francisco, CA 94105;
Amazon Web Services EMEA SARL, 38 avenue John F. Kennedy, L-1855 Luxembourg;
Heureka Shopping s.r.o., Karolinská 650/1, 186 00 Praha 8 – Karlín;
vpsFree.cz z.s., Nad Dalejským údolím 2699/9, 155 00 Praha-Stodůlky;
Levné knihy a.s., Do Čertous 2660/16, 193 00 Praha 9.
Trusted Shops AG – Cologne, Subbelrather Straße 15c, 50823 Cologne, Nemecko
Pikito a.s., Výtvarná 1023/4, Ruzyně, 161 00 Praha 6, Czech Republic
DoDo Group SE, Pernerova 702/39, Karlín, 186 00 Praha 8, Czech Republic
Deutsche Post DHL Group, Charles-de-Gaulle-Straße 20, 53113 Bonn, Germany
Österreichische Post AG, Rochusplatz 1, 1030 Vienna, Austria
Pošta bez hranic, třída 3. května 910, 763 02 Zlín – Malenovice, Česká republika
EM Autodoprava s. r. o., Ul. Jána Hajdóczyho 5835/22, Trnava 917 01, Slovakia
Airway spol. s r.o., Švecova 2383/2, 149 00, Praha 4, Czech Republic
Adyen International B.V., Simon Carmiggeltstraat 6-50, 1011 DJ, Netherlands
ComGate Payments, a.s. Gočárova třída 1754/48b, Pražské Předměstí, 500 02 Hradec Králové
BloomReach, Inc.82 Pioneer Way Mountain View, CA 94041
Thalia Book & Media GmbH, Country Road 41, 4010 Linz
Slovak Parcel Service s.r.o., Senecká cesta 1, 900 28 Ivanka pri Dunaji
7.4 We do not pass personal data to any third party for the purpose of further processing.

1. Where do we retain the data?
   8.1 The data is retained on our backup servers and in the data centre of vpsFree.cz z.s. The data centre security is fully GDPR compliant. All communication between your device and our web servers is encrypted.

2. How long do we process your personal data?
   9.1 We process your personal data subject to your consent until your consent is withdrawn, but for a maximum period of 3 years from the time of consent. We retain your personal data that we process on the basis of another legal reason for the entire duration of the contractual relationship and subsequently for a period of 3 years.

9.2 After the above periods, we only retain or otherwise process personal data if required to do so by applicable law.

9.3 We will anonymise or delete your personal data from our databases and systems once the period for which we are required to retain it by law has expired.

1. What are your rights?
   10.1 We process your data transparently, fairly, in accordance with the GDPR and generally binding legal regulations. You have the right to access your data and the right to have it corrected or completed. In cases of processing of your data for which you have given consent, you have the right to withdraw this consent at any time. In addition, you have the right to request the transfer of your personal data, the right to be informed of a breach of security of your personal data and, under certain conditions, the right to have certain personal data that we process in relation to you erased.

10.2 You can exercise your right to access your data and your other rights by sending a request electronically to info@bookbot.com, as well as any other questions. If you believe that the processing of your data is not in order, you can file a complaint with the Office for Personal Data Protection.

This Privacy Policy takes effect on 1 October 2021.