Thursday, May 14, 2020

Database Project on University Timetable - Free Essay Example

Sample details Pages: 6 Words: 1906 Downloads: 4 Date added: 2017/09/19 Category Education Essay Type Argumentative essay Tags: Knowledge Essay Did you like this example? Table of Contents 1. Introduction2 1. 1. Purpose2 1. 2. Scope2 1. 3. Technologies to be used2 1. 4. Overview2 2. Overall Description2 2. 1. Goals of proposed system2 2. 2. Background2 2. 3. Project Requirements2 2. 4. User Characteristics2 2. 5. Hardware Requirements2 2. 5. 1. Processor RAM Disk Space2 2. 6. Software Requirements2 2. 6. 1. Operating System2 2. 6. 2. Application(s)2 2. 6) Definitions of problems2 2. 7. Alternative Solutions2 3. Feasibility Study2 3. 1. Steps in feasibility analysis2 3. 2. Technical feasibility2 3. 2. 1. Front-end and back-end selection2 3. 2. 2. Front-end selection2 3. 3. Economical feasibility2 3. 4. Operational Feasibility2 3. 5. Schedule feasibility2 4. General Information2 4. 1. Entities2 4. 2. ERD Diagram2 4. 3. Data Dictionary and Normalization2 5. Testing2 6. Conclusion2 List of Tables Table 1: Entity course2 Table 2: Entity Lecturer2 Table 3: Entity Room2 Table 4: Entity subject2 Table 5: Entity subject_timetable2 1. Introduction Pu rpose The project aims to make an online university timetable which provides facilities to teachers and student to check out the classes that are going on presently. The purpose of creating a database is to keep track of class schedules and location. As current work is all paper based, an approach towards automation is being made to reduce human efforts by preventing them to look for a particular class in an index. The purpose of database on the whole is to: * Maintain daily time table such as information related to class schedule. * Provide information about teacher, room number and subject being taught Scope Interface and database on a back end that are being used can provide a greater scope and opportunities for students and teachers to look for their room number rather than contacting Admin Dept. to ask for the room number. Technologies to be used Initially, our intended goal was to create web-based application but due to lack of knowledge on working ASP. NET and other rel ated technologies, our application will be desktop based. This application will be designed on Visual Studio 2005. Following technologies are used in our project * MS Visio (For designing ERD diagram) * SQL Server 2005 (Database design and creation of database schema) * Visual Studio (for form design, interface and testing) Overview Main facilities that are associated with this project are:- †¢ Maintaining records of Classes, Room No, Computer lab, Teacher Information. †¢ Maintaining Notice Board for the students. Maintaining Every Section records. Overall Description Goals of proposed system * Planned approach towards working: It is necessary that the process, for its smooth on-going, should be well organized and structured. All the data will be stored properly in data stores, which will help in retrieval of information as well as its storage. * Accuracy: The level of accuracy in the proposed system will be higher. All operation would be done correctly and it ensures th at whatever information is coming from the center is accurate. * Reliability: The reliability of the proposed system will be high due to the above stated reasons. The reason for the increased reliability of the system is that now there would be proper storage and retrieval of information. * No Redundancy: In the proposed system, we can assure that no Information is repeated anywhere, in storage or otherwise. On the contrary, if a proposed system is paper based, there are high chances of redundant data. * Immediate retrieval of information: The main objective of proposed system is to provide for a quick and efficient retrieval of information. * Immediate storage of information: In manual system, there are many problems to store the huge amount of data and handling them. Easy to Operate: The system should be easy to operate and should be such that it can be developed within a short period of time and fit in the limited budget of the user. Background As students enter universit y, they look for their classes. They waste their precious time and knowledge while finding their classes. They have certain things in their mind such as â€Å"Where will be the class? †, â€Å"Is today’s class cancelled? †, â€Å"Is teacher available? â€Å", etc. For that concern, students have to rely on Academic controller to provide them with their desired information. Thus, Academic controller also gets busy in solving student queries rather than performing other important tasks. Project Requirements Following are the project requirements * The DBMS should be a generic software system, independent of any database instance. * The DBMS should have a user friendly and interactive interface. * The DBMS should have features for backup and recovery of data stored in the database. * The DBMS should provide for efficient retrieval of required data elements. * The DBMS should allow for constraints enforcement like data integrity, and referential integrity. The DBMS should allow for the definition of primary keys and indexing on the basis of keys. * The DBMS should allow for the definition of dependencies between tables. * The database tables must be modifiable with ease. * The DBMS must allow for selection of the specific database instance. * The DBMS must ensure that its operations are performed within reasonable limits of time and resources. User Characteristics Every user should be: * Comfortable of working with computer. * Able to understand the proposed system properly which means that interface to be designed with respect to human computer interaction. Having ‘read only’ access so that they can at least view the data. Hardware Requirements Processor RAM Disk Space * Pentium IV or higher * 512 MB RAM or higher * 40GB Hard Disk Software Requirements Operating System * Win-98, Win-XP, Win-2003, Linux(with GUIs) Application(s) * SQL Server * MS Visio * Visual Studio 2005 2. 6) Definitions of problems Problems with conventio nal system * Lack of immediate retrievals The information is very difficult to retrieve like, for example, to find out about the class room, students have to inquire Academic controller to know about their class room. Lack of immediate information storage The information that is being generated, such as any extra class, takes times and efforts to be stored at right place. * Lack of prompt updating Various changes to information like Classroom change, Teacher Availability, Class Schedules. Alternative Solutions This system provides online storage/ update and retrieval facility. This system promises very less or no paper work and also helps Student and Academic Controller staff. This system is fully automated so that information can be retrieved very easily without searching for data at various places. Feasibility Study Feasibility study is a test of system proposal according to its workability, impact of the organization, ability to meet needs and effective use of the resources. I t focuses on these major questions: * What resources are available for given system? * What are the likely impacts of the system on the organization? * Whether it is worth to solve the problem? Steps in feasibility analysis Steps that are involved in the feasibility analysis are: 1. Form a project team and appoint a project leader: A group of three people is formed out of which one is selected as project leader and other two as a team member. Team Leader * Rameez Xaveri Team Member(s) * Ali Asghar * Meysam Alizadeh 2. Assign each Group member a particular Task After forming a team, task was distributed among team members. Each individual is given some tasks that lead to the success of the project. Rameez Xaveri: He designed and implemented the front end for this project on MS Visual Studio 2005. Ali Asghar: He prepared the report for this project. Meysam Alizadeh: He designed the database on MS SQL Server 2005. 3. Prepare system flow charts All the system flow charts are designed on MS Visio which helped us in designing the database. 4. Determine and evaluate performance and cost effective of each proposed system 5. Weight system performance and cost data. Technical feasibility Front-end and back-end selection An important issue for the development of a project is the selection of suitable front-end and back-end. When we decided to develop the DBMS we went through an extensive study to determine the most suitable platform that suits the needs of the users. The aspects of our study included the following factors. Front-end selection 1. It must have a graphical user interface that every Non technical User can understand it easily. . Scalability and extensibility. 3. Flexibility. 4. Platform independent. 5. Easy to debug and maintain. According to the above stated features we selected Visual Studio 2005 as the front-end for developing our project. Economical feasibility Economical Feasibility means that how much it cost the organization for implementing the software. Does it fulfill the users’ needs, Does it beneficial to the university. The financial and the economic questions during the preliminary investigation are verified to estimate the following: †¢ The cost to conduct a full system. The cost of hardware and software for the class of application being considered. †¢ The benefits in the form of reduced cost. †¢ This feasibility checks whether the system can be developed with the available funds. The University Time Table Management System does not require enormous amount of money to be developed. Operational Feasibility The points to be considered are: †¢ What changes will be brought with the system? †¢ What new skills will be required? Do the existing staff members have these skills? If not, can they be trained in due course of time? The system is operationally feasible as it is very easy for the end users to operate it. It only needs basic information about Windows platform. Schedule feasibil ity Time evaluation is the most important consideration in the development of project. The time schedule required for the developed of this project is very important since more development time affects machine time and causes delay in the development of other systems. A reliable University Time table Management system can be developed in the considerable amount of time. General Information Entities 1. Tb_course 2. Tb_lecturer 3. Tb_room 4. Tb_subject 5. Tb_subject_timetable ERD Diagram Data Dictionary and Normalization Column Name| Column Type| Description| Course_id| Int (primary key)| ID associated with the course| Course_name| Varchar(30)| Name of the course| Table [ 1 ]: Entity course Column Name| Column Type| Description| Lecturer_ID| Int (primary key)| ID associated with the lecturer| Lecturer_name| Varchar(35)| Name of the lecturer| Table [ 2 ]: Entity Lecturer Column Name| Column Type| Description| Room_ID| Int (primary key)| ID associated with the room| Room_number| Int| In which room class is going on| Table [ 3 ]: Entity Room Column Name| Column Type| Description| Subject_id| Int (primary key)| ID associated with the course| Subject_name| Varchar(30)| Name of the course| C_id| Int(foreign key to tb_course. course_id)| Course id for building up relationship between two tables| Lecturer_id| Int(foreign key to tb_lecturer. lecturer_id)| Lecturer id for building up relationship between two tables| Table [ 4 ]: Entity subject Column Name| Column Type| Description| ID| Int (primary key)| ID associated with the course| Subject_ID| Int(foreign key to tb_subject. ubject_id)| Subject ID for building up relationship between two tables| Room_ID| Int(foreign key to tb_room. room_id)| Room ID for building up relationship between two tables| Course_Id| Int(foreign key to tb_course. course_id)| Course ID for building up relationship between two tables| hour| Int| For how long the class will be held| Time_start| Int| At what time the class will be started| Day s| Varchar(30)| On which day class will be held| Table [ 5 ]: Entity subject_timetable Testing University Timetable Data Base has been fully tested on the Windows XP / VISTA / 7 Operating System, installed on an INTEL-PC Compatible System. Performance restrictions and efficiency considerations of Timetable Data Base were affected by the performance of the Operating System on which it was deployed. Conclusion The Timetable Relational Database Management System is successfully designed, implemented, tested and deployed. It is able to efficiently store, retrieve data from database tables stored on disk files as and when requested. The University Timetable Data Base front – end Application is able to suitably format and display the retrieved database information to the user in a comprehensive manner. Don’t waste time! Our writers will create an original "Database Project on University Timetable" essay for you Create order

Wednesday, May 6, 2020

The Role Of The Teacher s Managing Behavior With...

Behaviour stems from children actions and decisions, adults use discipline to help children make appropriate decisions about their behaviour (Hayes, 2009). This assignment aims to focus on the role of the teacher in managing behaviour with reference too, teacher-pupil relationships and the way they impact both positively and negatively on individual children, learning through reinforcement/rewards and how they influence children to behave in a particular way, rules and structure in order for children to be more comfortable in their school environment. The teacher is the key person for managing behaviour, the steer report (2005, page 22) cited in (Adams, 2010) states that consistent experience of good teaching promotes good behaviour. However schools also need to have positive strategies for managing pupil behaviour that helps pupils understand their schools expectations. Learning through reinforcement is an effective method of managing behaviour, as everyone knows children love to be rewarded and praised ‘It is recommended that something positive is said to each child at least once a day and that the whole class is praised which is used to motivate the class towards achieving a specific behavioural goal’ (Grigg, 2010). If children show a favourable behaviour then they will be given something they desire (positive reinforcement) if children display unwanted behaviours then they will have something positive taken away from them (negative reinforcement), consequently allShow MoreRelatedQualities of an Effective Teacher2093 Words   |  8 PagesWhat it means to be an effective teacher Introduction An effective teacher is someone who increases the understanding of a pupil. Effective teaching is the ability of providing instructions to students of varying abilities while incorporating instructional objectives and assessing the effective education form of students. In the evaluation of performance, efficiency on the lesson plan and technique of delivery forms form part of the criteria taken into consideration. The teachers practices thatRead MoreStrategies for Promoting Positive Behaviour According with the Policies and Procedures of the Setting17778 Words   |  72 PagesCHILDEN AND YOUNG PEOPLE’S BEHAVIOR 1.1 SUMMARISE THE POLICIES AND PROCEDURES OF THE SETTING RELEVANT TO PROMOTING CHILDREN AND PEOPLE’S POSITIVE BEHAVIOUR When managing pupil’s behavior, all staff will need to be aware of school policies. The majority of children/young people do not present challenging behavior, and they attend a range of educational settings in environments which are conducive to learning appropriate behaviors. It is essential to ensure that behavior which does not meet school/setting’sRead MoreEssay about The Common Problem of Absenteeism in the Field of Education2505 Words   |  11 PagesThe Common Problem of Absenteeism in the Field of Education Absenteeism is a common problem encountered by teachers and others who work in the field of education. There are many reasons why some children fall into a pattern of repeated absence from school. In a number of cases, willful absence can be traced to an alienation from schooling due to poor achievement, family circumstances or behavioral causes. In some cases, parents or children simply defy the requirement to participate. This areaRead MoreField Study Episode 39378 Words   |  38 PagesEpisode 3 CLASSROOM MANAGEMENT AND LEARNING Name of FS Student: Shiena Mae T. Openia Course: BEED Year and Section: III Resource Teacher: Mrs. Perlita Celocia Cooperating School: Bato Primary School Your Target At the end of this activity, you will gain competence in managing time, space and resources to provide an environment which is appropriate to the learners and conducive to learning. Your Map To reach your target, do the following tasks: Your Tools 1Read MoreSchool Management12126 Words   |  49 Pages ANS 1 – Definition of School Management The term ‘management’ encompasses an array of different functions undertaken to accomplish a task successfully. In the simplest of terms, management is all about ‘getting things done’. However, it is the way and the process of how one achieves ones target or goals and it is in this respect that management is considered an art and a science as well.   Management comprises  planning,organizing,  staffing,  leading  or directing, and  controlling  an  organization  (aRead MoreGuidance and Counselling Thesis8290 Words   |  34 Pagesorientation to guidance dominated professional training and practice in our schools. The focus was on a position (counselor) and a process (counseling), not on a program (guidance). Administratively, guidance, with its position orientation, was included in pupil personnel services along with other such services as attendance, social work, psychological, psychiatric, speech and hearing, nursing, and medical (Eckerson Smith, 1966). The position orientation had its beginnings when guidance was first introducedRead MoreUnit 302 Schools and Organisations Essay examples4715 Words   |  19 PagesIn the UK all children aged between 3 and 4 years have the right to receive the minimum of 15 hours education which can be used between 3 and 5 days per week. There are many ways that this can be pro vided. * Nursery schools These are stand alone schools for children ages 3 to 4 years old. Some have their own head teacher and trained nursery staff, and may be state funded; however there are also privately run nursery schools. * Nursery classes These are attached to a primary school and usuallyRead MoreThe Learning Theories of Skineer, Brunner and Maslow.4710 Words   |  19 Pagesthe knowledge of how we learn, how are we to understand its importance for learners and their abilities to grasp the information being given? This definition of learning implies three objectives: 1. that learning must change the student in some way; 2. that this change comes about as a result of experience; 3. that this is a change in the student’s potential behaviour; Cohen et al. (2003:15) I intend to explore three theories of learning - the behaviourist approach of Frederic SkinnerRead MoreFactors Affecting the Low Performance in National Achievement Test of Grade 6 Pupils6433 Words   |  26 Pagesoutcome.   6.Auditors must be avoided as they can cheat you very easily if you are a duffer in maths.   7.All the constructions on earth require mathematics. Wherever you go, whatever you do, you are using math daily without even realizing it. Sure teachers, parents, and adults tell students this on a regular basis. But, what do they know? Have you honestly thought about how math is involved in your everyday? If you take twenty minutes to ponder the notion of math in your life, you might just startRead MoreThe Path Towards The Completion Of This Dissertation9598 Words   |  39 Pagesare truly a remarkable person, and I am so glad you are in my life. I would also like to thank Dr. Rebecca Wood, Dr. Keena Inman, and Dr. Tammy Stewart. Thank you for your encouragement and support. I also would like to thank the principals and teachers of Cumberland County who participated in this study for their openness and time. As I share my findings, I hope others see what an amazing group of educators Cumberland County truly has. A very special thank you to Marti. Without your help and

Tuesday, May 5, 2020

TPN Hypokalemia Essay Example For Students

TPN Hypokalemia Essay Alys Latimer, Layla Mohamed, and Sandra Zhengwhat IS tpn?Total Parenteral Nutrition (TPN):Infusion of intravenous nutrition (macro- and micro- nutrients)Those with contraindications to oral dietary approachSpecialized mixtures of amino acids, dextrose, lipid emulsions, electrolytes, vitamins and mineralsInfused centrally into internal jugular or subclavian veinsINDICATIONS: comatose, inadequate GI function, completebowel rest, and paediatric disordersADVERSE COMPLICATIONS: infections, post-op wound complications, immune compromise, fluid/electrolyte imbalance, GI bleeding, etc. (Arya et al., 2013)What is hypokalemia?Hypokalemia:Normal Findings: 3.5 5.0 mEq/LCritical Values: 2.5 mEq/LPotassium (K+), important part of protein synthesis and maintenance of normal oncotic pressure and cellular electrical neutrality(Pagana Pagana, 2013)Signs and Symptoms of HypokalemiaTypically not present until Potassium levels are less than 3.0 mEq/LSigns and symptoms of hypokalemia are typically related to cardiac, skeletal, and smooth muscle weaknessCARDIOVASCULAR: flattened T-wave and prominent U-wave, ST segment depression, conduction abnormalities, dysrhythmias, worsening hypertension, sudden deathKIDNEY: polyuria, hypokalemic nephropathy, increased risk of nephrolithiasis, and chloride-depletion metabolic alkalosisCNS/NEUROMUSCULOSKELETAL: fatigue, malaise, hyporeflexia, weakness, cramps, paralysis, myalgia, and rhabdomyolysisGI TRACT: Constipation, vomiting, prolonged gastric emptying, paralytic ileus, anorexia, worsening hepatic encephalopathyGU TRACT: hypotonic bladd erPULMONARY: respiratory acidosis, respiratory failure ENDOCRINE: insulin resistance and impairment in insulin release(Asmar et al., 2012; Elgart, 2004; Pagana Pagana, 2013)How to treat hypokalemia?Treatment Options:GOAL: identifying definitive cause of hypokalemia, prevent the development of life-threatening consequences, and correct any potassium deficit which avoiding hyperkalemiaMILD MODERATE HYPOKALEMIA (3.0 3.5 MEQ/L):Treat underlying disorder if possibleTreat with 60 80 mEq/d of KCl via PO in divided doses Reassess serum potassium concentration after replacement therapy and adjust accordinglySEVERE HYPOKALEMIA ( 3.0 MEQ/L):Preferred: 40 mEq/d of KCl via PO q3-4h TIDReassess serum potassium concentration after replacement therapy and adjust accordinglyIf necessary: 10 20 mEq/h of KCl via IV (in setting of cardiac arrhythmias, recent or ongoing cadiac ischemia, and digitalis toxicityContinuous cardiac monitoring is mandatory Reassess serum potassium concentration q2-4h (ensure that serum potassium concentration is 3.5 mEq/L)(Asmar et al., 2012)Thank you References:Asmar, A., Mohandas, R., Wingo, C.S. (2012). A physiologic-based approach to the treatment of apatient with hypokalemia. American Journal of Kidney Diseases: The Official Journal of the NationalKidney Foundation, 60(3), 492 497. doi: 10.1053/j.ajkd.2012.01.031Arya, I. N., Shah, B., Arya, S., Dronavalli, S., Karthikenyan, N. (2013). A review of literature on modernparenteral nutrition. International Journal of Medical Science and Public Health, 2(4), 801 806.doi: 10.5455/jimsph.2013.030920131Elgart, H. N. (2004). Assessment of fluids and electrolytes. AACN Clinical Issues, 15(4). 607-621.Retrieved from: https://learn.humber.ca/bbcswebdav/pid-4534008-dt-content-rid24071933_1/courses/1528.201750/Assessment%20of%20Fluids%20and.pdfPagana, K. D., Pagana, T. J. (2013). Mosbys Canadian manual of diagnostic and laboratory tests (FirstCanadian ed.). Toronto, ON: Elsevier Canada