For example, each record in a " Faculty and Their Courses " table might contain a Faculty ID, Faculty Name, Faculty Hire Date, and Course Code — thus we can record the details of any faculty member who teaches at least one course, but we cannot record the details of a newly hired faculty member who has not yet been assigned to teach any courses except by setting the Course Code to null.

The " Faculty and Their Courses " table described in the previous example suffers from this type of anomaly, for if a faculty member temporarily ceases to be assigned to any courses, we must delete the last of the records on which that faculty member appears, effectively also deleting the faculty member.

Their duties, as assigned by Jefferson, were preeminently scientific.

Their names were assigned by later astronomers.

Their times would be assigned a point value.

Their only consistently successful act until the " Beat Boom " was that of teen idol Adam Faith: Faith was assigned to the label in 1959 by Norman Newell, an EMI A & R man " without portfolio ".

Their physical appearance was not imposing or especially horrific: they were depicted as six limbed, relatively diminutive creatures ( an appearance which would later be assigned to Tyranid termagants ).

Their hit " Up Above My Head " showed both of them to great advantage: Knight provided the response to Tharpe in traditional call and response format, then took the role that would have been assigned to a bass in a male quartet after Tharpe's solo.

Their fear may actually be a combination of fears, such fear of failing at assigned tasks, fear of speaking before groups at work ( both of which are types of performance anxiety ), or fear of socializing with co-workers ( a type of social phobia ).

Their joy was tempered, however, by the aftermath of the battle, in which a storm prevented the ships assigned to rescue the survivors of the 25 disabled or sunken Athenian triremes from performing their duties, and a great number of sailors drowned.

Their Vulcans were equipped in late 1966 with WE. 177 laydown nuclear bombs at RAF Cottesmore in the low-level penetration role and assigned to SACEUR, before spending six years in the same role 1969-74 at RAF Akrotiri, Cyprus, as part of the Near East Air Force Wing ( NEAF ) where the squadron formed part of the United Kingdom's commitment to CENTO.

Their Sovereigns sometimes assigned them the role of local tax collection from the above named classes of the ruler ’ s subjects.

Their assigned destination was the city of Mainz, on the river Rhine.

Their home was close to the Fore River Shipyard, Quincy, Massachusetts, where LCDR Hart was assigned inspecting the building of the new in which he was assigned to prior to its commissioning ( Monday, 11 April 1910 ).

Their estate at Loughcrew was assigned by Sir William Petty to the Naper Family c. 1655.

Their primary channel is therefore assigned virtual channel 021.

According to Dwight D. Eisenhower, " During the time I have had WACs under my command they have met every test and task assigned to them .... Their contributions in efficiency, skill, spirit, and determination are immeasurable.

Their first episode as staff writers was " Marge in Chains ", an existing idea that they were assigned.

Their feast is observed on 7 October, and a mass is assigned to them in the " Sacramentarium " of Pope Gelasius.

Their raw field notes support their original classification: They found a Swadesh list of Kwomtari to have 45 % cognates with Biaka ( Nai ), while they note that Baibai has only 3 % cognates with Biaka, and so cannot be assigned to the same family.

Their lungs improved and their skeletons became heavier and stronger, better able to cope with the increased gravitational effect of life on land.

Their reasons for this exclusion was their consideration of the south shore of the Baltic to be terra incognita, " unknown land.

Their steaming location was closer to the targets in Afghanistan than any land based assets and thereby more responsive.

Their combined population was 35, 930 and their combined land area was at the 1999 census.

Their combat insertion techniques include, airborne, air assault, amphibious and by land.

Their first obstacle was the unusual shape of the building site, a trapezoid of land at the intersection of Constitution and Pennsylvania Avenues.

Their land, which had probably been part of Great Moravia, and Bohemia, was annexed by Mieszko I some time in late 10th century.

Their goal to " use local resources, travel light, and live off the land " became the hallmark of Mars Direct.

Their strength and reputation kept the newly arrived Europeans from exploiting the animals and resources of most of their land.

Their son-in-law, Samuel Robertson, donated $ 5, 000 and of land.

Their major revenues came from the trade between Tibet and India and from land taxes.

* Isaiah 2: 7 Their land also is full of silver and gold, neither is there any end of their treasures ; their land is also full of horses, neither is there any end of their chariots.

Their relationship reached a crisis in the 1250s when de Montfort was brought up on spurious charges for actions he had taken as lieutenant of Gascony, the last remaining Plantagenet land across the English Channel.

The Scots Holding Their Young King's Nose To the Grindstone, from a satirical English pamphlet When negotiations stalled, Charles authorised General Montrose to land in the Orkney Islands with a small army to threaten the Scots with invasion, in the hope of forcing an agreement more to his liking.

Their wagons were the first to reach the Columbia River over land, and they opened the final leg of Oregon Trail to wagon traffic.

Their total land area is, with a total population of 304 persons.

Their total land area as of the 2000 census was.

Their extensive stance among the other empires of the Liao, Song, and Jin was attributable to their effective military organizations that integrated cavalry, chariots, archery, shields, artillery ( cannons carried on the back of camels ), and amphibious troops for combats on land and water.

Their son Robert inherited his father's land.

Their ancient right to leave the service of one prince for another was curtailed, as was their right to hold land without giving obligatory service to the tsar.

Their pilots decided to land in Chicago to refuel.

Their achievements produced the first detailed " map of the Amur land ".

Their heartland is the two large and many smaller islands known as Haida Gwaii, which means " land of the people " in Haida.

Their base of operation included land storage facilities on the shore and on the beach ( Manasota ) to salt, dry and pack the fish in barrels.