This website uses cookies to ensure you have the best experience. Learn more

It520 Unit 5 Essay

552 words - 3 pages

Kaplan University
Dr. Michael Collins
November 27, 2012

Part 1
Part 2
Use screenimages

--Creates the Agents table
create table Agent (
AgentID INT not null,
FirstName VARCHAR(50) not null,
LastName VARCHAR(50) not null,
Agency VARCHAR(75) not null,
OfficeLocation VARCHAR(50) not null,
Phone VARCHAR(20) not null,
Email VARCHAR(60) not null,
constraint pk_agent primary key (AgentID)
Use screenimages

--Creates the Order table
create table Orders (
OrderID INT not null,
AgentID INT not null,
OrderDate DATE not null,
ShipDate DATE not null,
constraint pk_orders primary key (OrderID),
constraint fk_agent1 foreign key (AgentID)
references Agent (AgentID),

Use screenimages

--Creates the Products table
create table Products (
ProductID INT not null,
Photo VARBINARY(max) null,
Descript VARCHAR(max) not null,
Price MONEY not null,
constraint pk_Products primary key (ProductID) ...view middle of the document...

1567, 'Nancy', 'Shimek', 'Remax', 'East', '515-876-3929', '',
1654, 'Tony', 'Frank', 'Iowa Realty', 'Jordan Grove', '515-453-7856', '',
1765, 'Dennis', 'Rivera', 'Prudential First Realty', 'Downtown', '515-453-7643', '',
1651, 'Judy', 'Urbanek', 'Remax', 'Beaverdale', '515-876-4095', '');

Insert Orders (OrderID, AgentID, OrderDate, ShipDate)
(24675, 1567, 10/19/12, 10/19/12,
24676, 1478, 10/25/12, 10/26/12,
24677, 1651, 11/04/12, 11/04/12,
24678, 1651, 11/05/12, 11/05/12,
24679, 1765, 11/05/12, 11/05/12,
24680, 1654, 11/10/12, 11/12/12);

Insert Products (ProductID, Photo, Descript, Price)
(3001, NULL, 'Remax Open House Yard Sign', 18.50,
3003, NULL, 'Remax For Sale Yard Sign', 19.80,
3008, NULL, 'Remax Tent Sign', 32.25,
3100, NULL, 'Iowa Realty For Sale Yard Sign', 21.50,
3101, NULL, 'Iowa Realty Open House Yard Sign', 21.50,
3102, NULL, 'Iowa Realty Tent Sign', 32.50,
3200, NULL, 'Prudential First Realty For Sale Sign', 16.80,
3206, NULL, 'Prudential First Realty Open House Sign', 17.40);

Insert Inventory (InventoryID, ProductID, InventoryQty, ReorderPoint)
(189, 3001, 70, 10,
190, 3003, 80, 10,
191, 3008, 50, 5,
194, 3100, 4000, 1000,
257, 3101, 350, 100,
286, 3102, 560, 10,
291, 3200, 400, 100,
297, 3206, 8000, 5000);

Insert OrderLine (OrderID, ProductID, Quantity)
(24675, 3003, 4,
24675, 3008, 3,
24676, 3100, 100,
24677, 3001, 100,
24679, 3206, 8,
24679, 3200, 100,
24680, 3100, 100,
24680, 3101, 100,
24680, 3102, 5);

Part 3B

Hoffer, J., Ramesh, V., Topi, H. 2011. Modern Database Management (10th Ed). Upper Saddle River, NJ. Prentice Hall. 2012. SQL Commands and Functions. Retrieved on November 26, 2012 from

Other Papers Like It520 Unit 5

A Heart Of Darkness Essay

1748 words - 7 pages In this short story, there are frequent significant subject and ideas that make the story, "A Heart of Darkness," by Joseph Conrad, and haunting novel. The main theme is absolute white power over the natives. The theme validates the corruption, and the dependence caused by the white people as they took over the Congo. White men were giving all the power; they had no self-control, and in the end they did not use wisely. The white men became

The Aspects Of Vulnerability Among The Exploited In Medical Research

2287 words - 10 pages contamination rate. Since the prevalence of the disease was so high, it seemed the results could be found instantaneously. They began the experiment by testing the gamma globulin on the new entrees of Willowbrook while withholding it from others. The leading researcher, Dr. Krugman, decided to open up another unit to Willowbrook, with their own staff, and admitted children for research purposes. The children were fed the live hepatitis virus by way of the

The Hitchhiker’S Guide To The Galaxy

1171 words - 5 pages The Hitchhiker’s Guide to the Galaxy As the human race makes life-changing discoveries, it is made apparent that there is always more to learn as the universe, instead of becoming familiar, is becoming absurd. The Hitchhiker’s Guide to the Galaxy, written by Douglas Adams, as well as the 2005 film adaption, portrays absurdity to be an all-encompassing system in the universe. Through the introduction and attempt to understand lack of reason, the

The Ford Motor Company Wage Increase Of 1914 And The Theory Of Incentives And Efficiency Wages

1252 words - 6 pages the decision by Ford Motor was based on a combination of all three: efficiency wages, minimising risk of unionisation and personal utility maximisation for Henry Ford. References Amesen, D. (2004), The human tradition in American labour history, Rowman and Littlefield Chauhan, S. (2009), Microeconomics: An advanced treatise, PHI Learning Pvt. Ford (2011), ‘Historic sites: Henry Ford’s $5-a-day revolution, Ford Corporate

Historical Analysis Of The Economical Breakthroughs Of The Industrial Revolution

1396 words - 6 pages A Historical Analysis of the Economical Breakthroughs of the Industrial Revolution During the Industrial Revolution, many elements of society experienced huge breakthroughs that would change the way they functioned forever. Economics were definitely one of them. With many new inventions and many factories appearing, many, many, more resources were being created than ever before. Also, all of the revenue from these resources was being given to

Leadership Portrayed in Monologue from Shakespeare’s Henry V

1214 words - 5 pages Leadership is defined as a socially constructed process and which also affect organizational future outcomes. Leader is someone at high position who have overall duty for an organization, she or he decide what to do and the way how to achieve it. (Carter and Greer, 2013)The role of leader is extremely important for an organization, leader use their own power to influence the followers though many different ways such as motivation in order to

Cuba Civil Rights

1906 words - 8 pages Picture a country that has limits on how much you can make random government imprisonments and more what do you do. That is the situation for the eleven million seventy-five thousand two hundred forty-four people of Cuba since the takeover of Fidel Castro. The US is opposed to Castro taking control of Cuba. Castro managed to ease the United States nerves when he said that Cuba was against all forms of communism. According to Lana Wylie the Union

US Freight System

1273 words - 6 pages a crucial role in the promotion of competitive and efficient commercial transport in all modes. Also the Economy is an important matter for NITL; transport accounts for approximately 5% of the national GDP, and has remained stable for the last decade. Political and Legal is the arena in which the League competes for attention, resources and a voice of overseeing the body of laws and regulations guiding the interactions between shippers and

Democratic Peace Theory

1852 words - 8 pages promise, their approval numbers dropped (Braden 5). She used the example of President Bush and in his second inaugural address stated that freedom would produce peace (Braden 1). When that took too long to come through on that promise, the people and their thought on the president began to drop. Democratic Peace Theory is not successful because, like the previous example, lying does not solve the problem of creating peace; it only opens up rifts

Booker T. Washington

1621 words - 7 pages “Success is to be measured not so much by the position that one has reached in life as by the obstacles which he has overcome” –Booker T. Washing. Booker Taliaferro Washington was born in Hale’s Ford, Virginia on April 5th, 1856 to Jane Burroughs and an unknown White man. Washington was married three times. His first wife was Fannie N. Smith from Malden, West Virginia. Booker and Fannie were married in the summer of 1882 and had one child

Corn, Broccoli, Grass Or Balanced

2611 words - 11 pages and nationalize the historic good farming standards and to eat meat from these environments since sustainable farms are the most beneficial method for humans, animals, and the environment to prosper. The solution for the future is often grounded in the past. In the American industrial food system, 99% of meat comes from CAFOs and feedlots (Foer 5), that ratio are wreaking havoc over Americans health. The rising diet-related health issues are

Related Essays

Freedom And Responsibility Essay

2141 words - 9 pages Built within the Constitution of the United States are specifically defined freedoms that are guaranteed to all citizens. Conversely, with every constitutional freedom there comes a corresponding responsibility. On September 25, 1789, the state legislature’s twelve proposed amendments were transmitted by congress, the first two dealing with congressional representation and congressional pay. The following numbers three through twelve were

Hate Crime Laws Essay

2348 words - 10 pages facial bones broke and he fell backward onto the pavement, cracking his skull and dislocating his brain from the brain stem. Kennedy was taken off life support later that day. Moller was initially charged with his death, but the charges were reduced to manslaughter without the hate crime attachment, and he was sentenced to only 5 years. With good behavior and other benefits, Moller served a little over 1 year for the death of Sean Kennedy (Algren

Rational Emotional Behavior Therapy Case Study Conceptualization And Treatment Plan

2140 words - 9 pages Rational Emotional Behavior Therapy Case Study of Sarah: A Conceptualization and Treatment Plan Rational emotive behavior therapy, REBT, was developed by Albert Ellis and holds the central belief that the events in our lives do not cause our disturbances but that they are instead caused by our view of the events (Murdock, 2009). Murdock (2009) states that “people are seen as responsible for their behavior” (p. 279) but, because they are

Holidays In Albania Essay

1636 words - 7 pages exhibits the life of Albanians since the Illyrian time until the communism period (Howe 5). Dedicate the next visit to the Albanian official institutions, which lie along “Mother Teresa” boulevard. To proceed, Kruja is the city of the famous Skanderbeg. As it is shown in the film The Great Warrior Skanderbeg, many battles between Albanians and Turkish have taken place around the Skanderbeg castle. Therefore, this castle is worth seeing. The famous