The Maya Essays - Maya Classic Period, Maya Civilization, Tikal

The Maya The Maya The Maya were once considered one of the greatest civilizations in North America, and possibly the world. They built many pyramids and temples to honor their gods and to preserve their religion. Their lives revolved around their king and sacrifice of his blood. The cultural achievements of the Maya along with the educational achievements came centuries before other cultures. These achievements still exist today along with the Mayan culture, which has spanned over two thousand years. The Mayan people of today still hold these traditions sacred and want to preserve them. Only about two million Mayan Indians exist today, but their culture reflects that of their ancestors, along with the Spanish, who invaded the Maya around the sixteenth century. Archeologists who have dug up and studied many Mayan sites trace the Mayas back ten thousand years when their ancestors migrated from Asia to the Yucatan peninsula and northern Central America. The history of the Maya is divided into three major time periods: preclassic (two thousand BC ? AD three hundred), classic (AD three hundred ? AD nine hundred), and postclassic (AD nine hundred ? AD fifteen hundred). Early Mayan settlements date back to twenty four hundred BC, but few traces of Mayan culture before AD four hundred have been found. In the preclassic era of Mayan history, corn was farmed and the early Mayans laid a base for their culture, which was believed to have been influenced by the Olmec Indians near-by. The very first hieroglyphics were written, and cities started to appear. The early Mayan economy was based on agriculture and the exchange of farm goods. The Maya grew Indian corn, or maize. It was a staple food of many Indians in Central America for centuries. The Mayans developed the slash-and-burn farming method. A Mayan farmer would clear the cornfield by cutting bushes and girdling trees, and then he would allow the piled brush to catch fire under the hot sun. The ashes were then scattered among the stumps of the trees, and a sharp stick called a mattock was used to poke holes in the ground for the seeds to be laid. This method was used for centuries and it made farming the basis of the Mayan economy. It is estimated that as many as one hundred and fifty days out of the year were free from farm labor. Using the time off from farming, the Mayans built magnificent cities and temples to honor their many gods. In early Mayan history, homes were built with wattle-and-daub walls in an oval shape with a thatched roof of palmetto fronds. These homes stayed dry when it was raining, and cool when it was hot. They contained very little furniture, and were used only for eating and sleeping. Decedents of the Maya still continue to build and live in these huts today. The Mayans used stone to construct temples and pyramids. Some of their best creations include: the Caracol, an astronomical observatory in Chichen-Itza, the tomb of Lord Pacal (inside the Temple of the Inscriptions), the royal palace, which was used to look out for invaders over the Usumacinta River, El Castillo, or the Pyramid of Quetzalcoatl (the feathered serpent), and finally the Temple of the Magician, which was rebuilt five times to follow the rounds of the Mayan calendar every fifty two years. The great architecture was only one of the many aspects that made the Maya such an advanced civilization. The Maya reached their height in the classic period (AD three hundred to AD nine hundred). Over one hundred cities existed during this time, and some of the most advanced included: Tikal, Uaxactun, Quirigua, Copan, Palenque, Uxmal, Kabah, Sayil, Labna, Etzna, Old Chichen, and Coba. All of these cities served as cultural, religious, and spiritual centers for the Mayan people and rulers. Culture was a very important aspect of Mayan life. The Mayans favorite way to express their pride and religious devotion was to build many temples, pyramids, and building that would all form large cities. The Mayan workers who constructed these dwellings often decorated the walls with many pictures and symbols that would tell anything from a person's life to an important religious belief or tale.

The Geography of Terrorism essays

The Geography of Terrorism essays In "Terrorism's Widening Circle" and "From Terrorism to Insurgency," the author traces the specific geographic issues related to terrorism in the modern age. While terrorism is hardly new, the scope and nature of terrorist attacks have been changing over the recent years, a fact that became quite evident in the United States and the world on September 11, 2001. It was at that moment that the reality of Islamic terrorism became manifest for the world, including the terrorist movements willingness to go to extreme lengths in attacks on the West. Chapters 8 and 9 of the text, respectively listed above, describe the geographical component of terrorism in the modern age and the importance it plays in our understanding of Islamic terrorism, its roots, and its intentions. In "Terrorism's Widening Circle" the author describes circuitously the non-locality of Islamic terrorism in comparison with other major terrorist groups. What does this mean? In a geographical sense, most terrorist groups in the past have been local or regional in their organization. Consider the Irish Republican Army, which is situated firmly in Northern Ireland and has engaged nearly all of its operations in that region. Or we might consider Aum Shinryuko, the Japanese cult and terrorist organization responsible for the sarin gas attack on the Tokyo subway. They, too, centered nearly all of their activities in a single nation, a single geographical region. The modern Islamic terrorist movement, on the other hand, does not operate in such a limited fashion. Defying the logic of national boundaries, Islamic terrorism has apparently struck out war on all fronts against any ideological enemy. By and large, this has meant attacks on the West. But because Western interests are strewn around the globe, Islamic terrorist organizations have responded by attacking targets throughout the world. This non-locality makes traditional containment and control operations by nations...

Rewright this paper Essay Example | Topics and Well Written Essays - 500 words - 2

Rewright this paper - Essay Example Creative communities are groups of people that have dedicated themselves to discovering how to introduce new ways of eating, building and communicating to the general society. These communities are designed to discover new models of sustainable living through the creativity of the community members. All creative communities share some characteristics. The members of a creative community try to take care of their needs for things like education and health care within the community. They try to provide for the needs of humanity at the local level and in a way that is safe for future generations. They think locally with the idea of setting an example of proper living for the nation. Some people say that creative communities isolate themselves from the rest of society. They say that this keeps them from influencing anything. This is not true, because member of creative communities participate in institutions of the larger society. This is how they share their ideas and experiences. For a very long time the term designer has had a specific definition. A designer was viewed as a person that made a plan and then other people were to follow the plan. Manzini challenges this view by saying a designer is anyone that acts in for change in society. Therefore, people who wear the title of designer as well as members of creative communities or regular citizens can be viewed as designers. Traditional vies of design are still valid. Designers can operate within their areas of expertise. This way they can imagine and create those things that do not exist yet. What needs to change is the isolation of the designer. Design needs to be seen as a social learning process. In this view, the designer is more of a facilitator than a boss. The designer works with the community enacting change instead of directing the change. The designer needs to use the skills they possess to facilitate the changes. This change makes the designer’s job more complex. Instead of

Article Reviews Essay Example | Topics and Well Written Essays - 500 words - 2

Article Reviews - Essay Example He brought with him a young boy and though it was too late, the judge allowed him to be sworn in to stand up for Good. The boy said he had seen it himself. The accuser had lied about the knife mysteriously breaking. The accuser was in trouble for lying to the judge. But Sarah Good , the alleged witch, was still sentenced to death. This became the start of something strange: a witch hunt. All people who seemed to be able to conduct something â€Å"magical† were hunted and it was throughout all of the New England states in America. An author Cotton Mather, had seen the effects of the people who were afflicted with this witchcraft. Blistered with fire, pins stuck into their flesh by invisible hands, convulsions, and scalded with hot water; these were just some of the claims of accounts afflicted upon people who said that they were affected by the witchcraft. Peoples only escape from conviction was to tell the truth, which was actually sometimes a lie. Many people died because they were found to be suspicious people; people of the devil. The author wrote this article to tell about the trials and oddities surrounding the Salem Witch Trials. It was a narrative telling about particular instances in trials and tribulations that described what it was like in New England during the time when everyone was out to chase and destroy whomever they thought practiced witchcraft, magic labeling them witches. This article was written as a news story that appeared in the area newspaper in Baltimore, Maryland in the mid 1800s to tell the story of how the hunt and execution of witches came to begin. The article originally began with the narration of the story of Sarah Good. But in this article, she was merely an example of what others had to expect if they were suspicioned of conducting witchcraft. The author barely touched on all of the occurrences during the

Research paper on emily dickinson with some analysis of her work Essay

Research paper on emily dickinson with some analysis of her work - Essay Example Her poems were marked by very close descriptions of inspirational moments, and moments of happiness. Most of here poems centered around ideas of death and immortality. Her works received severe criticism in the late 19th and early 20th century, but she is now considered as a major American poet by most (Bloom, 9). Before 1861: Only five poems have been dated to be written before 1858 (Pickard, 20). These are more conventional in nature than her later works, and are based on subjects like valentines, her feared of loss of friendship, her missing of her brother. Dickinson’s work showcases her artistic prowess and is centered around a variety of themes. She is often regarded as a transcendentalist as she was deeply inspired by works of Emerson. Her poems had a very intelligent usage of humor, sarcasm, irony, and satire (Wolff, 171). Some of the major themes that can be seen her works include: Morbidity: This theme of her characterized by her interest with topics like illness, dying and death. Her poems describe death by many methods: drowning, hanging, suffocation, premature burial, stabbing and so on. Her sharpest work came in the form of â€Å"death blow from the GOD† and â€Å"funeral in the brain†. These works reflect the starving characteristic of her personality. Her most complex work is based on the principle of death of self because of the loss of hunger for life. Flowers and gardens: Poems written in the early period of her life were characterized by an intelligent blending of her poetry with a bouquet. Farr (1-7) notes that she associates some flowers like the gentians and anemones to youth and humility; while others with prudence and insight. Examples of such work by her include: "My nosegays are for Captives –  / Dim – long expectant eyes –  / Fingers denied the plucking,  / Patient till Paradise –  / To such, if they shd

Database Management System for Car Company

Database Management System for Car Company STRATEGY ANALYSIS DESCRIPTION OF CURRENT BUSINESS ACTIVITIES INTRODUCTION DMC is a Dedicated cars company that is specialized in Car sales business, and it was established Four years ago in 7th May 2005, and its main name stands for Dedicated Motor Cars and its main division is in Tripoli Libya, it is a company with many high workers and skilled employees working on it as they are sharing the same ambition, and always aiming for the best in their business, in both to improve their employees skills and also to provide the best services to their dear customer. DMC is really working hard to achieve a new improvement in their business every year, also to get the most popular and successful cars to get them, and for the best prices to its customers, as they are also filling their case show with a good collection in each month. As for this month they got a very promising collection of new cars that just released this year, and old ones but got well comments from millions of people who tried them, this collection will be for this year as in this time its the companys season time for the business. Current System The current system of my company is going like this, each day we are improving, and as I can see now we are well known as 1 of the top 20 Private companies in Libya, and we are also known in the other continents as well. We are also not restrict with only 1 nationality as we are offering jobs, because our company contains employees from different nationality as we have some of them in the main division and some other are in our different offices around the globe. DMC has a good budget as overall, and it is improving, also the customers are so pleased with our services in general, and our economical prices. That includes that we are always taking care of our employees in terms of payment and to keep them improving by sending them to take courses in different kind of fields. Although we are doing a pretty good job in this business field and improving by a good rate percentage every year, but we are really facing some of the major problems in our business, the main problem is that we are facing a new changes and new challenges in our business, also we have other competitors companies in the countries we are doing this business and selling our cars and making our different services. Problem Background Effects of it So our main problem actually includes semi problems that we should take care of them so we can solve the main problem, which is we really need to move on with our services with the technology we are facing these days in doing those kind of business to make it better, faster, and easier. And 1st of all is our own system in the company, because it is still not well organized as an strong infrastructure and we also need a well studied design model for this infrastructure for our company. Thats where I planned to made a Special database system to our company, which will be including our employees, our daily customers for each season, and our sales of cars on this season on as well covered by the invoice section of the company, and some specific information about our shipment idea and its fee and coverage services. The good thing is that with this new system we will be able to make a clear and direct relational between all the sections mentioned above and make a really strong infrastructure for the company plus to be able to store information and data more sufficiently. In this segment I would like to give you an idea about the goals and aims that we are aiming to achieve and they are: Improve the business even much further, to reach a new level of development. Reduce the paper work as we had a lost of some data from time to time. To always keep up with the other contenders companies so we wont lose our customers. Secure our data in a sufficient way. Provide a system where it is easy to get data for any of our customers. Improvement of production to satisfy the customers needs. Easy access to database and information used by employees. Remove barriers to widen its production by improving sales procedure and reducing costs. Hardware and Software Necessity These are all the hardware requirements needed Minimum Requirements Processor 2 Gigahertz (GHz) Pentium IV-Intel processor or Higher. Memory 512 MB of RAM or Higher. Hard Disk 900 MB of available space required on the system drive, 4 gigabytes (GB) of available space capacity on the installation drive. Drive DVD-ROM or CD-ROM drive and Floppy drive Display Super VGA (1024 x 768) or higher resolution. These are all the software requirements needed Minimum Requirements Operating Systems Windows XP Service Pack Final, Windows Vista, or Windows 7 any edition with MS-Office. H I S T O R Y DMC Companys history is not that much as the company only established two years ago, but in those two years we can say that the company earned its name and make various successful that led it to earn a respectful history archive in the day it starts doing business till our day now. Specification for New System The main purpose from making this new application in my company is 1st to achieve the objectives that DMC is aiming to achieve, 2nd to make the business much easier for the customer and the employee as each of them will have the advantage of these kind of applications in our business. Also the cars sales section (which is the Cars Details) will be much more attractive this way, and as it shows all the possible information that needed at the same time. That goes for the employee and customers tables as well; they are helping the company over all by making it progressing even much faster and also to reduce the paper work. About Us table shows the company in a really short cut way, and its true words shows on this section, also for the producer of this application to have his word on that section. Also the shipment tables is an important section and it is one of the reasons to determine whether a certain car sales company is really know about its business and can keep up, or sadly but have no idea about this field of business as it helps a lot in showing exactly the steps taking to ship your car and to not need to discuss any of the employee about it because it is very clear. On the other hand, last one but not last, is Plate Info table, which holds all the plate number for the cars that have been purchased from our company, and also saving the numbers from the other cars for the customers that are ding services for their own car. BUISNESS ACTIVITIES OPERATIONS DESCRIPTION OF OPERATIONS Þ Assign an Employee to handle a certain invoice. Þ Check the Country of the Customer to make the delivery shipment service for his/her order. Þ Adding an Employee to the company. Þ Assign a Unique ID to a Customer. Þ Adding a new Car to the showcase. Operation Name: Assign an Employee to handle a certain invoice. Description: This operation handles the fact that when we are having a new invoice table, we hand it over to a certain employee, and a (certain) employee means that he/she is not busy with another invoice or another operation in the moment. Input: The assigned Employee must appear his/her unique ID number, along with his name, and should be clear to read. Output: The Employee will be responsible for that invoice, and handle its full data. ============================ Operation Name: Check the Country of the Customer to make a delivery shipment service for his/her order. Description: This operation handles the action when the Customer wants to make a shipment service for his current order and to make it to a certain country. Input: The Customer must give information about the destination (Country) area where he/she wants to deliver the order. Output: The Customer will be given an information about the shipment service such as the fee that known for that country. ============================ Operation Name: Adding an Employee to the company. Description: As DMC expanding greatly in the past years, we are making this issue more than usual lately, and it is about recruiting a new employee to the company, further adding his information to the database. Input: For this operation we need to have the new Employee Name, Age, Nationality, and his/her Date of Birth to be able to add him/her to our database. Output: The new Employee will be added to our database, and will be given a Unique ID number to be known as one of DMC employees. ============================ Operation Name: Assign a Unique ID to a Customer. Description: This operation deals with having a new customer and need to be having his/her information in our database to be given an ID number for easily checking the customer status when he/she makes more orders in the future. Input: To make this operation successful, we need to have basic information yet helpful for us such as Name, Age, and Contact number. Output: The Customer has been given a unique ID number. BUSINESS ACTIVITIES This section describes the operations of DMC Company which is as I mentioned before but in more specific it deals with car sales that the company get from other retailers which recently built up a really strong relationship with DMC and are getting the best deals to expand our business. So mainly DMC deals with customers with services, and we do car sale business, also we are very restrict with our system and the invoice we made are very clear for every car, further our employees are doing their best in every deal been made for each car. And more to mention here for our upcoming Database building is that we are going to build a new design system model that contains Cars, Employee, Invoice, Shipment, and Customer. Those Five elements that I mentioned above will be our main focus on this database design, as it is in general what DMC is is all about. For that matter here we are going to explain in details every Element we have for our Design Model, been explained by including its Attributes and a brief description about its main purpose. And every element will be known later on in the database description as Entity. Invoice Entity This entitys main purpose is to keep track of the sales, and for every deal that have been sold by whom as an employee and for whom as a customer, also it will display all the data necessary about the product (Car) AND ITS Unique ID, plus other major information such as total price and the invoice reset number, whats more is this entity acts as the main entity related to all the other entities as it is also related to the (Shipment) entity as it also saves the shipment number in the invoice paper. The Attributes that have been made for this Entity are: Invoice_Number, Customer_ID, Employee_ID, Shipment_Nmber, Total_Price, and Car_ID, and we will be talking about all the attributes for every entity in more details later on. Cars Entity This entity deals with all the cars that the company DMC stores, and contains all its details such as the car brand name, its color and the car ID, and the shipment number for every specific shipment that been made, along with the most important attribute for all the customers which is: the cars price. Employee Entity This entity here will be busy of containing the Employee_ID, Name, Age, Nationality, and Date of Birth, it will be also including two separated types of employees and they are: Part Time, and Full Time. Customer Entity This Entity is busy with giving the full information needed about the customers we are dealing with such as their Customer_ID, Name, Age, Contact_Number, and these information will be helpful in many facts in our company such as in making our invoices and assigning a specific car for a certain customer. Shipment Entity Shipment entity is one of the services that made our company earn its name in such a short time, as this service allow a full shipment service for as much as needed for cars for our customers viewed with its price, and a unique Shipment_Number, also the Country attributes as it tells the destination for each shipment services and the Fee attribute to tells the price for each country shown on the list. BUSINESS RULES In this section we will be listing DMC companys main rules in its business, as for our customers for an example they are able to buy as much cars as they can with no any problems but for our cars in the stock we cannot offer to sell the car for more than one and only one customer, also with our employees as any 1 of our employees can deal with more than just one car, but for the cars they should be dealt with only one employee to make the sell process. And as for these examples here we will be listing all the business rules for our company to make sure to be followed as it is: For every Shipment service that been made, it has to be assigned into an invoice that is related to it and that is a MUST. Every Car in stock can have one invoice specialize for it; same goes for the invoice as we made only one car can fit in each invoice rather than more than just one to make the business more flexible. Every Car can have a shipment service depends on the customers need, and as for this shipment service, it can be done for more than just one car as well, but it should be made for at least one car for this service to be available. For every single customer, he/she can belong to more than just one invoice depends on the orders he/she made and how many cars been bought, and in the other hand for the invoice it can only belong to one and only one customer, means we cannot include two customers buying the same car model in one invoice because they sold the same car model. Every employee can handle more than just one invoice when making the selling process, he/she can serve more than just one invoice, but for the invoices, every invoice should be handled by only one employee. Also we have to make sure that we wont start the buying process for our customers unless we have their personal data in our database system. For our new employees, we cannot let them start working in active business unless the process of having their personal information inside our database is done. INITIAL E.R DESIGN SPECIFICATION TABLE SPECIFICATION Inside DMC database I would like to create few modules and show the way to create them, and the purpose of making them, plus the reason of every column, so they can help me on the objectives Im aiming to achieve which they are: Database Description My database consists of five tables (And two sub-type tables that will be mentioned later on) and they are: Cars Invoice Customer Employee Shipment Table Specification Table Name: Invoice Table Description: To be used as a reference of all the sales of the company. Attribute of the Table: Invoice_Number, Customer_ID, Car_ID, Employee_ID, Shipment_Number, Total_Price. Table Type: Independent. Primary Key: Invoice_Number. ============================ Table Name: Customer Table Description: To be shown the customer basic information, along with his/her unique ID number. Attribute of the Table: Customer_ID, Name, Age, Contact_Number. Table Type: Independent Primary Key: Customer_ID ============================ Table Name: Employee Table Description: To be shown the Employee private data inside the database. Attribute of the Table: Employee_ID, Name, Nationality, Date of Birth. Table Type: Independent (Supertype) Primary Key: Employee_ID ============================ Table Name: Cars Table Description: To be shown the Car basic data, along with the cars price and its shipment number. Attribute of the Table: Brand_Name, Color, Car_ID, Shipment_Number, Price. Table Type: Independent Primary Key: Car_ID ============================ Table Name: Shipment Table Description: To be shown more specific information about the shipment service, such as the countries that are available for the service, plus the fee. Attribute of the Table: Shipment_Number, Country, Fee Table Type: Independent Primary Key: Shipment_Number ============================ Table Name: Full Time Table Description: To be shown more specific information about the Full Time employees, such as the Salary for the Full Time employees section, and the administration section which shows each full time employee and hi/her related administration division, along with the Employee ID. Attribute of the Table: Employee_ID, Salary, and Administration. Table Type: Independent (Subtype) Primary Key: Employee_ID ================================ Table Name: Part Time Table Description: To be shown more specific information about the Part Time employees, such as their Salary as well, and the Part time employees time shifting for their work time, and for sure their employee ID.. Attribute of the Table: Employee_ID, Salary, and Time Shifting. Table Type: Independent (Subtype) Primary Key: Employee_ID ATTRIBUTE SPECEFICATION 1. Invoice Entity Name: Invoice Primary Key: Invoice_Number Name Datatype Length Classification Allow Null Constraints Description Invoice_Number Int Simple No Unique A certain unique numbers to keep track of each invoice Customer_ID Varchar (10) Simple No Unique The ID for a customer Employee_ID INT (10) Simple No Unique The unique ID for an employee Car_ID Varchar (10) Simple No Unique The ID for a car Total_Price Double Simple No Unique Total price of a certain invoice Shipment_Number Int (10) Simple No Unique Unique number made for a certain shipment made 2. Cars Entity Name: Cars Primary Key: Car_ID Name Datatype Length Classification Allow Null Constraints Description Brand_Name VarChar (20) Simple No Unique Model name of the car Color VarChar (10) Simple No Unique Color of the car Car_ID Varchar (10) Simple No Unique The ID for a car Shipment_Number Int (20) Simple No Unique Unique number made for a certain shipment made Price Double Simple No Unique Actual Price of a car 3. Employee Entity Name: Employee Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Name VarChar (20) Simple No Unique The first name of employee Nationality Varchar (20) Simple No Unique The employees nationality Date of Birth Date Simple No Unique The employees date of birth 4. Customer Entity Name: Customer Primary Key: Customer_ID Name Datatype Length Classification Allow Null Constraints Description Customer_ID Varchar (10) Simple No Unique The ID for a customer Name VarChar (10) Simple No Unique The first name of a customer Age Int (2) Simple No Unique The customer age Contact_Number Int (10) Simple No Unique Customer Contact number 5. Shipment Entity Name: Shipment Primary Key: Shipment_Number Name Datatype Length Classification Allow Null Constraints Description Shipment_Number Int (20) Simple No Unique Unique number made for a certain shipment made Country VarChar (10) Simple No Unique The country where the shipment destination Fee Int (5) Simple No Unique The price of the shipment 6. Full Time (Sub-Type Entity) Entity Name: Full Time Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Salary Currency Simple No Unique The salary of a particular employee Administration VarChar (20) Simple No Unique The certain task that the employee is responsible for 7. Part Time (Sub-Type Entity) Entity Name: Part Time Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Salary VarChar (10) Simple No Unique The salary of a particular employee Time Shifting Date/Time Simple No Unique The certain day that the employee have his/her work shifts on CODING CREATING OF TABLES CREATING OF TABLES As for my companys project for our database I used Microsoft Office Access 2007, and I started creating tables on it. [1] Cars Table Script Name Create Cars Table CREATE TABLE Cars ( Car_ID VARCHAR PRIMARY KEY NOT NULL, Brand_Name VARCHAR(20) NOT NULL, Color VARCHAR(10) , Shipment_Number INTEGER(20) NOT NULL, Price Double NOT NULL, ); [2] Invoice table Script Name Create Invoice Table CREATE TABLE Invoice ( Invoice_Number INTEGER PRIMARY KEY NOT NULL, Customer_ID VARCHAR(10) NOT NULL, Car_ID VARCHAR(10) NOT NULL, Shipment_Number INTEGER(10) NOT NULL, Price Double NOT NULL, ); [3] Customer table Script Name Create Customer Table CREATE TABLE Customer ( Customer_ID VARCHAR PRIMARY KEY NOT NULL, Name VARCHAR(10) NOT NULL, Age INTEGER(2) NOT NULL, Contact_Number INTEGER(10) NOT NULL, ); [4] Employee table Script Name Create Employee Table CREATE TABLE Employee ( Employee_ID VARCHAR PRIMARY KEY NOT NULL, Name VARCHAR(20) NOT NULL, Nationality VARCHAR(20) NOT NULL, Date of Birth Date NOT NULL, ); [5] Shipment table Script Name Create Shipment Table CREATE TABLE Shipment ( Shipment_Number INTEGER PRIMARY KEY NOT NULL, Country VARCHAR(10) NOT NULL, Fee INTEGER(10) NOT NULL, ); CONSTRAINTS SPECIFICATION Generalization hierarchy on an Employee. Description: This hierarchy assigns the Employee entity as Supertype, and Full Time, Part Time as Subtypes, and since the both subtypes have many similarities, the Supertype have the attributes in common to the subtypes and they are: Employee_ID, Name, Nationality, Date of Birth. . The subtypes cannot be one in another, means the Full Time employee cannot be a Part Time employee, and therefore this generalization hierarchy is of the type disjoint. Type: Disjoint Super type Entity: Employee Super type Primary Key: Employee_ID Common Attributes: Employee_ID, Name, Nationality, Date Of Birth. Constraints Full Time: This subtype entity shows certain data about the Full time employees in the company and their related information which is needed to our database. As for the attributes for this entity: Employee_ID, Salary, Administration. Part Time: This subtype entity shows the data the other type of employees which is the part time employee type. As for the attributes for this entity: Employe_ID, Salary, Time shifting, INITIAL POPULATING OF TABLES Cars Table Populating Table (Cars) INSERT INTO Cars (Brand_Name, Color, Car_ID, Shipment_Number, Price) VALUES (Mustang, Orange, 17111, 11333, 40000) ; Invoice Table Populating Table (Invoice) INSERT INTO Invoice (Invoice_Number, Customer_ID, Car_ID, Employee_ID, Shipment_Number, Total_Price) VALUES (11, 9844, 17633, 1432, 11771, 25) ; Customer Table Populating Table (Customer) INSERT INTO Customer (Customer_ID, Name, Age, Contact_Number) VALUES (9020, Avinash, 39, 2800131) ; Employee Table Populating Table (Employee) INSERT INTO Employee (Employee_ID, Name, Nationality, Date of Birth) VALUES (1422, Vadimas, Libyan, 2/21/1986) ; Shipment Table Populating Table (Shipment) INSERT INTO Shipment (Shipment_Number, Country, Fee) VALUES (11311, Germany, 130) ; Full Time Table Populating Table (Full Time) INSERT INTO Full Time (Employee_ID, Salary, Administration) VALUES (1433, 1300, Secretary) ; Part Time Table Populating Table (Part Time) INSERT INTO Part Time (Employee_ID, Salary, Time Shifting) VALUES (1441, 2000, 3/23/2009) ; USERS INPUT (INSERTION, DELETION, UPDATE) INSERTION: Add New Car (Cars Table) Query name: Insert (New Car in the cars showcase) INSERT INTO Cars (Brand_Name, Color, Car_ID, Shipment_Number, Price) VALUES ([Type the Cars Brand], [Type the Color of the Car ], [The Car ID], [The Shipment Number related to this Car], [The Price of this Car is); INSERTION 2 Here we are going to try to insert a new data into the Shipment form, as we will be using it through the Shipment form insertion button included in that form. Then here the database will ask you if your up for inserting new data into that form And here the data has been inserted successfully below UPDATE: Update New Customer (Customer Table) Query name Update (New Customer in the Customers Table) UPDATE Customer SET Contact_Number = [Enter Customers phone number] WHERE Customer_ID = [ID]; DELETION: Delete a Shipment Country (Shipment Table) DELETE * FROM Shipment WHERE Country = [Enter the Country that will be eliminated]; PERFORMING QUERIES, SUB-QUERIES QUERY [1] (Performing Alias technique into a Query) Description: To manage all the Employees names into one query QUERY [2] (Performing Function technique into a Query) Description: To display all the cars available at the moment QUERY [3] (Performing Concatenation technique into a Query) Description: To give a brief description about each car in the showcase QUERY [4] (Performing Sub-Query technique into a Query) Description: To Create a query from the employee data where it concern only employees who are British. QUERY [5] (Performing another Sub-Query technique into a Query) Description: To Create a query from the Cars data where it concern only the minimum prices of listed cars plus be grouped by the cars brand name. TESTING Test case : 1 Objectives : To use ALIAS in Employee Table Test Data : SELECT NAME AS FULLNAME FROM Employee; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 2 Objectives : To use ALIAS in Customer Table Test Data : SELECT Name AS CustomerName FROM Customer; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 3 Objectives : To use ARITHMETIC in Car Table Test Data :SELECT Car_ID, Brand_Name, (Price*2) AS [Price with Shipment] FROM Cars; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 4 Objectives : To Create Shipment Table Test Data : CREATE Table Shipment ( Shipment_Number int (5), Country varchar (10), Fee money (10) ) ; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 5 Objectives : To use COMPARISON in Cars Table Test Data : SELECT Car_ID, Brand_Name FROM Cars WHERE Price>6000; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 6 Objectives : To use COMPARISON in Shipment Table Test Data : SELECT Shipment_Number, Country FROM Shipment WHERE Fee Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 7 Objectives : To Create Cars table Test Data : CREATE Table Cars ( Car_ID int (5), Shipment_Number int (5), Brand_Name varchar (10), Color varchar (10), Price (10) ) ; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test Database Management System for Car Company Database Management System for Car Company STRATEGY ANALYSIS DESCRIPTION OF CURRENT BUSINESS ACTIVITIES INTRODUCTION DMC is a Dedicated cars company that is specialized in Car sales business, and it was established Four years ago in 7th May 2005, and its main name stands for Dedicated Motor Cars and its main division is in Tripoli Libya, it is a company with many high workers and skilled employees working on it as they are sharing the same ambition, and always aiming for the best in their business, in both to improve their employees skills and also to provide the best services to their dear customer. DMC is really working hard to achieve a new improvement in their business every year, also to get the most popular and successful cars to get them, and for the best prices to its customers, as they are also filling their case show with a good collection in each month. As for this month they got a very promising collection of new cars that just released this year, and old ones but got well comments from millions of people who tried them, this collection will be for this year as in this time its the companys season time for the business. Current System The current system of my company is going like this, each day we are improving, and as I can see now we are well known as 1 of the top 20 Private companies in Libya, and we are also known in the other continents as well. We are also not restrict with only 1 nationality as we are offering jobs, because our company contains employees from different nationality as we have some of them in the main division and some other are in our different offices around the globe. DMC has a good budget as overall, and it is improving, also the customers are so pleased with our services in general, and our economical prices. That includes that we are always taking care of our employees in terms of payment and to keep them improving by sending them to take courses in different kind of fields. Although we are doing a pretty good job in this business field and improving by a good rate percentage every year, but we are really facing some of the major problems in our business, the main problem is that we are facing a new changes and new challenges in our business, also we have other competitors companies in the countries we are doing this business and selling our cars and making our different services. Problem Background Effects of it So our main problem actually includes semi problems that we should take care of them so we can solve the main problem, which is we really need to move on with our services with the technology we are facing these days in doing those kind of business to make it better, faster, and easier. And 1st of all is our own system in the company, because it is still not well organized as an strong infrastructure and we also need a well studied design model for this infrastructure for our company. Thats where I planned to made a Special database system to our company, which will be including our employees, our daily customers for each season, and our sales of cars on this season on as well covered by the invoice section of the company, and some specific information about our shipment idea and its fee and coverage services. The good thing is that with this new system we will be able to make a clear and direct relational between all the sections mentioned above and make a really strong infrastructure for the company plus to be able to store information and data more sufficiently. In this segment I would like to give you an idea about the goals and aims that we are aiming to achieve and they are: Improve the business even much further, to reach a new level of development. Reduce the paper work as we had a lost of some data from time to time. To always keep up with the other contenders companies so we wont lose our customers. Secure our data in a sufficient way. Provide a system where it is easy to get data for any of our customers. Improvement of production to satisfy the customers needs. Easy access to database and information used by employees. Remove barriers to widen its production by improving sales procedure and reducing costs. Hardware and Software Necessity These are all the hardware requirements needed Minimum Requirements Processor 2 Gigahertz (GHz) Pentium IV-Intel processor or Higher. Memory 512 MB of RAM or Higher. Hard Disk 900 MB of available space required on the system drive, 4 gigabytes (GB) of available space capacity on the installation drive. Drive DVD-ROM or CD-ROM drive and Floppy drive Display Super VGA (1024 x 768) or higher resolution. These are all the software requirements needed Minimum Requirements Operating Systems Windows XP Service Pack Final, Windows Vista, or Windows 7 any edition with MS-Office. H I S T O R Y DMC Companys history is not that much as the company only established two years ago, but in those two years we can say that the company earned its name and make various successful that led it to earn a respectful history archive in the day it starts doing business till our day now. Specification for New System The main purpose from making this new application in my company is 1st to achieve the objectives that DMC is aiming to achieve, 2nd to make the business much easier for the customer and the employee as each of them will have the advantage of these kind of applications in our business. Also the cars sales section (which is the Cars Details) will be much more attractive this way, and as it shows all the possible information that needed at the same time. That goes for the employee and customers tables as well; they are helping the company over all by making it progressing even much faster and also to reduce the paper work. About Us table shows the company in a really short cut way, and its true words shows on this section, also for the producer of this application to have his word on that section. Also the shipment tables is an important section and it is one of the reasons to determine whether a certain car sales company is really know about its business and can keep up, or sadly but have no idea about this field of business as it helps a lot in showing exactly the steps taking to ship your car and to not need to discuss any of the employee about it because it is very clear. On the other hand, last one but not last, is Plate Info table, which holds all the plate number for the cars that have been purchased from our company, and also saving the numbers from the other cars for the customers that are ding services for their own car. BUISNESS ACTIVITIES OPERATIONS DESCRIPTION OF OPERATIONS Þ Assign an Employee to handle a certain invoice. Þ Check the Country of the Customer to make the delivery shipment service for his/her order. Þ Adding an Employee to the company. Þ Assign a Unique ID to a Customer. Þ Adding a new Car to the showcase. Operation Name: Assign an Employee to handle a certain invoice. Description: This operation handles the fact that when we are having a new invoice table, we hand it over to a certain employee, and a (certain) employee means that he/she is not busy with another invoice or another operation in the moment. Input: The assigned Employee must appear his/her unique ID number, along with his name, and should be clear to read. Output: The Employee will be responsible for that invoice, and handle its full data. ============================ Operation Name: Check the Country of the Customer to make a delivery shipment service for his/her order. Description: This operation handles the action when the Customer wants to make a shipment service for his current order and to make it to a certain country. Input: The Customer must give information about the destination (Country) area where he/she wants to deliver the order. Output: The Customer will be given an information about the shipment service such as the fee that known for that country. ============================ Operation Name: Adding an Employee to the company. Description: As DMC expanding greatly in the past years, we are making this issue more than usual lately, and it is about recruiting a new employee to the company, further adding his information to the database. Input: For this operation we need to have the new Employee Name, Age, Nationality, and his/her Date of Birth to be able to add him/her to our database. Output: The new Employee will be added to our database, and will be given a Unique ID number to be known as one of DMC employees. ============================ Operation Name: Assign a Unique ID to a Customer. Description: This operation deals with having a new customer and need to be having his/her information in our database to be given an ID number for easily checking the customer status when he/she makes more orders in the future. Input: To make this operation successful, we need to have basic information yet helpful for us such as Name, Age, and Contact number. Output: The Customer has been given a unique ID number. BUSINESS ACTIVITIES This section describes the operations of DMC Company which is as I mentioned before but in more specific it deals with car sales that the company get from other retailers which recently built up a really strong relationship with DMC and are getting the best deals to expand our business. So mainly DMC deals with customers with services, and we do car sale business, also we are very restrict with our system and the invoice we made are very clear for every car, further our employees are doing their best in every deal been made for each car. And more to mention here for our upcoming Database building is that we are going to build a new design system model that contains Cars, Employee, Invoice, Shipment, and Customer. Those Five elements that I mentioned above will be our main focus on this database design, as it is in general what DMC is is all about. For that matter here we are going to explain in details every Element we have for our Design Model, been explained by including its Attributes and a brief description about its main purpose. And every element will be known later on in the database description as Entity. Invoice Entity This entitys main purpose is to keep track of the sales, and for every deal that have been sold by whom as an employee and for whom as a customer, also it will display all the data necessary about the product (Car) AND ITS Unique ID, plus other major information such as total price and the invoice reset number, whats more is this entity acts as the main entity related to all the other entities as it is also related to the (Shipment) entity as it also saves the shipment number in the invoice paper. The Attributes that have been made for this Entity are: Invoice_Number, Customer_ID, Employee_ID, Shipment_Nmber, Total_Price, and Car_ID, and we will be talking about all the attributes for every entity in more details later on. Cars Entity This entity deals with all the cars that the company DMC stores, and contains all its details such as the car brand name, its color and the car ID, and the shipment number for every specific shipment that been made, along with the most important attribute for all the customers which is: the cars price. Employee Entity This entity here will be busy of containing the Employee_ID, Name, Age, Nationality, and Date of Birth, it will be also including two separated types of employees and they are: Part Time, and Full Time. Customer Entity This Entity is busy with giving the full information needed about the customers we are dealing with such as their Customer_ID, Name, Age, Contact_Number, and these information will be helpful in many facts in our company such as in making our invoices and assigning a specific car for a certain customer. Shipment Entity Shipment entity is one of the services that made our company earn its name in such a short time, as this service allow a full shipment service for as much as needed for cars for our customers viewed with its price, and a unique Shipment_Number, also the Country attributes as it tells the destination for each shipment services and the Fee attribute to tells the price for each country shown on the list. BUSINESS RULES In this section we will be listing DMC companys main rules in its business, as for our customers for an example they are able to buy as much cars as they can with no any problems but for our cars in the stock we cannot offer to sell the car for more than one and only one customer, also with our employees as any 1 of our employees can deal with more than just one car, but for the cars they should be dealt with only one employee to make the sell process. And as for these examples here we will be listing all the business rules for our company to make sure to be followed as it is: For every Shipment service that been made, it has to be assigned into an invoice that is related to it and that is a MUST. Every Car in stock can have one invoice specialize for it; same goes for the invoice as we made only one car can fit in each invoice rather than more than just one to make the business more flexible. Every Car can have a shipment service depends on the customers need, and as for this shipment service, it can be done for more than just one car as well, but it should be made for at least one car for this service to be available. For every single customer, he/she can belong to more than just one invoice depends on the orders he/she made and how many cars been bought, and in the other hand for the invoice it can only belong to one and only one customer, means we cannot include two customers buying the same car model in one invoice because they sold the same car model. Every employee can handle more than just one invoice when making the selling process, he/she can serve more than just one invoice, but for the invoices, every invoice should be handled by only one employee. Also we have to make sure that we wont start the buying process for our customers unless we have their personal data in our database system. For our new employees, we cannot let them start working in active business unless the process of having their personal information inside our database is done. INITIAL E.R DESIGN SPECIFICATION TABLE SPECIFICATION Inside DMC database I would like to create few modules and show the way to create them, and the purpose of making them, plus the reason of every column, so they can help me on the objectives Im aiming to achieve which they are: Database Description My database consists of five tables (And two sub-type tables that will be mentioned later on) and they are: Cars Invoice Customer Employee Shipment Table Specification Table Name: Invoice Table Description: To be used as a reference of all the sales of the company. Attribute of the Table: Invoice_Number, Customer_ID, Car_ID, Employee_ID, Shipment_Number, Total_Price. Table Type: Independent. Primary Key: Invoice_Number. ============================ Table Name: Customer Table Description: To be shown the customer basic information, along with his/her unique ID number. Attribute of the Table: Customer_ID, Name, Age, Contact_Number. Table Type: Independent Primary Key: Customer_ID ============================ Table Name: Employee Table Description: To be shown the Employee private data inside the database. Attribute of the Table: Employee_ID, Name, Nationality, Date of Birth. Table Type: Independent (Supertype) Primary Key: Employee_ID ============================ Table Name: Cars Table Description: To be shown the Car basic data, along with the cars price and its shipment number. Attribute of the Table: Brand_Name, Color, Car_ID, Shipment_Number, Price. Table Type: Independent Primary Key: Car_ID ============================ Table Name: Shipment Table Description: To be shown more specific information about the shipment service, such as the countries that are available for the service, plus the fee. Attribute of the Table: Shipment_Number, Country, Fee Table Type: Independent Primary Key: Shipment_Number ============================ Table Name: Full Time Table Description: To be shown more specific information about the Full Time employees, such as the Salary for the Full Time employees section, and the administration section which shows each full time employee and hi/her related administration division, along with the Employee ID. Attribute of the Table: Employee_ID, Salary, and Administration. Table Type: Independent (Subtype) Primary Key: Employee_ID ================================ Table Name: Part Time Table Description: To be shown more specific information about the Part Time employees, such as their Salary as well, and the Part time employees time shifting for their work time, and for sure their employee ID.. Attribute of the Table: Employee_ID, Salary, and Time Shifting. Table Type: Independent (Subtype) Primary Key: Employee_ID ATTRIBUTE SPECEFICATION 1. Invoice Entity Name: Invoice Primary Key: Invoice_Number Name Datatype Length Classification Allow Null Constraints Description Invoice_Number Int Simple No Unique A certain unique numbers to keep track of each invoice Customer_ID Varchar (10) Simple No Unique The ID for a customer Employee_ID INT (10) Simple No Unique The unique ID for an employee Car_ID Varchar (10) Simple No Unique The ID for a car Total_Price Double Simple No Unique Total price of a certain invoice Shipment_Number Int (10) Simple No Unique Unique number made for a certain shipment made 2. Cars Entity Name: Cars Primary Key: Car_ID Name Datatype Length Classification Allow Null Constraints Description Brand_Name VarChar (20) Simple No Unique Model name of the car Color VarChar (10) Simple No Unique Color of the car Car_ID Varchar (10) Simple No Unique The ID for a car Shipment_Number Int (20) Simple No Unique Unique number made for a certain shipment made Price Double Simple No Unique Actual Price of a car 3. Employee Entity Name: Employee Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Name VarChar (20) Simple No Unique The first name of employee Nationality Varchar (20) Simple No Unique The employees nationality Date of Birth Date Simple No Unique The employees date of birth 4. Customer Entity Name: Customer Primary Key: Customer_ID Name Datatype Length Classification Allow Null Constraints Description Customer_ID Varchar (10) Simple No Unique The ID for a customer Name VarChar (10) Simple No Unique The first name of a customer Age Int (2) Simple No Unique The customer age Contact_Number Int (10) Simple No Unique Customer Contact number 5. Shipment Entity Name: Shipment Primary Key: Shipment_Number Name Datatype Length Classification Allow Null Constraints Description Shipment_Number Int (20) Simple No Unique Unique number made for a certain shipment made Country VarChar (10) Simple No Unique The country where the shipment destination Fee Int (5) Simple No Unique The price of the shipment 6. Full Time (Sub-Type Entity) Entity Name: Full Time Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Salary Currency Simple No Unique The salary of a particular employee Administration VarChar (20) Simple No Unique The certain task that the employee is responsible for 7. Part Time (Sub-Type Entity) Entity Name: Part Time Primary Key: Employee_ID Name Datatype Length Classification Allow Null Constraints Description Employee_ID INT (10) Simple No Unique The unique ID for an employee Salary VarChar (10) Simple No Unique The salary of a particular employee Time Shifting Date/Time Simple No Unique The certain day that the employee have his/her work shifts on CODING CREATING OF TABLES CREATING OF TABLES As for my companys project for our database I used Microsoft Office Access 2007, and I started creating tables on it. [1] Cars Table Script Name Create Cars Table CREATE TABLE Cars ( Car_ID VARCHAR PRIMARY KEY NOT NULL, Brand_Name VARCHAR(20) NOT NULL, Color VARCHAR(10) , Shipment_Number INTEGER(20) NOT NULL, Price Double NOT NULL, ); [2] Invoice table Script Name Create Invoice Table CREATE TABLE Invoice ( Invoice_Number INTEGER PRIMARY KEY NOT NULL, Customer_ID VARCHAR(10) NOT NULL, Car_ID VARCHAR(10) NOT NULL, Shipment_Number INTEGER(10) NOT NULL, Price Double NOT NULL, ); [3] Customer table Script Name Create Customer Table CREATE TABLE Customer ( Customer_ID VARCHAR PRIMARY KEY NOT NULL, Name VARCHAR(10) NOT NULL, Age INTEGER(2) NOT NULL, Contact_Number INTEGER(10) NOT NULL, ); [4] Employee table Script Name Create Employee Table CREATE TABLE Employee ( Employee_ID VARCHAR PRIMARY KEY NOT NULL, Name VARCHAR(20) NOT NULL, Nationality VARCHAR(20) NOT NULL, Date of Birth Date NOT NULL, ); [5] Shipment table Script Name Create Shipment Table CREATE TABLE Shipment ( Shipment_Number INTEGER PRIMARY KEY NOT NULL, Country VARCHAR(10) NOT NULL, Fee INTEGER(10) NOT NULL, ); CONSTRAINTS SPECIFICATION Generalization hierarchy on an Employee. Description: This hierarchy assigns the Employee entity as Supertype, and Full Time, Part Time as Subtypes, and since the both subtypes have many similarities, the Supertype have the attributes in common to the subtypes and they are: Employee_ID, Name, Nationality, Date of Birth. . The subtypes cannot be one in another, means the Full Time employee cannot be a Part Time employee, and therefore this generalization hierarchy is of the type disjoint. Type: Disjoint Super type Entity: Employee Super type Primary Key: Employee_ID Common Attributes: Employee_ID, Name, Nationality, Date Of Birth. Constraints Full Time: This subtype entity shows certain data about the Full time employees in the company and their related information which is needed to our database. As for the attributes for this entity: Employee_ID, Salary, Administration. Part Time: This subtype entity shows the data the other type of employees which is the part time employee type. As for the attributes for this entity: Employe_ID, Salary, Time shifting, INITIAL POPULATING OF TABLES Cars Table Populating Table (Cars) INSERT INTO Cars (Brand_Name, Color, Car_ID, Shipment_Number, Price) VALUES (Mustang, Orange, 17111, 11333, 40000) ; Invoice Table Populating Table (Invoice) INSERT INTO Invoice (Invoice_Number, Customer_ID, Car_ID, Employee_ID, Shipment_Number, Total_Price) VALUES (11, 9844, 17633, 1432, 11771, 25) ; Customer Table Populating Table (Customer) INSERT INTO Customer (Customer_ID, Name, Age, Contact_Number) VALUES (9020, Avinash, 39, 2800131) ; Employee Table Populating Table (Employee) INSERT INTO Employee (Employee_ID, Name, Nationality, Date of Birth) VALUES (1422, Vadimas, Libyan, 2/21/1986) ; Shipment Table Populating Table (Shipment) INSERT INTO Shipment (Shipment_Number, Country, Fee) VALUES (11311, Germany, 130) ; Full Time Table Populating Table (Full Time) INSERT INTO Full Time (Employee_ID, Salary, Administration) VALUES (1433, 1300, Secretary) ; Part Time Table Populating Table (Part Time) INSERT INTO Part Time (Employee_ID, Salary, Time Shifting) VALUES (1441, 2000, 3/23/2009) ; USERS INPUT (INSERTION, DELETION, UPDATE) INSERTION: Add New Car (Cars Table) Query name: Insert (New Car in the cars showcase) INSERT INTO Cars (Brand_Name, Color, Car_ID, Shipment_Number, Price) VALUES ([Type the Cars Brand], [Type the Color of the Car ], [The Car ID], [The Shipment Number related to this Car], [The Price of this Car is); INSERTION 2 Here we are going to try to insert a new data into the Shipment form, as we will be using it through the Shipment form insertion button included in that form. Then here the database will ask you if your up for inserting new data into that form And here the data has been inserted successfully below UPDATE: Update New Customer (Customer Table) Query name Update (New Customer in the Customers Table) UPDATE Customer SET Contact_Number = [Enter Customers phone number] WHERE Customer_ID = [ID]; DELETION: Delete a Shipment Country (Shipment Table) DELETE * FROM Shipment WHERE Country = [Enter the Country that will be eliminated]; PERFORMING QUERIES, SUB-QUERIES QUERY [1] (Performing Alias technique into a Query) Description: To manage all the Employees names into one query QUERY [2] (Performing Function technique into a Query) Description: To display all the cars available at the moment QUERY [3] (Performing Concatenation technique into a Query) Description: To give a brief description about each car in the showcase QUERY [4] (Performing Sub-Query technique into a Query) Description: To Create a query from the employee data where it concern only employees who are British. QUERY [5] (Performing another Sub-Query technique into a Query) Description: To Create a query from the Cars data where it concern only the minimum prices of listed cars plus be grouped by the cars brand name. TESTING Test case : 1 Objectives : To use ALIAS in Employee Table Test Data : SELECT NAME AS FULLNAME FROM Employee; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 2 Objectives : To use ALIAS in Customer Table Test Data : SELECT Name AS CustomerName FROM Customer; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 3 Objectives : To use ARITHMETIC in Car Table Test Data :SELECT Car_ID, Brand_Name, (Price*2) AS [Price with Shipment] FROM Cars; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 4 Objectives : To Create Shipment Table Test Data : CREATE Table Shipment ( Shipment_Number int (5), Country varchar (10), Fee money (10) ) ; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 5 Objectives : To use COMPARISON in Cars Table Test Data : SELECT Car_ID, Brand_Name FROM Cars WHERE Price>6000; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 6 Objectives : To use COMPARISON in Shipment Table Test Data : SELECT Shipment_Number, Country FROM Shipment WHERE Fee Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test case : 7 Objectives : To Create Cars table Test Data : CREATE Table Cars ( Car_ID int (5), Shipment_Number int (5), Brand_Name varchar (10), Color varchar (10), Price (10) ) ; Expected Test Result : To display the corresponding records. Actual Test Result : As shown in the image below. Conclusion : Success. The record was displayed. Test

Tom Clancy Bio :: essays research papers

Clancy's next novel, Red Storm Rising, took on U.S./Soviet tension by providing a realistic modern war scenario arising from a conventional Soviet attack on NATO. Other bestsellers followed: Patriot Games dealt with terrorism; Cardinal of the Kremlin focused on spies, secrets and the strategic defense initiative; Clear and Present Danger asked what if there was a real war on drugs; The Sum of All Fears centered around post-Cold War attempts to rekindle U.S./Soviet animosity; Without Remorse took on the rising U.S. drug trade and Vietnam War era POW's; and Debt of Honor explored the hazards of American/Japanese economic competition, the vulnerability of America's financial system, and the dangers of military downsizing. In light of recent events, Debt of Honor demonstrated once and for all Clancy's cutting-edge prescience in predicting future events. The novel ends with a suicide attack against the U.S. Capitol Building by a terrorist flying a 747 out of Dulles airport. Clancy's uninterrupted string of bestsellers continued with Executive Orders, which combined the threat of biological and conventional terrorism with the instability of the Persian Gulf region; Rainbow Six, which explored the dual threats posed by former Soviet intelligence operatives willing to sell themselves to the highest bidder, and genetically engineering bio weapons; and, most recently, The Bear and The Dragon, which posited a limited war between China, the U.S. and Russia. Clancy's non-fiction works include Submarine, Armored Cav, Fighter Wing, Marine, and Airborne—a series of guided tours of America's warfighting assets. He has also written three books in an extraordinary nonfiction series that looks deep into the art of war through the eyes of America's outstanding military commanders. Into The Storm: A Study in Command, written with armor and infantry General Fred Franks Jr., and Every Man a Tiger, written with Air Force General Chuck Horner, won unanimous praise for their detailed exploration of traditional war-fighting from the ground and from the air.

Introduction to Social Sciences

Topic of study – Sociologist and Psychologist â€Å"Do people from deferent background Influence they choice of school they go to? † This topic Is derived from the article, which states: â€Å"What we are seeing Is that the students who are going to some of the more brand-name schools, they're all coming from a certain background†¦ Expanded financial help for students who are keen to enter top independent schools but are put off for fear they cannot afford it or fit in. This might be of interest to both sociologist and psychologist, looking at the activities/ behavior of small groups at ground level, both will then examine whether what is mound on small scale applies on large scale. 1. 1 Sociologist Approach For sociologist, the question they might ask could be: â€Å"How did this social idea comes about? ‘ Sociologists study the social norms and values, and also social processes like formation of power and status relationship. In this case, they may be int erested to find out how come most students that are enrolled In elite schools are from better background.The social function for hilling practice might derive from schooling. It might be believed that students that graduated from an elite school have higher neighborhood school. This would then drive the parents who have adequate financial ability to enroll their children into a better school so that their child may have a better chance of getting employed in the future. As a result, students from better background will end up in top independent school as their parents can afford to put them through the education. 1. 2 Psychologist Approach As for psychologist, they may ask: â€Å"How do groups influence human behavior? They are interested in how it will develop one's belief system. In this case, it is said that students from better background are enrolled in top schools. That being said, what ill happen if a student from normal background were to be awarded with study grant to be e nrolled in the elite school? If students from top schools are mostly from better background, they will start thinking that because they come from better background, they are entitled to go into this school. Consequently, will a student from normal background choose to enroll into the elite school, if given study grant?There could be fear of being ostracizes and not being able to fit in due to the differences. While both disciplines are concerned on the same topic, the emphasis on sociology is the individual in interaction with others. On the other hand, psychology focuses on the individual, which explains human behavior. 2. Topic of study – Political Scientist and Economist â€Å"How effective is introducing niche program able to accommodate multiple pathway of success? † This might be of interest to both political scientist and economist as it both consists of decision making.The topic is derived from the article that mentioned: â€Å"†¦ Opportunity arises becau se we have been committed to this philosophy of many alternative ways of success. † 2. 1 Political Scientist Approach For political scientist, they study on who gets what, when and how. In short, they decide how the society should operate. They analyses the forms the institution takes and the process that emerge. Political scientists look at how the policy introduced will impact the situation. In this topic, the policy is introduced and time is taken to find out how effective is the proposed policy. . 2 Economist Approach For an economist, usually it decides on how to allocate scarce resources, deciding what to produce, how and for whom. In this case, they will be interested to know if the policy introduced will affect the labor market. With the program introduced, will it eve any significant impact on how the distribution, production, and consumption of might be an increase in new businesses emerging from graduates since the school they attended focuses on personal interest a nd competencies, rather than academic standing of school.On the other hand, there is also a concern whether Singapore will have enough Jobs to support the increase in graduates. 3. Social Science Discipline, Chosen Topic of Study and Hypothesis The social science discipline chosen to discuss in this essay will be sociology and the selected above topic: â€Å"Do people from different background influence they choice of school they go to? † 3. 1 Hypothesis With this topic, the hypothesis formed is: â€Å"Having a better background can influence the student's choice of selecting top school†. 3. Variables They key variables are â€Å"better background†, â€Å"type of students† and â€Å"choice of top school† Independent variable, which can be changed during the study, is â€Å"Background†. Different type of background can be chosen to study anytime. Background is chosen as it can affect the type of school a student enrolls into. Having a better background means student can afford to study in independent school. Dependent variable, which would be measured and counted in the study is â€Å"Choice of top school†. Choice of top school means the results of what the student chosen.Will a student from better background choose to enroll into a normal school because of the extra-curriculum offered or will the student choose a top independent school because he/she knows that they can afford it? This is the variable that is observed during the study. Controlled variable, which is not changed throughout the study, is â€Å"type of students†. The same type of students (graduating students who is at the stage of choosing their schools) is used for this study. It will not be fair if the students used are of different age group as they may have different maturity level in their way of thinking.Choosing the same age group of graduating students to study on the choice of school chosen to enrolled into will be the most desirabl e. 4. Developing Research Design This is the stage after hypothesis is formed. Decisions must be made about how best to obtain the data through research methods. By personalizing variables, questioned are asked to covert them into a form which is measurable or testable. In this topic, we are discussing about: â€Å"Having a better background can influence the student's choice of school†.Do student has siblings or friends in the school they are enrolled in? – This is to measure if the choice is affected by other factors such as peers. How many students enrolled in top independent schools come from better background? -This is to measure the past and existing patterns, whether the social structure is built in a way that it influences them to choose the school because ‘it's the way. 4. 2 Research Methods To test and bolster hypothesis formed, there will be research carried out and the 2 hat will be discussed here will be Survey and Secondary Data Research. 4. . 1 Sur vey Research This method is used for establishing facts and subjects of research will be a statistically valid sample of a population. A series of questions will be asked to collect the data needed. Questionnaires will be designed in a way that does not lead the subject. No. Question What is the top factor in mind when choosing a school? (a) Affordability (c)Friends/siblings state: 2. (b) Vicinity (d) Rank of school Others, please If given a choice to enroll in any school, will an elite school be your choice? (a) Yes (b) No For both answers, please explain why: 3.Do you think it is important to be in a school you feel socially accepted? (a) Yes Once these questions are designed, the next step is to survey the sample population. This survey can only be used at the point of time when the student is preparing to enroll 4. 2. 2 Secondary Data Research This method of research gathers relevant information on one's research topic. One will be able to discover what other researchers have wr itten related to that topic and what research methods they have used. It can also be used to obtain other research studies/methods backup or contradict one's findings.As extracted from Ministry of Education Singapore Preliminary Replies, it shows that there is higher percentage of students from better background in top independent schools. With this backed up from a credible source, it supports the hypothesis that students from better background tend to be influenced and choose a top independent school. 5. Possible outcome of study This study shows that there is a possibility of social gap between the rich and poor in Singapore. Due to the influence that because students that comes from better background are choosing to enroll in brand-name schools, they think they are entitled to enter this school.This is a concern, as this social gap will also affect other factors such as the economic in Singapore. The income between rich and poor might widen, as the poor never got the chance to s tudy in a good school for a better Job in the future. Policymaking is vital in Singapore as it maintain order in a country. It is a good effort to introduce niche program in schools and taking steps to tear down any walls that may reinforce elitism in Singapore. Definitely, there will not be instant results shown on how effect a policy is but people must be willing to accept and give it time to work. Introduction to Social Sciences Topic of study – Sociologist and Psychologist â€Å"Do people from deferent background Influence they choice of school they go to? † This topic Is derived from the article, which states: â€Å"What we are seeing Is that the students who are going to some of the more brand-name schools, they're all coming from a certain background†¦ Expanded financial help for students who are keen to enter top independent schools but are put off for fear they cannot afford it or fit in. This might be of interest to both sociologist and psychologist, looking at the activities/ behavior of small groups at ground level, both will then examine whether what is mound on small scale applies on large scale. 1. 1 Sociologist Approach For sociologist, the question they might ask could be: â€Å"How did this social idea comes about? ‘ Sociologists study the social norms and values, and also social processes like formation of power and status relationship. In this case, they may be int erested to find out how come most students that are enrolled In elite schools are from better background.The social function for hilling practice might derive from schooling. It might be believed that students that graduated from an elite school have higher neighborhood school. This would then drive the parents who have adequate financial ability to enroll their children into a better school so that their child may have a better chance of getting employed in the future. As a result, students from better background will end up in top independent school as their parents can afford to put them through the education. 1. 2 Psychologist Approach As for psychologist, they may ask: â€Å"How do groups influence human behavior? They are interested in how it will develop one's belief system. In this case, it is said that students from better background are enrolled in top schools. That being said, what ill happen if a student from normal background were to be awarded with study grant to be e nrolled in the elite school? If students from top schools are mostly from better background, they will start thinking that because they come from better background, they are entitled to go into this school. Consequently, will a student from normal background choose to enroll into the elite school, if given study grant?There could be fear of being ostracizes and not being able to fit in due to the differences. While both disciplines are concerned on the same topic, the emphasis on sociology is the individual in interaction with others. On the other hand, psychology focuses on the individual, which explains human behavior. 2. Topic of study – Political Scientist and Economist â€Å"How effective is introducing niche program able to accommodate multiple pathway of success? † This might be of interest to both political scientist and economist as it both consists of decision making.The topic is derived from the article that mentioned: â€Å"†¦ Opportunity arises becau se we have been committed to this philosophy of many alternative ways of success. † 2. 1 Political Scientist Approach For political scientist, they study on who gets what, when and how. In short, they decide how the society should operate. They analyses the forms the institution takes and the process that emerge. Political scientists look at how the policy introduced will impact the situation. In this topic, the policy is introduced and time is taken to find out how effective is the proposed policy. . 2 Economist Approach For an economist, usually it decides on how to allocate scarce resources, deciding what to produce, how and for whom. In this case, they will be interested to know if the policy introduced will affect the labor market. With the program introduced, will it eve any significant impact on how the distribution, production, and consumption of might be an increase in new businesses emerging from graduates since the school they attended focuses on personal interest a nd competencies, rather than academic standing of school.On the other hand, there is also a concern whether Singapore will have enough Jobs to support the increase in graduates. 3. Social Science Discipline, Chosen Topic of Study and Hypothesis The social science discipline chosen to discuss in this essay will be sociology and the selected above topic: â€Å"Do people from different background influence they choice of school they go to? † 3. 1 Hypothesis With this topic, the hypothesis formed is: â€Å"Having a better background can influence the student's choice of selecting top school†. 3. Variables They key variables are â€Å"better background†, â€Å"type of students† and â€Å"choice of top school† Independent variable, which can be changed during the study, is â€Å"Background†. Different type of background can be chosen to study anytime. Background is chosen as it can affect the type of school a student enrolls into. Having a better background means student can afford to study in independent school. Dependent variable, which would be measured and counted in the study is â€Å"Choice of top school†. Choice of top school means the results of what the student chosen.Will a student from better background choose to enroll into a normal school because of the extra-curriculum offered or will the student choose a top independent school because he/she knows that they can afford it? This is the variable that is observed during the study. Controlled variable, which is not changed throughout the study, is â€Å"type of students†. The same type of students (graduating students who is at the stage of choosing their schools) is used for this study. It will not be fair if the students used are of different age group as they may have different maturity level in their way of thinking.Choosing the same age group of graduating students to study on the choice of school chosen to enrolled into will be the most desirabl e. 4. Developing Research Design This is the stage after hypothesis is formed. Decisions must be made about how best to obtain the data through research methods. By personalizing variables, questioned are asked to covert them into a form which is measurable or testable. In this topic, we are discussing about: â€Å"Having a better background can influence the student's choice of school†.Do student has siblings or friends in the school they are enrolled in? – This is to measure if the choice is affected by other factors such as peers. How many students enrolled in top independent schools come from better background? -This is to measure the past and existing patterns, whether the social structure is built in a way that it influences them to choose the school because ‘it's the way. 4. 2 Research Methods To test and bolster hypothesis formed, there will be research carried out and the 2 hat will be discussed here will be Survey and Secondary Data Research. 4. . 1 Sur vey Research This method is used for establishing facts and subjects of research will be a statistically valid sample of a population. A series of questions will be asked to collect the data needed. Questionnaires will be designed in a way that does not lead the subject. No. Question What is the top factor in mind when choosing a school? (a) Affordability (c)Friends/siblings state: 2. (b) Vicinity (d) Rank of school Others, please If given a choice to enroll in any school, will an elite school be your choice? (a) Yes (b) No For both answers, please explain why: 3.Do you think it is important to be in a school you feel socially accepted? (a) Yes Once these questions are designed, the next step is to survey the sample population. This survey can only be used at the point of time when the student is preparing to enroll 4. 2. 2 Secondary Data Research This method of research gathers relevant information on one's research topic. One will be able to discover what other researchers have wr itten related to that topic and what research methods they have used. It can also be used to obtain other research studies/methods backup or contradict one's findings.As extracted from Ministry of Education Singapore Preliminary Replies, it shows that there is higher percentage of students from better background in top independent schools. With this backed up from a credible source, it supports the hypothesis that students from better background tend to be influenced and choose a top independent school. 5. Possible outcome of study This study shows that there is a possibility of social gap between the rich and poor in Singapore. Due to the influence that because students that comes from better background are choosing to enroll in brand-name schools, they think they are entitled to enter this school.This is a concern, as this social gap will also affect other factors such as the economic in Singapore. The income between rich and poor might widen, as the poor never got the chance to s tudy in a good school for a better Job in the future. Policymaking is vital in Singapore as it maintain order in a country. It is a good effort to introduce niche program in schools and taking steps to tear down any walls that may reinforce elitism in Singapore. Definitely, there will not be instant results shown on how effect a policy is but people must be willing to accept and give it time to work.

Rose Water Recipe

Rose Water Recipe Rose water is one of several products your can buy or make that retains the fragrance of rose petals. It is used in perfumes and cosmetics, plus it has slightly astringent properties, so it makes an excellent facial toner. Because the commercial process used to make rose water is labor intensive and requires a lot of roses, its an expensive product to buy. However, if you have roses, you can make your own rose water quite easily. Its an easy example of distillation, an important chemical separation and purification process. Rose Water Materials rose petalswatersmall pancotton balls Experiment with different types of roses, since each rose has its own characteristic scent. Damask rose has the classic rose scent, but some roses smell like citrus fruit, spices, or licorice.The resulting rose water wont smell exactly the same as the original flowers because distillation only captures some of the volatile compounds present in the petals. There are other methods used to capture other essences, such as solvent extraction and more complex distillations. Directions Place the rose petals in a small pan.Add enough water to just barely cover the petals.Gently boil the water.Collect the steam that boils off using a cotton ball. You may wish to place the cotton ball on a fork or hold it with tongs, to avoid getting burned. Once the cotton ball is wet, remove it from the steam and squeeze it out over a small jar. This is the rose water.You can repeat the process to collect more steam.Store your rose water in a sealed container, away from direct sunlight or heat. You can refrigerate it to keep it fresh longer. Large Scale Rose Water Recipe Are you ready for a more advanced version of the project? If you have a few quarts of rose petals, you can collect much more rose water using a slightly more complex home steam distillation apparatus: 2-3 quarts rose petalswaterice cubespot with rounded lidbrickbowl that fits inside pot Place the brick in the center of the pot. There is nothing magical about the brick. Its purpose is simply to hold the collection bowl above the surface of the roses.Put the rose petals in the pot (around the brick) and add enough water to barely cover the petals.Set the bowl on top of the brick. The bowl will collect the rose water.Invert the lid of the pot (turn it upside down), so the rounded part of the lid dips into the pot.Heat the roses and water to a gentle boil. Place ice cubes on the top of the lid. The ice will cool the steam, condensing the rose water inside the pot and making it run down the lid and drip into the bowl.Continue gently boiling the roses and adding ice as needed until you have collected the rose water. Dont boil off all the water. Youll collect the most concentrated rose water in the first few minutes. After that, it will become more and more dilute. Turn off the heat when you notice the condensation isnt as rose-scented as you would like. You can collect be tween a pint and quart of rose water in 20-40 minutes using 2-3 quarts of rose petals. Other Floral Scents This process works with other floral essences, too. Other flower petals that work well include: honeysucklelilacvioletshyacinthirislavender You can experiment with mixing the scents to make custom fragrances. While rose water, violet water, and lavender water are edible and safe for use in cosmetics, some other types of flowers are only good as fragrances and shouldnt be applied directly to the skin or ingested. Safety Notes This is a fun project for kids, but adult supervision is required because boiling water and steam are involved. Kids can collect flowers and squeeze liquid from cooled cotton balls.If you are using the rose water (or violet or lavender water) for cooking or cosmetics, be sure to use flowers that are free of pesticides. Many gardeners spray flowers with chemicals or feed them with systemic pesticides. For a simple fragrance project, its fine to simply rinse off the flower petals to remove any residue, but avoid using chemically treated flowers for food projects or cosmetics. Learn More Design Your Own PerfumeSolid Perfume RecipeSafety Tips for Making Perfume

Stop Smoking, Stop Killing Essays

Stop Smoking, Stop Killing Essays Stop Smoking, Stop Killing Paper Stop Smoking, Stop Killing Paper Cigarettes continue to be the most popular form of tobacco world wide. In 1993 the total cigarettes, (Facts About 3). This useless habit causes many problems in the United States today; cigarettes cause health problems, are extremely addictive, create health hazards for nonsmolers, and cause complications for women who smoke during pregnancy. Many people have tried smoking once or twice, but never continue. Other people who start smoking continue and become addicted to the nicotine. Many people believe that the power of nicotine has no effect on them, and think that they can stop at anytime;however, this is incorrect. If smoking continues, addiction usually develops before the smoker even realizes it; when this person tries to quit smoking, it is very difficult (N-O-T: Not on 1). One substance found in tobacco smoke, which can make it difficult to quit smoking is nicotine, a highly poisonous oily liquid that acts on the brain. It is poisonous,although, only in large amounts. Its poisonous properties make nicotine addiction very powerful. In 1988 the Surgeon General of the United States published a report concluding that nicotine in cigarettes is addicting inexactly the same sense as alcohol, cocaine, and heroin. Most former smokers have made at least one unsuccessful attempt to quit before finally succeeding, and many have to try several times, (Taylor 17). The quitting process is so hard vecause the body develops a dependency on the drug nicotine. This dependency is so great that people do not quit smoking even though they are aware that it may cost them their lives. According to Centers for Disease Control and Prevention, 419,000 American deaths are caused by cigarette smoking each year. Surprisingly, many smokers are aware of these statistics, but continue to risk theur lives anyway. In the United States, smoking is responsible for 1/5 of all deaths, and kills 1/2 of all long term smokers, (Troyer 33). These statistics are small compared to the number of people who suffer everyday because of smoking related illnesses. Thirty percent of all cancer deaths, according to the American Lung Association, are caused by smoking. Besides lung cancer, smokers also suffer from a number of other smoking related illnesses. The least significant effect that most smokers experience is smokers cough. Although smokers cough is not deadly , it is very painful and disgusting to others. It usually occurs early in the morning, because the smokers lungs are trying to cough up some of the harmful substances that have built up from the previous day of smoking. Many respiratory diseases are also attributed to smoking. These diseases occur because of bacteris growing in the lungs which makes it difficult for a persons immune system to fight viral infections. As a result, Smokers develop more flu, pneumonia, coughs, tuberculosis, and other breathing related problems than nonsmokers, (Troyer 33). Other potentially fatal diseases can result from smoking, such as cardiovascular diseases. Cardiovascular diseases are those that affect the heart and circulatory system, such as heart attacks, stroke, vascular disease, and aortic aneurysm, (34). With so many potentially fatal diseases attributed to smoking, smokers receive more than 1/2 of all medical care,(35). The effects of smoking are very costly to the economy. If the sale of cigarettes was banned the United States government would save billions of dollars each year. Opponents argue that banning the sale of cigarettes would eliminate nearly one million jobs in the tobacco industry, and rob the government of billions of dollars they receive from cigarette taxes. However, the truth is that each year 100 billion dollars is spent on somking related health care costs, which is twenty-three times greater than the amount that hte government receives from cigarette taxes. Most of these costs come from the cost of treating dieseases caused by tobacco and from the loss when workers are too ill (or have died) and cannot contribute to economic activity, (Taylor 17). if cigarettes were banned in the United States, the government could apend the money currently used to pay medical bills, on more necessary causes. Instead of this money being used for diseases which were knowingly brought upon by the smoker him or herslf, this money could be used in finding a cure for diseases that are not preventable. Perhaps the saddest effect of smoking is that on pregnant smokers and their babies. When pregnant women smoke, their babies are being forced to smoke, too. many women begin smoking at an early age and find it hard to quit even during pregnancy. Information given from Health Watch discribes smoking as a harmful gas and deadly substance thats passes throughout babys blood from mothers blood (2). This selfish act on the mothers part can result in miscarriage, stillborn (SIDS). When a pregnant woman smokes, the various chemicals, including nicotine and carbon monoxide , also affect the baby. These chemicals have a direcct effect on the growth of the fetus. The more the mother smokes during pregnancy, the lower the weight of the newborn infant. Smoking increased the risk(by more than 50% in light smokers and well over 100% in heavy smokers) taht the babys weight will be less than 2500 grams, (Tye 6). Such babies are more likely tio be stillborn, to need intensive care in the hospital, or to die in infancy. Not only does smoking gave dangerous and fatal effects on the baby, but the mother is at risk as well. The more a pregnant womean snokes, her risk of placenta abnormality and excessive bleeding increases. Also, nicotine may decrease mild production and make successful breast feeding more difficult, (Taylor 8). So if a mother would knowingly endanger her life and the life of the baby she is carrying, this woman would have no problem smoking in a room full of nonsmokers, endangering their lives as well. Many people who do not smoke so not enjoy being in a room where people are smoking. However, discomfort should be the least of their worries. Cigarette smoke carries carcinogens and other harmful substances. Many of these substances are poisons: tar, nicotine, carbon monoxide, arsenic, cyanide, and other deadly aubatances. Anyone exposed to secondhand smoke breathes in over four thousand chemical substances. Secondhand smoke kills 53,000 Americans each year. It is the third largest preventable cause of death . Only direct smoking and alcohol-related deaths rank higher,(Rumph 20). To demonstrate that nonsmokers are affected by the smoke, a study was done by the Americans for non Smokers Rights Foundation on children living in homes with parents who smoke. The study was compared with children living in homes with no smoking. The children living with smokers, had a ten percent lower amount of high density lipoprotein, which prevent against heart disease, as compared to children in non-smoking homes, (Rumph 20). Also, girls with parents who smoke have a lower ability to carry oxygen in the blood, while boys had a lower testosterone level than children living in non-smoking homes, (Houston 121). Although some progress has been made to reduce secondhand smoke in public places, it is not enough. There are no laws to protect people on the street or innocent children in their homes. The only way to protect innocent non-smokers is to ban the sale of cigarettes, so there would be no second-hand smike at all. Cigarettes are harmful to everyone. They result in addiction, fatal illnesses, birth complications, and death. Cigarettes create economic problems because of the high costs the government must pay for medical bills. cigarettes benefit no one, they only cause harm.