Show some simple proof of concept types of activities

Assignment Help Database Management System
Reference no: EM131395714

Accessing External Sources

Your first task at Big Data Datacenter is to show some simple proof of concept types of activities. You will need Perl for the proof of concept activities, so you should download it if it is not already installed on your system. It can be downloaded here.

Management is eager to see how Perl can connect and interact with databases and common gateway interface (CGI) applications.

For the database connection, you will need to download and install the database interface driver (DBI) and show the following using the Big_Data_Servers_Table.xlsx as your guide:

• A connection to a database
• A query from the database that returns all of the servers that have status of production
• An insert into the database that adds a new server to the table with ("PERLBD4",128.33.23.198, "Development")
• An update to the database that changes PERLDB2 from development status to production status
• A delete on the database that removes the record information for PERLDB1 because it is no longer in service

For the CGI test, you should connect to the same data source and return the following:

• The number of rows in the Big_Data_Servers_Table.xlsx
• A query that shows all of the production servers

Use the attached spreadsheet as your guide. Your database and CGI tasks should reflect the actions against the spreadsheet as if it were a table in a database.

You can optionally download and install a small database and load it with the data from the spreadsheet. A simple, lightweight database will do, such as one of the following:

• Option 1- https://www.oracle.com/technetwork/database/database-technologies/express-edition/downloads/index.html
• Option 2- https://dev.mysql.com/downloads/

Complete the following:

• Provide a 2-paragraph summary on how you might use DBI and CGI to manage and report on information in a database.

• Share the syntax that is required to perform the DBI and CGI tasks. Simply cut and paste the Perl commands that you are using into a Word document.

Reference no: EM131395714

Questions Cloud

Devise a game plan for antonio : In 300 words discuss how Antonio's "looking glass self" has been influenced by the agents of socialization. Be sure to explain how this looking glass self is related to his "answerability" and what role that has in his desire to change his behavio..
Expansion into southeastern states : Delish Foods, Inc., a regional snack foods company (corn chips, potato chips, etc.) in the northeast, is considering two alternative proposals for expansion into southeastern states.
Criticize the given definitions : Criticize the following definitions in light of the eight rules for lexical definitions:- A cynic is a person who knows the price of everything and the value of nothing.
Trade must be restricted in order to save domestic jobs : Opponents of free trade often argue that trade must be restricted in order to save domestic jobs. As a free-trader, how would you counter this argument?
Show some simple proof of concept types of activities : Your first task at Big Data Datacenter is to show some simple proof of concept types of activities. You will need Perl for the proof of concept activities, so you should download it if it is not already installed on your system.
Monopolized instead of being competitive : What difference does it make it society if the market is monopolized instead of being competitive? With reference to the models of perfect competition and pure monopoly compare and contrast the market and firm level outcomes regarding price,quanti..
Write a function that takes a vector argument : Write a function that takes a vector argument and returns a vector containing the number of characters in each string. Also find the longest and the shortest string and the lexicographically first and last string. How many separate functions would..
Criticize the definitions - semantics : Criticize the following definitions in light of the eight rules for lexical definitions:- "Semantics" is when somebody studies words.
Explain the key reasons : Explain the key reasons why you classified the company as a monopoly, and state how the company operates relative to at least two (2) characteristics of that particular market.

Reviews

Write a Review

Database Management System Questions & Answers

  Populate vehicles and customers table with at least ten rows

You can create your database on Nova or any other Oracle system you wish, but you must use the Oracle RDBMS. Populate the VEHICLES and CUSTOMERS tables with at least ten rows each. Populate your SALES table with at lease ten rows.

  Data mining

DATA MINING-Business and Management Scenario assignment-Data Warehouse Reports. This is Part Three of the three-part assignment. For this week, you will complete the following: Resource: Business and Management Scenario assignment, Document data ware..

  Reflect upon the desirable characteristics of a primary key

Reflect upon the desirable characteristics of a primary key (below) that were presented in this week's lecture. (150-300 words) Choose one characteristic and discuss why you believe it would be undesirable if this were not a characteristic of a pr..

  Implement a basic initial ner classifier

COMP9318 (16S2) PROJECT - you will use scikit-learn and python 3 to engineer an effective clas- sifier for an important Information Extraction task called Named Entity Recognition and

  Describe the six default referential integrity actions.

How are N:M relationships implemented?

  Location information for dui checkpoints

let's consider location information for DUI checkpoints. If law enforcement agencies publish this information, is it okay to have law an app for drivers

  Describe a dbms and its functions

Describe a DBMS and its functions. List, at minimum, three of the popular DBMS products and give a brief description of each.Explain what mobile devices are and why mobile systems are important. Give examples of mobile devices, and, if applicable, n..

  Do that most companies need this type of implementation

Do you think that most companies would need this type of implementation? Why?

  Specify your physical design by identifying the attributes

List the names, ages, and salaries of managers of a user-speci?ed sex (male or female) working in a given department. You can assume that, while there are many departments, each department contains very few project managers.

  Build an entity relationship model for the above scenario

Draw a DFD (Context and Level 1) for placing an order based on the E-R diagram shown here.

  Compose conceptual data modeling techniques

Prepare database design documents using the data definition, data manipulation, and data control language components of the SQL language.

  How database processing differs from file processing

Over time computers have evolved from room-sized machines to hand-held devices. What has been the impact of this evolution?

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd