Wednesday, July 31, 2019

Mumbai Slums Essay

An earthquake occurs when there is a sudden release of energy in the Earth’s crust that causes seismic waves. Earthquakes are typically caused by opening of geological faults. They are however also caused by volcanic activity, landslides, mine blasts, and nuclear experiments. The effects of earthquakes are many and far reaching. Earthquakes cause shaking and ground ruptures which result in less or sometimes more severe damage to buildings or other rigid structures. Earthquakes also results in landslides and avalanches, which sometimes causes damage in hilly and mountain areas. After an earthquake, the place can catch fire by breaking of the electrical power or gas lines. Because of the shaking, sometimes the soil liquefies, the loose saturated cohesion less soil loses its strength and temporarily transforms from a solid to a liquid state. Soil liquefaction causes firm structures like buildings and bridges to slant or sink into a liquefied state. Earthquakes result in loss of life, damage to property, fatal diseases, lack of basic necessities and it affects the financial and economical structure of the country. Some safety measures are used so that the government, individual and businesses can prepare themselves against this calamity. To reduce the damage, retrofitting techniques and modern earthquake resistant designs of new buildings and lifeline structures like bridges, hospitals and power plants are used in earthquake prone areas. The emergency services under the local and state government ensure that the public is safe by dealing with the crisis. Individuals and businesses are encouraged by governments to have an earthquake kit and supplies for three days at hand. As a result of an increase of the number of seismic stations today, the earthquakes are reported more than in the past, which help in the preparation process. Slums in Mumbai Slums always existed in Mumbai. In 19th century, slums grew around mills and other places of employment. Now they grow where ever there is empty space. Slum dwellers today cover 60% of Mumbai’s population. The government tried to rectify the problem in 1985 by passing the Slum Upgradation Project. Regrettable the project targeted only 10-12% of the slum population, those who were able to of upgrade their homes. It ignored inhabitants in slums, those who did not have homes at all. In spite of all the attempts to cure the problem of slums in Mumbai, slums are still growing. The growth rate of slums is actually greater than the growth rate of general urban. It is estimated that everyday 100 to 300 new families come to Mumbai. Most of them end up in a slum colony or just put up a shanty on the on the footpath. Due to migration, the city’s population is increasing and with it the slums. These facts show that migration has to stop to cure the problem of slums. According to Professor RN Sharma, (the head of the Urban Studies Unit in Tata Institute of Social Sciences), Mumbai, the city is unquestionably disintegrating into slums. A Jockin of SPARC, (the NGO that works for slums) said that the rehabilitation process is the only solution to the problem of slums in Mumbai. He said: â€Å"This talk about Mumbai having predominantly slums is rubbish. Already 67 per cent of slums on railway land have been re-settled. The airport project and the rehabilitation near Mithi River is also happening at a good pace. These figures of slum population rising is not true†. Former housing minister Nawab Mallik also agreed that rehabilitation is a best way to get rid of slums. References: Earthquake. (2007, November 4). Retrieved November 5, 2007 from World Wide Web: http://en. wikipedia. org/wiki/Earthquake Juneja, Saakshi. (2006, January 9). Mumbai Slums. Retrieved November 5, 2007 from the World Wide Web: http://mumbai. metblogs. com/archives/2006/01/mumbai_slums. phtml Slums. Retrieved November 5, 2007 from the World Wide Web: http://www. macalester. edu/courses/GEOG61/espencer/slums. html Slums: The Magnitude of the Problem. Retrieved November 5, 2007 from World Wide Web: http://theory. tifr. res. in/bombay/amenities/housing/slum-stats. html

Tuesday, July 30, 2019

Extended Kalman Filter Model for Gps and Indoor Positioning System

Extended Kalman Filter Model for GPS and Indoor Positioning System Long Kam-Kim Department of Telecommunications Engineering, Faculty of Electrical and Electronics Engineering HCM City University of Technology, Ho Chi Minh City, Vietnam Tuan Do-Hong Department of Telecommunications Engineering, Faculty of Electrical and Electronics Engineering HCM City University of Technology, Ho Chi Minh City, Vietnam Abstract – Object positioning is an old subject. It’s being used more and more in many areas, especially in military, traffic, social security and civil services.The most popular positioning system in the world is Global Positioning System (GPS). However, GPS has limited degree of accuracy for low priority users. This paper proposes a solution for solving these limitations by using Extended Kalman Filter (EKF). Moreover, GPS is almost invalid in indoor environments. The paper also introduces an indoor positioning system model based on GPS ideology and EKF algorithm. Beca use of the similarity in ideology, it’s easier for handoff procedure between outdoor and indoor environments and brings back the spatial continuous in positioning.The simulation results show that with the EKF, the accuracy of positioning is improved significantly in both outdoor and indoor environments. Keywords- GPS, Kalman filter, RFID, RSSI, EKF, indoor positioning. I. INTRODUCTION II. EKF MODEL FOR GPS Generally, Kalman algorithm is a group of mathematical equations described an efficient recurrence method for state estimation of process that it is optimal in the sense that it minimizes the estimated error covariance, when some presumed conditions are met [2]. EKF is an extension of Kalman filter for non-linear systems.A. Global Positioning System (GPS) In order to positioning, it requested that user’s receivers get signals from at least 4 GPS satellites. Distances between user and satellites are determined by using pseudorange code. At the same time, satellites an d receiver transmit a same pseudorange code. Because of propagation delay, signal received from satellites have phases delay than signal of receiver. By compared their phase, the distances can calculate. This method is called Time of Arrival (TOA). [1] B. Problem ExpressionPositioning based on GPS is affected by many noise sources, such as propagated errors, satellite and receiver caused errors, other errors from Selective Availability, dilution of precision, interference etc [1]. Several techniques are used to improve the accuracy of positioning in GPS, for example, DGPS (Differential GPS), Smart Antenna, Kalman Filter etc. This paper focuses on Extended Kalman Filter (EKF) solution, in order to introduce one way to model GPS system and sources of error. Nowadays, positioning applications in indoor environment are being extended.Especially, it becomes necessary in tunnels, supper huge plants, very high buildings, etc. The paper introduces a kind of Indoor Positioning System based o n GPS’s ideology and using EKF algorithm to help this system improve the accuracy of positioning. Assume that GPS system is tracking a mobile object. It is a uniform speed motion in 3D space with attendance of random acceleration events. GPS receiver puts on object updates its position continuously. However, the location is affected by measurement noises and propagation noises.Therefore, the calculating position and the real position are different. In order to improve the accuracy of position, we use EKF to model system and noises so that it diminishes the effect of noises. C. Modeling of system Defining the sate vector of system as follow: ? RX ( n ) ? ? RY ( n ) ? ? ? ? RZ ( n ) ? X (n) = ? ? ? VX ( n ) ? ?VY ( n ) ? ? ? ?VZ ( n ) ? where RX(n),RY(n),RZ(n) are coordinates of user at nth sample, VX(n), VY(n), VZ(n)) are x, y, z – components of user’s velocity at nth sample.Following [3], the characteristic equations for system can be extended as RX(n+1) = RX(n) + VX(n)T + ax(n)T 2 RY(n+1) = RY(n) + VY(n)T + ay(n)T 2 RZ(n+1) = RZ(n) + VZ(n)T + az(n)T 2 VX(n+1) = VX(n) + ax(n)T VY(n+1) = VY(n) + ay(n)T VZ(n+1) = VZ(n) + az(n)T (1) (2) (3) (4) where VX(n), VY(n), VZ(n)) are x, y, z – components of user’s velocity at nth sample, bf = ? bu/? t, dPRi is called delta-pseudorange correlated with user and ith satellite. [4] In order to reducing effect of errors, the EKF is used to model state noise vectors and measurement noise vectors.After characteristic matrixes are calculated, EKF iteration loops are started. The EKF algorithm will calculate estimation of the state vector by minimizing the estimated error covariance (between estimated values and real values). D. Simulation results for outdoor-EKF GPS Data for simulation on Matlab7. 8. 0(R2009a) †¢ †¢ †¢ User’s initial velocity: (3,6,2) meters/second Sampling rate: 1000 samples/second Iteration steps: 500 Process noise vector: W = 5* NORMRND (0, 500, 3, 1) Pr ocess noise variance: Q = 50* eye (3) Measurement noise vector: V = 5 * NORMRND (0, 500, 2, 1) Measurement noise variance: R = 50 * eye (2) (5) (6) here ax(n), ay(n), az(n) represent acceleration events at nth sample ( it is referred to state noises or process noises). According to [4], User’s positions are determined base on distances between user and four satellites. PRi= +bu, i=1,2,3,4 (7) †¢ Fig. 1 shows the simulation results for Lagrange iteration and EKF iteration compared with the true position values. In geographic coordinates, PRi is the distance between the user and the ith satellite, (SXi,SYi,SZi) are coordinates of ith satellite, (RX,RY,RZ) are coordinates of the user; bu=c. t with t is receiver clock offset compared to GPS time and c is the speed of light.PRis are determined by GPS’s receiver. Coordinates of satellites are obtained by decoding satellite report, while (RX, RY, RZ) and bu are unknowns. With system of equations (7) above, the root [RX,R Y,RZ,bu,] can be calculated by using Lagrange iteration [4]. However, measurement values PRi are affected by noises (measurement noises). Therefore the root of system of equations is not accuracy. After differentiating equations (7), we obtain dPRi = (RX ? SXi)? RX + (RY ? SYi)? RY + (RZ ? SZi)? RZ (RX ? SXi)2 + (RY ? SYi)2 + (RZ ? SZi)2 + ? bu = (RX ? SXi). VRX +(RY ? SYi). VRY +(RZ ?SZi). VRZ +bf PRi ? bu Figure 1. Simulate tracking User’s trajectory in outdoor environment (8) In Fig. 1, red curve simulates user’s motion,Green curve simulates calculated trajectory of user receiver without EKF, blue curve simulates calculated trajectory of user receiver in EKF model. Based on GPS’s ideology, this paper introduces an indoor positioning model using EKF, called Indoor-EKF GPS. Indoor-EKF GPS is hoped that it makes over easier with GPS, in such a way, we just use a handle equipment to keep the continuous positioning while moving between indooroutdoor environments.I n Fig. 3, an arranged system of equipments in space can be recognized as pseudo-satellites. Indoor spaces are complicated environments for wave propagation. Distances between user and pseudo-satellites cannot be determined using TOA technique like in outdoor GPS. Here, TOA technique is replaced by RSS (Received Signal Strength) technique. This technique measures the path loss and calculates the distance between source and receiver. Figure 2. Errors in outdoor positioning. Red points: positioning errors without EKF. Green points: positioning errors in EKF model.Comments on simulation results: †¢ The maximum error is about 5 meters in case using EKF model, whereas 25 meters in case without EKF. Trajectory of user receiver in EKF model is closer to trajectory of user’s motion than trajectory of user receiver without EKF. The average estimation error of EKF is very small than without EKF case. However, several points in curve are under suddenly changing errors. Figure 3. Ind oor positioning system. †¢ According to IEEE 802. 11 recommended channel model, the relation between free space path loss and distance d in breakpoint radius is given by [5] LFS(d) = L0 + 10? 1lg(d), 0 < d ? BP (9) †¢ According to the result, it shows that the positioning errors are reduced significantly. III. A. INDOOR POSITIONING SYSTEM where ? 1 is called distance-power-gradient up to breakpoint distance dBP, Lo represents the path loss in decibels at one meter distance. The overall path los for any distance is modeled as [5] Indoor-EKF GPS Recent years, indoor environment has been extended so that indoor positioning demands are extended, too. Furthermore, it becomes necessary in tunnels, supper huge plants, very high buildings etc, and giving convenient for absent minder when household equipments are positioning.However, GPS is almost invalid in indoor environment. The reason is that GPS signal has low power. Even GPS signal can be received, the error positioning of GP S is not appropriate with Indoor applications. ?LFS (d ) +W, d ? dBP ? L(d ) = ? ? d ? ?LFS (dBP ) +10? 2 lg ? d ? +W, d > dBP ? BP ? ? (10) where ? 2 is distance-power-gradient over break-point distance dBP. It’s required at least four distances form user to pseudosatellites are determined for calculating the user’s coordinates. Fig. 4 shows calculation process for user position. Figure 6. The second model. Figure 4. User’s coordinates calculation.B. In the next section, the RFID (Radio Frequency Identification) technology will be used to implement this system. There are two implementation models: The first model: (Fig. 5) The RFID active chips are pseudo-satellites, and readers will be used as GPS’s receivers. Modeling of system Definition of the sate vector and the characteristic equations for system are similar with outdoor case above. However, because of difference on distances calculating method, equation (7) and equation (8) are not used here. This equation below is replaced equation (7) LPi=L0 + 10? lg (di) , i=1? 4 (11) here di is distance between user and ith pseudo-satellite, LPi is value of path loss on distance di. W appears as representative of noises and interferences. Here, we assume that it is Gaussian distribution, ? is distance-power-gradient (we have not examined its change yet. Here, we assume that it is constant). After differentiating equations (11), we obtain dLPi = Figure 5. The first model. 10? ( RX ? SRXi ). VX + ( RY ? SRYi). VY + ( RZ ? SRZi). VZ . ln10 di 2 + ? Wi , i=1,2,3,4 (12) The RFID active chips will transmit these data to readers: †¢ †¢ †¢ The chip’s coordinates (in local coordinates) and its identification.The nominal value of transmitting power. The parameters in IEEE 802. 11 that supporting to correct distance measurements in each specific environment. where (SXi,SYi,SZi) are coordinates of ith pseudo-satellite, (RX,RY,RZ)are coordinates of the user, VX, VY, VZ are x, y, z – components of user’s velocity, dLPi means the variation of path loss on distance di . We imply that the values are taken at nth sample. C. Simulation results for indoor-EKF GPS Data for simulation on Matlab7. 8. 0(R2009a) The second model: (Fig. 8) The RFID active chips will be attached to users. Users will move in space that arranged with RFID readers.These readers will be connected to data fusion center. This center will determine user’s coordinates and send the result to user’s receiver by other channel link. †¢ †¢ †¢ User’s initial velocity: (1,2,1) meters/second Sampling rate: 1000 samples/second Iteration steps: 500 Process noise vector: W = 5* NORMRND (0, 120, 3, 1) Process noise variance: Q = 50* eye (3) †¢ Measurement noise vector: V = 5 * NORMRND (0, 0. 4, 2, 1) Measurement noise variance: R = eye (8) This simulation was repeated 100 times. †¢ The maximum error is about 0. 5 meters in case using EKF model, wh ereas 4. 5 meters in case without EKF.Trajectory of user receiver in EKF model is not closed to trajectory of user’s motion correlative with appreciably positioning error. However the error reduces very quickly by exponential curve. The average estimation error of EKF is very small than without EKF case. However, several points in curve are under suddenly changing errors. IV. CONCLUSION Fig. 7 shows the simulation results for Newton iteration and EKF iteration compared with the true position values. †¢ †¢ In positioning systems, the accuracy of positioning is very important. It must be appropriated with the positioning applications.The paper recommends one way to improve the accuracy of positioning using the EKF. The results of simulations show that the EKF reduce effect of noises on the accuracy of positioning significantly in both outdoor and indoor positioning systems. The Indoor-EKF GPS system is a suggestion model for the future indoor positioning. It is easy f or implementation and expansion, since RFID is very popular and cheap today. Moreover, the Indoor-EKF GPS system has the same structure with GPS system, wherefore the handle equipment can be designed to keep the continuous positioning while moving between indoor-outdoor environments.REFERENCES [1]. Ahmed EI-Rabbany, â€Å"Introduction to GPS†, Artech House, Inc, ISBN 1-58053-183-0, 2002, pp. 13-25,2741. [2]. Grey Welch and Gary Bishop, â€Å"An introduction to the Kalman filter†, Technical Report TR 95-041, 2001. [3]. Jorge Quijano, â€Å"Estimation of the position of a moving target using Extended Kalman Filter†,term paper for the class ECE 510 Statistical Signal Processing, winter 2006. [4]. James Bao-Yen TSui, â€Å"Fundamentals of Global Positioning System Receivers: A Software Approach†, John Wiley & Sons , Inc, ISBN 0-471-20054-9, 2000, pp. 9-15, 230-231. [5].Ahmad Hatami, â€Å"Application of Channel Modeling for Indoor Location Using TOA and RSSà ¢â‚¬ , PhD Thesis, Worcester Polytechnic Institute, 2006, pp. 14-19. Figure 8. Errors in indoor positioning. Figure 7. Simulate tracking User’s trajectory in indoor environment. In Fig. 7, red curve simulates user’s motion, green curve simulates calculated trajectory of user receiver without EKF, blue curve simulates calculated trajectory of user receiver in EKF model. Red points: positioning errors without EKF. Green points: positioning errors in EKF model. Comments on simulation results:

Monday, July 29, 2019

Legal And Ethical Issues Of The Audit Of Industries Essay

Legal And Ethical Issues Of The Audit Of Industries - Essay Example There will be danger of committing biases when providing the services and will eventually lead to unethical acts within the company. The second issue that can be considered ethical is when the company withheld, covered up and overlooked discrepancies in the company’s record (citation). The company was found to cover up and did not disclose accounting discrepancies of companies in which they provided their services. Evidences were obtained that suggest such acts were committed by Andersen. The third ethical issue that is present in the Andersen case is the company’s act of destroying evidences that can be used against them (citation). Ten days just before the U.S. Securities Exchange Commission formally started the investigation again Arthur Andersen, the management instructed their employees to destroy all potential evidences that may prove their illegal actions. This act can be said to be legally wrong too. This is a form of obstruction of justice because the company d id not disclose evidences that will help the investigation become successful. Question # 2 What role did Arthur Andersen’s culture play in their business? Arthur Andersen was one of the top accounting firms and considered to be one of the â€Å"Big Five† in the United States (citation). ... Question # 3 How would have the Sarbanes-Oxley Act will help minimize the likelihood of other accounting practices happening? Sarbanes-Oxley Act is the act passed by the Congress to â€Å"establish a system of federal oversight of corporate accounting practices† (citation). Because of this act, the accounting firms will be evaluated and monitored according to the established standards and rules of accounting firms. This act created the Public Company Accounting Oversight Board which is tasked to monitor the accounting firms (citation). Because of this law, the accounting firms will not provide both the auditing and consulting services to the same company as what Andersen did. This act will eliminate the conflict of interest. Thus, because of the passage of the act, unethical auditing methods will be eliminated and shareholders will gain confidence back and will soon invest to more efficient and effective accounting firms. Question #4 As an ethics consultant, what recommendations would you have made to the partner’s at Arthur Andersen? As an ethical consultant, I would have recommended to the partners of Arthur Andersen to eliminate and avoid any unethical methods and practices from the very beginning. They should have made an action to prohibit such acts in the very first place. If they knew about the said commission of unethical, if not illegal, methods, they should have come to the proper authority and reported about the issue. The proper authority will surely advice them about the proper procedure of what to do next. If only they have done what is right, they would have not lost multi-million investments. Laws were made to be followed based on fairness and justice. If they committed a violation of the law, they will face consequences.

Sunday, July 28, 2019

Annotated Bibliography Example | Topics and Well Written Essays - 750 words - 16

Annotated Bibliography Example The author is an associate professor of history at Hamilton College with a vast of experience on the experiences of black-American soldiers at the hand of the white majority, despite their efforts in the war. Being well-researched for from a wide scope of scholarly materials, the book deeply covers financial and racial discrimination visited upon the black soldiers. It is a good historical on racial discrimination against black soldiers during the civil war. The author is a senior partner in the Washington, D.C., law firm Covington & Burling, and has published carefully documented articles on the experiences of black American soldiers during the Civil War for more than thirty years.  These articles cover a broad spectrum of discriminatory nature of white soldiers and white societies against black veterans during the civil war. A profile of the author of this book reveals that he has authored many books on civil war and has a deep sense of knowledge about the experiences of black soldiers during the civil war. The book also helps us understand the various discriminatory practices that the black soldiers had to endure like substandard medical care. The book is well written and the author has extensively researched for the book. It is recommendable to history students and I expect to learn more about the predicaments of African-American soldiers during the civil war. The author is an expert in history and is a professor of History at Princeton University, and a leading historian on civil war. The book also clearly presents the humiliating experiences the black soldiers went through in the hands of white colleagues and from their white superiors. The author has drawn his references from contemporary journalism, books, speeches and letters. The book contains reputable information that helps the reader to vividly understand the discriminatory environment the Black-American soldiers lived in. The author is an amateur scholar

Self -executing treaties Essay Example | Topics and Well Written Essays - 2500 words

Self -executing treaties - Essay Example In an effort to assess how international laws and treaties are applied by nation-states, this paper shall discuss the application of self-executing treaties and the position of treaties recovering provisional application. The views of different authors, courts, and international tribunals shall be used to critically assess the implementation of the dualist and the monist approach to treaties. As part of the international community, states are obliged to follow and respect the provisions and mandates of international laws. These laws help keep the peace between nations and help secure and protect the sovereignty of the different nations of the world. Treaties form part of our international laws. Through the Vienna Convention on the Law of Treaties, the principle of pacta sunt servanda finds application. Nations are free to apply these treaties in any way they see fit. They may apply the dualist approach or the monist approach in order to seek the application of the treaties in their territory. Whatever approach to implementation they choose, these nations have international obligations to fulfill, and their failure to comply cannot be excused using domestic laws as a scapegoat. International responsibilities cannot be ignored because states are risking their economic and political position in the international community (Council of Europe, p. 16). In some countries which follow a dualist approach to treaties, these treaties cannot, as a general rule, be applied by municipal courts until they have been transformed into municipal law by legislative action. However, in the case of self-executing treaties, this rule must be qualified. Treaties are normally endorsed by states and are considered the most common and trusted sources of international law. The Vienna Convention on the Law of Treaties in 1969 was passed in order regulate the enactment of treaties between state parties as well as organizations. According

Saturday, July 27, 2019

Importance of an entrepreneurial leader Assignment

Importance of an entrepreneurial leader - Assignment Example Entrepreneurial leaders have the drive to be successful and their flexibility leads to adaptability. Entrepreneurial leaders are result-oriented and have high levels of enthusiasm that ensures full commitment to the goals and objectives of the organization. The role of an entrepreneurial leader is different from other leader roles since they are take personal responsibility of the growth of the organization. Their roles are different from other leader roles since they continuously search for new opportunities that will lead to innovative products and ideas rather than ensuring the success of the already established products and ideas. The entrepreneurial leader will assemble and coordinate resources towards attainment of organizational goals and will take personal responsibility for the failures of the team and utilize such challenges in ensuring the organization attains its objective. Unlike other leader roles, an entrepreneurial leader plays the role of a risk-taker through investi ng in new and innovative ideas that will enhance the growth potential of the organization. An entrepreneurial leader role is different from other leaders since an entrepreneur is a change catalyst and champions creative. An entrepreneurial leader is important in an organization since he continuously searches for new opportunities and ensures creativity that ultimately leads to new and innovative products and ideas. The entrepreneurial leader roles are different from other leader roles since he or she is a risk-taker and acts as a change champion.

Friday, July 26, 2019

LIT 201 3-3 Ouline Thesis Example | Topics and Well Written Essays - 250 words

LIT 201 3-3 Ouline - Thesis Example A comparison of the literal works of Oedipus Tyrannous and Don Quixote gives a depiction of irony depicted in two literally unique set ups. Literary works of both Oedipus Tyrannous and Don Quixote utilizes irony is a vital aspect of literary brilliance. Oedipus made an endeavor to challenge God yet his future was made clear to him by the Oracle of Delphi and the future too of his entourage. Despite this, he repelled and wanted to mend his own fate and destiny (Salomon, 2008). The characters own perceptions, ideologies and beliefs helped actualize his prophecy. This was purely ironically since fate took its course of action that Oedipus knew prior to drafting and following his strategy. Conversely, Sancho a loyalist of Quixote remarked that the black mole on the back of Quixote was a sign of a sturdy man. Quixote compared it to the Islamic forecaster Mohammed and an indication of the strength of a knight even though the audience knows the truth. Oedipus and Don Quixote have displayed vast through paths that proved to be tremendously ironic retrospection. A clear comparison of the irony in Oedipus and Don Quixote and similarities made to appreciate the literal works of the classic writers. It is a literature drive engine intended to spice the stories, enhance its impact and keep the audience fully involved. It is thus a vital part of

Thursday, July 25, 2019

Product development Assignment Example | Topics and Well Written Essays - 1750 words

Product development - Assignment Example Product development process is basically an introduction of a new product which every company has to go through at a certain point of time. Individual’s needs and wants change with time, therefore it is essential for the organization to tailor an existing product or develop a new product in accordance to those needs. Aims and Objectives: The aim of the research would be to find out whether product development is the best way to gain competitive advantage and in doing so achieve the following objectives: Impact of product development in the current fast-moving environment. Identify how product development can result in higher market share. Background and Methodology Presently, competition has increased so much that it has become essential for every company to gain a competitive edge over its competitors by adopting various strategies and methods. The purpose of this study is to find out the role of product development in achieving competitive advantage and increasing companyâ⠂¬â„¢s market share. This research will be based on secondary data, where I would be going through various research reports, working papers and publications on product development. Literature Review: Though developing a new product is not at all an easy task to do, but to succeed and maintain your position in the industry, it is essential to build up a new product line. To do this, it is important to conduct a detailed survey in order to come up with a product that perfectly meets the requirements of your target market. Mark Abraham has defined product development as a process of creating and altering products delivered to the consumers and doing variations that are significant and demanded by the customers. He further said that an item can never be considered a product until it is not delivered properly. Therefore, the process of product development also includes various departments like marketing, testing, technical, quality service and many others within the organization. As ment ioned earlier product development is a complicated process and the positive result can only be achieved if this process is broken down into various steps and each step is successfully completed. New product development not only helps meet the needs and wants of an individual which in turn increases company’s overall sale but also helps maintain its competitive position. (Mark Abraham, 2011) In another study which was conducted by Khade and Alan it is said, companies in order to gain competitive advantage should offer customers with what they demand and at a cost they are willing to pay for it. Competitive advantage can be gained by different means but two most feasible methods include: utilizing experience curve and through product development or innovation. The intelligent use of both these methods can help in achieving a competitive advantage. When does a company have competitive advantage? It is when a company is ahead of its competitors in terms of quality products, profi t and attracting consumers. This can be done by producing superior products, providing excellent customer service and attaining lower cost. All this come under the process of product development. In today’s fast changing environment, it is difficult for the organizations to cope up with the growing needs of the people. Therefore, only organizations that are successfully able to meet these needs by developing new products are able to sustain their position in the market. (Khade, Alan S,2003) Presently, there are so many companies in a single industry that it has become difficult to compete. Competing on services and price is not enough in current

Wednesday, July 24, 2019

The types of board diversity and its impact on board performance Essay

The types of board diversity and its impact on board performance - Essay Example This research will begin with the definition of diversity as the difference between things or people, the variety of assortment that makes us unique. Every person has unique skills, characteristics, and challenges that contribute much in the board performance. Despite that, the body structure is the same; physical characteristics differ making people have a greater deal of diversity. Diversity has the composition of age, gender, race, and ethnicity, education, physical appearance, political persuasion among others. It is the examination of these differences in a safe, affirmative, and fostering environment. Age diversity- workforce increasingly varied in age demographics, creating proficient environment loaded with experience and maturity as well as youthful enthusiasm. Companies that employ more workers in wide ranges of age have an advantage of creating a dynamic workforce with a diverse range of skills beneficial to the company. Gender diversity- it is an Umbrella term used by Aus tralians to swap transgender in a more comprehensive fashion. It is the skill of sex or gender identity beyond the biological and dual philosophy of male and female. It celebrates the diversity in gender identities rather than some categories of people. Gender composition in a workplace has its own advantages and disadvantages in the workforce. Most of the top boards in Australian do not have women. The following graph shows the percentage of women in 48 boards, in ASX 200 files. Available from: http://www.companydirectors.com.au/Director-Resource-Centre/Governance-and-Director-Issues/Board-Diversity/~/media/Resources/Director%20Resource%20Centre/Governance%20and%20director%20issues/Board%20diversity/Board%20Diversity%20images/Graph%20images/Percentageofwomen_19April.ashx?w=360&h=275&as=1 [accessed on May 03 2013] Race diversity- a race is a population distinguished from other populations within a species by hereditarily transmitted physical characteristics. It has a unique and distinct ensemble of genes and remains identified by this genetic ensemble. Members of the same race share distinguished genetic characteristics because they share the same ancestry. This also depends on language distribution. The following graph show race or ethnic diversity from a county make up. Available from: Http://www.google.com/imgres?imgurl [accessed on May 06 2013] Culture diversity- this is about the ethnic groups, nationalities, lifestyles, and the educational level. Two people may appear similar on the outside but have different cultures, values, view points, and work styles. It is equally valuable for a business to acknowledge multiple cultures that exist within the work place. Mangers work in hand with the employees to ensure that their cultures remain respected. The following graph shows women cultural diversity on trusteeship in 1931. Available from: http://www.google.com/imgres?imgurl [accessed on May 06 2013] Religion diversity- people continue to express a high level of religion involvement that is highly significant and productive in both the work force and our daily lives. In the recent, religious discrimination, remain practiced highly in the workforce. This diversity contributes much in the performance of a company. Catholics and Christians have the highest percentage in Australia while others like Anglican, uniting church, Presbyterian and reformed among others follow. The following gr

Tuesday, July 23, 2019

ASSIGNMENT Essay Example | Topics and Well Written Essays - 1500 words

ASSIGNMENT - Essay Example The â€Å"Book of Job† and the â€Å"Wisdom of Ben-Sira,† are two of the accounts of the Bible which greatly emphasized these two concepts. In this paper, Job’s challenge against ancient wisdom, proceeded by Ben-Sira’s justification about the goodness of God will be taken into account. What Victor Hugo has to say is a reminder of the literary magnificence of the Book of Job. Stating that if all forms of literature would vanish from the Earth, he would save the Book of Job, is a proof that the book is not only an ordinary piece of religious instruction, rather, a source of wisdom with eloquence in pronouncing the teachings of God. Basically, the purpose of the book is to answer the age old question about the nature of man’s suffering and why the righteous should suffer (Copeland 4). Although someone might argue the image of God presented in the Old Testament is an angry, punishing God, He is still the same loving, ever righteous and just God as in the New Testament. However, the great misfortunes of the wicked and the rigid test of faith in the persons found in the Old Testament might be the root of this misconception. Ancient wisdom contends that God is omnipotent and punishes whoever commits a violation of the Commandment. Job, on the other hand, is a man of good deed and yet, he suffered greatly. As a father and a faithful, he believes that God is all-powerful and acknowledges it through sacrifices and teaching his children about the greatness of God. Clearly, he was favored by God in giving him wisdom and wealth, but due to the afflictions made by Satan (with God’s permission), he has changeable convictions about the existence of humans and their relationship toward God. As stated, â€Å"Job questions the moral underpinnings of human existence, for he no longer receives proper dividends from above† (ABD, III, 862). Job complains about his innocent suffering. However, adjacent to his complaints are his own assumptions why such

Monday, July 22, 2019

Identity Thesis Essay Example for Free

Identity Thesis Essay Over the course of history, different theories have been formulated to help explain the complex relationship between the mind and the body. One of the theories elucidating the mind-body relation is dualism—the view that mental states are independent from physical states. Mental states are ones of thinking, feeling, and believing whereas physical states are those outlined by physical and biological sciences. In contrast to dualism, physicalism insists that mental states are somehow physical states. The most straightforward version of physicalism is the identity thesis—the theory that every type of mental state is identical to some type of physical state (Reasons and Responsibility, 285-286). Dualists and physicalists have disputed over the validity of the identity thesis; dualists denying its claim and physicalists defending it. The biggest problem facing physicalists and the identity thesis is the concept of qualia, the phenomenal quality of a mental state (Reasons and Responsibility, 281). Philosopher Frank Jackson offers what he calls the â€Å"Knowledge Argument† for qualia. Jackson’s knowledge argument presents that nonphysical facts can be devised from facts about phenomenal quality. Through the concept of qualia, Jackson’s knowledge argument shows that the identity thesis is false. The identity thesis holds that mental events are simply identical with brain processes—identical in the same manner that sounds are identical with density waves in the air. The thesis bases on the idea that mental states of thought, sensation, and awareness are alike those of physical states (such as those of the brain and central nervous system). An example of identity thesis is that lightning and an electric charge are two of the same thing. In other words, lightning is an electric charge. An advocate of the identity thesis is materialist Peter Carruthers. Carruthers argues that everything (including mental states) exists through physical causes. Carruthers’ argument for the identity thesis can be summarized from the beliefs that some conscious states and events are casually necessary for the occurrence of some physical ones, and that there will be no need to advert to anything other than physical-physical causality in a completed neuro-physiological science. Thus, some conscious states and events are identical with physical brain states and events (Reason and Responsibility, 301-302). However, the concept of qualia refutes the idea of physicalism, and is the foundation of Jackson’s knowledge argument against identity thesis. As a believer of dualism, Jackson uses the concept of qualia to support that the mind and matter are distinct and independent substances capable of existing without the other. Qualia are the subjective, felt qualities of experiences. For example, one may know all the physical properties of the color red and the physics behind why some things are red; however it is qualia that allows one to experience what it is like to actually see red. Jackson constructs his knowledge argument around the ideas of dualism and qualia. To further illustrate Jackson’s argument for qualia (and dualism), the case of Fred and his unique color vision will be presented (Reasons and Responsibility, 298-299). For some reason, Fred has the ability to see two colors where others only see one. His retina is capable of distinguishing between two wavelengths of red in which others familiarizes with only one. He tries to explain the difference between the two reds. However he fails in doing so because others do not comprehend the difference. Therefore it is concluded that Fred can visually see one more color than everyone else. Despite having all the physical information about Fred and his special trait, one cannot know what it actually feels like to see two different types of red. Thus, Jackson believes that the physicalist left something out in the theory of physicalism—the qualia or what it feels like to actually experience something. Consequently, quale explains how dualism is valid and physicalism is incomplete. The existence of knowledge through qualia (mental state) and that of physical facts (physical state) demonstrates the idea of dualism—the view that two fundamental concepts exist. Jackson’s knowledge argument derives mainly from his thought experiment of Mary; the brilliant scientist who has spent her life confined within a black-and-white room and has never seen colors. Mary learns all the physical facts relevant to the mind. She becomes an expert on the neurophysiology of vision and knows all there is to know about color. When Mary is released from her room, she experiences color for the first time. One would think intuitively that her color experiences provide her with knowledge she previously lacked, and that what she learns includes certain facts about what color experiences are like. The facts she learns upon her release cannot be physical facts because she already knew all physical facts before leaving the room. Therefore, the new knowledge comes from the concept of qualia, which indicates that not all facts are physical facts (Reason and Responsibility, 298-299). Thus physicalism is false. Jackson reaches his conclusion that the identity thesis is false by proving that mental states are not physical states. According to the identity thesis, states and processes of the mind are identical to states and processes of the brain. The concept of qualia refutes the validity of the identity thesis by presenting subjective forms of experiences. The knowledge acquired from subjective forms of experiences differs from those of physical knowledge about experiences. Since physicalism requires that all aspects of knowledge are the same, physicalism cannot be sound. Thus the identity thesis must be false. The cases of Fred and Mary show that physicalism doesn’t amount to all knowledge. The summation of Jackson’s knowledge argument can be illustrated by the following: before Mary leaves the room, she knows all the physical facts about color experiences. When Mary leaves the room, she learns new facts about color experiences—facts about what it’s like to see in color. Therefore, there are nonphysical facts about color experiences. Furthermore, the identity thesis is false because Jackson’s knowledge argument reveals that there is something about the experience of color (in Mary’s case) that cannot be captured by the physicalist view. So, physicalism is incomplete. Physicalism lacks the phenomenal quality of the mental state—the ability to experience something regardless of physical knowledge. Qualia and the mental experience can never be achieved from the premises of physicalism and the identity thesis. Thus, the phenomenal quality of experiences cannot be accounted for through physical properties of the brain. In conclusion, the identity thesis is false because nonphysical properties, like phenomenal properties, exist.

René Descartes Essay Example for Free

Renà © Descartes Essay Philosophy begins as an art of wondering. This art of wondering, leads man into asking a number of questions about himself and the world around him. Variations in philosophical thoughts as result questions posed by man, help in modification of philosophy. The purpose of this essay therefore, is to do a comparative analysis of Sophie’s World by Josteen Gaarder with three philosophical texts: George Berkeley’s Treatise on Human Knowledge, John Locke’s Essay on Human Understanding and Rene Descartes’ Passions of the Soul. We shall also show the roles of authors and texts in Philosophy. TREATISE ON HUMAN KNOWLEDGE VERSUS SOPHIE’S WORLD One of the outstanding efforts of Berkeley in this work was to show that the world exists as it does because of the ideas perceived by the mind of God and as such, existence of things depends on their perception through the senses. Likewise in Sophie’s World, Aristotle through his belief showed a similarity with Berkeley’s stance in this text Treatise of Human Understanding. For Aristotle, highest degree of reality is what we perceive with our senses. Berkeley also said that existence is the state of being perceived by a perceiver, but on the contrary, Descartes in Sophie’s World believed that he exists because he thinks. It furthermore means that his existence depends on his ability to think. He used such words like cogito ergo sum (latin) and je pense, donc je suis (French) all meaning `I think therefore I am` to illuminate his thesis on this. Plato while stressing the sovereignty of reason in Sophie’s World said that the reason can only give us the true reality of things and as such contradicted the empiricist approach of Berkeley. ESSAY ON HUMAN UNDERSTANDING VERSUS SOPHIE’S WORLD John Locke illuminated in this work that idea is derived from experience of sensation or reflection, just like it reflected in Sophie’s World in which his fellow empiricists likewise stressed the inevitability of experience as the source of true knowledge. David Hume in particular established that man has two types of perceptions, namely: impressions and ideas. By `impressions` he means the external sensations of reality. By `ideas` he means the recollections of such impressions. Aristotle the trail blazer of empiricism, in alignment with the empiricists believed our reason to be completely empty until we have sensed something. John Locke in this book made an attempt to refute the notion of `innate ideas` by proving that it does not exist, whereas in Sophie’s World, philosopher like Plato believed in an innate idea, an external world of ideas outside of the natural world. Descartes even believed that the idea of God is innate. PASSIONS OF THE SOUL VERSUS SOPHIE’S WORLD Descartes defined passions of the soul as a mental state or thought that arises as a direct result of brain activity and such passions can move us to action. He also suggested that one needs to learn to control one’s passions, for they can move one to perform vicious acts. Benedict Spinosa in Sophie’s World, suggested that we must free ourselves from our feelings and passions only then shall we find happiness. Conversely, also in Sophie’s World, the Epicureans through the teachings of Aristippus believed that the aim of life is to attain the highest possible pleasure or passions and by so doing, they contradict Descartes belief. AN EYE ON THE ROLES OF AUTHORS AND TEXTS IN PHILOSOPHY Authors in philosophy play incredible roles in modification of philosophy through their texts. There various attempts to answer the underlying questions of nature and man have led to the developments of dialectical methods like thesis, antithesis and synthesis used in philosophy today. An eye on the three authors and philosophers: Descartes, Berkeley and Locke whose works where compared with Sophie’s World above showed the vital role they played in philosophy. While Descartes was a rationalist, Berkeley and Locke were empiricists, but through their texts, they contributed in `epistemology` or theory of knowledge. CONCLUSION Having done these comparisons, we can see the successful deduction of similarities and differences between the Sophie’s World and three aforementioned philosophical texts. I attest that Sophie’s World is necessary philosophical paraphernalia needed by a neophyte in Philosophy as seen from its versatility in the course of this comparison done, and also how it covered aspects of history of Philosophy in such a sublime manner. POPE JOHN PAUL II MAJOR SEMINARY OKPUNO, AWKA NAME: UMENABA BENJAMIN C COURSE: INTRODUCTION TO PHILOSOPHY COURSE CODE: PHIL 101 REG NO: PJPS/NAU/013/O69 LECTURER: REV. FR DR. AUGUSTINE OBUROTA TOPIC: A COMPARATIVE ANALYSIS OF SOPHIE’S WORLD WITH THREE PHILOSOPHY TEXTS WITH AN EYE ON ROLES OF AUTHORS AND TEXTS IN PHILOSOPHY DATE: 28TH NOVEMBER, 2012 OUTLINES INTRODUCTION TREATISE ON HUMAN KNOWLEDGE VERSUS SOPHIE’S WORLD ESSAY ON HUMAN UNDERSTANDING VERSUS SOPHIE’S WORLD PASSIONS OF THE SOUL VERSUS SOPHIE’S WORLD AN EYE ON THE ROLES OF AUTHORS AND TEXTS IN PHILOSOPHY CONCLUSION.

Sunday, July 21, 2019

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