Creating A Database For Student Information System Computer Science Essay

Creating A Database For savant development dodging Computer skill EssayA entropybase brings convenient to todays work argona such(prenominal) as macroscopic business clutches company. The main purpose of a infobase 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 pass on be complicated to control and form. This is why a database is introduced to keep these data organized to solelyow users to portal, retrieve, and use of the data without any hassle. DBMS or Database wariness administration is softwargon that apply 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 put off is constructed. In this assignment, a Student selective cultivation ashes is used as an case to keep educatee reading in a database.Moreover oracle, Microsoft SQL waiter and Microsoft entrance money are example software provided by database vendor that used to create a database. Other than Student Information System as stated preceding(prenominal), this software allows changes in database such as adding student entity birth to expand the database. Microsoft Access is used to create Student Information System Entity Relationship(ER) because it has easy interface likend to oracle and yet it is still a hefty legal instrument to create a simple database. qualify Question 11.0 What is Database and why is it undeniable?A database is a collection of several(a) types of sto ruby-red data so it gravel be used for operation purposes. These data faeces be organized in various modal such as hierarchical, nedeucerk and relative models depend which one is sui shelve for that particular operation.A database plays an beta role in numerous fields such as large companies, colleges as well as super markets we visit daily. around of databases are being used in large business company which they often enter their purchases, sales and keep intersect with employees t each(prenominal)ing. Database introduce, depot and emergence data to generate a variety of information for decision-making at the various levels in an boldness or business company. However large chassis of information cannot be handle by just human totally this is why a database is used to complete these tasks accurate, relevant and timely.There are many advantages when database is used becauseIt helps reduces data redundancy.Has high processing speed to draw off data in a very short time.It allows data sharing among different users.Maintain data independence to keep database safe still if one data is corrupted.Have meliorate 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 shadowy without an operating system. T his is why DBMS (Database Management System) is inevitable in couch 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 Oracle1.1.0 Database of a Student Information SystemThe idea of a database can be advantageously 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 think information such as their major power numbers, home addresses, gender and so on. The concept is started with evidence, which is a collection of related fields of an entity. all(prenominal) record consists of several data world power image firstly work drop dead phoneAgeGenderAddress ancestry ground floorS0001JuliaYasmin17F13 Hibiscus RoadBMAStudent Information System in a CollegeIndex NumberFirst breakLast NameAgeGenderAddress score arrange gestatement PaidS0001JuliaYasmin17F13 Hibiscus RoadBMAYesS0002NicholasWong18M24 Metro StreetITAYesS0003NikoBellic18M53 Hove BeachITBNoS0004DavidKim17M4 Lake GardenITBNoS0005Carl throneson18M77 Park LaneBMCNoS0006JohnKay17M22 Lin Seng ParkBMBYesS0007JasmineStewart17F16 Park LaneBMBYesS0008Tony spud19M55 Brooker RoadITCYesS0009TinaShaw18F31 Hibiscus RoadBMANoS0010DavidFord18M28 Lake GardenITCNoKey term BM = military control Management, IT = Information engineering scienceThe table in a higher place shows that all student information is save in detail of a college. Index Number is created to attain each student. All different single line of records are grouped together to form a 10 records table. The table is also cognize as file, which is a collection of related records and these data will be stored in colleges main database. indigenous KeyA base list 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 whitethorn need a primary key in a database, which is an important key name for searching a particular record in the file as well as distinguish each record uniquely within relative. primitive key can be consists of exponent number or name because they bring on 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 TablesSince the database is related to student information, this table may be divided up in several departments such as casher, lecturers, class and students overall trial run 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 cardinal-dim ensional 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 CasherColleges CasherIndex NumberCasherIndexFirst NameLast NameAgeGenderCourseFee PaidS0001C101JuliaYasmin17FBMYesS0002C102NicholasWong18MITYesS0003C103NikoBellic18MITNoS0004C104DavidKim17MITNoS0005C105CarlJohnson18MBMNoS0006C106JohnKay17MBMYesS0007C107JasmineStewart17FBMYesS0008C108TonyMurphy19MITYesS0009C109TinaShaw18FBMNoS0010C110DavidFord18MITNoPrimary Key Casher IndexThe 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 psychometric test 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 courseLecturers will hav e 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 spring it easy, this large table will be needed to break up into two related table, which are telephone line Management and Information engine room classes. This concept is called data normalization.Normalization makes data to a greater extent 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. blood Management Course (BM)Index Number psychometric test IDFirst NameLast NameAgeGenderCourseS0001E1001JuliaYasmin17FBMS0005E1005CarlJohnson18MBMS0006E1006JohnKay17MBMS0007E1007JasmineStewart17FBMS0009E1009TinaShaw18FBMPrimary Key Index NumberInformation applied science Course (IT)Index NumberExamination IDFirst NameLast NameAgeGenderCours eS0002E1002NicholasWong18MITS0003E1003NikoBellic18MITS0004E1004DavidKim17MITS0008E1008TonyMurphy19MITS0010E1010DavidFord18MITPrimary Key Index NumberThe tables show that two different tables, which are Business Management Course and Information Technology Course. Students and their course can be comfortably indentified after the table is isolated into two. We can clearly know that IT students are all male and two courses have equally five students each.1.2.3 Students Examination GradeIndex NumberExamination IDFirst NameLast NameCourseGradeS0001E1001JuliaYasminBMAS0002E1002NicholasWongITAS0003E1003NikoBellicITBS0004E1004DavidKimITBS0005E1005CarlJohnsonBMCS0006E1006JohnKayBMBS0007E1007JasmineStewartBMBS0008E1008TonyMurphyITCS0009E1009TinaShawBMAS0010E1010DavidFordITCPrimary Key Examination IDThe in a higher place table shows all students examination grade in the full(a) college and it is stored in Students examination database. This table is required for students certificate prin tout 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 in the buff user before data is record in Database Management software.Define Question 22.0.0 Student Information System Entity Relationship(ER) modelWe 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 golf-club to make these tables and their relationship more expeditious 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 Access2.1.1 Primary KeyBe fore tables can relate each other, a primary key is needed to declare in each table.The image to a higher place shows that primary key is declared in Students in Design beguile. A small key attribute (marked as small red circle) shows that Index Number has declared to primary key with primary key dickhead 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 ChartCreating 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 appearsTables must link decently in order to view their relationship. Primary Keys are colligate to another tables, for example if we compare Students table with Casher table, Casher Index will become primary key eon 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 CasherStudentsThe 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.CasherThe data in Casher table has created to record students fee paid. somewhat field such as Index Number and Course are shared together with Student table.Relationship between Students and CasherThe table above shows the relationship between Students and Casher. From the first record we can clearly read 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 ExaminationBusiness Management chassisInformation Technology ClassBusiness Management and Information Technology classes are separated into two different tables. These tables are also linked together with Students Examination Grade, which is to bring out 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 GradeThe table abo ve 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 solid manner and made user easily retrieve, access and view all students information in short time. remnant and RecommendationInformation 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 mod el. Learning Microsoft Access will be a good start for a beginner to learn and practice how database works tied(p) though it is not powerful enough compared to other database management software.Since directly 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.BibliographyOppel Andy, 2009, Database a Beginners Guide, Second Edition, McGraw-Hill Professional Publishing, ground forcesAnderson Virginia, 2001, How to do everything with Access 2002, McGraw-Hill Professional Publishing, USAMacMillan, Andy Huff, Brian, Transforming Info glut A Pragmatic system for Oracle Enterprise Content Management, 2008, McGraw-Hill Professional Publishing, USAP.Sellappan, 2002, Information Technology in Business, Fourth edition, Federal Publication Sdn Berhad, MalaysiaJames L. Johnson, 1997, Database Models, Languages, Design, , Oxford University Press Inc, USAShelly Vermaat, 2009, Discovering Computer 2009, Complete Edition, Shelly Cashman Series, United States of AmericaSQL 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.gifPrimary Definition, 2010, online, retrieved 12 October 2010, from http//databases.about.com/cs/administration/g/primarykey.htm