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

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

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