The Difference Between Traditional File Systems Information Technology Essay

The Difference Between Traditional File carcasss larn Technology EssayWikipedia The tralatitious filing organisation is a manner of storing and arranging calculating machine acc single-valued intimacys and the breeding in the lodge. Basic exclusivelyy it organizes these shows into a selective t from each oneingbase for the storage, judicature, manipulation, and convalescence by the computers operating outline.For this method, a file name is assigned to a file in order to secure storage jam in the computer memory or info storage devices much(prenominal) as with child(p) disks or CD-ROMs be use of goods and servicesd to apply the physical location of the files. By this file name a file nooky be further entrance moneyed. Whether the file arranging has an underlying storage device or non, file governing bodys typic solely in ally down directories which associate file name with files, unremarkably by connecting the file name to an advocator in a file allo cation t equal to(p).A new invention for file commission is the concept of a infobase-based file remains.Files argon identified by their characteristics, like fictitious character of file, topic, author, etc( entropybase perplexity system) consists of packet that operates infobases, providing storage, get at, surety, backup and former(a) facilities. This system bottomland be categorised according to the teachingbase model and the type of computer that they support such as a server cluster or a mobile ph unitary, the interrogate language(s) that access the selective organic evolutionbase, such as SQL or XQuery, performance trade-offs, such as maximum scale or maximum speed or others. slightly database way system cover more than one entry in these categories, e.g., supporting triple dubiousness languages.Mean objet dart entropybase management systems ar usually accessed in a client-server manner, where the infobase client and the server atomic number 18 lo cated on divers(prenominal) machines (in a local argona net movement).Both systems deal with training management.File-based governanceFile-based systems were an early attempt to computerize the manual filing system. File-based system is a collection of performance programs that perform services for the end- drug users, such as updating, insertion, ablation adding new files to database etc. Each program defines and manages its data.When a computer user wants to stack away data electronically they must do so by placing data in files. Files are investment comp any(prenominal)d in specific locations on the hard disk (directories). The user female genitalia give new files to place data in, netcel a file that contains data, rename the file, etc which is known as file management a function provided by the Operating System (OS).Advantages of conventional file based systemDisadvantages of traditional file based systemNo collect of external storageProvides less(prenominal) ausp ices.No need of a highly technical person to handle the database.Redundancy is more. bear on speed is high as compared to database management systemLess integrity.High complexity in updating of database.Table 1.1.1Database Management SystemThe cleansement of the File-Based System (FBS) was the Database Management System (database management system) which came up in the 60s.The Database Management System withdraw the trouble of manually locating data, and having to go by means of it. The user could create a suitable twist for the data beforehand, to place the training in the database that the DBMS is managing. Hence, the physical organizing of files is done away with and provides the user with a crystalline view of the data input.A database is a collection of interrelated information caudexd in a database server these data depart be stored in the form of tables. The primary aim of database is to provide a way to store and retrieve database information fast and in an efficien t manner.AdvantagesControl of data circumlocutionAlthough the database progress does not remove redundancy completely, it restricts the union of redundancy in the database.Data consistencyBy removing or controlling redundancy, the database forward motion suppresss the stake of inconsistencies occurring. It ensures all copies of the idea are kept consistent.More information from the akin amount of dataWith the amalgamation of the operated data, it is executable to derive extra information for the same data.Sharing of dataDatabase be hankers to the whole arranging and fundament be shared by all reliable users.Improved data integrityDatabase integrity provides the validity and consistency of stored data. Integrity is usually show in terminals of constraints, which are consistency rules that the database is not permitted to violate.Improved securityProvides protection of data from unauthorized users. It forget require user names and passwords to identify user type and their access right in the mathematical process including retrieval, insertion, updating and deletion.Enforcement of standardsThe integration of the database enforces the necessary standards including data formats, naming conventions, documentation standards, modify procedures and access rules.Economy of scaleCost savings notify be obtained by combining all organizations operational data into one database with uses to hunt on one source of data.Balance of conflicting requirementsBy having a structural design in the database, the conflicts among users or divisions can be resolved. Decisions leave alone be based on the base use of resources for the organization as a whole rather than for an individual person.Improved data accessibility and responsivenessBy having integration in the database approach, data accessing can cross departmental boundaries. This feature provides more functionality and better services to the users. change magnitude productivityThe database approach prov ides all the low-level file-handling routines. The provision of these functions allow the software engineer to concentrate more on the specific functionality compulsory by the users. The fourth-generation milieu provided by the database can simplify the database application development.Improved principal(prenominal)tenanceProvides data independence. As a change of data building in the database will affect the application program, it simplifies database application aid.Increased concurrencyDatabase can manage coincidental data access tellingly. It ensures no interference between users that would not endpoint whatsoever loss of information or loss of integrity.Improved sustenance and reco truly servicesModern database management system provides facilities to minimize the amount of process that can be lost following a trial by using the transaction approach.DisadvantagesComplexityA difficult software. on the whole users must be familiar with its functionality and take fu ll advantage of it. therefore, cooking for the administrators, designers and users is needed.SizeUses a substantial amount of principal(prenominal) memory as well as large amount of disk space in order to make it run efficiently.Cost of DBMSA multi-user database management system may be genuinely expensive. Even after the installation, there is a high regular annual maintenance cost on the software.Cost of conversionWhen moving from a file-base system to a database system, the confederation is required to rich person additional expenses on hardware acquisition and information cost.PerformanceAs the database approach is to cater for many a(prenominal) applications rather than totally for a particular one, round applications may not run as fast as before.Higher impact of a trialIncreases the photograph of the system due to the centralization. As all users and applications reply on the database availability, the failure of any component can bring operations to a baulk and affect the services to the customer seriously.The difference between TFS and DBMSBalajee B. (2005), there are outlet of characteristics that differ from traditional file management system to database management system. In file system approach, each user go throughs the required files for a specific application to run. (Example in a gross sales department of an demeanprise, one user will be maintaining the details of the number of sales personnel office in that department and their grades. These details will be stored and kept up(p) in a let out file. other user will maintain the salary details of these sales personnel and the detailed salary spread over will be stored and lapse in a separate file. Although twain of the users need the data of the salespersons, they will be having their details in separate files and they need contrasting programs to operate their files.) When such data is isolated in separate files, it is difficult to access data that should be fu nctional for virtual(prenominal)ly(prenominal) users. This will lead to wastage of space and redundancy or replication of data, which may lead to confusion, as sharing of data among various users is not possible and data inconsistency may occur. These files will not be having any inter-relationship among the data stored in these files. Therefore in traditional file processing every user will be defining their own constraints and utilize the files according to their call for.In database approach, a single store of data is maintained that is defined once and then accessed by many users, as database belongs to the entire organization and can be shared by all authorized users. The essential characteristic of database approach is that the database system not only contains data notwithstanding it contains complete definition or description of the database structure and control. These definitions are stored in a system catalog, which contains the information around the structure and definitions of the database. The information stored in the catalog is called the metadata, it describes the primary database. Hence this approach will work on any type of database for example, insurance database, Airlines, banking database, Finance details, and Enterprise information database. only in traditional file processing system the application is developed for a specific purpose and they will access specific database only. only the processing speed in TFS is high compared to DBMS.The other main characteristic of the database is that it will allow multiple users to access the database at the same time and sharing of data is possible. The database must include concurrency control software to ensure that several users trying to update the same data at the same time, it should maintain in a controlled manner. In file system approach many programmers will be creating files over a long period and various files sacrifice disparate format, in various application languages, where duplication of data can occur.This redundancy in storing same data multiple times leads to higher costs and wastage of space. This may result in data inconsistency in the application this is because update is done to some of the files only and not all of the files. Moreover in database approach multiple views can be createdExternal view User/Application view,conceptual view Logical view,Internal view Details about the structure of data and physical storage of information.View is a tailored means of information contained in one or more tables. View is in like manner called as Virtual table because view does not contain physically stored destroys and will not occupy any space.A multi-user database whose users have form of applications must provide facilities for defining multiple views. In traditional file system, if any changes are made to the structure of the files it will affect all the programs. Therefore, changes to the structure of a file will require to change all progr ams that access the file and whereby data dependence will be lost. But in the case of database approach the structure of the database is stored separately in the system catalog from the access of the application programs. This property is known as program-data independence.Database can as well as be used for continuous storage for program objects and data structures that resulted in object oriented database approach. Traditional systems suffered from impedance mismatch task and difficulty in accessing the data, which is avoided in object oriented database system. Database can be used to represent complex relationships among data as well as to retrieve and update related data easily and efficiently. Hence DBMS does not automatically remove redundancies, but help to control redundancy.It is possible to define and enforce integrity constraints for the data stored in the database. The database similarly provides facilities for chance on hardware and software failures, as it has aut omatic and intelligent backup and recovery procedures. It reduces the application development time considerably when compared to the file system approach and availability of up-to-date information of all the users. It also provides security to the data stored in the database system and maintains integrity.A highly technical person will be required to handle the database, while for TFS, it is not so.File-based systems are very dependent upon the application programmer. Any required queries or reports have to be written by the application programmer. Normally, a fixed format query or report can only be entertained and no facility for ad-hoc queries if offered. DBMS has data independence. The way information is stored and the way information issued is independent of each other.File-based systems also give tremendous pressure on data processing staff, with users complaints on programs that are inadequate or incompetent in accumulateing their demands. Documentation may be limited and m aintenance of the system is difficult. Provision for security, integrity and recovery capability is very limited. Whereas, DBMS has control over security as it provides tools such as use of User Code, Password / Privileges and Roles to ensure security of data.Data, Field, Record, and File are the main components of Database milieu. Briefly explain those.DataWebopedia (Anon., n.d.), Distinct pieces of information usually formatted in a special way. All software is divided into two customary categories data and programs. Programs are collections of instructions for manipulating data. Data can exist in a variety of forms as numbers or text on pieces of paper, as bits and bytes stored in electronic memory, or as facts stored in a persons mind. Strictly speaking, data is the plural form of datum, a single piece of information. In practice, however, people use data as both the singular and plural form of the word. The term data is often used to distinguish double star machine-readable information from textual human-readable information. For example, some applications make a distinction between data files (files that contain binary data) and text files (files that contain ASCII data). In database management systems, data files are the files that store the database information, whereas other files, such as index files and data dictionaries, store administrative information, known as metadata.FieldWebopedia (Anon., n.d.), A space allocated for a particular item of information. A tax form, for example, contains a number of arenas one for your name, one for your Social Security number, one for your income, and so on. In database systems, sphere of influences are the smallest units of information you can access. In spreadsheets, fields are called cells. almost fields have certain attributes associated with them. For example, some fields are numeric whereas others are textual some are long, while others are short. In addition, every field has a name, called the field name.In database management systems, a field can be required, optional, or calculated. A required field is one in which you must enter data, while an optional field is one you may leave blank. A calculated field is one whose value is derived from some formula involving other fields. You do not enter data into a calculated field the system automatically determines the correct value.A collection of fields is called a record.RecordWebopedia (Anon., n.d.), In database management systems, a complete set of information. Records are composed of fields, each of which contains one item of information. A set of records constitutes a file. For example, a personnel file might contain records that have ternary fields a name field, an address field, and a phone number field. In relational database management systems, records are called tuples. Some programming languages allow you to define a special data structure called a record. Generally, a record is a combination of other data objects. For example, a record might contain three integers, a floating-point number, and a character string. In database management systems, a complete set of information. Records are composed of fields, each of which contains one item of information. A set of records constitutes a file. For example, a personnel file might contain records that have three fields a name field, an address field, and a phone number field.Figure 1.2.1 initiation Author Anon.,FileWebopedia (Anon., n.d.), A collection of data or information that has a name, called the filename. Almost all information stored in a computer must be in a file. There are many different types of files data files, text files, program files, directory files, and so on. Different types of files store different types of information. For example, program files store programs, whereas text files store text.What is the Importance of DBMS in a Defense Organization and in an information surgical incision? defence reaction OrganizationBenjamin (n.d. ), A Database Management System (DBMS) is a set of computer programs that controls the creation, maintenance, and the use of the database with computers of an organization and its end users. It allows organizations to place control of organization-wide database development in the hands of database administrators (DBAs) and other specialists.As organizations develop with time, their word sense to the latest technologies in the computer field becomes a necessity. A Defence organization is no different. In these turbulent times, when national security is more important, providing all Defence personnel with access to the latest applied science and discipline opportunities not only directly contributes to Defence capability but also improve the defence personnels career development.Hence the importance of a DBMS in such an organization like Defence is vital. Because Database administrators could use this system to configure and operate databases as the software provides high level, pri vileged database access. But the management should restrict use of this software to authorized personnel. One function of the database administrator is to create particular views of information stored in the database that are unparalleled for each type of user. For example, one officer will have a different view of information in the database than another, say Senior officer. The different user groups will also have different abilities to add, modify, or delete information. The database administrator is responsible for providing users with access to the appropriate level of information. The primary risk associated with database administration is that an administrator can alter sensitive data without those modifications existence detected.A secondary risk is that an administrator can change access rights to information stored within the database as well as their own access rights.Database security is the last line of defence. So it deserves great focus on the protection of private data from both internal and external.The sensitivity and compartmentalization of the information stored in the database form the basis for establishing controls. A database that stores confidential information may require a more significant control environment than a database that stores non-sensitive information. Management should consider the security and performance implications of the security options procurable with modern database management systems.Database security professionals and information security and risk management professionals could adopt a security strategy in DBMS to1) array database security policies with information security policies2) Ensure well-defined and formalized database security procedures3) Enforce role separation and4) Apply advanced security measures such as database auditing, monitoring, database encryption, data masking, and vulnerability assessment to all critical databases that store private data.The DBMS can provide long-term benefits for t he Defence organization reducing duplication of data and making it easier for HR to update personnel records. If not for DBMS, each time there was a personnel change, trainers would have to go through their entire content to make the necessary changes. Now, replacing Brigadier Xs picture in the content library with Commodore Ys picture can be automatically replicated through all relevant programs. Thereby reduce its expenditure on storage. But, initial training will be required for all programmers and users. Even though database systems are complex, difficult, and time-consuming to design, there is greater data integrity and independence from applications programs andEducation DepartmentSue Bushell (2004), To improve teaching and learning with the help of modern information and communication technology eLearning is honorable to education, corporations and to all types of learners. It is affordable, saves time, and produces measurable results.E-learning comprises all forms of elect ronically supported learning and teaching. The Information and communication systems, whether networked or not, serve as specific media to implement the learning process.E-learning services have evolved since computers were first used in education. There is a trend to move towards blended learning services, where computer-based activities are merged with practical or classroom-based situations.E-learning is essentially the computer and network-enabled transfer of skills and knowledge. E-learning applications and processes include Web-based learning, computer-based learning, virtual classroom opportunities and digital collaboration. Content is delivered via the Internet, intranet/extranet, audio or pic tape, beam TV, and CD-ROM. It can be self-paced or instructor-led and includes media in the form of text, image, animation, streaming video and audioThe definition of e-learning varies depending on the organization and how it is used but fundamentally it involves electronic means of communication, education, and training.Regardless of the definition you chose to use, designers, developers, and implementers make or crumble the instructional courses and tools. E-learning is simply a medium for delivering learning and like any other medium, it has its advantages and disadvantages. E-learning covers a wide array of activities from supported learning, to blended or hybrid learning (the combination of traditional and e-learning practices), to learning that occurs 100% online.As per wikipedia.org, the worldwide e-learning industry is estimated to be worth over $48 zillion US according to conservative estimates. Developments in internet and multimedia technologies are the basic enabler of e-learning, with consulting, content, technologies, services and support being identified as the quintuplet key sectors of the e-learning industry.E-learning is naturally suited to distance learning and flexible learning, but can also be used in conjunction with personal teaching , in which case the term Blended learning is commonly used. E-Learning lead up Bernard Luskin argues that the E must be understood to have broad convey if e-learning is to be effective. Luskin says that the e should be interpreted to mean exciting, energetic, enthusiastic, emotional, extended, excellent, and educational in addition to electronic that is a traditional national interpretation. This broader interpretation allows for twenty-first century applications and brings learning and media psychology into the equation.E-Learning can also refer to educational web sites such as those offering learning scenarios, worksheets and interactive exercises for children. The term is also used extensively in the business sector where it primarily refers to cost-effective online trainingThere are many advantages to online and computer-based learning when compared to traditional face-to-face courses and lectures. There are a few disadvantages as well.Advantages of eLearning(Anon., n.d) E-le arning is beneficial to education, corporations and to all types of learners. It is affordable, saves time, and produces measurable results.Cost effectiveE-learning is more cost effective than traditional learning because less time and money is spent traveling. Since e-learning can be done in any geographic location and there are no travel expenses, this type of learning is much less costly than doing learning at a traditional institute. tractablenessFlexibility is a major benefit of e-learning. E-learning has the advantage of taking class anytime anywhere. Education is available when and where it is needed. E-learning can be done at the office, at home, on the road, 24 hours a day, and seven days a week.Learnerslike e-learning because it accommodates different types of learning styles.They have the advantage of learning at their own pace. Students can also learn through a variety of activities that apply to many different learning styles. Learners can fit e-learning into their busy schedule. If they hold a job, they can participate in eLearning right at their desk. If the learner needs to do the learning at night, then this option is available while in their pajamas and do the learning if they desire.Personalized learningE-learning encourages students to peruse through information by using hyperlinks and sites on the worldwide Web.Learners are able to find information relevant to their personal situations and interest. E-learning allows selection oflearning materials that pair their level of knowledge, interest and what they need to know to perform more in effect in an activity.E-learning is more focused on the learner and it is more arouse for the learner because it is information that they want to learn. E-learning is flexible and can be customized to meet the individual needs of the learners.Develops knowledgeE-learning helps develop knowledge of the Internet. This knowledge will help learners throughout their careers. E-learning encourages students to t ake personal responsibility for their own learning. When learners succeed, it builds self-knowledge and potencyDisadvantages of eLearningAccessOne disadvantage of eLearning is that learners need to have access to a computer as well as the Internet. They also need to have computer skills with programs such as word processing, Internet browsers, and e-mail. Without these skills and software it is not possible for thelearner to succeed in eLearning.E-learners need to be very comfortable using a computer. Slow Internet connections or aged computers may make accessing course materials difficult. This may cause the learners to get foiled and give up.Software and filesAnother disadvantage of e-learning is managing computer files, software comfortability and learning new software, including e-learning. For learners with beginner-level computer skills it can sometimes seem complex to keep their computer files organized.The lesson points you to download a file which the learner does and late r cannot find the file. The file is downloaded to the brochure the computer automatically opens to rather than a folderchosen by the learner. This file may be lost or misplaced to the learner without good computer organizational skills.High wantE-learning also requires time to complete especially those with assignments and interactive collaborations. This means that students have to be highly motivated and responsible because all the work they do is on their own. Learners with low motivation or bad study habits may not complete modules and may fall behindIsolationAnother disadvantage of e-learning is that students may feel isolated and unsupported while learning. book of instructions are not always available to help the learner so learners need to have discipline to work independently without assistance. E-learners may also become bored with no interaction with instructors or classmates.Without the routine structures of a traditional class, students may get lost or confused about course activities and deadlines. Instructor may not always be available when students are studying or need helpConclusion nowadays many technologies can be, and are, used in e-learning, from blogs to collaborative software, E-Portfolios, and virtual classrooms. Most e-learning situations use combinations of these techniques.Even though the hardware and software start-up are costly, the advantages are reduced data redundancy, reducing updating errors and increased consistency, greater data integrity and independence from applications programs, improved data access to users through use of host and query languages, improved data security and availability of facilitated development of new application programs and ability for intensive research are the benefits of DBMS. labour 2Draw an Entity Relationship Data Model which describes the content and structure of the data held by the Medi Check hospital.Produce the resulting tables of above Medi Check Hospital and clearly indicating the p rimary and foreign keys.Data TablesDoctorDoctorID (primary)LnameFnameAddress echoPagerSpecialtyLocationAvailabilityPatientPatientNo (primary)PatientFirstNamePatientLastNamePatientAddressPatientTelNoPatientDobPatientMaritalStatusPatient learnRegisteredAppointmentAppointmentNo (primary)PatientNameDate/TimePatientTelNoSymptomSymptomCode (primary),SymptomNameDescriptionTreatmentTreatmentTitle (primary)TreatmentTypeDurationStatusTreatmentCost medicinemedicamentNo (primary)MedicationTypeSideEffectDosageFrequencySeverityMedicationBrandNameMedicationManufactureNameMedicationManufactureAddressMedicationManufactureTelNormalize these tables to ensure that are all in BCNF. Show the steps you have taken in normalizing the tables.UNFMedication (DoctorID, Lname, Fname, Address, Phone, Pager, Specialty, Location,Availability, PatientNo, PatientFirstName, PatientLastName,PatientAddress, PatientTelNo, PatientDob, PatientMaritalStatus,PatientDateRegistered, AppoinmentNo, PatientName, Date/Time,Patient TelNo, SymptomCode, SymptomName, Description,TreatmentTitle, TreatmentTy