Information Technology Exam Essay

2665 words - 11 pages

SMGT 335
Exam 2
Lorie LaPorta

How does a relational database organize data, and how does it differ from on object-orientated database? (10 points)

Relational databases are organized into two-dimensional tables called relations with rows and columns. Each business entity will have its own table. For instance, one table is used for suppliers, and another table used for customers. Object orientated databases are more versatile. Not only do they include images, drawing and photographs and other features, object-orientated databases are capable of retrieving graphics and multimedia applications, whereas relational databases strictly deal with rows and columns which is limiting.

Define ...view middle of the document...

Entity-relationship diagrams illustrate the connection or relationship in terms of one-to-one, one-to-many, or many-to-many relationships between entities. By using a connecting line followed by short marks and crows feet, a reader can see how many different relationships each entity has.

Normalization streamlines multiple relationship entities, or many-to-many relationship entities to eliminate duplicate data and better equip the system to maintain itself. It increases stability, flexibility and minimizes redundant data.

Define and object-orientated database and explain how it differs from a relational database.

Object-orientated database is as it says in that it contains objects, videos, multimedia formats, whereas relational databases strictly contain rows and columns. However, relational databases tend to be quicker to retrieve data. Object-orientated databases are becoming increasingly popular because with all the variations on multimedia, such as java applets on the Web, integrating pieces of data is easier. Hybrid systems are surfacing that are capable of both relational and object-orientated.
---------------------------
What are the principal tools and technologies for accessing information from databases to improve business performance and decision making? (12 points)

Databases provide information to executives and managers for them to make better decisions and run the business more efficiently. Separate functions for manufacturing, sales, accounting, special capabilities and tools are needed to analyze data and access information from multiple sources. Functions such as data warehousing, data mining and tools for accessing internal databases are such items.

Define a data warehouse and describe how it works.

A data warehouse is a database the holds current and historical data of potential interest to decision makers throughout a company. When it extracts historical and current data it with external data and reorganizes it into a central database that is used for management reporting and analysis.

Define business intelligence and explain how it is related to database technology.

Business intelligence is a series of analytical tools that work with data stored in databases to find patterns and insights for helping managers and employees make better decisions to improve organizational performance. Databases keep track of transactions; data warehouses find patterns and insights through OLAP, data mining, querying and reporting. Business intelligence allows managers and employees the ability to make decisions and respond to the data and patterns.

Describe the capabilities of online analytical processing (OLAP).

OLAP is similar to a rubix cube in that twisting and turning the data in multidimensional avenues will produce varying useful information. It enables users to view the same data in different ways using multiple dimensions. OLAP enables users to obtain online...

Other Papers Like Information Technology Exam

Effects of Study Habits in Licensure Examination

4971 words - 20 pages reveals auditing problems as having the relatively strongest effect in passing the board exam. Theory of accounts and auditing theory as second and third influential clusters; management services comes next followed by practical accounting problems 2, practical accounting problems 1 and lastly by business law and taxation in that order. This information would provide the student and the pre-review coordinator to assess the student’s readiness and

Mkt 571 Final Exam Latest Uop Final Exam Questions with Answers

1375 words - 6 pages , dependent, and perpetual • Comprehensive, systematic, independent, and periodic • Dependent, non-comprehensive, quarterly, and unannounced Final Exam Answers just a click away MKT 571 Final Exam Question Answer 8. ABC Technology is nearing completion on their product and market research has discovered a competitor is also close to launching a similar product. ABC has decided launch before their competition, this is called ________. • first

Mkt 571 Final Exam Latest Uop Complete Class Assignments

1440 words - 6 pages . The marketing manager needs to know the cost of the research project before approving it. During which stage of the marketing research process would such a consideration most likely take place? • Step 1 – defining the problem • Step 2 – developing the research plan • Step 4 – analyzing the information • Step 5 – drafting the report Want to see the complete Individual Assignment Check..?? Click MKT 571 Final Exam Questions and Answers

Qualifying Exam

3760 words - 16 pages EFFECTS OF TAKING QUALIFYING EXAMINATION TO THIRD YEAR ACCOUNTANCY STUDENTS CHAPTER 1 The Problem and Its Background Introduction Examination is one of the best ways to prove whether a student, or anyone who undergoes learning, learned something from what they have studied. Exam results can show in which lesson the students were not able to fully understand and what they were able to. But does this result help the student improve in

Lei Discussion 3

587 words - 3 pages responded that because the exam was done in the doctor’s office and not the hospital, her physician would be unable to gain access to the image or results of the exam. Unfortunately, she was not thrilled with my answer and refused the exam. This example is one reason why the patient’s information should be recorded electronically. Legislation passed during the Bush administration which requires an electronic health record (EHR) to be established

The Nursing Home Administrator

596 words - 3 pages technology, verbal and nonverbal forms of communication as essential components of being an effective leader. The common denominator of most responsibilities involve some form of communication. Communication can be through the sharing of information, often utilizing technology, verbal and nonverbal forms of communication as essential components of being an effective leader. References Purnell, L. D.T. (1999, Spring

Hello11111111111

918 words - 4 pages IPCC Examination after passing CPT and nine months of study. IPCC has two groups of seven subjects. Group – I consists of four subjects and Group – II of three subjects.Group I: Paper 1 : Accounting Paper 2 : Business Laws, Ethics and Communication Paper 3 : Cost Accounting and Financial Management Paper 4 : Taxation Group II: Paper 5 : Advanced Accounting Paper 6 : Auditing and Assurance Paper 7 : Information Technology and Strategic

Bus 515 Midterm Exam Assignment

951 words - 4 pages Multiple Choice Question 56 Supply chain management involves managing: • the flow of internal information only. • the flow of materials and information from suppliers and buyers to the final customer. • the flow of raw materials to inventory only. • managing the stock room supply only. Multiple Choice Question 14 A company with a low customer contact that is capital intensive is called: • a farm • manufacturing • quasi-manufacturing

Mkt 571 Week 1 Quiz Complete Assignment Help

969 words - 4 pages 1. What data analysis type is being used here? When Sam thought about opening a foreign car repair shop in Phoenix, he researched all of the firms in the area before deciding on a location. He also analyzed their capabilities and found articles about many of them in terms of their capabilities, strengths, and weaknesses. • Secondary data • Primary data • Licensed information • Tertiary information 2. Marketing is considered both

Mkt 571 Week 1 Quiz Complete Assignment Help

969 words - 4 pages 1. What data analysis type is being used here? When Sam thought about opening a foreign car repair shop in Phoenix, he researched all of the firms in the area before deciding on a location. He also analyzed their capabilities and found articles about many of them in terms of their capabilities, strengths, and weaknesses. • Secondary data • Primary data • Licensed information • Tertiary information 2. Marketing is considered both

Str 581 Capstone Final Examination Part One Latest Tutorials

1507 words - 7 pages interactions. What type of training method does Mary’s new employer use? • Simulation • Information presentation • On-the-job training • Organizational development Click here and download STR 581 Week 6 Strategic Plan and Presentation 23. Which of the following is one of Dr. Eli Goldratt's rules of production scheduling for optimized production technology? • Utilization and activation of a resource are not the same

Related Essays

Biology At Penn Foster Essay

705 words - 3 pages Overview of veterinary medicine and veterinary technology; roles of the various members of the veterinary health care team; professional ethics and legal aspects of veterinary practice; aspects of distance education in veterinary technology and strategies for success. SPECIAL REQUIREMENTS LS5493(1501) Grading Criteria Lesson exams (2) 100% You can submit exams online at the school’s website by selecting the “Take an Exam” option

Aapm Essay

1121 words - 5 pages compliance role of a payroll professional, including how payroll can expand its role in an organization Analyze payroll's relationship with the finance, human resources and information technology departments in an organization Participate in continuous improvement strategies through benchmarking and the application of best practices Identify the processes required for evaluating, implementing and maintaining new payroll systems Participate in the

Health Technician Essay

834 words - 4 pages national exam. An individual who is interested in technology, medicine, and management can pursue a challenging and rewarding career by earning a Master’s Degree in Health Information Management (HIM). Most master’s degree programs take two years to complete, with academics focusing on reviewing coding performance, policies to support revenue cycle, and accomplishing business objectives. Salary Range The average salary for a Health Information

Students Cheating On Exams, Essays, And Tests Reasons And Solutions

1020 words - 5 pages find ways to sneak in note-cards, write answers on their hands, peek at a textbook, or store information in electronic devices. Students usually do this to ensure that they don't forget any information while taking the test. The best way to prevent any of these actions from happening is for the teacher to walk around the room and make sure that there is no material present. Unfortunately, technology makes this difficult. If a student is taking a