Wednesday, January 29, 2020

Supermarket Database-Computer Coursework Essay Example for Free

Supermarket Database-Computer Coursework Essay Introduction There are many supermarkets around us, but there do you know how it works. In this coursework., we will anyalsis the problem of the old supermarket system and how to solve this problem. Besides, in this coursework, it will introduce a new supermarket system, introduce its advantage, how to set up, how to use it and what is its advantages. Old supermarket system Disadvantage: piles of papers are used to keep the records it is hard to back up the records, if you really do so, the cost of the ink and the papers can make you bankrupt the payments are calculated by men, if your mathematics is poor, you will bankrupt again you need to spend nights after nights to turn the pages by your hands in order to search the data of the customers and supplier snail mail is used, which means time and money is wasted your customers cannot immediately get the most update news of your product, simply the million-dollar contract will fly to other companies the piles of paper wont remind you when your product is expired, you need to search through the papers it is not easy to comunicate to your branch stores. Many workers are needed to check the store Solution of the problem To solve the problem in the old supermarket system,setup up a database system that would control local store inventory, and cover the ordering of stock from the customers. Advantages of the new system Digital record is used. Millions of information are stored in a 6-inch hard-dish. The records can be backed up inside a DVD or a hard dish drive. the payments are calculated by computer, which decreases the human error In order to search the data of the customers and supplier, you simply need to type the name, or tel. number. email is used, your customers can get the most update news of your product, at once the computer will remind you when your product is expired, so you can make preparations you can communicate the computer form one branch store to another. Information can be transferred immediately computer can do most of the jobs. Less workers are employed Old system Computer system Space needed to keep the records more Much less Back up Very difficult Very easy error High possibility Low possibility Search data Very complicated Very convenient mail Slow and expensive Quick and free Check expired stock By hand automatically Communication Slow and inconvenient Quick and easy Number of employees more less Requirement of the system. It is consider that the supermarket has original system which has only one computer with the following equirement. Working system Windows 2000, standard edition Processor Pentium III 733Mhz, RAM 256MB recommended Drive space 20GB Video 32MB shared ram In order to reach the requirement of the new system, the computers need to replace new ones and connected as the following instructions. Requirement of the server. Working system Windows server 2003, standard edition Processor Pentium 4 3.0Ghz, 550+ MHz recommended RAM 1024MB/1G recommended Drive space 250GB Video 128MB shared ram or better This computer is highly security. It needed the voice check and the password of the three highest manager to open the report of the profit and also to open the economy condition of the supermarket. Besides, the server is connected to a internet server with domain name. This is because this can convenient the customers to shopping or order products from the internet. Requirement of the other computers The other four computres is used to save data. They should have the following requirement. Working system Windows XP, Professional Processor Pentium 4 3.0Ghz, 550+ MHz recommended RAM 512 MB recommended Drive space 80 GB Video 128MB shared ram or better Software of the programme The supermarket can use Microsoft Access or Visual Basic The advantages of using MS Access are: * It is a relational database, which makes the data management easier. * It integrates easily with other Microsoft packages such as Word and Excel. * It is inexpensive. * It is a flexible product that cab be used for all kinds of databases. * It can be used to build extensive database applications. * All the information is held in one place and the information only needs to be updated once. * It can retrieve and update information quickly and easily. * Reports, standard letters can be easily produced. * Backup and archiving is easy. The disadvantages of using MS Access are: * It lacks in high volume capacity. * It is limited to a low transaction rate. * It can bring down the entire servers if it is not used properly. The advantages of using Visual Basic are: * It provides a user-friendly interface. * The modular structure in visual basic program helps the programmer to develop a large program without knowing all the variables and their relationships. * It is provided by an integrate development environment that helps the programmer in debugging syntax errors. The disadvantages of using Visual Basic are: * It is limited in the kind of application that visual basic can code. * That additional memory might be required because of the graphics. * That visual basic is not a matural programming language. * That successful operations are crucial. * It has a slower processing in some applications. * It is more difficult to recover. Set up of the programme In this system, the programme is based on the Microsoft Access Create a new database file first and then create a table which should contain the following item: * Image of the * item description * bar code * item code * item location in store * price * maximum (amount to order) * current stock * date ordered * date received * quantity received * expired date * supplier * supplier address * supplier email * supplier telephone number * The characteristic of each item of data, such as The data on the documents have been analysed, where on the next page tables have been completed to show what information is contained. The information that is contained includes: * What tables and column are presented. * The names of the current tables and columns. * Any validations on the values of certain columns. Data Item Description Data Type Validation * item description The description of the product Text * bar code The bar code of a product Text Letters only * item code The code of a product Text Letters only * item location in store The location of the product in the supermarket Text Letters only * price The price of a product Numbers * maximum (amount to order) The number of product in the supermarket Numbers * current stock Whether the book is hardback or paperback Text Letters only * date ordered The order of the product by the customer Number * date received The order of the product ordered by the customers Number After create the above table, by using the Microsoft Access, a new table will be created to input the data of each product. Besides, to show the out and in of each product, by using the Microsoft Access, a report can be created. Shopping from the Internet Some customers will order products from the internet. Therefore a website should be set up for their confident. In order to get associate with the system, some more items are needed to create in order to record the information of each customer. It can be done as shown: Contain of the table This table is about the information of the customers which order products from the internet. The table should contain the following item: * Customer name * Customer no. * Address * Contact method * Phone number * Credit card number Data Item Description Data Type Validation * Customer name Name of the customer Text * Customer id. The id of the customer in the system number * Address The home address of the customer Text Letters only * Contact method How to contact to the customer E-mail/phone choose * Phone number The mobile/home number of the customer Numbers * Credit card number The Credit card number of the customer Number This website should also be linked to the main server of the supermarket and the website should have the following function. Function A laiding form will need to be printed, which will accompany the shipment to the store, and should include the following information: * (from) address of supplier, (to) supermarket ID, * supermarket address, * department, * managers name * and order number, * as well as a list of item descriptions, * item codes, * amount requested, * and amount sent. When the shipment reaches the store, the manager initials the bill of laiding, confirming that the shipment has arrived. This form is then returned to the warehouse where an invoice must be generated . The invoice, which will be sent to the store should be in some form that can either be printed (and subsequently mailed), or simply sent via email to the specific store. The proccess is done as shown. Problem of the security As it is easily to shopping on the Internet, and is easily to hacked by the hackers in the Internet and the personal information of each customers will be stolen. Thus, to prevent this happen, security is needed. SECURITY of the system This system requires some form of a hierarchical security system which should consist of three categories. * Level one access should be for the Head Manager. The Head Manager should have access to everything in the system, and should be able to add new people to the system, and delete them when necessary. It should also be possible for the Head Manager to easily switch people between different security levels, and to add/delete departments as required. * Level two access should include privileges for Department Managers. These managers should have complete access to everything in their department, including the placing of orders and allocation of access for cashiers/stockers in their departments. However, they should not have access to any other department functions * Level three access is intended for cashiers/stockers. Basically they should be allowed to change the amount of stock in the current inventory, either through the selling of an item to a customer, or in the stocking of shelves with new inventory. In order to identify the power of the different manager in the system to increase the security. The table should contain the following items: * Worker ID * Worker Name * Working position * Power of the worker * Date of birth * Address * Phone number And then setup the table ass shown Data Item Description Data type Manager Id The Managers ID Number Manager name Manager name Text The working position working position of the manager Text Power Power of the worker in the system Text Date of Birth Birth of the worker Number address Address of the worker Text Phone number Phone number of the worker Number This table is used to input the data of each worker in the supermarket. It also identify the power of the worker in the system. It decides what the worker can see in the system. Work and power of the manager Managers also have the ability to cancel an order altogether, and to change the supplier. As new products hit the market, they should be able to add a new item to the database. Similarly, managers should be able to delete an item from the database in the case that it may not be selling, or is discontinued by the manufacturer Some mechanism allowing the manager to adjust the information contained in the database will be a beneficial tool. This mechanism should include among other things the ability to change the product point of order value, change the product maximum order value, transfer items between departments, and add and delete departments as necessary. Changing current inventory stock is a function that should be given to everyone in some form. For example, cashiers will automatically decrease the item count when a product is sold to a consumer. Stockers and/or managers will also need the ability to increase current stock count as new stock arrives. The order form should contain the default amount of stock to be ordered for each item, and should be able to be adjusted by the manager under special circumstances (such as a promo). When the manager gives his/her OK to the system, the system should send the order to the warehouse. If some product has been ordered, and it takes a while for that product to arrive, we do not want the same product ordered several days in a row. The system must contain some sort of list of items on order. As the items received come in, they should be taken off this list. The objectives of the proposed system are: * To make buying things an easier process. * To produce reports on overdue books. * To check which products are currently available in the supermarket. * For the staff to be able to obtain information of who has ordered a particular product. * To keep a record of customers and their details. * To be able to add, edit or deleted details concerning the customers * For each customer to have a unique id in case two people have the same name * For each product have a unique id * The system should only allow authorised people to the data. Problem of this system When using the Microsoft Access to setup the programme, it will take a long time to set up. As it needs to create a lot of tables, besides, each table is linked together and totally linked to the server to the internet. When linked to the internet,it is difficult to get a good domain name. Also, it is easily linked wrong. Solution of the problem To solve the problem * First, set up the system more carefully. * Try to buy a good Domain

Tuesday, January 21, 2020

The Beat Generation Essay -- essays research papers fc

The â€Å"beat movement† is a literary period born out of World War II. This movement in American Literature has become an important period in the history of literature and society in America. Characterized by personal alienation and contempt for convention, the movement celebrated stylistic freedom and spontaneity. The Beat writers created a new vision of modern life and altered the nature of awareness in America. The Beat Generation was one of the first groups of writers to break down the barriers of traditional literature and set a precedent for future writers with their writing style, their way of life, and by the messages they portrayed. They were the kids dressed in black, hanging out at coffee shops, reading their latest poetry. They protested wars, were drug users, and openly expressed homosexuality, as they expressed every aspect of their life candidly. But, the Beats are best known for their writing style. It was unique for that time to cast aside conventional structures of sentences and poetry. They used dashes instead of commas and periods; to write the way a person hears speech. Their poetry had a style of it’s own, unknown to any other groups of poets at the time; no rhyming, no structure, and non-conforming beauty. The Beat writers formed in New York City, started with only a few members, but grew to have an impact on American society, especially in literature and politics, which still lasts today. Jack Kerouac and Allen Ginsberg were the founders of the Beat G...

Monday, January 13, 2020

Module a

Whilst texts may be fictitious constructs of composers’ imaginations, they also explore and address the societal issues and paradigms of their eras. This is clearly the case with Mary Shelley’s novel, Frankenstein (1818), which draws upon the rise of Galvanism and the Romantic Movement of the 1800’s, as well as Ridley Scott’s film Blade Runner (1992), reflecting upon the increasing computing industry and the predominance of capitalism within the late 20th Century. Hence, an analysis of both in light of their differing contexts reveal how Shelley and Scott ultimately warn us of the dire consequences of our desire for omnipotence and unrestrained scientific progress, concepts which link the two texts throughout time. Composed in a time of major scientific developments, including Galvani’s concept of electricity as a reanimating force, Shelley’s Frankenstein utilises the creative arrogance of the Romantic imagination to fashion a Gothic world in which the protagonist’s usurpation of the divine privilege of creation has derailed the conventional lines of authority and responsibility. Her warning of the dangers of such actions is encapsulated within Victor’s retrospective words of â€Å"how dangerous is the acquirement of knowledge†, whilst Shelley’s use of a fragmented epistolatory narrative adds a disturbing sense of truth, foreshadowing the dark consequences of Frankenstein’s actions. Moreover, her allusions to John Milton’s Paradise Lost evoke the poetic retelling of Satan’s fall from grace, wherein the daemon’s association with â€Å"the fallen angel† exacerbates the effects of Victor’s rejection, ultimately transforming its â€Å"benevolent nature† into a thirst for retribution. Together with its questioning of how Victor could â€Å"sport with life†, Shelley’s warning reverberates past the page, directly questioning the scientists of her era, including evolutionary theorist Erasmus Darwin, to reinforce the dangers of our humanity’s inherent yearning to play the role of the Creator. Such a warning also exists within Scott’s Blade Runner, hence linking the two texts throughout time, where the director echoes the rise of capitalist ideals and the Wall Street mantra, â€Å"greed is good†, through the symbolic dominance of Tyrell’s towering ziggurat, a reflection of both his desire for omnipotence and commercial power. Tyrell’s egocentric nature is epitomised within the religious connotations of his abode, including his voluminous bed, modeled after that of Pope John Paul II, as well as his reference to Batty as â€Å"the prodigal son†. Such symbols are unnervingly subverted through both the foreboding Chiarscuro of flickering candle-light with shadow and his violent death at the hands of his own creation. Scott’s warning of the dangers of such a desire is also evident within the expansive shots of 2019 LA, revealing a dark and tenebrous world lit by the glow of corporate advertisements, a representation of a bleak future dominated by commercial dominance. Hence, by drawing upon elements of his context, including the growth of capitalism and the ‘trickle-down theory’ of Reagan’s era, Scott positions us to reassess the consequences of overstepping our boundaries. In addition, both texts’ warnings also encompass the dangers of unrestrained scientific progress, where Frankenstein further demonstrates the Romantic Movement’s influence on Shelley’s mindset, as her criticisms of the Age of Reason and Industrial Revolution reflect their denigration of rationality. The imagery of the â€Å"dead corpse† and repetitious use of â€Å"horror† upon the creation of the â€Å"miserable monster† establish a strong aura of death and despair around this scientific advancement, whilst Victor’s warning of Walton to â€Å"avoid ambitions of science and discoveries† encapsulates Shelley’s vilification of contributors to the Industrial Revolution, including renowned inventor James Watt. Moreover, Shelley stresses her warning through the protagonists’ connections with nature, where Victor’s â€Å"insensibility to its charms†, arising from his immersion in science, results in his â€Å"deep, dark and deathlike solitude†, with the heavy alliteration exemplifying his degraded sense of humanity. Conversely, the monster possesses greater â€Å"benevolence† and a more intimate connection with â€Å"the pleasant showers and genial warmth of spring†, with such characterisation capturing Shelley’s reflection of Romanticism’s idolisation of nature, cautioning us against the dehumanising effect of unrestrained scientific advancement. Blade Runner is no different, with Scott’s reflection of the explosion of technological progress during the 1980’s, including the rise of computing giants IBM and Microsoft, highlighting the dangers of such unrestrained progress. Most notable is the opening panoramic shot of blazing smokestacks which, together with the haunting synthetic pulses of the Vangelis soundtrack, establishes a festering miasma of technological overload, adding further semiotic weight to the film’s nightmarish dystopian agenda. Indeed, this portrayal of a decaying environment reflects the growing ecological awareness of the 1980’s, which, whilst different to Shelley’s Romantic values, is similarly employed to highlight the destruction of mankind due to technology. Moreover, Scott illuminates us to the dehumanising effects of such progress, foregrounded through Deckard’s â€Å"retiring† of the Replicant Zhora. Here, the stylistic placement of the transparent poncho places further emphasises the violence of her death, with slow-motion low angle shot conveying her heightened sense of humanity within her last painful moments. In contrast, Deckard’s emotionless features, together with the monotonous drone of the droid, suggests that our artificial creations will ultimately lead to the dehumanising of mankind, undermining our humanist framework and hence, warns us of the dire consequences of unchecked scientific progress. Thus, we can see how both Shelley and Scott reflect their zeitgeists in their texts, Frankenstein and Blade Runner, as they draw upon the societal concerns of their times in order to warn us of the consequences of overstepping our boundaries and unbridled technological advancement. Subsequently, it becomes evident that despite their temporal and contextual differences, both texts are in fact linked through their common concerns and concepts.

Saturday, January 4, 2020

My Most Important Skills Someone Can Be Our Own Pop Culture

One of my most defining traits is being very analytical to what I am passionate about. I feel that critical thinking and analysis are some of the most important skills someone can have in this world today. The ability to look at everything presented to us critically: whether it be our own pop culture, the people around us, the events happening in the world, the social situations close to us, or the crucial decisions you make every day, can lead us to making better judgements by thinking about things with more complexity and understanding. I want to teach high school English for sophomores and seniors, because I feel that those are the most formative years during high school. For sophomores because that’s when they start forming their identity as a young adult, and for seniors because that is when they are about to leave high school and enter the adult world. Those two points in high school feel like the most crucial times we should be teaching literature to high schoolers, as an appreciation for literature and analysis can be very beneficial for students who are grappling with difficult questions and ideas about themselves. The lessons we can learn from literature and the critical thinking skills they would gain through analysis can help benefit the students and help them process the difficult changes they might be facing. Something that I would want to advocate to my students is that all media presented to them has the potential teach important lessons; whether it would beShow MoreRelatedThe Cognitive Development Of Children1269 Words   |  6 Pagesexample, of what can shape the cognitive development of a child can be an educational game. Educational games can be very useful in shaping a child’s development because they are having fun while learning at the same time and what kid doesn’t like to play games, the fact that it is even educational makes it even better for them. Not only are they having fun but there are many different games that help in different categories of development in different age groups. These games can engage children inRead MoreMy Cultural Identity Essay1258 Words   |  6 PagesPeriod: 2 | 9/15/17#1 Everyone has their own, one of a kind cultural identity and culture. Your culture could be anything like an interest in technology or what hobbies you like even food. My cultural identity would not exist if it wasn t for what I value the most and what I love the most. In the world, nowadays people like a lot of things such as music. But what I like is completely different, There is one that influences my cultural identity and that is my electronic devices, I say this becauseRead MoreHow Did Queen Have Influence The Influence On Queen And Mercurys Influence1422 Words   |  6 Pagesfrom the 70’s whose influence transcends genres and continues to inspire and affect artists to this day. There are three main reasons that Queen continues to be so influential and well known, even decades after their peak has passed. The first and most obvious reason is Queen’s frontman, Freddie Mercury, and his amazing performances and extraordinary vocal range. The next reason is Queen’s accomplishments and the many awards they won during their time. The final reason is their tendency to take risksRead MoreAgents of Socialization Essay 51720 Words   |  7 Pagesas a teenage girl some part of my life revolve around this aspiration to be as be autiful as the girls in magazines, television, and the movies. As a result, I tend to want to wear makeup while continuously buying new clothes to strive for this ideal. Seeing as this is so unattainable, I often find myself feeling insecure about my face, body, and myself in general. Furthermore, the internet seems to implement these ideas in a much more sexual way when it comes to pop-ups and Facebook who promote thatRead MoreWho Is The Best Entrepreneur?1435 Words   |  6 Pagescomplete misconception of what, exactly, makes someone an entrepreneur. Pop culture has bombarded us with the image of the money hungry businessman out to make a profit at whatever cost to his personal life and relationships, not all too far from Jesse Eisenberg’s portrayal of Facebook founder Mark Zuckerburg in 2010’s Social Network. However, having spent the last semester in my first entrepreneurial studies, it is clear that the real entrepreneurs of our society have qualities that go m uch deeperRead MoreDigital Vs. Traditional Art1281 Words   |  6 Pagesalso under the subgenre â€Å"digital art.† A popular web definition for digital art is: â€Å"a general term for a range of artistic works and practices that use digital technology as an essential part of the creative and/or presentation process.† Drawing is my hobby and I usually draw with digital media. I prefer digital drawing to traditional drawing for a few reasons: the lower cost of purchasing the necessary materials, storing the material, and preserving the artwork effectively. Some of the benefitsRead MoreEssay about Fandom in Popular Culture1319 Words   |  6 PagesRiver Steinberg Fandom in Popular Culture Everyone is a fan of something. Whether it’s a sports team, celebrity, or television show there is at least one thing that a person enjoys to partake in, talk about, etc. Yet when does becoming too much of a fan – or a fanatic – become a problem? This question raises concern because recently many different fan bases or fandoms of certain movies, books, etc. have been criticized over the last decades due to their extreme dedication and obsession. Some peopleRead MoreA Loyal Servant, Graphic Design And Its Journey2084 Words   |  9 PagesA loyal servant, Graphic Design and its Journey Introduction Graphic design is a very young profession which has been forming for years and earned its own, separate name from other areas of art in around 80`s . Before that, graphic design was called commercial art and its practitioners were called visual communicators. As a such a young profession it grew incredibly fast and spread globally. In the book of Graphic Design For The 21st Century, C. P. Fiell describes it as the part of the fabric ofRead MoreEssay on pulp fiction2691 Words   |  11 Pages Pulp Fiction (1994) is a mesmerizing, violent and entertaining movie. It has a bizarre cast of characters, a nonlinear sequence of events and endless references to pop culture. The underlying theme of the movie, however, deals with religion and the transformation of two characters: Jules (Samuel L. Jackson) and Butch (Bruce Willis). nbsp;nbsp;nbsp;nbsp;nbsp;In the beginning of the film, Vincent (John Travolta) has returned from a stay in Amsterdam, and the conversation between Jules and VincentRead MoreThe Hero As A Hero1529 Words   |  7 Pagesnoted for courageous acts or nobility of character; and a person who, in the opinion of others, has special achievements, abilities, or personal qualities and is regarded as a role model or ideal.† Nowadays, the word â€Å"hero† can be associated with literally anyone. Heroism can be associated such as famous people, fictional characters, average people, or even personally known ones. Therefore, the term â€Å"heroism† has completely evolved from its original meaning to a much more complex connotation. To