text:
- Ethelbert Lang
- 4 years ago
- Views:
1 6 QUERY-BY-EXAMPLE (QBE) Example is always more efficacious than precept. Samuel Johnson 6.1 INTRODUCTION Query-by-Example (QBE) is another language for querying (and, like SQL, for creating and modifying) relational data. It is different from SQL, and from most other database query languages, in having a graphical user interface that allows users to write queries by creating example tables on the screen. A user needs minimal information to get started and the whole language contains relatively few concepts. QBE is especially suited for queries that are not too complex and can be expressed in terms of a few tables. QBE, like SQL, was developed at IBM and QBE is an IBM trademark, but a number of other companies sell QBE-like interfaces, including Paradox. Some systems, such as Microsoft Access, offer partial support for form-based queries and reflect the influence of QBE. Often a QBE-like interface is offered in addition to SQL, with QBE serving as a more intuitive user-interface for simpler queries and the full power of SQL available for more complex queries. An appreciation of the features of QBE offers insight into the more general, and widely used, paradigm of tabular query interfaces for relational databases. This presentation is based on IBM s Query Management Facility (QMF) and the QBE version that it supports (Version 2, Release 4). This chapter explains how a tabular interface can provide the expressive power of relational calculus (and more) in a userfriendly form. The reader should concentrate on the connection between QBE and domain relational calculus (DRC), and the role of various important constructs (e.g., the conditions box), rather than on QBE-specific details. We note that every QBE query can be expressed in SQL; in fact, QMF supports a command called CONVERT that generates an SQL query from a QBE query. We will present a number of example queries using the following schema: Sailors(sid: integer, sname: string, rating: integer, age: real) 177
2 178 Chapter 6 Boats(bid: integer, bname: string, color: string) Reserves(sid: integer, bid: integer, day: dates) The key fields are underlined, and the domain of each field is listed after the field name. We introduce QBE queries in Section 6.2 and consider queries over multiple relations in Section 6.3. We consider queries with set-difference in Section 6.4 and queries with aggregation in Section 6.5. We discuss how to specify complex constraints in Section 6.6. We show how additional computed fields can be included in the answer in Section 6.7. We discuss update operations in QBE in Section 6.8. Finally, we consider relational completeness of QBE and illustrate some of the subtleties of QBE queries with negation in Section BASIC QBE QUERIES A user writes queries by creating example tables. QBE uses domain variables, asin the DRC, to create example tables. The domain of a variable is determined by the column in which it appears, and variable symbols are prefixed with underscore ( ) to distinguish them from constants. Constants, including strings, appear unquoted, in contrast to SQL. The fields that should appear in the answer are specified by using the command P., which stands for print. The fields containing this command are analogous to the target-list in the SELECT clause of an SQL query. We introduce QBE through example queries involving just one relation. To print the names and ages of all sailors, we would create the following example table: P. N P. A A variable that appears only once can be omitted; QBE supplies a unique new name internally. Thus the previous query could also be written by omitting the variables Nand A, leaving just P. in the sname and age columns. The query corresponds to the following DRC query, obtained from the QBE query by introducing existentially quantified domain variables for each field. { N,A I,T( I,N,T,A Sailors)} A large class of QBE queries can be translated to DRC in a direct manner. (Of course, queries containing features such as aggregate operators cannot be expressed in DRC.) We will present DRC versions of several QBE queries. Although we will not define the translation from QBE to DRC formally, the idea should be clear from the examples;
3 Query-by-Example (QBE) 179 intuitively, there is a term in the DRC query for each row in the QBE query, and the terms are connected using. 1 A convenient shorthand notation is that if we want to print all fields in some relation, we can place P. under the name of the relation. This notation is like the SELECT * convention in SQL. It is equivalent to placing a P. in every field: P. Selections are expressed by placing a constant in some field: P. 10 Placing a constant, say 10, in a column is the same as placing the condition =10. This query is very similar in form to the equivalent DRC query { I,N,10,A I,N,10,A Sailors} We can use other comparison operations (<, >, <=,>=, ) as well. For example, we could say < 10 to retrieve sailors with a rating less than 10 or say 10 to retrieve sailors whose rating is not equal to 10. The expression 10 in an attribute column is the same as 10. As we will see shortly, under the relation name denotes (a limited form of) in the relational calculus sense Other Features: Duplicates, Ordering Answers We can explicitly specify whether duplicate tuples in the answer are to be eliminated (or not) by putting UNQ. (respectively ALL.) under the relation name. We can order the presentation of the answers through the use of the.ao (for ascending order) and.do commands in conjunction with P. An optional integer argument allows us to sort on more than one field. For example, we can display the names, ages, and ratings of all sailors in ascending order by age, and for each age, in ascending order by rating as follows: P. P.AO(2) P.AO(1) 1 The semantics of QBE is unclear when there are several rows containing P. or if there are rows that are not linked via shared variables to the row containing P. We will discuss such queries in Section
4 180 Chapter QUERIES OVER MULTIPLE RELATIONS To find sailors with a reservation, we have to combine information from the Sailors and the Reserves relations. In particular we have to select tuples from the two relations with the same value in the join column sid. Wedothisbyplacingthesamevariable in the sid columns of the two example relations. Id P. S Id To find sailors who have reserved a boat for 8/24/96 and who are older than 25, we could write: 2 Id P. S > 25 Id 8/24/96 Extending this example, we could try to find the colors of Interlake boats reserved by sailors who have reserved a boat for 8/24/96 and who are older than 25: Id > 25 Id B 8/24/96 Boats bid bname color B Interlake P. As another example, the following query prints the names and ages of sailors who have reserved some boat that is also reserved by the sailor with id 22: Id P. N Id B 22 B Each of the queries in this section can be expressed in DRC. For example, the previous query can be written as follows: { N Id,T,A,B,D1,D2( Id,N,T,A Sailors Id,B,D1 Reserves 22,B,D2 Reserves)} 2 Incidentally, note that we have quoted the date value. In general, constants are not quoted in QBE. The exceptions to this rule include date values and string values with embedded blanks or special characters.
5 Query-by-Example (QBE) 181 Notice how the only free variable (N) is handled and how Id and B are repeated, as in the QBE query. 6.4 NEGATION IN THE RELATION-NAME COLUMN We can print the names of sailors who do not have a reservation by using the command in the relation name column: Id P. S Id This query can be read as follows: Print the sname field of Sailors tuples such that there is no tuple in Reserves with the same value in the sid field. Note the importance of sid being a key for Sailors. In the relational model, keys are the only available means for unique identification (of sailors, in this case). (Consider how the meaning of this query would change if the Reserves schema contained sname which is not a key! rather than sid, and we used a common variable in this column to effect the join.) All variables in a negative row (i.e., a row that is preceded by ) must also appear in positive rows (i.e., rows not preceded by ). Intuitively, variables in positive rows can be instantiated in many ways, based on the tuples in the input instances of the relations, and each negative row involves a simple check to see if the corresponding relation contains a tuple with certain given field values. The use of in the relation-name column gives us a limited form of the set-difference operator of relational algebra. For example, we can easily modify the previous query to find sailors who are not (both) younger than 30 and rated higher than 4: Id P. S Id > 4 < 30 This mechanism is not as general as set-difference, because there is no way to control the order in which occurrences of are considered if a query contains more than one occurrence of. To capture full set-difference, views can be used. (The issue of QBE s relational completeness, and in particular the ordering problem, is discussed further in Section 6.9.) 6.5 AGGREGATES Like SQL, QBE supports the aggregate operations AVG., COUNT., MAX., MIN., andsum. By default, these aggregate operators do not eliminate duplicates, with the exception
6 182 Chapter 6 of COUNT., which does eliminate duplicates. To eliminate duplicate values, the variants AVG.UNQ. and SUM.UNQ. must be used. (Of course, this is irrelevant for MIN. and MAX.) Curiously, there is no variant of COUNT. that does not eliminate duplicates. Consider the instance of Sailors shown in Figure 6.1. On this instance the following sid sname rating age 22 dustin rusty horatio Figure 6.1 An Instance of Sailors query prints the value 38.3: A P.AVG. A Thus, the value 35.0 is counted twice in computing the average. To count each age only once, we could specify P.AVG.UNQ. instead, and we would get QBE supports grouping, as in SQL, through the use of the G. command. To print average ages by rating, we could use: G.P. A P.AVG. A To print the answers in sorted order by rating, we could use G.P.AO or G.P.DO. instead. When an aggregate operation is used in conjunction with P., orthereisauseofthe G. operator, every column to be printed must specify either an aggregate operation or the G. operator. (Note that SQL has a similar restriction.) If G. appears in more than one column, the result is similar to placing each of these column names in the GROUP BY clause of an SQL query. If we place G. in the sname and rating columns, all tuples in each group have the same sname valueandalsothesamerating value. We consider some more examples using aggregate operations after introducing the conditions box feature.
7 Query-by-Example (QBE) THE CONDITIONS BOX Simple conditions can be expressed directly in columns of the example tables. more complex conditions QBE provides a feature called a conditions box. For Conditions boxes are used to do the following: Express a condition involving two or more columns, suchas R/ A > 0.2. Express a condition involving an aggregate operation on a group, for example, AVG. A > 30. Notice that this use of a conditions box is similar to the HAVING clause in SQL. The following query prints those ratings for which the average age is more than 30: G.P. A Conditions AVG. A > 30 As another example, the following query prints the sids of sailors who have reserved all boats for which there is some reservation: P.G. Id Id B1 B2 Conditions COUNT. B1 = COUNT. B2 For each Id value (notice the G. operator), we count all B1 values to get the number of (distinct) bid values reserved by sailor Id. We compare this count against the count of all B2 values, which is simply the total number of (distinct) bid values in the Reserves relation (i.e., the number of boats with reservations). If these counts are equal, the sailor has reserved all boats for which there is some reservation. Incidentally, the following query, intended to print the names of such sailors, is incorrect: P.G. Id P. Id B1 B2 Conditions COUNT. B1 = COUNT. B2
8 184 Chapter 6 The problem is that in conjunction with G., only columns with either G. or an aggregate operation can be printed. This limitation is a direct consequence of the SQL definition of GROUPBY, which we discussed in Section 5.5.1; QBE is typically implemented by translating queries into SQL. If P.G. replaces P. in the sname column, the query is legal, and we then group by both sid and sname, which results in the same groups as before because sid is a key for Sailors. Express conditions involving the AND and OR operators. We can print the names of sailors who are younger than 20 or older than 30 as follows: P. A Conditions A < 20 OR 30 < A We can print the names of sailors who are both younger than 20 and older than 30 by simply replacing the condition with A < 20 AND 30 < A; of course,the set of such sailors is always empty! We can print the names of sailors who are either older than 20 or havearatingequalto8byusingthecondition20 < A OR R = 8, and placing the variable Rintherating column of the example table And/Or Queries It is instructive to consider how queries involving AND and OR canbeexpressedinqbe without using a conditions box. We can print the names of sailors who are younger than 30 or older than 20 by simply creating two example rows: P. < 30 P. > 20 To translate a QBE query with several rows containing P., we create subformulas for each row with a P. and connect the subformulas through. If a row containing P. is linked to other rows through shared variables (which is not the case in this example), the subformula contains a term for each linked row, all connected using. Notice how the answer variable N, which must be a free variable, is handled: { N I1,N1,T1,A1,I2,N2,T2,A2( I1,N1,T1,A1 Sailors(A1 < 30 N = N1) I2,N2,T2,A2 Sailors(A2 > 20 N = N2))} To print the names of sailors who are both younger than 30 and older than 20, we use the same variable in the key fields of both rows:
9 Query-by-Example (QBE) 185 Id P. < 30 Id > 20 The DRC formula for this query contains a term for each linked row, and these terms are connected using : { N I1,N1,T1,A1,N2,T2,A2 ( I1,N1,T1,A1 Sailors(A1 < 30 N = N1) I1,N2,T2,A2 Sailors(A2 > 20 N = N2))} Compare this DRC query with the DRC version of the previous query to see how closely they are related (and how closely QBE follows DRC). 6.7 UNNAMED COLUMNS If we want to display some information in addition to fields retrieved from a relation, we can create unnamed columns for display. 3 As an example admittedly, a silly one! we could print the name of each sailor along with the ratio rating/age as follows: P. R A P. R/ A All our examples thus far have included P. commands in exactly one table. This is a QBE restriction. If we want to display fields from more than one table, we have to use unnamed columns. To print the names of sailors along with the dates on which they have a boat reserved, we could use the following: Id P. P. D Id D Note that unnamed columns should not be used for expressing conditions such as D>8/9/96; a conditions box should be used instead. 6.8 UPDATES Insertion, deletion, and modification of a tuple are specified through the commands I., D., and U., respectively. We can insert a new tuple into the Sailors relation as follows: 3 A QBE facility includes simple commands for drawing empty example tables, adding fields, and so on. We do not discuss these features but assume that they are available.
10 186 Chapter 6 I. 74 Janice 7 41 We can insert several tuples, computed essentially through a query, into the Sailors relation as follows: I. Id N A Students sid name login age Id N A Conditions A > 18 OR N LIKE C% We insert one tuple for each student older than 18 or with a name that begins with C. (QBE s LIKE operator is similar to the SQL version.) The rating field of every inserted tuple contains a null value. The following query is very similar to the previous query, but differs in a subtle way: I. Id1 N1 A1 I. Id2 N2 A2 Students sid name login age Id1 N1 A1 > 18 Id2 N2 LIKE C% A2 The difference is that a student older than 18 with a name that begins with C is now inserted twice into Sailors. (The second insertion will be rejected by the integrity constraint enforcement mechanism because sid is a key for Sailors. However, if this integrity constraint is not declared, we would find two copies of such a student in the Sailors relation.) We can delete all tuples with rating > 5 from the Sailors relation as follows: D. > 5 We can delete all reservations for sailors with rating < 4byusing:
11 Query-by-Example (QBE) 187 Id < 4 D. Id We can update the age of the sailor with sid 74 to be 42 years by using: 74 U.42 The fact that sid is the key is significant here; we cannot update the key field, but we can use it to identify the tuple to be modified (in other fields). We can also change theageofsailor74from41to42byincrementingtheagevalue: 74 U. A Restrictions on Update Commands There are some restrictions on the use of the I., D., and U. commands. First, we cannot mix these operators in a single example table (or combine them with P.). Second, we cannot specify I., D., oru. in an example table that contains G. Third, we cannot insert, update, or modify tuples based on values in fields of other tuples in the same table. Thus, the following update is incorrect: john U. A+1 joe A This update seeks to change John s age based on Joe s age. Since sname is not a key, the meaning of such a query is ambiguous should we update every John s age, and if so, based on which Joe s age? QBE avoids such anomalies using a rather broad restriction. For example, if sname were a key, this would be a reasonable request, even though it is disallowed. 6.9 DIVISION AND RELATIONAL COMPLETENESS * In Section 6.6 we saw how division can be expressed in QBE using COUNT. It is instructive to consider how division can be expressed in QBE without the use of aggregate operators. If we don t use aggregate operators, we cannot express division in QBE without using the update commands to create a temporary relation or view. However,
12 188 Chapter 6 taking the update commands into account, QBE is relationally complete, even without the aggregate operators. Although we will not prove these claims, the example that we discuss below should bring out the underlying intuition. We use the following query in our discussion of division: Find sailors who have reserved all boats. In Chapter 4 we saw that this query can be expressed in DRC as: { I,N,T,A I,N,T,A Sailors B,BN,C Boats ( Ir,Br,D Reserves(I = Ir Br = B))} The quantifier is not available in QBE, so let us rewrite the above without : { I,N,T,A I,N,T,A Sailors B,BN,C Boats ( Ir,Br,D Reserves(I = Ir Br = B))} This calculus query can be read as follows: Find Sailors tuples (with sid I) for which there is no Boats tuple(with bid B) such that no Reserves tuple indicates that sailor I has reserved boat B. We might try to write this query in QBE as follows: Id P. S Boats bid bname color B Id B This query is illegal because the variable B does not appear in any positive row. Going beyond this technical objection, this QBE query is ambiguous with respect to the ordering of the two uses of. It could denote either the calculus query that we want to express or the following calculus query, which is not what we want: { I,N,T,A I,N,T,A Sailors Ir,Br,D Reserves ( B,BN,C Boats(I = Ir Br = B))} There is no mechanism in QBE to control the order in which the operations in a query are applied. (Incidentally, the above query finds all Sailors who have made reservations only for boats that exist in the Boats relation.) One way to achieve such control is to break the query into several parts by using temporary relations or views. As we saw in Chapter 4, we can accomplish division in
13 Query-by-Example (QBE) 189 two logical steps: first, identify disqualified candidates, and then remove this set from the set of all candidates. In the query at hand, we have to first identify the set of sids (called, say, BadSids) of sailors who have not reserved some boat (i.e., for each such sailor, we can find a boat not reserved by that sailor), and then we have to remove BadSids from the set of sids of all sailors. This process will identify the set of sailors who ve reserved all boats. The view BadSids can be defined as follows: Id Id B Boats bid bname color B BadSids sid I. Id Given the view BadSids, it is a simple matter to find sailors whose sids are not in this view. The ideas in this example can be extended to show that QBE is relationally complete POINTS TO REVIEW QBE is a user-friendly query language with a graphical interface. The interface depicts each relation in tabular form. (Section 6.1) Queries are posed by placing constants and variables into individual columns and thereby creating an example tuple of the query result. Simple conventions are used to express selections, projections, sorting, and duplicate elimination. (Section 6.2) Joins are accomplished in QBE by using the same variable in multiple locations. (Section 6.3) QBE provides a limited form of set difference through the use of in the relationname column. (Section 6.4) Aggregation (AVG., COUNT., MAX., MIN., and SUM.) and grouping (G.) can be expressed by adding prefixes. (Section 6.5) The condition box provides a place for more complex query conditions, although queries involving AND or OR can be expressed without using the condition box. (Section 6.6) New, unnamed fields can be created to display information beyond fields retrieved from a relation. (Section 6.7)
14 190 Chapter 6 QBE provides support for insertion, deletion and updates of tuples. (Section 6.8) Using a temporary relation, division can be expressed in QBE without using aggregation. QBE is relationally complete, taking into account its querying and view creation features. (Section 6.9) EXERCISES Exercise 6.1 Consider the following relational schema. An employee can work in more than one department. Emp(eid: integer, ename: string, salary: real) Works(eid: integer, did: integer) Dept(did: integer, dname: string, managerid: integer, floornum: integer) Write the following queries in QBE. Be sure to underline your variables to distinguish them from your constants. 1. Print the names of all employees who work on the 10th floor and make less than $50, Print the names of all managers who manage three or more departments on the same floor. 3. Print the names of all managers who manage 10 or more departments on the same floor. 4. Give every employee who works in the toy department a 10 percent raise. 5. Print the names of the departments that employee Santa works in. 6. Print the names and salaries of employees who work in both the toy department and the candy department. 7. Print the names of employees who earn a salary that is either less than $10,000 or more than $100, Print all of the attributes for employees who work in some department that employee Santa also works in. 9. Fire Santa. 10. Print the names of employees who make more than $20,000 and work in either the video department or the toy department. 11. Print the names of all employees who work on the floor(s) where Jane Dodecahedron works. 12. Print the name of each employee who earns more than the manager of the department that he or she works in. 13. Print the name of each department that has a manager whose last name is Psmith and who is neither the highest-paid nor the lowest-paid employee in the department. Exercise 6.2 Write the following queries in QBE, based on this schema:
15 Query-by-Example (QBE) 191 Suppliers(sid: integer, sname: string, city: string) Parts(pid: integer, pname: string, color: string) Orders(sid: integer, pid: integer, quantity: integer) 1. For each supplier from whom all of the following things have been ordered in quantities of at least 150, print the name and city of the supplier: a blue gear, a red crankshaft, and a yellow bumper. 2. Print the names of the purple parts that have been ordered from suppliers located in Madison, Milwaukee, or Waukesha. 3. Print the names and cities of suppliers who have an order for more than 150 units of a yellow or purple part. 4. Print the pids of parts that have been ordered from a supplier named American but have also been ordered from some supplier with a different name in a quantity that is greater than the American order by at least 100 units. 5. Print the names of the suppliers located in Madison. Could there be any duplicates in the answer? 6. Print all available information about suppliers that supply green parts. 7. For each order of a red part, print the quantity and the name of the part. 8. Print the names of the parts that come in both blue and green. (Assume that no two distinct parts can have the same name and color.) 9. Print (in ascending order alphabetically) the names of parts supplied both by a Madison supplier and by a Berkeley supplier. 10. Print the names of parts supplied by a Madison supplier, but not supplied by any Berkeley supplier. Could there be any duplicates in the answer? 11. Print the total number of orders. 12. Print the largest quantity per order for each sid such that the minimum quantity per order for that supplier is greater than Print the average quantity per order of red parts. 14. Can you write this query in QBE? If so, how? Print the sids of suppliers from whom every part has been ordered. Exercise 6.3 Answer the following questions: 1. Describe the various uses for unnamed columns in QBE. 2. Describe the various uses for a conditions box in QBE. 3. What is unusual about the treatment of duplicates in QBE? 4. Is QBE based upon relational algebra, tuple relational calculus, or domain relational calculus? Explain briefly. 5. Is QBE relationally complete? Explain briefly. 6. What restrictions does QBE place on update commands?
16 192 Chapter 6 PROJECT-BASED EXERCISES Exercise 6.4 Minibase s version of QBE, called MiniQBE, tries to preserve the spirit of QBE but cheats occasionally. Try the queries shown in this chapter and in the exercises, and identify the ways in which MiniQBE differs from QBE. For each QBE query you try in MiniQBE, examine the SQL query that it is translated into by MiniQBE. BIBLIOGRAPHIC NOTES The QBE project was led by Moshe Zloof [702] and resulted in the first visual database query language, whose influence is seen today in products such as Borland s Paradox and, to a lesser extent, Microsoft s Access. QBE was also one of the first relational query languages to support the computation of transitive closure, through a special operator, anticipating much subsequent research into extensions of relational query languages to support recursive queries. A successor called Office-by-Example [701] sought to extend the QBE visual interaction paradigm to applications such as electronic mail integrated with database access. Klug presented a version of QBE that dealt with aggregate queries in [377].
Query-by-Example (QBE)
Query-by-Example (QBE) Module 3, Lecture 6 Example is the school of mankind, and they will learn at no other. -- Edmund Burke (1729-1797) Database Management Systems, R. Ramakrishnan 1 QBE: Intro A GUIMore information
Chapter 5. SQL: Queries, Constraints, Triggers
Chapter 5 SQL: Queries, Constraints, Triggers 1 Overview: aspects of SQL DML: Data Management Language. Pose queries (Ch. 5) and insert, delete, modify rows (Ch. 3) DDL: Data Definition Language. Creation,More information
SQL: Queries, Programming, Triggers
SQL: Queries, Programming, Triggers Chapter 5 Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 1 R1 Example Instances We will use these instances of the Sailors and Reserves relations inMore information
Example Instances. SQL: Queries, Programming, Triggers. Conceptual Evaluation Strategy. Basic SQL Query. A Note on Range Variables
SQL: Queries, Programming, Triggers Chapter 5 Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 1 Example Instances We will use these instances of the Sailors and Reserves relations in ourMore information
Boats bid bname color 101 Interlake blue 102 Interlake red 103 Clipper green 104 Marine red. Figure 1: Instances of Sailors, Boats and Reserves
Tutorial 5: SQL By Chaofa Gao Tables used in this note: Sailors(sid: integer, sname: string, rating: integer, age: real); Boats(bid: integer, bname: string, color: string); Reserves(sid: integer, bid:More information
SQL: Queries, Programming, Triggers
SQL: Queries, Programming, Triggers CSC343 Introduction to Databases - A. Vaisman 1 R1 Example Instances We will use these instances of the Sailors and Reserves relations in our examples. If the key forMore information
Relational Calculus. Module 3, Lecture 2. Database Management Systems, R. Ramakrishnan 1
Relational Calculus Module 3, Lecture 2 Database Management Systems, R. Ramakrishnan 1 Relational Calculus Comes in two flavours: Tuple relational calculus (TRC) and Domain relational calculus (DRC). CalculusMore information
COMP 5138 Relational Database Management Systems. Week 5 : Basic SQL. Today s Agenda. Overview. Basic SQL Queries. Joins Queries
COMP 5138 Relational Database Management Systems Week 5 : Basic COMP5138 "Relational Database Managment Systems" J. Davis 2006 5-1 Today s Agenda Overview Basic Queries Joins Queries Aggregate FunctionsMore information
Relational Algebra and SQL
Relational Algebra and SQL Johannes Gehrke firstname.lastname@example.com http://www.cs.cornell.edu/johannes Slides from Database Management Systems, 3 rd Edition, Ramakrishnan and Gehrke. Database ManagementMore information
There are five fields or columns, with names and types as shown above.
3 THE RELATIONAL MODEL Exercise 3.1 Define the following terms: relation schema, relational database schema, domain, attribute, attribute domain, relation instance, relation cardinality, andrelation degree.More information
Relational Algebra. Module 3, Lecture 1. Database Management Systems, R. Ramakrishnan 1
Relational Algebra Module 3, Lecture 1 Database Management Systems, R. Ramakrishnan 1 Relational Query Languages Query languages: Allow manipulation and retrieval of data from a database. Relational modelMore information
Databases and BigData
Eduardo Cunha de Almeida email@example.com Outline of the course Introduction Database Systems (E. Almeida) Distributed Hash Tables and P2P (C. Cassagnes) NewSQL (D. Kim and J. Meira) NoSQL (D. Kim)More information
The Relational Model. Why Study the Relational Model? Relational Database: Definitions
The Relational Model Database Management Systems, R. Ramakrishnan and J. Gehrke 1 Why Study the Relational Model? Most widely used model. Vendors: IBM, Microsoft, Oracle, Sybase, etc. Legacy systems inMore information
The Relational Model. Ramakrishnan&Gehrke, Chapter 3 CS4320 1
The Relational Model Ramakrishnan&Gehrke, Chapter 3 CS4320 1 Why Study the Relational Model? Most widely used model. Vendors: IBM, Informix, Microsoft, Oracle, Sybase, etc. Legacy systems in older modelsMore information
Relational Database: Additional Operations on Relations; SQL
Relational Database: Additional Operations on Relations; SQL Greg Plaxton Theory in Programming Practice, Fall 2005 Department of Computer Science University of Texas at Austin Overview The course packetMore information
The Relational Model. Why Study the Relational Model? Relational Database: Definitions. Chapter 3
The Relational Model Chapter 3 Database Management Systems 3ed, R. Ramakrishnan and J. Gehrke 1 Why Study the Relational Model? Most widely used model. Vendors: IBM, Informix, Microsoft, Oracle, Sybase,More information
The Relational Model. Why Study the Relational Model?
The Relational Model Chapter 3 Instructor: Vladimir Zadorozhny email@example.com Information Science Program School of Information Sciences, University of Pittsburgh 1 Why Study the Relational Model?More information
3. Relational Model and Relational Algebra
ECS-165A WQ 11 36 3. Relational Model and Relational Algebra Contents Fundamental Concepts of the Relational Model Integrity Constraints Translation ER schema Relational Database Schema Relational AlgebraMore information
Introduction to Microsoft Jet SQL
Introduction to Microsoft Jet SQL Microsoft Jet SQL is a relational database language based on the SQL 1989 standard of the American Standards Institute (ANSI). Microsoft Jet SQL contains two kinds ofMore information
Part A: Data Definition Language (DDL) Schema and Catalog CREAT TABLE. Referential Triggered Actions. CSC 742 Database Management Systems
CSC 74 Database Management Systems Topic #0: SQL Part A: Data Definition Language (DDL) Spring 00 CSC 74: DBMS by Dr. Peng Ning Spring 00 CSC 74: DBMS by Dr. Peng Ning Schema and Catalog Schema A collectionMore information
2. Basic Relational Data Model
2. Basic Relational Data Model 2.1 Introduction Basic concepts of information models, their realisation in databases comprising data objects and object relationships, and their management by DBMS s thatMore information
Lecture 6. SQL, Logical DB Design
Lecture 6 SQL, Logical DB Design Relational Query Languages A major strength of the relational model: supports simple, powerful querying of data. Queries can be written intuitively, and the DBMS is responsibleMore information
Chapter 5 More SQL: Complex Queries, Triggers, Views, and Schema Modification
Chapter 5 More SQL: Complex Queries, Triggers, Views, and Schema Modification Copyright 2011 Pearson Education, Inc. Publishing as Pearson Addison-Wesley Chapter 5 Outline More Complex SQL Retrieval QueriesMore information
5 SQL: QUERIES, CONSTRAINTS, TRIGGERS Online material is available for all exercises in this chapter on the book s webpage at http://www.cs.wisc.edu/~dbbook This includes scripts to create tables for eachMore information
A Comparison of Database Query Languages: SQL, SPARQL, CQL, DMX
ISSN: 2393-8528 Contents lists available at www.ijicse.in International Journal of Innovative Computer Science & Engineering Volume 3 Issue 2; March-April-2016; Page No. 09-13 A Comparison of DatabaseMore information
Database Applications Microsoft Access
Database Applications Microsoft Access Lesson 4 Working with Queries Difference Between Queries and Filters Filters are temporary Filters are placed on data in a single table Queries are saved as individualMore information
Database Implementation: SQL Data Definition Language
Database Systems Unit 5 Database Implementation: SQL Data Definition Language Learning Goals In this unit you will learn how to transfer a logical data model into a physical database, how to extend orMore information
Database Security. Chapter 21
Database Security Chapter 21 Introduction to DB Security Secrecy: Users should not be able to see things they are not supposed to. E.g., A student can t see other students grades. Integrity: Users shouldMore information
Instant SQL Programming
Instant SQL Programming Joe Celko Wrox Press Ltd. INSTANT Table of Contents Introduction 1 What Can SQL Do for Me? 2 Who Should Use This Book? 2 How To Use This Book 3 What You Should Know 3 ConventionsMore information
INFO/CS 330: Applied Database Systems
INFO/CS 330: Applied Database Systems Introduction to Database Security Johannes Gehrke firstname.lastname@example.com http://www.cs.cornell.edu/johannes Introduction to DB Security Secrecy:Users should not beMore information
Relational Database Systems 1
Relational Database Systems 1 Wolf-Tilo Balke Philipp Wille Simon Barthel Institut für Informationssysteme Technische Universität Braunschweig www.ifis.cs.tu-bs.de 7.0 Summary of Last Week Basic relationalMore information
Chapter 8. SQL-99: SchemaDefinition, Constraints, and Queries and Views
Chapter 8 SQL-99: SchemaDefinition, Constraints, and Queries and Views Data Definition, Constraints, and Schema Changes Used to CREATE, DROP, and ALTER the descriptions of the tables (relations) of a databaseMore information
Elena Baralis, Silvia Chiusano Politecnico di Torino. Pag. 1. Active database systems. Triggers. Triggers. Active database systems.
Active database systems Database Management Systems Traditional DBMS operation is passive Queries and updates are explicitly requested by users The knowledge of processes operating on data is typicallyMore information
Access Queries (Office 2003)
Access Queries (Office 2003) Technical Support Services Office of Information Technology, West Virginia University OIT Help Desk 293-4444 x 1 oit.wvu.edu/support/training/classmat/db/ Instructor: KathyMore information
Creating QBE Queries in Microsoft SQL Server
Creating QBE Queries in Microsoft SQL Server When you ask SQL Server or any other DBMS (including Access) a question about the data in a database, the question is called a query. A query is simply a questionMore information
Relational Databases
Relational Databases Jan Chomicki University at Buffalo Jan Chomicki () Relational databases 1 / 18 Relational data model Domain domain: predefined set of atomic values: integers, strings,... every attributeMore information
Introduction to SQL: Data Retrieving
Introduction to SQL: Data Retrieving Ruslan Fomkin Databasdesign för Ingenjörer 1056F Structured Query Language (SQL) History: SEQUEL (Structured English QUery Language), earlier 70 s, IBM Research SQLMore information
The SQL Query Language. Creating Relations in SQL. Referential Integrity in SQL. Basic SQL Query. Primary and Candidate Keys in SQL
COS 597A: Principles of Database and Information Systems SQL: Overview and highlights The SQL Query Language Structured Query Language Developed by IBM (system R) in the 1970s Need for a standard sinceMore information
Answer Key. UNIVERSITY OF CALIFORNIA College of Engineering Department of EECS, Computer Science Division
Answer Key UNIVERSITY OF CALIFORNIA College of Engineering Department of EECS, Computer Science Division CS186 Fall 2003 Eben Haber Midterm Midterm Exam: Introduction to Database Systems This exam hasMore information
Database Design. Marta Jakubowska-Sobczak IT/ADC based on slides prepared by Paula Figueiredo, IT/DB
Marta Jakubowska-Sobczak IT/ADC based on slides prepared by Paula Figueiredo, IT/DB Outline Database concepts Conceptual Design Logical Design Communicating with the RDBMS 2 Some concepts Database: anMore information
Proposed solutions Project Assignment #1 (SQL)
Proposed solutions Project Assignment #1 (SQL) (a) Database creation: create table sailor (sname CHAR(30), rating INTEGER) create table boat (bname CHAR (30), color CHAR (15), rating INTEGER) create tableMore information
CS2Bh: Current Technologies. Introduction to XML and Relational Databases. The Relational Model. The relational model
CS2Bh: Current Technologies Introduction to XML and Relational Databases Spring 2005 The Relational Model CS2 Spring 2005 (LN6) 1 The relational model Proposed by Codd in 1970. It is the dominant dataMore information
Advance DBMS. Structured Query Language (SQL)
Structured Query Language (SQL) Introduction Commercial database systems use more user friendly language to specify the queries. SQL is the most influential commercially marketed product language. OtherMore information
Oracle SQL. Course Summary. Duration. Objectives
Oracle SQL Course Summary Identify the major structural components of the Oracle Database 11g Create reports of aggregated data Write SELECT statements that include queries Retrieve row and column dataMore information
Oracle Database: SQL and PL/SQL Fundamentals
Oracle University Contact Us: 1.800.529.0165 Oracle Database: SQL and PL/SQL Fundamentals Duration: 5 Days What you will learn This course is designed to deliver the fundamentals of SQL and PL/SQL alongMore information
Introduction to tuple calculus Tore Risch 2011-02-03
Introduction to tuple calculus Tore Risch 2011-02-03 The relational data model is based on considering normalized tables as mathematical relationships. Powerful query languages can be defined over suchMore information
Macros allow you to integrate existing Excel reports with a new information system
Macro Magic Macros allow you to integrate existing Excel reports with a new information system By Rick Collard Many water and wastewater professionals use Microsoft Excel extensively, producing reportsMore information
Databases 2011 The Relational Model and SQL
Databases 2011 Christian S. Jensen Computer Science, Aarhus University What is a Database? Main Entry: da ta base Pronunciation: \ˈdā-tə-ˌbās, ˈda- also ˈdä-\ Function: noun Date: circa 1962 : a usuallyMore information
IT2305 Database Systems I (Compulsory)
Database Systems I (Compulsory) INTRODUCTION This is one of the 4 modules designed for Semester 2 of Bachelor of Information Technology Degree program. CREDITS: 04 LEARNING OUTCOMES On completion of thisMore information
Database Query 1: SQL Basics
Database Query 1: SQL Basics CIS 3730 Designing and Managing Data J.G. Zheng Fall 2010 1 Overview Using Structured Query Language (SQL) to get the data you want from relational databases Learning basicMore information
Course: CSC 222 Database Design and Management I (3 credits Compulsory)
Course: CSC 222 Database Design and Management I (3 credits Compulsory) Course Duration: Three hours per week for 15weeks with practical class (45 hours) As taught in 2010/2011 session Lecturer: Oladele,More information
Bridge from Entity Relationship modeling to creating SQL databases, tables, & relations
1 Topics for this week: 1. Good Design 2. Functional Dependencies 3. Normalization Readings for this week: 1. E&N, Ch. 10.1-10.6; 12.2 2. Quickstart, Ch. 3 3. Complete the tutorial at http://sqlcourse2.com/More information
Chapter 1: Introduction. Database Management System (DBMS) University Database Example
This image cannot currently be displayed. Chapter 1: Introduction Database System Concepts, 6 th Ed. See www.db-book.com for conditions on re-use Database Management System (DBMS) DBMS contains informationMore information
Exploring Microsoft Office Access 2007. Chapter 2: Relational Databases and Multi-Table Queries
Exploring Microsoft Office Access 2007 Chapter 2: Relational Databases and Multi-Table Queries 1 Objectives Design data Create tables Understand table relationships Share data with Excel Establish tableMore information
Chapter 1: Introduction
Chapter 1: Introduction Database System Concepts, 5th Ed. See www.db book.com for conditions on re use Chapter 1: Introduction Purpose of Database Systems View of Data Database Languages Relational DatabasesMore information
CS 338 Join, Aggregate and Group SQL Queries
CS 338 Join, Aggregate and Group SQL Queries Bojana Bislimovska Winter 2016 Outline SQL joins Aggregate functions in SQL Grouping in SQL HAVING clause SQL Joins Specifies a table resulting from a joinMore information
Once the schema has been designed, it can be implemented in the RDBMS.
2. Creating a database Designing the database schema... 1 Representing Classes, Attributes and Objects... 2 Data types... 5 Additional constraints... 6 Choosing the right fields... 7 Implementing a tableMore information
Developing Web Applications for Microsoft SQL Server Databases - What you need to know
Developing Web Applications for Microsoft SQL Server Databases - What you need to know ATEC2008 Conference Session Description Alpha Five s web components simplify working with SQL databases, but whatMore information
Lesson 8: Introduction to Databases E-R Data Modeling
Lesson 8: Introduction to Databases E-R Data Modeling Contents Introduction to Databases Abstraction, Schemas, and Views Data Models Database Management System (DBMS) Components Entity Relationship DataMore information
2874CD1EssentialSQL.qxd 6/25/01 3:06 PM Page 1 Essential SQL Copyright 2001 SYBEX, Inc., Alameda, CA www.sybex.com
Essential SQL 2 Essential SQL This bonus chapter is provided with Mastering Delphi 6. It is a basic introduction to SQL to accompany Chapter 14, Client/Server Programming. RDBMS packages are generallyMore information
The Import & Export of Data from a Database
The Import & Export of Data from a Database Introduction The aim of these notes is to investigate a conceptually simple model for importing and exporting data into and out of an object-relational database,More information
Information Systems SQL. Nikolaj Popov
Information Systems SQL Nikolaj Popov Research Institute for Symbolic Computation Johannes Kepler University of Linz, Austria email@example.com Outline SQL Table Creation Populating and ModifyingMore information
Relational model. Relational model - practice. Relational Database Definitions 9/27/11. Relational model. Relational Database: Terminology
COS 597A: Principles of Database and Information Systems elational model elational model A formal (mathematical) model to represent objects (data/information), relationships between objects ConstraintsMore information
3.GETTING STARTED WITH ORACLE8i
Oracle For Beginners Page : 1 3.GETTING STARTED WITH ORACLE8i Creating a table Datatypes Displaying table definition using DESCRIBE Inserting rows into a table Selecting rows from a table Editing SQL bufferMore information
IT2304: Database Systems 1 (DBS 1)
: Database Systems 1 (DBS 1) (Compulsory) 1. OUTLINE OF SYLLABUS Topic Minimum number of hours Introduction to DBMS 07 Relational Data Model 03 Data manipulation using Relational Algebra 06 Data manipulationMore information
Oracle Database: SQL and PL/SQL Fundamentals NEW
Oracle University Contact Us: + 38516306373 Oracle Database: SQL and PL/SQL Fundamentals NEW Duration: 5 Days What you will learn This Oracle Database: SQL and PL/SQL Fundamentals training delivers theMore information
2. Conceptual Modeling using the Entity-Relationship Model
ECS-165A WQ 11 15 Contents 2. Conceptual Modeling using the Entity-Relationship Model Basic concepts: entities and entity types, attributes and keys, relationships and relationship types Entity-RelationshipMore information
Security and Authorization. Introduction to DB Security. Access Controls. Chapter 21
Security and Authorization Chapter 21 Database Management Systems, 3ed, R. Ramakrishnan and J. Gehrke 1 Introduction to DB Security Secrecy: Users should not be able to see things they are not supposedMore information
SES Project v 9.0 SES/CAESAR QUERY TOOL. Running and Editing Queries. PS Query
SES Project v 9.0 SES/CAESAR QUERY TOOL Running and Editing Queries PS Query Table Of Contents I - Introduction to Query:... 3 PeopleSoft Query Overview:... 3 Query Terminology:... 3 Navigation to QueryMore information
From Databases to Natural Language: The Unusual Direction
From Databases to Natural Language: The Unusual Direction Yannis Ioannidis Dept. of Informatics & Telecommunications, MaDgIK Lab University of Athens, Hellas (Greece) email@example.com http://www.di.uoa.gr/More information
Oracle Database 10g Express
Oracle Database 10g Express This tutorial prepares the Oracle Database 10g Express Edition Developer to perform common development and administrative tasks of Oracle Database 10g Express Edition. ObjectivesMore information
Oracle Database: SQL and PL/SQL Fundamentals
Oracle University Contact Us: +966 12 739 894 Oracle Database: SQL and PL/SQL Fundamentals Duration: 5 Days What you will learn This Oracle Database: SQL and PL/SQL Fundamentals training is designed toMore information
Duration Vendor Audience 5 Days Oracle End Users, Developers, Technical Consultants and Support Staff
D80198GC10 Oracle Database 12c SQL and Fundamentals Summary Duration Vendor Audience 5 Days Oracle End Users, Developers, Technical Consultants and Support Staff Level Professional Delivery Method Instructor-ledMore information
Triggers & Packages. {INSERT [OR] UPDATE [OR] DELETE}: This specifies the DML operation.
Triggers & Packages An SQL trigger is a mechanism that automatically executes a specified PL/SQL block (referred to as the triggered action) when a triggering event occurs on the table. The triggeringMore information
Outline. Data Modeling. Conceptual Design. ER Model Basics: Entities. ER Model Basics: Relationships. Ternary Relationships. Yanlei Diao UMass Amherst
Outline Data Modeling Yanlei Diao UMass Amherst v Conceptual Design: ER Model v Relational Model v Logical Design: from ER to Relational Slides Courtesy of R. Ramakrishnan and J. Gehrke 1 2 ConceptualMore information
Handling Missing Values in the SQL Procedure
Handling Missing Values in the SQL Procedure Danbo Yi, Abt Associates Inc., Cambridge, MA Lei Zhang, Domain Solutions Corp., Cambridge, MA ABSTRACT PROC SQL as a powerful database management tool providesMore information
CS2Bh: Current Technologies. Introduction to XML and Relational Databases. Introduction to Databases. Why databases? Why not use XML?
CS2Bh: Current Technologies Introduction to XML and Relational Databases Spring 2005 Introduction to Databases CS2 Spring 2005 (LN5) 1 Why databases? Why not use XML? What is missing from XML: ConsistencyMore information
SUBQUERIES AND VIEWS. CS121: Introduction to Relational Database Systems Fall 2015 Lecture 6
SUBQUERIES AND VIEWS CS121: Introduction to Relational Database Systems Fall 2015 Lecture 6 String Comparisons and GROUP BY 2! Last time, introduced many advanced features of SQL, including GROUP BY! Recall:More information
Review: Participation Constraints
Review: Participation Constraints Does every department have a manager? If so, this is a participation constraint: the participation of Departments in Manages is said to be total (vs. partial). Every didMore information
Microsoft Access 3: Understanding and Creating Queries
Microsoft Access 3: Understanding and Creating Queries In Access Level 2, we learned how to perform basic data retrievals by using Search & Replace functions and Sort & Filter functions. For more complexMore information
1 Structured Query Language: Again. 2 Joining Tables
1 Structured Query Language: Again So far we ve only seen the basic features of SQL. More often than not, you can get away with just using the basic SELECT, INSERT, UPDATE, or DELETE statements. SometimesMore information
UNIT 6. Structured Query Language (SQL) Text: Chapter 5
UNIT 6 Structured Query Language (SQL) Text: Chapter 5 Learning Goals Given a database (a set of tables ) you will be able to express a query in SQL, involving set operators, subqueries and aggregationsMore information
CHAPTER 6 DATABASE MANAGEMENT SYSTEMS. Learning Objectives
CHAPTER 6 DATABASE MANAGEMENT SYSTEMS Management Information Systems, 10 th edition, By Raymond McLeod, Jr. and George P. Schell 2007, Prentice Hall, Inc. 1 Learning Objectives Understand the hierarchyMore information
Section of DBMS Selection & Evaluation Questionnaire
Section of DBMS Selection & Evaluation Questionnaire Whitemarsh Information Systems Corporation 2008 Althea Lane Bowie, Maryland 20716 Tele: 301-249-1142 Email: email@example.com Web: www.wiscorp.comMore information
Lesson 07: MS ACCESS - Handout. Introduction to database (30 mins)
Lesson 07: MS ACCESS - Handout Handout Introduction to database (30 mins) Microsoft Access is a database application. A database is a collection of related information put together in database objects.More information
A Brief Introduction to MySQL
A Brief Introduction to MySQL by Derek Schuurman Introduction to Databases A database is a structured collection of logically related data. One common type of database is the relational database, a termMore information
Introduction to SQL for Data Scientists
Introduction to SQL for Data Scientists Ben O. Smith College of Business Administration University of Nebraska at Omaha Learning Objectives By the end of this document you will learn: 1. How to performMore information
Data Base Management Systems (DBMS) Study Material (Objective Type questions with Answers) Shared by Akhil Arora Powered by www. your A to Z competitive exam guide Database Objective type questions Q.1More information
Excel Database Management Microsoft Excel 2003
Excel Database Management Microsoft Reference Guide University Technology Services Computer Training Copyright Notice Copyright 2003 EBook Publishing. All rights reserved. No part of this publication mayMore information
Performance Tuning for the Teradata Database
Performance Tuning for the Teradata Database Matthew W Froemsdorf Teradata Partner Engineering and Technical Consulting - i - Document Changes Rev. Date Section Comment 1.0 2010-10-26 All Initial documentMore information
- Eliminating redundant data - Ensuring data dependencies makes sense. ie:- data is stored logically
Normalization of databases Database normalization is a technique of organizing the data in the database. Normalization is a systematic approach of decomposing tables to eliminate data redundancy and undesirableMore information
TIBCO Spotfire Metrics Modeler User s Guide. Software Release 6.0 November 2013
TIBCO Spotfire Metrics Modeler User s Guide Software Release 6.0 November 2013 Important Information SOME TIBCO SOFTWARE EMBEDS OR BUNDLES OTHER TIBCO SOFTWARE. USE OF SUCH EMBEDDED OR BUNDLED TIBCO SOFTWAREMore information
1. SELECT DISTINCT f.fname FROM Faculty f, Class c WHERE f.fid = c.fid AND c.room = LWSN1106
Database schema: Department(deptid, dname, location) Student(snum, sname, deptid, slevel, age) Faculty(fid, fname, deptid) Class(cname, time, room, fid) Enrolled(snum, cname) SQL queries: 1. Get the namesMore information
SQL Database queries and their equivalence to predicate calculus
SQL Database queries and their equivalence to predicate calculus Russell Impagliazzo, with assistence from Cameron Helm November 3, 2013 1 Warning This lecture goes somewhat beyond Russell s expertise,More information
Normalization in Database Design
in Database Design Marek Rychly firstname.lastname@example.com Strathmore University, @ilabafrica & Brno University of Technology, Faculty of Information Technology Advanced Databases and Enterprise Systems 14More information
Using Multiple Operations. Implementing Table Operations Using Structured Query Language (SQL)
Copyright 2000-2001, University of Washington Using Multiple Operations Implementing Table Operations Using Structured Query Language (SQL) The implementation of table operations in relational databaseMore information
Oracle Database 10g: Introduction to SQL
Oracle University Contact Us: 1.800.529.0165 Oracle Database 10g: Introduction to SQL Duration: 5 Days What you will learn This course offers students an introduction to Oracle Database 10g database technology.More information
SQL Server 2008 Core Skills. Gary Young 2011
SQL Server 2008 Core Skills Gary Young 2011 Confucius I hear and I forget I see and I remember I do and I understand Core Skills Syllabus Theory of relational databases SQL Server tools Getting help DataMore information
Microsoft Excel 2007 Mini Skills Overview of Tables
To make managing and analyzing a group of related data easier, you can turn a range of cells into a Microsoft Office Excel table (previously known as an Excel list). A table typically contains relatedMore information
Physical Design. Meeting the needs of the users is the gold standard against which we measure our success in creating a database.
Physical Design Physical Database Design (Defined): Process of producing a description of the implementation of the database on secondary storage; it describes the base relations, file organizations, andMore information


text:
5 Ways to Strengthen a Job Ad Reply Letter
Certain methods of writing job search letters really help them to stand out from the crowd. Below are five methods you can use to strengthen your job search letter and examples of other people using these methods.
Graph gems
Graphs and charts present information easily and quickly, enabling you to get your points across quickly. In job search letters, the can effectively communicate your impressive performance and accomplishments. Notice the high impact of graphs in these three samples:
An operations executive uses graphs to communicate her success in meeting revenue goals, after she compares the studio operations director's requirements with her own qualifications.Credit: Dan Dorotik, NCRW — Lubbock, Texas
A sales professional dramatically uses a graph in a business-savvy letter to illustrate how his sales nearly doubled in one quarter.Credit: Don Orlando, CPRW, JCTC, CCM, CCMC, CJSS, MCD — Montgomery, Ala.
Another sales professional embeds a twist: He incorporates the Sales Skills Index, an independent evaluation of skills needed to succeed in the sales environment, into his recounting of a highly successful track record.Credit: Dan Dorotik, NCRW — Lubbock, Texas
Attention grabbers
In the following samples, can you spot the use of bold typefaces, italics, and underscoring to highlight some combination of the following factors?
The position sought
Accomplishments and achievements
Skills and personal characteristics
Special benefits, such as security clearances and fluency in more than one language
Writing quality is another factor that causes employers to pay serious attention to you. Check out the following five samples for inspiration:
A well-educated researcher uses eloquent but comfortable language to propose that she join the staff of a prestigious research institute.Credit: Don Orlando, CPRW, JCTC, CCM, CCMC, CJSS, MCD — Montgomery, Ala.
A candidate for a human resource director's position doesn't say that she hasn't yet held an HR director's title, but uses a classically simple design to direct eyes to her professional merit. The candidate's branding statement proclaims a commitment to excellence, followed by a focus on her master's degree in HR management.Credit: Erin Kennedy, MCD, CMRW, CPRW — Lapeer, Mich.
A bilingual senior technology executive speaks geek in language a corporate chief can cheer, especially the part about adding 30 percent to company sales for a new technological product.Credit: Karen Bartell, CPRW — Massapequa Park, N.Y.
An experienced food and beverage server responds to a job ad for a part-time server position with a short, punchy message that can be sent as a letter or an online cover letter note.Credit: Gay Anne Himebaugh — Corona del Mar, Calif.
A chief executive officer of a firm in the green energy industry decides he wants to be on someone else's payroll. As a hint that he fits well into the industry's youthful culture, the candidate chooses an informal "business casual" approach when reaching out to the third-party recruiter.Credit: Donald Burns — New York, N.Y.
Memorable storytellers
Simply being remembered as a qualified individual among faceless hoards of candidates is a big threshold to cross. A memorable story helps employers recall individuals when deciding who to interview. Notice the humanizing touches that bring readers closer to good feelings about unknown candidates in the two following samples:
A national health care practitioner weaves a personal history into her letter to a health food products sales manager, suggesting that she is a good fit in the health food culture by closing with "Namaste," a conventional Hindu expression, usually stated while holding the palms together vertically in front of the bosom.Credit: Stephanie Clark, CRS, CIS — Nanaimo, B.C., Canada
A new graduate competing for a position as an occupational therapy assistant begins her occupational story at the beginning, when she was a candy striper. The reader thinks, "What an empathetic, thoughtful person."Credit: Judith L. Gillespie, CPCC, CPRW, CEIP — W. Melbourne, Fla.
Blue standard bearers
Job search documents, including cover letters and resumes, are increasingly welcomed by employers of installation, maintenance, repair, construction, and production workers. Plenty of people continue to get jobs without self-marketing documents, but why not get an edge for the best jobs by using every available tool? The following two samples illustrate:
A construction estimator nails key job requirements in a short and zippy letter. He precludes the agony of sitting around waiting for a contact by saying he'll call to discuss not an interview, but "your needs and my qualifications." Well played!Credit: Louise Garver, CPBS, JCTC, CMP, CPRW, CEIP — Broad Brook, Conn.
An "unretirement" candidate responds to an ad for a maintenance technician. He adroitly puts his motto ("You can count on me!") in italics and emphasizes his command of systems and equipment. Inspired! Employers of blue-collar workers seek reliable and able workers, a good selling point for an older worker.Credit: Judith L. Gillespie, CPCC, CPRW, CEIP — W. Melbourne, Fla.
Main points
Look over the following sample that shows the wisdom of getting to the heart of the matter. What is the one factor that, if missing, kills interest in the candidate? Always try to pinpoint the make-or-break factor in a hiring decision and make it work for you:
A personal banking officer relocating from one city to another knows that the ability to offer great customer service is a key essential in selecting personal bankers; she loads her letter with charm and warmth.Credit: Haley Richardson, CPRW, JCTC — Minneapolis, Minn.

subset: commoncrawl


text:
Take a step closer to the Triumph that your dreams are made of...
We understand that, now more than ever, your time is so valuable, so we at Lings Norfolk Triumph are committed to supplying that 1st class experience that we all desire.
So now with just a few clicks you can view our complete demo range, LIVE availability and even reserve the test ride that has so far eluded you, and all this from the comfort of your home.
A cliche we know, however: Destiny truly is in YOUR hands!
You can book your preferred test ride time and date online. We'll send you a welcome email confirming your reservation.


text:
Mrs Kathy Bracher
Practice Business Manager
Mrs Karen Gallimore
Operations Manager
The Practice Manager and his team are involved in managing all of the business aspects of the Practice, making sure that the right systems are in place to provide a high quality of patient care, human resources, finance, patient safety, premises and equipment and information technology. The Practice Management Team supports the GPs and other medical professionals with delivering patient services and also helps to develop extended services to enhance patient care.
Gaynor Pretty
Julia Tregellas
Penny Urry
Cathryn Wass
Sarah Wilson
Copyright 2006 - 2019 My Surgery Website | Privacy & Usage | Edit | Staff Home | Site Map | Accessibility | Site T&C's | Service T&C's


text:
Crime - Sacto 911
Authorities: New Folsom prison correctional officer slashed, stabbed in inmate attack
A correctional officer at new Folsom prison was injured in a stabbing and slashing attack by an inmate, prison officials said.
At about 2:40 p.m. Friday, the correctional officer was conducting security checks in a housing unit when prisoner Pablo Melendez, 37, began running toward him, officials said.
In each hand, Melendez held an inmate-made weapon, officials said in a news release. The officer fought back and two officers in the same area tried to separate the injured officer from the inmate.
The officer warned his colleagues that Melendez was armed. They were quickly able to disarm him and place him in restraints.
The injured officer was treated for puncture wounds to his leg and head, cuts to his head and arm and scratches. The officer, who had required eight sutures to his arm, was released from the hospital Friday night and is recovering at home.
Melendez also went to a hospital outside the prison walls for treatment of fractured ribs, bruises, swelling and abrasions. He was back in California State Prison-Sacramento on Friday night and was placed in segregated housing while the attack is investigated.
Melendez entered the state prison system from Los Angeles County in 2011 to serve 98 years to life for kidnapping and lewd and lascivious acts with a child younger than 14.
Bill Lindelof: 916-321-1079, @Lindelofnews


text:
Coffee Promotions
We have some exciting new exceptionally tasting coffees for you to try in our promos this week
This week, we have some incredible coffee beans from across the globe, allowing you to sample the delicious aromas and tastes of coffee beans from everywhere from Brazil to Colombia and Sumatra.
If you're not able to get to these countries and escape the cold and miserable weather in the UK, it's the next best thing!
Only £12.50
Only £21.49
Displaying 1 to 3 (of 3 products)
- 1


text:
PC: Sarah Sweeney
Hey guys, finally checking in after what seems like forever. Let me tell you, there's nothing like being displaced by a move and losing all sense of normal. It's hard to believe that two months ago we saw our new house for the first time and that set into motion the crazy life we've been living. I would never have chosen to move houses, plan a remodel, launch new products and do Summer with four kids at the same time, but it turns out that's what we needed to do and that's what we've done.
Today is basically the last day of our new house renovations, although we moved in last week. By the end of today we'll have a working kitchen sink and laundry room and most of the dust and grime will be gone. We've been living in our upstairs- which thankfully has enough room for the kids and us to sleep and bathe. Meals have all been sandwiches, cereal and take out. I've been really struggling mentally with the lack of order or schedule or normal, but I keep reminding myself that it's really only for a short time. We're so fortunate to have a beautiful home to move into and for all of the blessings that a bigger home will provide. I just sometimes forget that there is struggle and effort attached to those rewards.
I am also trying to cut myself a break as the flu also ran through our house last week. Nothing like breaking in a new house with a little throw up. It FEELS like we'll never have a new normal, I'll never get any work done again and like I've left all productivity at the other house, but those are just feelings and I think I'll be able to prove them wrong one step or one unpacked box at a time.
Thanks for the love and the congrats on our new house. We really are thankful and it still doesn't feel real! I hope your July is off to a great start and you're enjoying Independence Day with your family!


text:
Ivey denounces impeachment inquiry as "a political charade"
Governor Ivey issues statement following completion of radiation treatment
Ivey's top lawyer to exit soon
Ivey completes first round of cancer treatment
Ivey announces that she will undergo treatment for cancer
Medical Cannabis Study Commission has a draft bill
Group urges legislators to pass female genital mutilation bills in upcoming session
Medical marijuana users tell their stories to Medical Cannabis Study Commission
McCutcheon appoints Chip Brown to House Rules Committee
Ethics Commission to rule on Burkette complaint
American Society of Civil Engineers names Chambliss outstanding public official
Reed elected chairman of Legislature's Oil and Gas Study Committee
Retired State Rep. Pete Turnham has died
Hyundai to build the Santa Cruz in Montgomery adding 200 jobs
Report: Alabama children's wellness making slight gains, but racial disparities remain
Tribe offers to buy exclusive rights to gambling in Alabama
Expanding Medicaid would cover more than 13,000 Alabama veterans, their family members
First summit on rural workforce development held in Livingston
45 years later, man sentenced to life at 16-years-old seeks parole
Foundation for Moral Law defends Little Sisters of the Poor from Obamacare mandate
Parole hearings in Alabama will resume today after a two month suspension of hearings
DNC chair: If elections aren't held on Saturday, Alabama could have no delegates at national convention
Court blocks the Alabama abortion ban
Marshall Space Flight Center expands collaboration with UA on in-space manufacturing
Boeing's Starliner passes critical safety test
Boeing contracted to build more rockets for NASA
Brooks questions NASA experts with conflicting views on best way to return to the moon
Byrne supports Huntsville for Space Command HQ
Charlotte Meadows wins House District 74 special election
Will Dismukes endorses Jessica Taylor
Shelby, ten other GOP Senators endorse Sessions
House District 74 voters go to the polls today
Byrne announces "Veterans for Byrne" coalition
SPLC: Emails show Trump advisor, former Jeff Sessions staffer, Stephen Miller promoted white nationalism
Ivey appoints Brigadier General Edward F. Crowell as Montgomery probate judge
Alabama Republicans continue to denounce impeachment as a "sham"
Rogers: Impeachment inquiry is "another dead-end witch hunt"
Opinion | Sessions in? Let the show begin
Opinion | With new leadership, a viable Democratic Party is possible, even likely
Opinion | Is Alabama's playbook bipartisan? No, but it could be
Opinion | Alabama's 1901 Constitution was written to benefit the few
Opinion | Time to make the "make-me state" do something on prisons
Opinion | Alabama kids just can't keep up
Opinion | Alabama Supreme Court's failure to act on Hubbard is jeopardizing other cases
Opinion | State Legislature not very good stepping stone
Analysis | Poarch Creeks' initial gaming offer isn't terrible, but lawmakers would be crazy to accept it
Opinion | An Alabama man popped the Baby Trump balloon and that sums up this state
Opinion | Serious about corruption? Investigate the Bidens
Opinion | A shameful vote cast by an Alabama congressman
Opinion | Fighting for our HBCUs
Opinion | It's time to unite as the Alabama Democratic Party
Opinion | Rebuttal to Phil Williams
A former student of a West Alabama private school has filed a lawsuit against the school, its board and its headmaster, alleging they were aware of...


text:
Plant Health Care
We know how important it is to home owners to have a blooming and thriving lawn and landscape that they can be proud of. A beautiful assemblage of turf areas and all of the trees, shrubs and flowers which come with the landscape always mean not only that the view is easy on the owner's eye, but this beauty is also converted in an added value to the property's financial status. The curb effect of a beautiful lawn and landscape isn't something to be neglected, besides the sheer enjoyment that comes from having the perfect picnic spot right in your yard. But few people remember that this kind of beauty in lawns and the plants which compose the landscape can only come from a great state of health, which is why a beautiful lawn is first and foremost a healthy lawn. With that in mind, we at Super Scapes offer special services oriented precisely at plant health care as the foundation of a great-looking lawn and landscape.
Our Plant Health Care Services
We offer our clients multiple programs to choose from and to personalize according to one's own preferences or needs, if the case. Here is a selection of our carefully constructed fail-safe plans of lawn and landscape plant health care:
- Annual program of ornamental fertilizer, ornamental insecticide, and pre-emergent weed control of beds;
- Injectable tree fertilization and tree insecticide (no more will pesky bugs damage your beautiful trees or shrubs);
- Azalea care: the service plan includes proper pruning, fertilizer and systemic insecticide;
All of these, of course, come with our unique Personal Iron-Clad, Risk-Free Guarantee that only the best lawn care service companies in the field can afford to give. The fact that we can make such a promise should only reveal how confident we are in the quality of our service; none of our competitors can afford such a promise because if they'd actually come to a point where they had to give the money back for faulty services, they'd be out of business soon enough. With us, there is nothing to lose and nothing to risk: all the materials and substances we use for plant health care are trustworthy, safe for people and the environment and turn your lawn into a blooming paradise.
Maintaining a Beautiful Lawn
If your lawn and the plants in the landscape are kept healthy, all that remains to be done for them is a bit of sunlight exposure and the right amount of watering. The bi-annual clean-ups and a careful application of fertilizer and weed control should then be enough to maintain all the plants in a healthy and beautiful state. But to make sure than you maintain everything within optimal parameters, make sure you keep an eye out for any change in your plants: if they suddenly look drier although the weather conditions and irrigation patterns remained more or less the same, contact us right away so we can diagnose and treat any potential problems with a minimally invasive approach.
When it comes to durable health and beauty in your lawn and landscape, you can trust the Super Scapes team to handle everything needed. This way, all that remains for you to do is to sit back and enjoy your beautiful yard to the maximum of its potential.


text:
This is a healthy recipe using a whole red snapper. Seems imitating? Luckily the fish monger does most of the hard work of gutting and removing the scales of the fish. I love red snapper because of its delicate white meat. But any medium sized white fleshed fish would work just as well.
I'm very particular about getting the freshest fish available. This snapper smelled very oceanic. The eyes were clear and the gills were red. The red snapper was wild caught from South America; I keep a look out on sales to get the best price.
Oven roasting the fish is one of the easiest methods of cooking as it minimizes the times you manhandle the fish, which could lead to uneven cooking and flaking. Oven roasting is also a healthier alternative to pan frying which requires lot more oil.
My favorite method of cleaning the fish is with sea salt or any course texture salt. I dip half a lemon in the sea salt and massage it all over the exterior of the fish, and in the gut. It's best not to use your hands because the fish might have sharp edges. The lemon and salt aids in removing the smell. Once the entire fish is covered with salt, rinse it with cold water to remove the excess salt. Repeat once more if necessary, but not too excessively because the acid in the lemon might start cooking the flesh.
I dry roast the fennel seeds, coriander seeds, cardamom pods, and bay leaves in a dry skillet for a few minutes. Dry roasting the spices releases the oils which make the spices more fragrant and give it a slight toasted flavor. Allow the whole spices to cool before grinding it to a fine powder in a coffee grinder. The marinade is a paste made of a few spices which are mellow and not overpowering, but still pack a punch of flavor. The coriander gives a nutty flavor along with the sweet licorice flavor of the fennel. Cardamom pods lend a floral sweet flavor and the bay leaves gives earthy depth.
Along with the dry roasted spices, I add turmeric powder and chili powder. The turmeric gives depth of flavor, and has antifungal properties with will get rid of any fishy smell also. Chili powder gives a vibrant color and spiciness to the fish. (Adjust to your tolerance.)
Once the fish is clean and ready, I make a few slits along the belly to allow the marinade to seep in the flesh. I mix all the spices with water to make a paste which I massage all over the fish. Massage the fish carefully with your hands to avoid the sharp edges, or use a silicone brush. Let the fish sit in the marinade for least 10 minutes. For maximum flavor you can do this step ahead and let the fish sit overnight in the refrigerator.
The stuffing for the fish is made of garlic, ginger, chilies, curry leaves, and onion. I add two types of chilies to give the sufficient heat I desired, if you have a low heat tolerance you can have one chili or skip it out completely. I mash the ingredients in a motor pestle to release the oils and get an even consistency. I chop the ingredients roughly so I don't have to pound them too long, but still achieve the flavor I desire. If you don't have a motor and pestle you can use a food processor.
After it's mashed up, add butter and olive oil to give a rich taste and ensure the stuffing doesn't burn in the oven. The stuffing flavors the fish inside out, perfuming the red snapper with ginger, garlic and red onions. The stuffing also keeps the fish moist and succulent. Once cooked it's a perfect complement to the light flaky fish.
Whenever I roast I line my cookie sheet with aluminum foil for easy cleanup. I elevate the fish for even cooking with thick slices of onions and lemon. It adds an additional layer of flavor. I would recommend using organic lemons because it contains no wax, and goes well with the fish. The onions are pickled by the lemons on top, and the lemon slices are soft, sweet and briny from the juices of the fish. Both are a perfect accompaniment for the roasted red snapper. I added sweet mini peppers with the fish for sweetness.
Cooking the fish at a high temperature makes the skin crispy; some parts may be more roasted than others from the oven. To ensure no burned parts, I recommend covering the cooking sheet with the fish for the first 15 minutes and then removing for the remaining 15 minutes. When serving the fish, add a portion of the fish with the pan juices, the lemon slices and onion slices from underneath the fish. All these components work to give a savory, sweet, and acidic bite.
- 1 whole red snapper gutted and scaled (2lbs)
- 1 tbsp. chili powder
- ½ tsp. turmeric powder
- 1 tbsp. coriander seeds
- ½ tbsp. cardamom pods
- 4 dried bay leaves
- ½ tsp. fennel seeds
- 2 tbsp. chopped garlic cloves
- 2 tbsp. roughly chopped ginger
- 1 chopped green chili
- 2 chopped thai chili (optional)
- 2 tbsp. chopped red onion
- 1 tbsp. chopped curry leaves
- 1 tbsp. butter
- 3 tbsp. olive oil
- 1 lemon sliced thick
- 1 medium red onion sliced thick
- Roast the dry spices (coriander seeds, cardamom pods, fennel seeds and bay leaves) on a dry skillet for 3-4 minutes till fragrant, then allow it to cool for a few minutes. Then grind the seeds to a fine powder in a coffee grinder.
- In a clean bowl, add the ground spices along with the turmeric and chili powder. Add a splash of water to make a thick paste.
- To the clean fish, make three diagonal slashes along the belly of the fish. This allows the marinade to seep in the flesh.
- Apply the paste liberally all over the red snapper and season with salt and black pepper. Allow the fish to sit in the marinade for at least 10 minutes.
- For the stuffing, mash the chopped garlic, ginger, red onion, green chili, thai chilies, and curry leaves to a chunky paste with a motor and pestle.
- To the stuffing mix in 1 tablespoon of soft butter and 1 tablespoon of olive oil. Season the stuffing with salt and black pepper.
- Preheat the oven to 450 degrees.
- On a cookie sheet, drizzle olive oil on the pan, line with thickly sliced red onion and sliced lemons on top. Season the onion and lemons with olive oil to prevent burning, along with salt and black pepper.
- Place the fish on top of the stack of thickly sliced red onions and lemon.
- Stuff the cavity of the fish with fresh paste made in the motor and pestle. Add remaining stuffing to the gashes on the belly of the fish as well.
- Place additional sliced red onion and lemon on top of the fish and drizzle with 1 tbsp. of olive oil.
- Optional you can roast some sweet peppers and potatoes alongside of the red snapper.
- Once the oven is preheated to 450, place the fish in the oven for 30 minutes in the middle rack. Cover the fish with aluminum foil for the initial 15 minutes of cooking and carefully remove for the last 15 minutes.
- Serve warm with the onions and lemons from the bottom of the fish. Enjoy!


text:
The gifts have been given. The games have been played. Here now stand four members of the DV Cast in the bright, fresh year of 2014 to conclude the Not So Secret Thanks a Lot Bryan Tactical Espionage Santa Xperience 2013. Stephen embarks on a decidedly Japanese RPG in Ys I, Bryan cautiously peers into the tiger-infested jungles of Far Cry 3, Cameron runs off at the speed of love to meet Sonic Generations and Sonic CD head on, and Zachary cackles with mad glee at the prospect of tearing into bottom-of-the-barrel motorcycle wreck Ride to Hell: Retribution. Will these games become beloved favorites for all of time or will they ruin Christmas forever? Both of these outcomes are profoundly unlikely! Opening/ending song: Christmas in the Village (Silver Bells), originally from Lufia II: Rise of the Sinistrals and remixed by Dale North.
[audio https://www.cubby.com/p/_43cd1e2c621f42bda72c9f655e76cbe5/Not%20So%20Secret%20Thanks%20a%20Lot%20Bryan%20Tactical%20Espionage%20Santa%20Xperience%202013%202014%20Results.mp3]


text:
Reflecting on this past year, my heart is full of love and gratitude. Yes, this year has stunk. But it also has shown me what love and charity look like. So here, in all it's glory, is the Johnson 2015 year in review.
January- Blake got to come home for 2 weeks from Korea! Plus, we had both our parents come visit at the same time. Grace was baptized and had both sets of Grandparents there! It was an amazing month!
February- I don't really remember too much about February. I started getting sick. We attended a Valentines party for deployed spouses.
March- March was tough. I got even sicker. We attended several parties, including a really fun family fun night. I finally went to the doctor. This is the month where I was diagnosed with a brain tumor.
April- Blake got to come home for good! Woohoo! Elsa turned one and Grant turned 5. I had major brain surgery, and turned 29 the next day. I was in the hospital the entirety of this month. Cancer was diagnosed. I got to relearn how to do many things. We were shown such love and support this month (and the months beyond).
May- This month was learning how to get back in the swing of things. Normal, everyday life. Schedules and work. School and healing.
We also visited Washington DC with friends and got to visit Blake's parents there!
June- We visited Baltimore, and met with my oncologist for the first time. Evelyn turned 3!
July- We spent the 4th of July camping in the Shenandoah valley with Megan and Brayton. And went to a parade in the small town called Middletown. We then 'moved' to Baltimore for 6 weeks of radiation treatments.
August- Spent the month in Baltimore. We were able to go see amazing sights. My mom came to visit! We visited Boston and got to see Nathan on his mission. We also visited NYC. I got to ring the bell that signified the end of radiation treatments! We attended a Orioles game and met some amazing friends that were also going through the cancer journey.
September- This was a very bittersweet month. I got to meet a very sweet angel that changed my life. Megan and Brayton moved to Idaho. I also lost my sweet grandmother. While the kids and Blake stayed in Virginia, I traveled to Utah to attend my grandmothers funeral. Grant started kindergarten and Grace started 3rd Grade!
October- Grace started soccer and loved it. My sweet friend, Mekselina passed away. This was a very difficult time for me. I drew a picture for her family, which helped me as well. We did a fun family Halloween, and all dressed as Star Wars characters.
November- Blake turned 33 and Grace turned 9. We went to Great Wolf Lodge for Grace's birthday. We had a little thanksgiving with just our small family.
December- It was a very warm December here in Virginia! (Which makes me happy!) I was in a car accident. Not so fun. But the rest of the month was full of blessings and because of that, Christmas was amazing! We were blessed by so many people, including friends and strangers.
So long, 2015. We are so ready for 2016!


text:
Sign up for our mailing list
Port Authority is the stylish solution to corporate and casual wear. Whether youre looking for polo shirts, hats, t-shirts, or other apparel and accessories, ProGarmentUSA has a wide selection of Port Authority clothing that will make you and your staff look great. Port Authority polo shirts are great for golf outings or to give to clients, while hats, beanies, and towels are useful accessories that your employees and customers will love.
Our custom embroidery will have your Port Authority uniforms and accessories looking professional no matter where you are representing your company, hospital, or medical clinic. Just send us an image and any other information you would like included on your uniforms and we will send you a proof.
Please dont hesitate to contact us if you have any questions about our selection of Port Authority clothing or embroidery process. We are standing by to help!
ProGarmentUSA 33121 Glenwood Wayne Michigan 48184 (800)434-3678Copyright ©


text:
The Student Recreation Center offers students, faculty, and staff the best opportunities for fitness in the area. The Fitness Program is here to help you reach your goals of a healthy lifestyle. The anchor is the almost 10,000 sq. ft. state of the art Fitness Center with an expanded line of cardiovascular equipment, free weights and strength training machines . Group Exercise classes are free and offered in the Group Fitness and Multipurpose Room.
Weight Room
The Weight Room offers 7,568 sq. ft. of strength equipment. Some of the highlights are 25+ selectorized strength training machines, 12,000+ lbs in dumbbells (5lbs. to 100lbs), 9 Olympic Benches (3 flat, 2 military, 2 incline, 2 decline), 2 Hammer Strength multi-racks with 8X8 platforms, and Smith Machine.
Cardio Fitness
Cardio Fitness provides over 70 pieces of cardiovascular equipment; everything you need to increase cardiorespiratory fitness, burn calories and improve overall health and wellness. Many of the pieces (24) have enhanced interaction consoles with internet connectivity, digital cable, and entertainment options. You can create preset favorites, personalized workouts, and build a custom workout app that works directly with equipment.
Equipment includes:
12 Life Fitness Discover Treadmills
6 Life Fitness 95T Treadmills
5 Life Fitness Discover Recumbent Bikes
1 Life Fitness 95Se Stair Climbers
2 Life Fitness Summit Trainers
4 Life Fitness Discover Ellipticals
4 Life Fitness 95x Ellipticals
2 Life Fitness Discover Upright Bikes
3 Star Trac E-Spinner
21 Star Trac NXT Spinners
4 Matrix Trainers
1 Sci Fit Pro Upper Body Ergometer
1 Sci Fit Recumbent Stepper
1 Jacob's Ladder
1 Rowing Machine
1 Life Fitness Power Mill
1 Helix Lateral Trainer
Hours of Operation
View the hours of operation of our facilities


text:
/ Videos
Coping With Debts Video
There are times when a person is totally overwhelmed with debts. Whatever the circumstances — a medical emergency, the loss of a job, or poor financial planning — a decision needs to be made about how to cope with debts and how to deal with collectors in this time of crisis. If you are an eligible Florida resident living in Brevard, Citrus, Flagler, Hernando, Lake, Marion, Orange, Osceola, Putnam, Seminole, Sumter, and Volusia and need legal help, call the CLSMF Helpline at 1-800-405-1417. For eligibility requirements visit clsmf.org/apply-for-help/eligibility/


text:
Words & Deeds
Country star Brad Paisley to perform in Boise. (But will Peyton Manning be his opening act?)
Country singer Brad Paisley is no stranger to Idaho.
He performed at the Mountain Home Country Music Festival in 2015. Before that, he headlined at the Idaho Center in 2012.
If you're a football fan, Paisley has been hanging out in your living room the past several weeks. Paisley stars in the inescapable "Jingle Sessions" ad campaign for Nationwide Insurance with retired quarterback Peyton Manning. It airs regularly during NFL games.
Still, fans shouldn't expect Paisley to bust out any commercial melodies when he performs Feb. 2, 2018, at Taco Bell Arena. Paisley's Weekend Warrior World Tour will be filled with hits such as "Ticks," "I'm Gonna Miss Her (The Fishin' Song) and "Mud on the Tires."
Ticket information has not been released, but the opening acts have been announced. They will be Dustin Lynch, Chase Bryant and Lindsay Ell. Sorry, football fans — no Peyton Manning.
When the Paisley concert does go on sale, you'll find tickets at Ticketmaster.


text:
New for 2011 - a new trombone/euphonium duet accompaniment book is now available that compliments this volume. Composed by Tom Ervin, these duets are aligned page for page with the Voxman and feature interesting harmonies and other surprises. See item (Contents)
(Bb Major etude)
(G Minor etude)
(Velocity Studies)
(Scale Studies)
Arpeggios Studies)
(Clef Studies)
Cadenza Studies)


text:
No products
The Extreme Cream is the absolute anti-aging concentrate of vital energy.
Jar 50 ml
In stock
Warning: Last items in stock!
Availability date:
This exceptionally rich, smooth cream protects and nourishes even the most mature and tired skin. The Extreme Cream is the absolute anti-aging concentrate of vital energy. Extremely nourishing and comfortable, its formula boasts a high concentration of 360° Skin Perfecting Complex® and Triple Collagen®. It works to intensely nourish and protect the skin. Visibly rejuvenated, the skin regains firmness, density, vitality and radiance. Its deep-down action corrects all signs of aging. Facial features are redesigned. Then apply The Sunscreen to keep your skin looking youthful for many years to come.
Regenerating and Anti-Aging: Triple Collagen®
Targets all signs of aging: The Skin Perfecting Complex®
Competitive inhibitory effect of glycation: Arginine/Lysine Polypeptid
Anti-oxidation, stimulation of structure proteins: Oligopeptide-6
Anti-aging and anti-oxydation: Carnosine
Anti-oxidation, stimulation of structure proteins, care of basal lamina: Hexapeptide-3
Anti-aging, lift up: Acetyl Dipeptide-1 CetylEster
Results after only 20 days of use:
What women think after use*:
93% The skin is softer
92% The skin is more radiant
100% The skin is deeply nourished and comfortable
Results confirmed by clinical study*:
+150% Increase of Fibroblasts Production
+320% Increase of Mitochondrial activity
+97% Wrinkles and fine lines are visibly reduced
* Clinical Study conducted on 50 women aged between 30 and 60, Results after 20 days of daily use.
Apply every morning and evening to a perfectly cleansed face and neck. After using The Extreme Serum, dispense a few drops on the face, work into skin with a gentle massage using small circular movements.
No customer comments for the moment.


text:
UTA Skips Oscars Party, Throws Star-Studded Rally Instead!
Instead of throwing an expensive Oscars party this year, United Talent Agency decided to throw an anti-Trump rally!
The star-studded event featured speeches from Jodie Foster, Wilmer Valderrama, and more. IT was held on Friday afternoon (February 24) outside of the UTA headquarters in Beverly Hills, Calif.
Jodie talked about how she usually doesn't like to use her celebrity for activism, but it's different now. "It's time to show up," she said (via USA Today). "It's a singular time in history. It's time to engage. And as the very, very dead Frederick Douglass once said 'any time is a good time for illumination.'"
Other celebs who showed up for the rally include Aaron Paul, Jai Courtney, Sam Heughan and girlfriend MacKenzie Mauzy, Skyler Samuels, Emily Robinson, Kate McKinnon, Minka Kelly, Dave and Odette Annable, and Michael J. Fox.


text:
It was a satire you idiot (humorist banter implied) .
Im not "crying" about arty so you have no tears to taste. You think I was going to use a poll in these forums to prove a point? Ya like any poll is accurate here.
Edited by Double_O7, Dec 11 2018 - 01:33.


text:
Why Digital Tradecraft℠
Digital Tradecraft
LLC is a provider of quality security consulting services as well as state-of-the-art security research for an ever-growing complex field. We specialize in providing practical security solutions for small and mid-size businesses. Here are a few reasons to consider our company:
Combines the best of industry training and experience only found from years of practicing our trade.
Nothing equates this when combined with formal training and education.
Our research provides us a unique perspective on some of the latest threats to your information.
Staying on top of the latest threats is difficult but solving a problem that has not been identified is impossible. Our goal is to minimize this effort.
Using Threat Modelling and Attack Surface Analysis, we can focus limited resources (e.g. time, money, personnel, etc.) on the components most vulnerable to attack.
This provides the best Return on Investment by focusing on eliminating threats to confidentiality, availability and integrity.
The Threats
With challenging economic times and a tightening risk and compliance environment, businesses are required to do more with less and need a better approach to secure their software and protect their business with existing budgets. Adversaries no longer have physical boundaries and as trends such as mobile communications, Software-as-a-Service (SaaS), and Cloud computing gain momentum the risks to your applications will be ongoing.
Latest Reported Vulnerabilities
Source: US-CERT
Sponsored by NIST
© 2005-2014 Digital Tradecraft LLC
Report Abuse
Powered By
Google Sites


text:
Ducru Beaucaillou 2001
Chateau Ducru Beaucaillou
Somewhat light-bodied for a Ducru, with a 1999-like personality, this blend of 68% Cabernet Sauvignon, 30% Merlot, and 2% Cabernet Franc is a forward, medium-bodied, pretty effort revealing notes of cranberries, black cherries, cassis, and earth. Full of finesse, but lacking concentration as well as depth, it should be consumed over the next 10-12 years.
€ 1,420
October 2015
Chateau Ducru Beaucaillou
Chateau Ducru Beaucaillou is a premier wine producer based in Bordeaux, France, in the Saint Julien appellation. As per the Official Bordeaux Classification of 1855, Chateau Ducru Beaucaillou holds the Second Growth status, alongside 14 other highly esteemed wineries. In addition to the primary wine, a second wine labeled La Croix de Beaucaillou is in production since 1995.
The estate of Chateau Ducru Beaucaillou is operated by Bruno Borie, the total area of the vineyards spanning 50 hectares of well drained gravel. The name of the chateau is most likely due to the composition of the vineyard; "Beaucaillou" means "beautiful stones". In terms of grape composition, it holds around 70% Cabernet Sauvignon and 30% Merlot.
During the 1980s, this highly rated chateau was struck by a TCA infestation, damaging several vintages like the 1988, 1989 and 1990. However, the issues have since then been rectified with a new underground cellar developed in the late 1990s.
22,000 - 25,000 cases
Second Growth
Saint Julien/Left Bank
50 hectares
DISCLAIMER - Bordeaux Traders © 2015
- - All prices are only for perfect OWC's (Original Wooden Case) = 12 * 750 ml bottles.
- - All stocks are of verified European provenance.
- - Bordeaux Traders holds no responsibility over accuracy of information.
- - Images may not reflect wines held in stock.
- - Current Price is an indicative figure from market average; actual market value may vary.
- - Due to constant market evolution, buy/sell prices may be subject to change.


text:
Tea Latte Recipes
Turmeric Latte Recipe
As I've mentioned in the past, turmeric is known as a healing spice in traditional Chinese medicine. However, you don't need to feel weak to enjoy this delicious hot drink. I was able to buy fresh turmeric root at a local Indian market a few months ago and I've stored it in the freezer since then. After going through our freezer today, I decided make good use of it and prepared a turmeric latte. It's so delicious, soothing and relaxing, especially with the weather we've been having.
You could prepare this drink with the milk of your choice. If you decide to go with a lower calorie milk such as almond or cashew milk, you could add a bit of coconut cream, oil or ghee (Indian clarified butter) to the turmeric. A little bit goes a long way but it makes such a difference and adds extra oomph.
Full Recipe...
Matcha Green Tea Latte
I prepared my matcha green tea latte with the same procedure one would use for making white hot chocolate. The drink is made with a blend of lightly sweetened matcha green tea, white chocolate, steamed milk and heavy cream. You wouldn't want to drink this every day, but that's what holiday treats are all about!
This recipe can be modified to feature many different seasonal flavors. Peppermint, cinnamon and other spices come to mind. You don't have to go to the local coffee shop to enjoy holiday specials anymore; be your own barista and save the change for stocking stuffers.
Full Recipe...


text:
Blog - Latest News
0 replies
Leave a ReplyWant to join the discussion?
Feel free to contribute!
Leave a Reply Cancel reply
Latest News
- Sitges Pride Pool Parties – 2 unique events in 2019May 11, 2019 - 9:19 am
After an absence last year, The Sitges Pride pool party returns for not one, but two dates! This party is always a sell-out, so make sure you book your tickets early.
- Bears Week – POPAIR Bbq SitgesApril 27, 2019 - 3:41 pm
Popair returns to Sitges for the annual Bears Wwek BBQ on Friday May 3rd from 1pm to 2am for an all day sausagefest!


text:
Author and Line Editor For Breathless Press
A blizzard, a hunky chef, and an accident-prone milkmaid—ingredients for a passionate fling, or a recipe for a blazing romance, hot enough for a lifetime of winters?
When Maxine Grant finds herself out in the freezing rain of a winter storm, an unlikely hero comes to her rescue. Brice Vanzetti is not only a moody hunky chef, he's the owner of a new black Lexus sporting a red scratch on the bumper. A red that perfectly matches Jilly, her beloved car. Maxine isn't looking for a knight in shining armor, but is it too much to ask that he comes with a sense of humor along with the hot, hard body?
Brice already has a lot on his plate just keeping his restaurant running. He doesn't have the time to deal with a woman who drives a rust bucket and doesn't know when to come in out of the icy rain. She may have left a mark on his car, but Brice is determined she won't put a dent in his resolve to remain a bachelor. No matter how sexy she looks when she's mad!
Forced to seek shelter together in his house, more heats up than Brice's hot chocolate! Stormed in with nowhere to go, Brice and Maxine can keep their differences between them, or give in to the sensual heat and accept the gifts winter has bestowed upon them.


text:
An Office Food Culture
This past Wednesday we celebrated our CEO Michael Arkes's **th birthday. As a result of this celebration we were able to take part in another time honored Hinda tradition:
I learned that if one wants to try and lose weight, they're working at the wrong company. Company potlucks and cookouts are a staple of the Hinda Incentives office. We seem to find any reason possible to celebrate an event and eating awesome food in the process. We've talked before on this blog in regards to using food as an engagement tool and here at Hinda - we certainly practice what we preach.
Michael's birthday was celebrated by a fanfare of grilling. We had piles of ribs with roasted chicken to accompany it. Sides of seasoned rice and homemade mac and cheese complimented the main meat dish extremely well, leaving barely any room for the ice cream cake that was to come.
Being the quiet-natured guy that he is, there wasn't a speech to accompany the pre-cake birthday song. Michael Arkes is the kind of guy that likes to get right down to business. Fortunately for us, the business at hand was multiple-layered ice cream cake.
This is just a slice of life inside the walls of Hinda. How do your companies celebrate special occasions?