...Hedvig Kjellström, Michael Minock and John Folkesson The purpose of Laboration 1 is to learn how to retrieve rmation stored in relational databases. You will learn 1) how to formulate SQL queries and understand how they apply to the schema and how they are executed; 2) how constraints effect insertions and deletions; 3) about the basics of view, transactions, indices and triggers. The recommended reading for Laboration 1 is that of Lectures 1-7 , particularly Chap 6-8. Laboration Come prepared to the review session! Only one try is allowed – if you fail, you are not allowed to try again until the next lab session. The review will take 10 minutes or less, so have all papers in order. To pass you should have Completed Task 1 with at least 9 of the 10 queries right, completed Task 2 and able to explain why certain actions give errors and other do not, also 8 of the 9 steps should be documented showing you executed them correctly, Task 3 the output file should show that the trigger works as it should. The grade is A if passed when the review when due. See the Lab Grading page in bilda contents for the due dates for the labs and the grading of late assignments. Laboration 1 is intended to take 30h to complete. Computing Environment In this assignment you will use Nestor 2.0. Nestor is KTH’s logic engine (computer) dedicated to hold the databases used in this and other similar courses. Nestor is aptly named after Nestor the Gerenian horseman from Homer’s Illiad. Nestor was, by the...
Words: 2303 - Pages: 10
...Applied Research Project Topic Selection: Review the list of possible topics and consider which you would like to research. Identify a company or which the topic would apply. You can use the Week 1 Q&A thread to pose any questions you may have about the research project. Post your chosen topic for my approval in the (required but ungraded) Discussion topic entitled "Applied Research Project" in Week2. You will be given feedback to make sure that you're on the right track for this assignment. If there are still questions regarding the project, the Q&A discussion in Week 3 will accommodate our continued discussion about the project. Applied Research Project Submission: Submit your assignment to the Week 6 Research Paper Dropbox located on the silver tab at the top of this page. (200 points) Dropbox | For instructions on how to use the Dropbox, please click here.See Syllabus/"Due Dates for Assignments & Exams" for due date information. | | | Topic Selection | | Week 1 Applied Research Paper Assignment: Topic Review Read the following description and possible topic choices. Week 2 Applied Research Paper Assignment: Topic Selection (ungraded but required) Choose your research project topic and prepare a brief description of your proposed topic. Post your proposed title and brief description in the Week 2 Applied Research Project discussion topic. Your description will be reviewed, and you will then receive feedback and approval of your topic choice...
Words: 2482 - Pages: 10
...system will be developed. In this stage, any development requirements will be completed. This may involve the development of a database system or modification of a commercial off the shelf system. During the integration phase, the physical installation of the system will occur. This is followed by testing. Once testing has been completed, the major project scope ends and the project enters into a maintenance phase. Major Tasks There will be five major tasks in this project, including: 1. Analysis and Design a. Design Documentation i. With this task, documentation is written up to describe the work that needs to be completed. This documentation is reviewed by all stake holders to ensure that the requirements are have been accurately conveyed and understood. b. Design Models i. With this task, flow charts and/or use case are created to describe the functionality. These documents are of particular importance to members of the project team, as they provide a model for the actual system 2. Development a. Database i. Depending on the results of the analysis and design task, either a custom or a commercial off the shelf system will be used. This system will require development or customizations to meet specific needs. b. Interface i. An interface is required to view access records. This is the front-end of the database. This is either included in a pre-packaged system or custom developed. 3. Integration a. Install radio-frequency card...
Words: 479 - Pages: 2
...course we begin to think about how what we have learned the previous week can apply to our personal and professional lives. We begin to think of ways we use these tools in our daily lives and how we can apply them in the future since we have learned about them. In week two of this class, we began to understand how databases are used in the world. The databases range on use and size but are used by millions without the realization of them. Many of us use them in our workplace and never gave a second thought to how life would be more difficult without them. The databases used in a work environment can hold the information inputted into them for a very long time. This allows us to go back and use the information with a stroke of the keys and click of the mouse. Without the databases that are utilized we would have to hope the hard copy of this information is filed correctly and easy to access. The databases can be used in our personal lives through organizing personal information. For example, keeping a record of one’s family genealogy could be contained in a database that many members of the family can access and add information to. A budget can be maintained in database to allow the information to be maintained and updated daily, allowing the family to stay on top of the finances without tons of paper work. We also examined how social networking can be relevant in the workplace. Each person has a different view of whether it is a positive or negative tool. It comes down to maintaining...
Words: 402 - Pages: 2
...Apple Operating System and Software Applications Lejon Starks, Ryan Sherrett, Melody Sheline, Phillip Mings, Mahsa Zeyghami | BIS 320 | | | | September 05, 2013 | | | Sherry Clarkson Apple Operating System and Software Applications Think of a specific organization (APPLE is our choice for this assignment) with which one of your group members is familiar and determine the main operating system, software applications used, and a one of a kind software application. Create a table like the example located on the student website for your specific organization. Introduction – (I will take this part) Operating System and Applications Describe how the operating system and applications help the company reach their objectives – Ryan please take this section – (At least 400 words) Functions of Computer Hardware Describe the functions of computer hardware components used in the organization. Provide at least one example of input hardware, output hardware, and storage hardware and describe how they are used in the organization. – Phillip take this section – (At least...
Words: 274 - Pages: 2
...The Advantages of a relational Model According to ACME Global’s website the mission of ACME Global is to “Help clients achieve profitable growth by aligning and improving customer facing processes and by continually seeking ways to improve operational performance"(“ACME Global,”2014) Because of your consultants over 100 clients maintain successful business with financially and operationally sound strategies. To continue this success and expand on that success a relational model would be easy to use. The revision of any information as tables consisting of rows and columns is much easier to understand. This would play a vital role in organization of not just your consultants but when you stop and look at your clients and the data you are responsible to managing along with the common data and information you want to know. An E-R Model provides Flexibility: Different tables from which information has to be linked and extracted can be easily manipulated by operators such as project and join to give information in the form in which it is desired. This would be most beneficial to you when you look at your areas of Strategic Development and Business planning, marketing & Sales Strategy and your Operations and Organization Management. In all of these are areas are key data and resources of ACME Global that would be enhanced by using a relational model. Purpose of an E-R Model Specific to ACME Global Consulting ACME Global along with your partner Deegit, Inc. deliver innovative...
Words: 672 - Pages: 3
...QUESTION YOUR ANSWER (MAX 300 WORDS TO ANSWER EACH QUESTION) MARKS 1. Describe how knowledge about online resources or database searching will help in your future studies and career? To begin with, online resources or data base searching has been a tremendous and effective contributing factor towards the fast and easy researching method my colleagues, myself and other learning colleagues are using widely in the twenty-first century. Fortunately, online resources have created essential communication skills between me and my colleagues, tutors and other acquaintances around the universe. This method has enabled me interact via online through discussing and exchanging learning information. However, the effect has not only made it easy for the general public and myself to access accurate and non-accurate information, but has also contributed in developing and improving social development/network. Most importantly, it has given me the privilege to search more than one database to enable obtaining a successful research project. Furthermore, the aspect of locating the right source is an enormous issue. Example is researching using Google and Google scholar. The difference is that, Google scholar is peer-reviewed but Google is not. Based on this evidence, not all information is academically evaluated or peer-reviewed before it is made public on the internet. Database searching enable me learn different techniques in acquiring successful research. Examples are: I get the privilege to...
Words: 353 - Pages: 2
...Software Requirements Specification October 28, 2013 Window App for Sending SMS to mobiles via internet from your computer Submitted by: Muhammad Gulfam Submitted to: Engr. Natasha Nigar Software Engineering Table of Contents Table of contents……………………………………………………………………. List of figures……………………………………………………………………….. 1. Introduction………………………………………………………………….3 1. Purpose……………………………………………………………...3 2. Scope of project……………………………………………………...3 3. Glossary……………………………………………………………...3 4. Overview of document……………………………………………….4 2. Overall Description……..…………………………………………………......5 2.1. System Environment...……………………………………………….5 2.2. Functional Requirement Specification ……………...……………….6 2.2.1. User use cases………………………………………………...6 2.3. User characteristics …………………………………………………….11 2.4. Non Functional Requirements ……………………………….…………11 3. Requirement Specification …………………………………………………..12 3.1 Functional Requirements ……………………………………………12 List of diagrams Fig.1 System Environment ………………………………………………………….3 1.0. Introduction 1.1. Purpose The purpose of this document is to present a detailed description of the Window App for Sending SMS to mobiles via internet from your computer. It will explain the purpose and features of the system, the interfaces of the system, what the system will do, the constraints under which it must...
Words: 2905 - Pages: 12
...IBM DB2 Express – C Introduction The intent of this paper is to describe the installation process of the Microsoft Windows version of the IBM DB2 Express-C database. This is a light-weight version of the more fully featured configuration of IBM’s best-selling DB2 database and includes core DB2 capabilities, free administration, development, autonomic, XML support and access to the online communities and forums. The version downloaded and running is configured for dual core processors and supports up to 2GB of system memory. Insights gained from working with the database after installed are also shared. Installation Process for DB2 Express-C Downloading and installing DB2 Express-C is easily accomplished over an Internet connection. The version installed is 389MB and took approximately 10 minutes to download over a cable modem running at fractional T1 speeds. Installation screens from the steps completed to get DB2 Express-C up and running are shown in the Appendix of this document. After installing the Control Center was invoked at the command line using the command db2cc which is specifically defined in the chapter assigned on DB2 Express-C. Using the command db2sampl -xml –sql to create the sample data worked, and there is the secondary option of using graphical interface commands to accomplish the same. The use of the DB2 Command Line tools show how quickly a multidimensional table can be viewed, edited and batch programming tasks completed using shell scripts...
Words: 728 - Pages: 3
...WORK EXPERIENCE Data Processing Company – Coventry DATA ENTRY CLERK June 2008 - Present Working as part of a team in a busy office environment processing, cleaning and then imputing data. Accurately entering the business names , addresses and financial details of on businesses and individuals. Duties: Ensuring report tables and listings accurately reflect data within a database. Entering data accurately onto computerised databases & Excel spreadsheets. Locate and correct data entry errors. Lifting of files and boxes containing paper records. Maintain logs of activities and completed work. Ensuring documents meet required quality standards. Compiling, coding, categorizing, calculating, tabulating and auditing data. Handling inbound telephone queries from colleagues / clients regarding data . Data manipulation in Excel spreadsheets. Occasionally carrying out various administration tasks like, photocopying, filing. Reviewing validation output and performing specified manual checks on the data to ensure consistency and completeness. KEY SKILLS AND COMPETENCIES Excellent knowledge of Excel & other specialist database tools & software. Computer literate with extensive IT knowledge. Experience of using a scanner and working with TIFF image files. Experience working with Sage systems. Enthusiastic, flexible and capable of working on own initiative. Comprehensive understanding of the Data Protection Act. An ability to work to deadlines whilst ensuring accuracy and efficiency. Capable of...
Words: 267 - Pages: 2
...1. RAS server provides the most secure method for remote access to the network if it is reburied. 2. Never allow client computers on the network to answer remote access connections. 3. Organize all remote access servers in a centrally controlled location. 4. Servers have no need to originate dial-out connections (Except when using telephone lines as low cost WAN connections, but these connections should be relatively permanent). 5. To simplify security administration, allow only one method of remote access into the network. 6. Remote access control procedures must provide adequate safeguards through robust identification, authentication and encryption techniques. 7. Carefully consider the wisdom of providing cellular telephones and modems for use with laptop computers. This technology isn’t usually justified considering the relatively modest increase in productivity compared to the cost and the security risk of a lost laptop. 8. Consider using only the NetBEUI protocol for remote access to limit the extent of intrusions on the network. 9. Control the distribution of remote access software on the network. Never allow client computers to run remote control software. If remote control software is necessary, run the software from centrally controlled computers or thin-client servers. 10. Disable dial-in networking, except in the cases of trusted individuals or to special computers,because dial-in networking can bypass regular network security. ...
Words: 609 - Pages: 3
...Computer Science department of Afe Babalola University Ado-Ekiti Ekiti state, intend to explore the discuss of Events Management and implement my foregained knowledge in my field of study, Computer Science, in the development of an application software which may be used in the planning and management of events. This application software would be able to ensure the supervision of planned out events be it of a corporate nature such as product launches, press conferences, corporate anniversary parties, meetings, conferences e.t.c. or private/ personal events such as birthdays, weddings, anniversaries e.t.c.. The software would provide an easy means for event managers to store information and data about proposed and organised events from a database, retrieve such data when necessary...
Words: 589 - Pages: 3
...Jackie Tau PT2520/Database March 23, 2013 Lab 1.2 –Define Major Topics for a Database Nouns | Major Topic | Hospitals | Conducting a double blind test of a new depression drug | Doctors | Need to be able to see their own patient’s information and be able to enter blood pressures, blood results, depressions indicators, notes, etc. | Patients | Should be able to see their own medical profile, doctor notes | Drugs | A new drug will be dispersed in generic bottles, given to half of the patients for depression & to test the side effects. | Lab1.3- Create a Statement of Work Grandfield College: There is a law that requires businesses’ including schools, track their software. It is important to know what software the school owns, the versions, & license agreement. They’re a several licensing schemes. The least restrictive is a site that allows am institution to have a copy of the software in any machine in the school property. It is also important for the school to know which software is installed on the machine, location & which users have access. The school just wants to track the faculty & staff computers & software. For students it will be separate & treated as a second project later. Lab 1.4 –Challenge Activity 1. Describe a situation in which the database might become inconsistent. * Transaction failure, database system failure, 2. How could a relational database ensure data consistency? * Data integrity 3. What...
Words: 262 - Pages: 2
...eLibrary Project Proposal Project Name: Online Library Management System - eLibrary. Project Members: This project is done in a group of two people. Project members are. 1. Atanu Maity 2. Problem Statement: Today most of the library is using either manual system for tracking the day to day activity or they are using desktop, stand-alone system to manage the day to day activity. In this proposed online eLibrary Management System it will run in internet or intranet and user can online check the book availability, they can search the books, library staff can issue, receive book, management can check the report from different location via internet. It can be used multi location also as it can be hosted in central location. Why eLibrary? The online eLibarary Management System is used to overcome the entire problem which they are facing currently, and making complete atomization of manual or semi automatic process of library management system. • Improve the search facility and members and library staff should get all the information in a second. • Should capable to use bar code reader for easy way to do book issue and receive process. • Library member should have limited and read-only access to the system via internet. • Library member should able to view member profile and transaction data pertinent only to them. • The supervisor should be able to enter or update master information like publisher’s details, authors and book details in one...
Words: 563 - Pages: 3
...Database Dictionary.com defines database as “a systematically arranged collection of computer data, structured so that it can be automatically retrieved or manipulated”. In today’s business, organizations run on data that have been processed into information and knowledge. That information is used by managers to apply to business problems and opportunities. Furthermore the data is transformed into knowledge and solutions in many different ways after detail analysis. Because data and information are processed in several stages and often in several places, they are frequently subject to problems and difficulties. Managing data in organizations is difficult for many reasons, so organizations in the effort to manage all of the data, developed databases to organize all of the collection. These databases are managed using database management systems, and by utilizing different applications. In our organization, we do have a database that we use for our data collection and analysis and storage of all the data we collect. We also use several applications in the daily operations of our business which I will explain further in this paper. Our organization is currently using several applications to make our processes more precise, effective and efficient. Currently, our organization is using a Sybase SQL database as the main database for all of our business functions. This database delivers extreme transaction processing and access to mission critical information...
Words: 732 - Pages: 3
