Constitutional Law Article Example | Topics and Well Written Essays - 3500 words

Constitutional Law - Article Example Parliamentary sovereignty has three elements: (1) Parliament can make any law whatsoever and no body or any court can question any Act of Parliament; (2) no Parliament can bind either itself or any of its successors; and (3) no limit can be placed on the territorial extent on any of the Acts of Parliament. The first of the elements is known as the Enrolled Bill doctrine. It states that the duty of the judiciary with regard to the statutes of Parliament is to analyze through the Parliamentary Roll and nothing more in addition to it and that the judiciary must give fundamental respect and conclusiveness over whatever acts of Parliament, especially if it is with regard to the statutes passed therein. The second main element is known as the implied repeal rule which states that subsequent Parliaments can expressly or impliedly repeal any previous passed statutes made by the present and past Parliaments for the reason that subsequent parliaments possess the same powers and authority to all prior parliaments that ever existed. Further stating that the implied repeal rule also shows that the past Parliaments cannot hinder future parliaments from exercising their legislative authority. The last main element is known as the territorial extent doctrine which emphasizes that parliament can enact statutes that are outside its territorial jurisdiction of the United Kingdom, such as the High-jacking Act of 1982, it states that high-jacking is punishable even if the crime is committed outside the territorial jurisdiction and sovereignty of the United Kingdom. Some limitations to this provision exists, such as that when the law requires that a certain procedure must be done in order that previously enacted statutes may be amended. An example is the requirement of a referendum among the people of Northern Ireland with regard to the concern of some of its territories. In the Manner and Form thesis it clearly defines the limits where the courts may intervene and even to point of invalidating an act of legislature such as with regard to those procedures and compositions but not on the area of its exercise of power. Therefore implying that it's power to change the law includes the power to subsequently change the law which will affect itself because the legal sovereign may impose on itself some legal restriction upon its acts. This is a contentious issues as long as the enrolled doctrine bill is in effect and recognizing both Parliament and the courts of law. Another big challenge to the Supremacy of the Parliament are the legal effects of the European Community which is incorporated in the UK legal system through the European Communities Act of 1972 and was asserted in the case law Mccarthys v Smith Jackson 3 (1979) 3 All ER 325 which states that specific Treaty as not only in aid of legislation and legal implementation but as having the force and effect of law which must be given priority over and above other national laws. Taking into consideration the Factortame cases which give the distinction as what kinds of repeals parliament can make with regard to treaties are concerned. This is shown in pertinent cases that parliament just cannot just impliedly repeal acts which have conflicts with the international treaties signed by the UK but may do so if there is an express repeal. As evidenced by a statute that was

Land Law Assignment Example | Topics and Well Written Essays - 2500 words

Land Law - Assignment Example S. No Table of Cases 1 â€Å"Bernstein v Skyviews General Ltd [1978] QB 479† 2 â€Å"Boomer v Atlantic Cement Co Ltd 257 NE 2d 870 ( NYCA ,1970)† 3 â€Å"Cadbury Schweppes Inc v FBI Foods Ltd (1999) SCR 142, 167, DLR (4th)† 4 â€Å"Chelsea Yacht and Boat Club v Pope [2001] 2 AII ER 409† 5 â€Å"Cooperative Wholesale Society Ltd v British Railway Board (1995)† 6 â€Å"Hulme v Brigham† 7 † Isenberge v East India House Estate Co Ltd {1863} 3 De G J & S23 â€Å" 8 â€Å"John Trenberth v National Westminster Bank (1979) 39 P & CR 104† 9 â€Å"Kelsen v Imperial Tobacco Co Ltd (1957) â€Å" 10 â€Å"Lemmon v Webb (1895)† 11 † Lewvest Ltd v Scotia Towers Ltd (1981) 126 DLR (3d) 239, Nfld SC†, 12 â€Å"Millennium Production Ltd v. Winter Garden Theatre (London) Ltd [1948] AC 173, HL† 13 â€Å"Mitchell v Mosley [1914] 1 Ch 438† 14 â€Å"Parker v British Airways Board (1982)† 15 â€Å"Reilly v Boo th (1890)† 16 â€Å"Rudd v Cinderella Rockerfellas Ltd [2003] EWCA Civ 529† 17 â€Å"Taylor v North West Water (1995)† 18 † Telecom Auckland Ltd v Auckland CC[1999] 1 NZLR 426† 19 â€Å"Woolerton and Wilson Ltd v Richard Costain Ltd [1970] 1 WLR 411† S. ... physical or tangible property like factories , fields , shops , houses and soil but also intangible privileges in the land such as right to create a charge on land to secure a loan or a right to walk along the neighbour’s driveway which is also known as an easement right, the privilege to take something from other’s land like fish, which is being a profit and an illustration of an â€Å"incorporeal hereditament’ and the privilege to manipulate the usage to which a neighbour may place his land, which is also known as a â€Å" restrictive covenant† . Thus, in legal parlance, a land includes both corporeal and physical asset and also includes the privilege that the owner or third parties may benefit from or over it1. Land may include any terrain, which is held other than the surface and hence, it is liable to horizontal division. Thus, land encompasses any specific map coordinates, which contain at least restricted segments of the superjacent and subjacent a reas. Thus, the area, the ownership to land can be differentiated and vested in various owners at a time, each owning a different part or stratum of the cubic space either above or below the surface layer of the ground. It is to be noted that owners of various floors in an apartment may own a freehold title by way of ‘common hold’ or have a claim of a leasehold estate2. The world of physical reality is being essentially related by the first three dimensions of land. However, the fourth and fifth dimension is not dealing with the physical aspects of land but deals with the intangible interest in the land. In Newlon Housing Trust v Alsulaimen (1999), it was held that the four dimensional of land is not only explained with the reference to the corporeal periphery of the land and also by reference to the period for

E-business business on the Internet

E-business business on the Internet E-business models: benefits, opportunities and threats E-business (electronic business) Derived from such terms as e-mail and e-commerce, is the conduct of business on the Internet, not only buying and selling but also servicing customers and collaborating with business partners. One of the first to use the term was IBM, when, in October, 1997, it launched a thematic campaign built around the term. Today, major corporations are rethinking their businesses in terms of the Internet and its new culture and capabilities. Companies are using the Web to buy parts and supplies from other companies, to collaborate on sales promotions, and to do joint research. Exploiting the convenience, availability, and world-wide reach of the Internet, many companies; such as Amazon.com, the book sellers; have already discovered how to use the Internet successfully. Whether customers are on or off line, in todays marketplace they want quality products and information in a quick and easy manner. What are the main benefits of the Internet? Even a kid knows its advantages for speed and convenience of use. Therefore e-business, which uses the internet as the core for business dealings, can help make a company more customer-friendly in addition to many other things, such as creating a more efficient exchange of information and/or products and services. IBM, in 1997, was one of the first to use the term when it launched a campaign built around the term. Today, many corporations are rethinking their businesses in terms of the Internet and its capabilities. Companies are using the Web to buy parts and supplies from other companies, to collaborate on sales promotions, and to do joint research. Exploiting the convenience, availability, and global reach of the Internet, many companies, both large and small have already discovered how to use the Internet successfully. 1. Removes Location and Availability Restrictions Users need not be in the same physical location as an e-business and the exchange of information and transactions may take place at any given time, twenty-four hours a day, seven days a week and from any location in the world with Internet access. A physical location is restricted by size and limited to only those customers that can get there, while an online store has a global marketplace with customers and information seekers already waiting in line. 2. Reduces Time and Money Spent In e-business, there is often a reduction in costs required to complete traditional business procedures. Many of those same traditional business approaches can be eliminated and replaced with electronic means, which are often easier to carry out as well as easier on the pocketbook. For example, compare the cost of sending out 100 direct mailings (paper, postage, staff and all), to sending out a bulk e-mail. Also think about the cost of paying rent at a physical location opposed to the cost of maintaining an online site. 3. Heightens Customer Service With e-business customers receive highly customizable service, and communication is often more effective. There is far more flexibility, availability and faster response times with online support. For example, think about the speed of e-mail inquiries and live chat as opposed to getting on the phone, especially when that business is closed for the day. There is also a faster delivery cycle with online sales, helping strengthen the customer/business relationship. The internet is a powerful channel for reaching new markets and communicating information to customers and partners. Having a better understanding of your customers will help to improve customer satisfaction. 4. Gives Competitive Advantage The internet opens up a brand new marketplace to businesses moving online. Competition via the internet is growing as the internet itself grows and waiting too long to move online may cause you to lose your place in line entirely. Easy access to real time information is a primary benefit of the internet, enabling a company to give more efficient and valid information and helping to gain the competitive advantage over those that are not online. Although there are risks associating with e-business, as with most business decisions, there is also the risk associated with the inability to adapt to the changing times. Change is inevitable in todays marketplace and should be embraced with open arms and open sites! Reference list: Article Source: http://EzineArticles.com/?expert=Stacie_Leonard E-Business will allow organisations to: Reduce costs Reach a larger market Eliminate the use of middlemen and intermediaries Reduce search costs by facilitating comparison of price, products and services Reduce lead times Improve production and supply capability Improve personalisation and customisation of product offerings While also offering: Giving your business the leading edge. A web presence gives your company maximum marketing exposure and an advantage over competitors Maximum exposure, Permanent advertising on a global scale at an extremely tiny cost Customer service and feedback. Customer or employee access to company information and databases during both business and non-business hours increases customer satisfaction. Approaches An e-business model is simply the approach a company takes to become a profitable business on the Internet. There are many different approaches that could seemingly be adopted when contemplating an e-business, all depend on the situation of the business and current market that the company operates in. Although some people, such as Kenneth P. Morse, believe that electronic models are no different from traditional business models, electronic business markets have produced differing models. The basic idea of e-commerce, or doing business on the Internet, is that at least two parties a seller and a buyer- exchange valuable products or services. The exchange transactions can occur between individuals, businesses and organizations (sic). This leads to an approach based on whether the organisation is: B2C (Business to Consumer) B2B (Business to Business) A2M (Association to Member) Conclusion Selling goods and services online is the natural progression for many companies that are looking to expand their market. There is no other way of reaching more customers that is more cost-effective than an ecommerce site. As you know, this model has been so successful that some businesses (e.g. Amazon.com and eBay) have even forgone a physical location. While their situations stand out from the rest, even existing bricks-and-mortar businesses can benefit from selling online. One of the keys to ensuring success with your ecommerce site is to make it robust enough to meet the needs of your customers while simple enough so that they dont need a manual to figure out how to buy something. Typically this means having a searchable catalog and a minimal number of clicks to get from the product page to the order page.

Homeless Essay -- essays research papers

â€Å"The weather seems to be getting a bit chillier around here lately† Charlie Houser proclaims. â€Å" Living homeless is not so bad as long as you understand that you are homeless and make it your every day life.† implies Charlie. Charlie is a man that goes around thinking of things to do from day to day. On Vine Street in Coryville, a thin, short, black man stands between two buildings fighting off another Cincinnati winter. He is unshaven with a scraggly beard. His skin is rugged looking and tough. His outfit consists of a tannish-brown jacket, which clashes with his turquoise pants that are short in length. Charlie wears a pair of black, puppy dog chewed up shoes. It is winter and he is shuffling back and fourth to keep warm. His steps are as timid as that of a mouse trying to sneak something to eat. The aroma of his alcoholic breath pollutes the frosty breath coming from his lips. Along with his breath, his eyes are glazed over, watery, and red. It is clear he has had been drinking. His hygiene is deteriorated to the point of him smelling like a dirty pair of socks, which had not been washed for quite some time. The teeth he had left are bright yellow and caked with plaque. His mouth is a nightmare for a dentist. It is a disturbing sight to see, but many passes by take no notice o f him. Charlie says, â€Å" I tried to find employment, but was unable to afford a haircut and employers would not even talk to me because of my looks.† Charlie lives his days by just getting through e...

Mexican and american mexican

Mexican American forms one of the most oldest and largest of ethnic communities living in USA. The overwhelming majority of Mexican Americans live in four southern US states, although many of them are spread also in upper northern parts. Spanish Mexicans were among the first people to explore and inhabit USA, even before arrival of western settlers. Later, as USA expanded its territories after the Mexican war of 1846, Texas was annexed from Mexico and thousands of Mexicans automatically found themselves as part of United States, forced to assimilate themselves with a distinct culture. The assimilation of Mexicans has been a very slow and comparatively unaccomplished process and ethnic Mexicans have always formed a distinguished niche for them, continuing in their traditional docile and peaceful outlook that stands at sharp contrast with materialist and high paced American lifestyle. This paper analyzes the social, political and economic factor that have guided the relation between Americans and Mexican Americans History of Mexican American Relation Spanish explorers had conquered Mexico by 16th century and they used Mexican territories as base to continue their exploration of USA. As the Spanish empire crumbled, Mexico struggled to get its independence, which it achieved in 1826. However, Mexican independence was not a sanguine affair by all accounts and there were numerous issues of internal discord, the chief one them being the problem of Texas. Mexico had allowed American settlers to inhabit the barren and desolate landscapes of its northern states, bordering with USA that included, Texas and   California in particular. However, the number of American settlers increased dramatically in these areas, and it reached to the proportion that Americans began to dominate the political and economic life of these areas. The dominance of Americans started episodes of conflict between the two people as Americans would not accept the hierarchical, state centric and rather outdated political and social model of Mexican people and this caused frequent incidents of friction among them and Mexican authorities. The American settlers of northern Mexican border areas definitely perceived that their future lay with a far more prosperous, secure and economically sound USA than a comparatively regressive and stagnant Mexico. Meanwhile US senators also perceived the economic and strategic importance of these northern bordering states. The troubles in these areas rapidly snowballed into a major problem when Texas seceded from Mexico in 1836, a decision that Mexico did not recognize. As the mutual affinity of both Texas and US was to each other, USA formally annexed Texas and as result Mexico entered in a two years war with USA. The results of war were disastrous for Mexico and it lost more than one third of its territories to USA at the Treaty of Guadalupe Hidalgo. However, the effects of the war were not limited to mere annexation of territories but also of Mexican people living in this huge geographical area who overnight became subjects of USA. The relations among Americans/Yankees and Mexicans were always strained due to superior attitude of Anglo-Americans that had always made them behave with certain arrogance towards Mexicans. In this context, the results of war were more humiliating, and the loss of national land created a lasting perception of injustice and wrong that stayed with American Mexicans for decades, and to an extent even today. Alienation of Mexican Americans Of all the major ethnic groups living in USA, the Mexican American community is unique in several respects. Despite their living in a predominantly American society, they have been able to preserve their value system, their culture and tradition, their family structure and their belief, a fact that has puzzled many social scientists. Although the likeliest explanation of this phenomena relates to the fact that most of the Mexican-American and newly arrived Mexican immigrants continued to settle in southern states of USA, bordering with Mexico, providing a sense of continuousness and native familiarity that helped them to stay in their niches. However, this is only partially true and doesn’t throw full light upon the causes. A major reason of separate and distinguished Mexican identity has been long lasting grievances of many Mexicans on account of their forced assimilation in USA and subsequent highhandedness of Americans towards Mexicans after the war years. The American superiority in terms of education and affluence when contrasted with general level of impoverishment, illiteracy, and ignorance of early Mexican Americans definitely presented a great divide between two people with a firm notion that any assimilation among them would be impossible. This stereotype further caused Mexican to recede in their self formed shell, and minimize their interaction with one of most rapidly changing and advancing world, of which they had become an unwilling part. Even the fact they were granted all the rights as any other American citizen and no discrimination, at theoretical and ideological level was practiced with them, it did not help in their assimilation in an completely alien and foreign political and social system. As a matter of fact, the very decisions of American government allowing complete political and religious freedom to Mexican population at the time of Treaty of Guadalupe Hidalgo allowed Mexican people to preserve their cultural and traditional identity in the great cultural potboiler called USA. However, the ground political, social and economic realities worked to gradually dilute the barriers that Mexican American had created around them. Slowly many of them started to interact with the mainstream society as they realized the necessity of assimilation in order to exist in circumstances that had changed irrevocably. Most of the Mexican Americans fanned out, taking participation in the world around them, though maintaining their cultural roots intact. Those with deeper sense of wrong and who found new system unacceptable, took violent methods of protests while some who completely failed to get assimilated continued to live isolated lives. Although some dissatisfied Mexicans tried to express their anger through means of violence, in general the Mexicans rejected violence as expression tool, for they realized that through peaceful course alone they could ensure the survival in a largely Anglo USA. As the Mexicans realized their future destiny to be intertwined with USA and their new status as Mexican Americans, they also gradually accepted the new political and social system. Mexican Americans formed their own political parties, elected representatives in the democratic processes and for a time become influential political force in the southern states, owing to their numerical superiority. The Mexican political leaders tried to protect the rights and privileges of their people to the best extent possible for them, notwithstanding the fact that among themselves there were frequent instances of both political and economic exploitation. However, the influence of Mexican politics lasted only as long as they could held to their numerical superiority. As the southern states were connected to rest of the country through extensive system of railways by 1880s, the inflow of North Americans (Yankees) reached steadily, and soon they outnumbered the native Mexicans to end their political and even cultural influence, gradually absorbing them in the Yankee mainstream. As the general trend showed in perspective, Mexicans Americans were successful in preserving their cultural roots and identity in all those places where they enjoyed numerical superiority, such as Southern Arizona, New Mexico and South Texas. In other places, where they were outnumbered, they become American Mexicans from Mexican Americans. The composition of Mexican Americans changed after the heavy immigration of Mexicans in USA in early 20th century, when USA offered much better employment opportunities. For a considerable time, the immigrants identified themselves merely as workers in an alien land, while culturally mingling with their own countrymen. But since 1960s Mexican community has seen wave of cultural liberation and social assimilation and integration in the mainstream American system. Reference David J. Weber. 1973. Foreigners in Their Native Land: Historical Roots of the Mexican Americans.; University of New Mexico Press, 1973. Leo Grebler, Joan W. Moore, Ralph C. Guzman, et al., 1970. The Mexican-American People: The Nation's Second Largest Minority . New York, p. 10. â€Å"The Mexican-American People: A Review Symposium†, Social Science Quarterly 52, no. 1 ( June 1971): 8-38, El Grito. 1968. The Anthropology and Sociology of Mexican-Americans: The Distortion of Mexican-American History†, 2, no. 1 (1968) The Anthropology and Sociology of Mexican-Americans: The Distortion of Mexican-American History†, El Grito 2, no. 1 (1968)            

E.J. Computers Case Essay

Introduction The company I am going to be doing my project on is a small firm named E.J Computers. The company have been around for about a year and a half now and have 3 staff. It’s run from a small shop, which they have just recently moved to and they are slowly expanding. Therefore I am going to introduce an Access database to help make the job of keeping the accounts work easier. Statement of problem The problem at the moment is that the company is currently using a paper-based way of doing their accounts. This way is still quite common, but it makes more work for the end-user, as he usually has to go rummaging through bits of paper and filing cabinets etc. Also a problem with doing it this way is that bits of paper etc could go missing and the data would be lost. Its slower, takes up more room and looks unprofessional. I am going to be creating a database for a computer store that sells various things, from computer parts and accessories to fully working systems. The database will consist of many tables, including ones for customer details, products, delivery etc. I will be making the database a relational database so that the tables will interact and it will make it much more easier for the end user to be able to do or get to what they want. A computer database will be a lot safer to keep the records on. If they desire the end user could use some form of data protection so that he viewing of the records are not accessible for anybody (by either pass wording it etc). This way is a lot faster, less hassle, takes up less space and I think it looks more professional. So I am going to be creating a database, which will meet all of these needs. My initial idea is to create a database consisting of 4 tables, one for the customer details, one for the components, one for the ready built computer systems, and one for the orders. Results from questionnaire I wrote a questionnaire, and took it to my end user so that he could fill it in. I got it back, and now I can use the information that he provided to enable me to design my database to suit his needs. Basically he has the appropriate equipment that is required for him to be able to use the database and he also has the knowledge. From the feedback that I got, he basically has left me to my own device on the formatting side, which is good because I can use my imagination a bit and hopefully make a good design. The end user has also said that he would also like a password on the database for data protection. This ensures that the confidential data of his customers remains confidential. He also said that he would like his database to consist of 4 tables, one for customer details, two for product details, and one for order details etc. Information about end user’s computer Fortunately, the end user already has a suitable computer system to enable him to use the database. The current system is an AMD Athlon 1500+ 512mb DDR pc2700 RAM, 40GB HDD, 40x CD re-writer, 3 1/2 † Floppy disk, 17†³ CRT Monitor. He also has sufficient software, which is a bonus. Is current operating system is Windows XP professional and he also has office 2000. Description of the previous system Input of the previous system At the moment the whole system is paper based. If a customer purchases an item, their details are written down on a little white card, this includes their name, address, telephone number etc and then it is stored into a filing case. Eddie then has to write out a receipt by hand and issue it to the customer. If a customer requires delivery, there is an extra fee for postage and packaging and their information gets put into a separate file where at the end of the day it will be processed. Process of the previous system After the information is collected it is left. Hey don’t use it for anything else like advertising or sending special offers. It is just stored in a cupboard and every time a customer phones up or comes into the store and purchases a product it is taken back out and another card is filled in. Output of the previous system Again, the information is not used for output at all, the do not send special offers or print receipts. The receipts are all manually drawn up and written out. All products are paid for up front; no credit is given so there are no fines and no need to use the data for output. Method used for the previous system Data Flow Diagram of the previous system Problems with previous System Main problems with the previous system Problem Solution Time consuming Database will be easy and quick to access and use. Storage All data will be stored on the computer and will be easily accessible and found. Untidy work area Database will be on a computer, which will be neatly stored on the desk. Untidy work All work will be word-processed, therefore the data will all be neat and easy to read. Unsafe Data The database will be pass worded so that no unauthorised access will be possible Requirements of the new system Objectives of the new system Using access 2000 I will be creating a database for the company, this will make the system a lot better for my end user. To enable me to get an idea if what my end user actually wants he has filled in a questionnaire for me. This should help me understand fully what the end-user wants. My database will consist of four tables, each table representing different parts of the company. The first table will be a table for the customer’s details, it will store the details of every customer that comes into the shop and purchases an item. It will store their name, address, telephone number and each one will have their own unique customer ID number. This information can then be used for any marketing schemes that my end-user comes up with and the data will be handy at all times. My second table will contain information about the components that are available for the customers to purchase. It will consist of a list of the products that the shop has on sale and the type of that product. It will have the price, the amount that the business has in stock and a short description. The third table will consist of a list of pre-built fully working systems that are on sale; it will have a field for system ID, the price, number in stock, and a specification of each computer system. I will then have a fourth table consisting of information of the orders that have been placed, it will have the customers ID, the ID of the product that they have ordered, how much it will cost, and whether or not it need to be delivered. How the objectives will be fulfilled Description of the new system Input of the new system As I said above I will be putting the customer and product information details into the database using a mouse and a keyboard. I will be using a mouse to select to appropriate options and applications. I will also be using a VDU so I can actually see the information that I will be putting into the system. Process of the new system The process of the system is going to be pretty simple, I spoke with my end-use and we decided that I will make queries and sorts for the tables so that the information is easier to find and get hold of. We decided that it would be a good idea if I also include a mail merged letter so that things do not have to be written time after time. Output of the new system My end user has out the point across, that the output of the system is not really as vital as the input. The main purpose of creating this database is so that the details are stored safely on the computer. However a printer will probably be needed for the purpose of printing out records, and letters etc. This is not a permanent thing and maybe things will change later but for now this would be the only output. Performance criteria and limitations of the proposed system Qualitative My database solution will enable the end user to be able to sort the customers surnames into alphabetical so that it makes it easier for the end user to be able to find a customers records. My end user will also be able to sort the prices of everything that he sells into price order (for example cheapest to most expensive). This will make it easier for the end user, so that if he gets a customer asking about certain products that are on sale he can easily do a quick sort and be able to tell the customer. Quantitative With the solution I have made my end-user will be able to find the following: * Begin using the database within 30 seconds of opening it. * Find a customer using name or ID within 15 seconds. * Find a certain product with information within 20 seconds. * Find out if there re any deliveries that need to be made within 20 seconds. System flow chart Software and Hardware considerations Hardware The hardware that I will be using to create my database is as follows: Computer system: 1.0Gghz Celeron Processor 256mb SD RAM 20gb HDD Internal AGP SiS 8.0mb GFX card 15†³ Cathode Ray Tube (CRT) monitor – Sufficient size display so I can easily see what I am doing. Keyboard – Standard RM keyboard enabling me to get the job done. Mouse – 3 button Key Mouse to make selecting options easier. Laser Printer – Printout copies of the work I am doing to take to my end-user to make sure it suits his needs accordingly. Some of my project will have to be completed at home in my own time on my own computer; my own computer consists of: AMD Athlon XP 1700+ 768mb DDR PC2700 RAM 40gb HDD NVIDIA Geforce4Ti 4800 SE Creative Sound Blaster 5.1 Microsoft Intellimouse Explorer 3.0 Optical (USB) Logitech Internet Navigator(tm) Keyboard Special Edition – Black Software The software that I will be using to create my database is as follows: Microsoft Windows 98 SE Operating System Microsoft Windows NT Network Microsoft Office 2000: Word Access – Mainly using access because it enables me to perform complex searches, have a splash screen and create an advanced database system. Excel FrontPage Outlook The software that I have on my computer at home, which will allow me to be able to design the database, is: Microsoft windows XP professional corporate edition Microsoft Office XP: Word Access Excel FrontPage Outlook Data security of the new system Use of passwords I am going to be using a password for my database, as my end user has requested it. My end – user will need a password, to ensure customer confidentiality. The password will be a word requested by the end user and only he and his staff will have access to the password and therefore the database. I have suggested that my end user should change his password on a regular basis, to ensure that if the password is found out it will get changed again. This makes the whole system more secure. Also, to make sure that the system does not get infected by viruses I have also suggested that the end – user invest in some form of anti – virus software. The software I have suggested is Norton Anti – Virus 2003 but it is down to the end – users discretion whether or not he goes ahead with it. Differences and similarities between the current system and the proposed ICT solution Similarities There are not many similarities between the two systems, as the general idea was to change the system to make it a lot better. However there is one similarity between the two systems, the same information is entered into the database as is entered onto cards. This is only a small similarity, as the whole process is completely different now. Specification – Design Possible solutions There were a few other possible solutions to my end-users problem; I came up with a number of alternatives but the database solution just seemed to stand out as being the best. The other solutions that I came up with which were taken into consideration by my end-user were as follows: * Swap the cards for sheets of paper, which could be stored in folder or filing cabinet. We decided that this would not be such a could idea, because its not really much of an improvement and my end-user needs a big improvement. * A spreadsheet using Microsoft Excel. We also decided against because is not a very efficient programme for the type of thing my end-user wants. You cannot perform clear searches or have different tables etc. * A table using Microsoft word. Again, we decided not to use word plainly because this programme is too simple and basic. It does not really include many advanced features like searches and the information cannot be stored neatly, which makes the information difficult to access. Reasons and justifications for final choice of software and hardware We eventually decided to go with the database using Microsoft Access, because overall we thought it was the best piece of software to use. A few of the reasons why we chose Microsoft Access are: * You can perform searches and queries * Data is easily accessed * Modern * You can create tables which are linked together * Create mail merged letters * Password In my hardware section I have already specified what I will be using for hardware. This specification of hardware is suitable for me to create the database because it offers enough speed and memory (both virtual and physical) to enable to be able to work efficiently. This is because the bigger the processor the bigger amount of RAM, all makes the computer a lot faster. Outputs required by the end user The outputs that are required by my end-user are: * Invoices – So that the customer has a proof of purchases. * Splash Screen – This is to improve the presentation of the database and to put information about the creator on. * Reports – To enable the end user to print out hard copies of queries etc * Mail-merged letters – So that the end user can automatically contact customers. Inputs and stored data needed to create the outputs Output What is required? Invoices Customer information, product information and details of purchase (date etc) Splash Screen My 1337 skillz Reports Results from queries from all 4 of my tables will be shown to make the reports, which will then be printed off so that the user has a hard copy Mail merged Letters Customer’s details, which can be automatically accessed. Processes that are required to produce the required outputs Knowledge and ability to use advanced package features Relationships The database that I will be creating will be a â€Å"many-to-many†. I will be in the form of first form normalisation. I will have four different tables, each having its own primary key that will be referentially integrated to a linking table, to make sure all the tables stay up to date.