Explore BrainMass

Management Information Systems

SQL Management Studio Database

Use SQL Management Studio to create a database called ITCO630_P1.MDF. Be sure to store the database in a location that you will remember. Add the tables and data shown in the attachment to the database. Use the appropriate field types and lengths for the tables. Create the following queries and save them all in a file called

Information Systems- SQL Servers

Using the Online Library, the Internet, and all course materials, locate information about the differences between SQL Server 2005 and SQL Server 2008. Try to complete the following: *What are some of the improvements made between these two versions? *Why are these changes important?

SDLC Waterfall Approach

Why is an accurate and complete requirements definition especially critical when using the SDLC "waterfall" approach? (Answer provided in approximately 100 words.)

Data Warehousing vs. Data Mining

Explain both data warehousing and data mining. How are they related? List at least two techniques (decision technologies) that are used in data mining.

Discussing Current and Emerging Technology

Develop and submit an Organizational Technology Plan paper. Provide a summary statement of key topics of the paper. Provide a summary of key points and examples, including the following: - Business description, objectives, and technological environment - Personal and organizational responsibilities for moral and ethical use

Preferred Operating Systems

Some people believe that the only reason that the Microsoft Windows operating system is so widely used is that it comes pre-installed on most systems. In other words, if users had a real choice, many would not choose to use Microsoft Windows. Do you agree or disagree with this sentiment? In your response to Software include your

IT Industry Infrastructure

Look at Figures 7.3, 7.4, 7.5 and 7.6 (attached). The use of these infrastructures and their advantages/limitations are important to understand and discuss. Why doesn't the IT industry standardize and use just 1 infrastructure? Please be thorough and use at least 200 words.

Subquery vs. Join.

Please help me with this question: Which is better to use, a subquery or a JOIN? Why? Show an example of each to support your reasoning. Communicate with a relational database to create tables, and query and manipulate data. Use normalizing and data integrity methodologies when designing a database. Create and manage databa

SQL Joins and Typical Query Usage.

Create the following queries on the ITCO630_A database used in unit 3 and save them all in a file called ITCO630_P5.SQL. Please note that you can execute individual queries in a query file by highlighting the lines that you want to execute before running the script. Remember to define what database to use with a USE statement.

The relationship between management of information systems and IT

Information systems are typically thought of as being the responsibility, and even property, of the department that manages an organization's information technology, often called IT. However, other functional areas are usually major users of this information; and as such, they would like a say in how it is managed as well. Expre

How Changing Technology is Shaping Business

Just like many other areas of business, organizational change has been impacted by technology. 1. How has the need for organizational change consulting been impacted by technology? 2. How has the process of organizational change been impacted by technology? 3. Do you see these changes as positive or negative? Explai

Improving Table Designs Using Normalization.

Consider a typical sales invoice that would include the following information. Design a single table to hold all of the information required to store an invoice including this information. Next, apply normalization to reduce this table to third normal form. Prepare a Word document showing the original and final tables. Include a

Planning or Using a New System

Have you been involved in either planning or using a new system? Discuss your experience. Was a SDLC (systems development life cycle) process used? Please answer as if you are an accountant. Use at least 200 words. Thanks.

Using SQL Management Studio to Create a Database.

Please refer to the attached document for data. Use SQL Management Studio to create a database called ITD640_P1.MDF. Add the tables and data shown below to the database. Use the appropriate field types and lengths for the tables. Create the following queries and save them all in a file called ITCO630_P1.SQL. Please note th

U.S. Patent Office

The U.S. Patent Office is granting patents on computer processes such as Amazon's "one-click ordering." Should patents be granted on such computer-supported business processes? Why or why not?

Stored Procedures.

Stored procedures in SQL 2008 can be written in a variety of languages. In 2-3 paragraphs, complete the following: - Why is this important in the development of database systems? - Provide an example of a stored procedure that a database designer might write to demonstrate why this capability is important.

Database System Requirements.

Database System Requirements (Group Work): Create a database and name it ITCO630_GPx where "x" is your group letter. Populate your database with appropriate test data. Include all of the scripts in a single file called ITCO630_GPx.SQL where x is your group letter. Create at least three related tables in the database. Creat

Role of a Chief Security Officer.

What is the role of a chief security officer, and why is this organizational role a relatively new one? 150 words minimum and please list all sources used.


Discuss how a software framework facilitates reuse and explain the benefits and drawbacks of frameworks compared to component-based reuse.

IS Operational Plans

Why might companies today develop IS operational plans that cover only one year?

Mobile Computing and Social Networks

There are thousands of iPhone Apps, iPad Apps, and Android Apps that have been developed to perform a myriad of tasks and processes. Initially, most of these applications were games intended to be played on mobile devices. The popularity of these applications led businesses to ponder whether some of their business process applic

IT Competitive Difference

How companies (i.e. CISCO or CVS) justified the technology investment to the shareholders and board before the project? Give examples of what you think they should have used.