Creating A Database For Student Information System Computer Science Essay

Creating A Database For Student Information System Computer Science Essay A database brings convenient to todays working area such as large business company. The main purpose of a database is just similar to handling and keep large amount of files and documents in a large cabinet. However this method takes a large space and will be complicated to control and organized. This is why a database is introduced to keep these data organized to allow users to access, retrieve, and use of the data without any hassle. DBMS or Database Management System is software that used to set up a database, creating a database requires planning and gets to know what kind of data will be imputed. Creating a database will be easier after a simple table is constructed. In this assignment, a Student Information System is used as an example to keep student information in a database. Moreover Oracle, Microsoft SQL Server and Microsoft Access are example software provided by database vendor that used to create a database. Other than Student Information System as stated above, this software allows changes in database such as adding student entity relationship to expand the database. Microsoft Access is used to create Student Information System Entity Relationship(ER) because it has user-friendly interface compared to oracle and yet it is still a powerful tool to create a simple database. Define Question 1 1.0 What is Database and why is it needed? A database is a collection of various types of stored data so it can be used for operation purposes. These data can be organized in different modal such as hierarchical, network and relational models depend which one is suitable for that particular operation. A database plays an important role in many fields such as large companies, colleges as well as super markets we visit daily. Most of databases are being used in large business company which they often record their purchases, sales and keep track with employees information. Database record, store and process data to generate a variety of information for decision-making at the various levels in an organization or business company. However large number of information cannot be handle by just human alone this is why a database is used to complete these tasks accurate, relevant and timely. There are many advantages when database is used because: It helps reduces data redundancy. Has high processing speed to manage data in a very short time. It allows data sharing among different users. Maintain data independence to keep database safe even if one data is corrupted. Have better security because of different levels of access privileges controlled. It avoids data inconsistency. Reduces storage requirements. A database will not run on its own without software. Similar to computer, a computer will be useless without an operating system. This is why DBMS (Database Management System) is required in order running and allows manipulation in database. DBMS is software that uses SQL (Structured Query Language) that is a programming language that manages data in a database. SQL Manager for Oracle 1.1.0 Database of a Student Information System The concept of a database can be easily understood because it is similar if we create a table that stores different kind of information. It is encouraged to plan the database by making a simple table so that it will be easier when creating in DBMS. In this case Student Information System is created to store all students related information such as their index numbers, home addresses, gender and so on. The concept is started with record, which is a collection of related fields of an entity. Each record consists of several data Index Number First Name Last Name Age Gender Address Course Grade S0001 Julia Yasmin 17 F 13 Hibiscus Road BM A Student Information System in a College Index Number First Name Last Name Age Gender Address Course Grade Fee Paid S0001 Julia Yasmin 17 F 13 Hibiscus Road BM A Yes S0002 Nicholas Wong 18 M 24 Metro Street IT A Yes S0003 Niko Bellic 18 M 53 Hove Beach IT B No S0004 David Kim 17 M 4 Lake Garden IT B No S0005 Carl Johnson 18 M 77 Park Lane BM C No S0006 John Kay 17 M 22 Lin Seng Park BM B Yes S0007 Jasmine Stewart 17 F 16 Park Lane BM B Yes S0008 Tony Murphy 19 M 55 Brooker Road IT C Yes S0009 Tina Shaw 18 F 31 Hibiscus Road BM A No S0010 David Ford 18 M 28 Lake Garden IT C No Keyword: BM = Business Management, IT = Information Technology The table above shows that all student information is recorded in detail of a college. Index Number is created to identify each student. All different single line of records are grouped together to form a 10 records table. The table is also known as file, which is a collection of related records and these data will be stored in colleges main database. Primary Key A primary key is similar to Internet search engine (Google), for example when you search for the word food, immediately all food related websites and pictures would display. Each file may need a primary key in a database, which is an important key name for searching a particular record in the file as well as identify each record uniquely within relation. Primary key can be consists of index number or name because they have their unique name or integers. However primary key cannot be address because the name is long. When a database grows larger, these primary keys will be very important to help user to find particular data they needed. 1.2.0 The Relationship between Tables Since the database is related to student information, this table may be shared in several departments such as casher, lecturers, class and students overall examination grade. This relationship is known as Relation Model, which is basically consists of a set of interrelated tables. Data in a relational model are stored in two-dimensional tables. Each department will have different privilege to access different type of data and only display the information they need. Below is the shared information in several departments. 1.2.1 Casher Colleges Casher Index Number Casher Index First Name Last Name Age Gender Course Fee Paid S0001 C101 Julia Yasmin 17 F BM Yes S0002 C102 Nicholas Wong 18 M IT Yes S0003 C103 Niko Bellic 18 M IT No S0004 C104 David Kim 17 M IT No S0005 C105 Carl Johnson 18 M BM No S0006 C106 John Kay 17 M BM Yes S0007 C107 Jasmine Stewart 17 F BM Yes S0008 C108 Tony Murphy 19 M IT Yes S0009 C109 Tina Shaw 18 F BM No S0010 C110 David Ford 18 M IT No Primary Key: Casher Index The table shows that all necessary information required in casher such as fee paid and casher index to track students that are not yet paid their tuition fee. While students addresses and examination grade are hidden to reduce complexity because it is not necessary. This is called as external view because it allows user to have own view of the database. 1.2.2 Student list in a particular course Lecturers will have their own student list depend on which course they in charge. Since in real colleges database may consist over hundred of students, working with a large table can be troublesome and complicated. To make it easy, this large table will be needed to break up into two related table, which are Business Management and Information Technology classes. This concept is called data normalization. Normalization makes data more manageable and allows many data to be shared in just one database. This is because it removes data inconsistency as data is modified in one place as well as reduces storage requirement and data redundancy. Business Management Course (BM) Index Number Examination ID First Name Last Name Age Gender Course S0001 E1001 Julia Yasmin 17 F BM S0005 E1005 Carl Johnson 18 M BM S0006 E1006 John Kay 17 M BM S0007 E1007 Jasmine Stewart 17 F BM S0009 E1009 Tina Shaw 18 F BM Primary Key: Index Number Information Technology Course (IT) Index Number Examination ID First Name Last Name Age Gender Course S0002 E1002 Nicholas Wong 18 M IT S0003 E1003 Niko Bellic 18 M IT S0004 E1004 David Kim 17 M IT S0008 E1008 Tony Murphy 19 M IT S0010 E1010 David Ford 18 M IT Primary Key: Index Number The tables show that two different tables, which are Business Management Course and Information Technology Course. Students and their course can be easily indentified after the table is separated into two. We can clearly know that IT students are all male and both courses have equally five students each. 1.2.3 Students Examination Grade Index Number Examination ID First Name Last Name Course Grade S0001 E1001 Julia Yasmin BM A S0002 E1002 Nicholas Wong IT A S0003 E1003 Niko Bellic IT B S0004 E1004 David Kim IT B S0005 E1005 Carl Johnson BM C S0006 E1006 John Kay BM B S0007 E1007 Jasmine Stewart BM B S0008 E1008 Tony Murphy IT C S0009 E1009 Tina Shaw BM A S0010 E1010 David Ford IT C Primary Key: Examination ID The above table shows all students examination grade in the entire college and it is stored in Students examination database. This table is required for students certificate printout and act as a primary place for tracking student examination grade. Overall, all the tables had mentioned are the examples on how Students Information System is recorded in a college. This is a basic and very important step for a new user before data is record in Database Management software. Define Question 2 2.0.0 Student Information System Entity Relationship(ER) model We already know all the relationship between previous tables of Student Information System. However create a table only helps to know the concept of a database creation. In order to make these tables and their relationship more efficient and easy organized, database software is required. Therefore these tables are needed to transfer to Microsoft Access. With Microsoft Access, information in each column can be easily created. Creating relational tables will be faster because column of data can be copied from one table to others. 2.1.0 Relationship between tables in Microsoft Access 2.1.1 Primary Key Before tables can relate each other, a primary key is needed to declare in each table. The image above shows that primary key is declared in Students in Design View. A small key symbol (marked as small red circle) shows that Index Number has declared to primary key with primary key tool clicked (marked as large red circle). A particular field that needed to become primary key is highlighted and then Primary Key tool is clicked. 2.1.2 Relationship Chart Creating relationship between tables is easy because Microsoft Access has user-friendly interface, simply drag a data from one table to others and the relation line will appears Tables must link correctly in order to view their relationship. Primary Keys are linked to another tables, for example if we compare Students table with Casher table, Casher Index will become primary key while Index Number becomes foreign key. Note that small key symbol represents which data is primary key. Moreover, tables like Students and Examination Grade are having more than one matching table, which is called as parent table while the table they linked to are child tables. This relationship is called as One-to-Many relationship between different records or tables. 2.1.3 Relationship between Students and Casher Students The Student Information System is recorded into Microsoft Access as shown in image above. These information consists of students index number, which is an unique code that identifies each students. Other information such as First name, Last name, Age, Gender, Addresses and so on are also recorded inside this table. Casher The data in Casher table has created to record students fee paid. Some field such as Index Number and Course are shared together with Student table. Relationship between Students and Casher The table above shows the relationship between Students and Casher. From the first record we can clearly see Julia Yasmins casher index, course and her fee payment. While the last record we can identify that David Ford is in IT course and he is not yet pay his fee. The dropdown table will only appear when the relationship is linked correctly with relevant primary key from each table. 2.1.4 Relationship between Students Course and Students Examination Business Management Class Information Technology Class Business Management and Information Technology classes are separated into two different tables. These tables are also linked together with Students Examination Grade, which is to reveal their examination grade when it is opened. A drop down table from the tables above show that students examination grade is revealed. Two different dropdown tables is shown (marked as red colour border), when we look at the Information Technology Class. We can easily identify Nicholas Wongs examination ID, which is E1002 and gets grade A in examination. Similar to Tony Murphy, which has examination ID of E1008 and gets grade C in the examination. Students Examination Grade The table above shows the entire examination grade among every student, which exactly contains the same record from the table we had created from Question 1 (Page 9). As mentioned before, Students Examination Grade is linked to Students Course and this allows records also appear in Information Technology and Business Management Course. Overall, the tables in Microsoft Access made Student Information System organized in good manner and made user easily retrieve, access and view all students information in short time. Conclusion and Recommendation Information is an important resource in any organization and it must be properly managed. Database plays an important role because it allows information to be stored and organized in good manner. To handle large amount of information such as Student Information System, creating several tables is required to store different data such as name, index numbers, age and so on. Creating a database also requires knowledge on how data relate each other and their model. Learning Microsoft Access will be a good start for a beginner to learn and practice how database works even though it is not powerful enough compared to other database management software. Since nowadays jobs are relying on technology, having computer knowledge is very important to keep ourselves not to be outdated. Similarly, people with knowledge of database will have better job opportunity because most large business and manufacturing company will hire them. Bibliography Oppel Andy, 2009, Database a Beginners Guide, Second Edition, McGraw-Hill Professional Publishing, USA Anderson Virginia, 2001, How to do everything with Access 2002, McGraw-Hill Professional Publishing, USA MacMillan, Andy Huff, Brian, Transforming Info glut! A Pragmatic Strategy for Oracle Enterprise Content Management, 2008, McGraw-Hill Professional Publishing, USA P.Sellappan, 2002, Information Technology in Business, Fourth edition, Federal Publication Sdn Berhad, Malaysia James L. Johnson, 1997, Database Models, Languages, Design, , Oxford University Press Inc, USA Shelly Vermaat, 2009, Discovering Computer 2009, Complete Edition, Shelly Cashman Series, United States of America SQL Manager for Oracle 2007, View from File Transit, SQL Manager for Oracle, online, retrieved 12 October 2010, from http://www.filetransit.com/images/screen/2935188e684b1f718eecbf92de0bdfd6_EMS_SQL_Manager_for_Oracle.gif Primary Definition, 2010, online, retrieved 12 October 2010, from http://databases.about.com/cs/administration/g/primarykey.htm

Film Reflection “Home” Essay

Film Reflection: â€Å"HOME (2009)† Title : Home year : 2009 Director : Yann Arthus-Bertrand Watch (Your) Home! I watched the documentary Home recently, and really, earth is so magnificent. So many beautiful shots, such an eye-opener of the need of every part of nature. I really loved this documentary about our home. Besides all the gorgeous pictures of the earth and its nature, I really enjoyed one specific scene about trees (00:47:48). This scene explains why trees are important for our living; why they are â€Å"the cornerstone f the climatic balance on which we all depend†. In the background a sad, sensitive song is sung. A man is singing solo and uses his dark, deep voice, as if he were mourning. The combination of sounds are like an introduction of the sad following message: 20% of the biggest rainforest have been cut down. The music fits so perfectly with this message, that it caught me and made me aware of the gravity of the overconsumption of wood. Just an example of how one and a half hours of pictures, voice and music changed me and my ideas toward the environmental issue. Change Change. I use that word conscious. And it should change everybodys mind, because the whole movie isn’t Just filled with gorgeous pictures about the earth and its perfect balance, but also with the destructive influence of humanity. Everything is linked together, everything is connected and all our actions are affecting natures balance. The consumption of water, wood and the need for oil: everything affects natures balance. That is the message of this documentary, and I was shocked about my, maybe our unconsciousness. It looks like the delicate balance of nature is going to be disturbed drastically if we continue behaving like this. Did you know? This message shocked me and changed my ideas toward the environmental issue. You and l, as home sapiens, should change this. But, can we? Business responsibility Like I said, natures balance is changed by our consumption manners. Consumption starts with production. I think production companies have a great responsibility in the solution for our home planet. Since a few years organizations give attention to he â€Å"green issue† – their responsibility in these environmental problems. They come up with issues like sustainability. I always thought these were particularly attempts to gain market share. Social environment has changed since the upcoming warnings about environmental issues; consumers expected organization to implement ‘green production ways’. To satisfy (and behold) its customers, organizations might have I’ve seen this movie â€Å"Home†, I see that organizations really have a great responsibility in changing the tide. Their decisions could be made with the sincere aim. But at the same time I think organization could make much more radical decisions if the really want to. Couldn’t organization decide to turn down product quality to improve environmental quality; to minimize the use of water and electricity; maybe to renounce the increase of sales numbers and stimulate customers to extend the lifetime of products? In the last scenes of Home, Yann Arthus-Bertrans gives a lot of examples of how companies reacted drastically towards the environmentally problems. It requires courage, will and moreover consciousness. Organization must be aware of the fact that their actions, their plans and strategies are linked to natural resources, to the future of our planet. Our home. Together Awareness and decisiveness amongst diverse operating organization can make a difference, I think. But the problem should be tackled together. All competitors should agree on â€Å"green† production, to prevent one competitor is competed out by doing the right thing. Only when this isn’t possible, legislation should control business activities, cause will is stronger than obligation. Also consumers like you and me have responsibility. Awareness of our habits can fade out greed, although we aren’t easily satisfied materially. When there’s the common believe we all are a shackle in the solution for environmental problems, I think it is possible consumer behavior will change, but a common believe must be created. That’s something the government should do. But also you and me can help. Tell your neighbors about the need for changes in both production and consumption. Buy this movie Home. Watch Home together, and let’s watch our home, together!

Supply Chain Management of Amazon Essay - 1620 Words

This paper reviews the supply chain management practices of Amazon.com (AMZN) and highlights findings in the framework of a Strengths – Weaknesses – Opportunities – Threats (SWOT) framework. AMZN opened its virtual doors on the World Wide Web in July 1995 as a web based bookseller and today offers Earth’s Biggest Selection according to the company’s 2012 annual report to shareholders. AMZN’s vision statement is to be Earth’s most customer-centric company for four primary customer sets: consumers, sellers, enterprises, and content creators. AMZN has organized its operations into two principal segments: North America and International. Figure 2 below shows AMZN’s net sales for the last three years reported. Figure 1: AMZN Net Sales†¦show more content†¦AMZN serves consumers directly via its retail websites, which offers millions of unique products across many categories sold directly by AMZN or via its vast network of third party sellers. Regardless of who is actually providing the product AMZN provides excellent user interfaces, seamless fulfillment, and world class customer service. Similar to Wal-Mart’s everyday low price strategy, AMZN strives to offer its customers the lowest prices possible through low everyday product pricing and shipping offers. AMZN fulfills customer orders through US and International fulfillment centers and warehouses as well as via digital delivery for media products. AMZN’s multi-tier inventory model also allows for order fulfillment through partner suppliers and third-parties. This enables AMZN to offer a vast product selection to its customers without the risk of large inventory carrying costs. AMZN’s multi-tier inventory model is depicted in figure 2 below. Figure 1: AMZN multi-tier inventory model. Source: Chiles and Dau, 2005 AMZN has competed on selection with traditional retailers since its inception. AMZN is able to support this selection through its multi-tier inventory network. The following is a description of the three tiers or echelons that comprise AMZN’s inventory network. The website www.amazon.com is the consumer interface and owns theShow MoreRelatedAmazon : Supply Chain Management3034 Words   |  13 PagesUniversity LGMT 683 – Supply Chain Management July 25th, 2015 Introduction With very little doubt, Amazon has become the most feared competition amongst traditional retailers such as Target, Wal-Mart and Best buy. To support this growth, Amazon has built one of the world’s largest supply chain distribution systems spanning 148 centers around the world, totally more than 17 million square feet in North America alone (Stone, 2009). However, in the midst of the massive growth of that Amazon has experiencedRead MoreAmazon s Supply Chain Management Essay1187 Words   |  5 PagesEvery company has their own supply chain in order to sort or produce goods. However, the company needs to manage supply chain to maximize its highest benefits. By having effective supply chain management, the company can ensure that the right product or service will be available at the time to the right place and at the right price (Kamal 2007). Amazon is one of the companies that have best supply chain practices in order to respond high level of responsiveness for the customers. Thereby, this paperRead MoreSupply Chain Management : Walmart And Amazon Essay838 Words   |  4 PagesSUPPLY CHAIN MANAGEMENT-INDIVIDUAL Introduction: The supply chain management is considered as a management concept from past two decades as the customers are concerned about timely and safe delivery. The competitiveness has been increasing among the companies to deliver the products as quickly as possible to the customers all around the world. This has made the supply chain management as a vital tool for the management. This is also measured as a competitive parameter for the companies. The two supplyRead MoreA case study of Amazon on its supply chain management2672 Words   |  11 Pagesï » ¿INTRODUCTION Every company has their own supply chain in order to sort or produce goods. However, the company needs to manage supply chain to maximize its highest benefits. By having effective supply chain management, the company can ensure that the right product or service will be available at the time to the right place and at the right price (Kamal 2007). Amazon is one of the companies that have best supply chain practices in order to respond high level of responsiveness for the customersRead MoreAnalysis Of Amazon And Wal Mart1614 Words   |  7 Pagespursue the same strategies. This is evident with both Amazon and Wal-Mart, both are direct competitors but each focuses on a different market channels and provide different customer value proposition. A business strategy characterizes a company’s unique position in the market and distinguishes the firm ’s value proposition from that of its competitors. Qupte Simci levi Such a unique market position drives and depends on operation s and supply chain strategies. Unfortunately due to the effiency curveRead MoreSupply Chain Management And Distribution1520 Words   |  7 PagesSupply chain is a network of facilities and distribution options that performs the functions of procurement of materials, transformation of these materials in to intermediate and finished products and distribution of these products to the customers. Supply chain Management (SCM) is the management of flow of information, products and services across a network of customers, organization and supply chain enterprises. It incorporates the development and capacity of raw materials, work-in-progress ofRead MoreAmazons Value Chain Analysis1620 Words   |  7 PagesValue Chain Analysis In the 1990s, Amazon (Amazon.com) introduced a new business model for entrepreneurs choosing to use the Web as its place of business rather than the traditional brick and mortar companies. Amazon’s e-business and e-commerce business models generated significant revenue for the company and resulted in creating an effective and sustainable competitive advantage for the online retailer. â€Å"Amazon was one of the early movers to recognize the opportunity in both e-commerce and cloudRead MoreWarehousing And Distribution Are Critical Parts Of The Global Supply Chain1638 Words   |  7 Pagesparts of the global supply chain. They are the points where the product pauses and is touched, consuming both space and time. Space and time, in turn, are expenses. By developing mathematical and computer models to fine-tune the layout and operations of a warehouse, managers can significantly reduce labor costs associated with product distribution, increase warehouse space utilization, and im prove the overall flow of projects. I. Introduction Overview Amazon.com, often simply Amazon, is a Fortune 500Read MoreAmazon.Com Supply Chain Management1550 Words   |  7 PagesRunning head: Amazon.com Supply Chain Project Amazon.com Supply Chain Project Jarrel Nightingale JNightingale2@CapellaUniversity.edu Capella University BUS3004: Supply Chain Management Professor Dr. Robert Goldwasser December 10, 2012 Amazon.com Supply Chain Project Introduction In today’s society, Online Shopping and the industry of e-commerce has become very popular and mainstream. Many individuals have integrated online shopping into their normal routine and haveRead MoreRobin Van Persie1682 Words   |  7 PagesGreen Supply Chains * According to Handfield and Nicols 1999, the nature of how supply chains are defined as â€Å"supply chain contains all activities that involve the flow and transformation from raw materials†. Following on from this description I will describe the nature, first of all, the supply chain is a network of facilities that distribute and output the performance from their findings of raw materials that which associates themselves with the products that already exist in supply chains

Araby vs. Going to the Moon Essay - 1130 Words

Araby Vs. Going to the Moon By: Heba Haidar Humans have always been curious beings. Their curiosity has brought about new experiences, and new knowledge that helped in the process of their evolution. Human children grow up and learn about the world by utilizing their sense of curiosity to gain new experiences in life. This curiosity that is built into us at birth is what drives us to be drawn to the unkown. Araby, by James Joyce and Going to the moon, by Nino Ricci are both short stories that show that the Human curiosity is indeed what makes humans drawn to the unknown. Both stories are about young boys and both have a female impact on them, both boys are drawn to new places unknown to them and in the end, both come out with†¦show more content†¦She was an unknown, an older female who has impact on him as a teacher. The little boys states, I felt the small bright hope that my life could differentÂ…by the love that I felt for our teacher Miss Johnson (p.212). As a poor Italian boy living in Canada, he felt that Mi ss Johnson, the older wiser female that he was attracted could make a difference for him, since she was an unknown he was trying to get closer to. Secondly, people are normally drawn to difference places that they wish to gain experiences or knowledge from. In both stories, the boys dream about going to particular places that they wouldnt normally go to. In Araby the little boy is drawn to a bazaar called Araby that he thought would be a great experience, because of the unknown factor. The boy imagined Araby as something grand, a completely new experience, The syllables Araby were called to me through the silence in which my soul luxuriated and cast an Eastern enchantment over me (p.289). This shows what the boy thought of the Bazaar, as an unknown thing to him. Similarly, in Going to the Moon, the little boy had immigrated from Italy and lives in Canada. He believes Windsor to be a, purgatory (p.210) because across the river was a teasing image of Detroit in the USA, which to him seemed to be much better than his current residence. Detroit was an unknown place to the boy, which is why he was so drawn to it. The boy thought of Detroit as a vague promise ofShow MoreRelatedAmerican Literature11652 Words   |  47 PagesThe fire eye in the clouds survives the gods. Human beings are often said to create their gods, beings frequently presumed by humans to be immortal, all-knowing, and all-powerful because they are presumed to have created things like the earth, the moon, the sun. Rather, this line of poetry emphasizes the mythical nature of gods and goddesses; their existence, so to speak, is tied to a culture, and once that culture has run its course, those gods can be said to have died. It is the sun, supposedly