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

  Sketch object-oriented model for private airport database

Sketch an object-oriented model for a small private airport database that is used to keep track of airplanes, their owners, airport employees, and pilots.

  Database implementation in mysql

After receiving 21 different setups, the management of Oak Creek Stadium has decided on the attached ER diagram and instance tables for the development of a database to keep track of its operations.

  Create a few queries that allow you to practice concepts

Create a few queries that allow you to practice concepts from the Lab. Please, don't simply post queries from this week's lab assignment! Post a screenshot of the query design and the results set in a Word document.

  Decompose relation into relations which are in bcnf

it is not essential to give violations which have more than one attribute on right side. Decompose the relation, as essential, into collection of relations which are in BCNF.

  High-level conceptual view of a data warehouse

Design a high-level conceptual view of a data warehouse (DW) for Huffman Trucking using Microsoft Visio that shows the Integration layers.

  What is data mining

What is data mining. What specific data elements are stored on your card subject to monitoring by the chain. Does this concern you from a privacy perspective

  Write sql statements to create the corresponding relations

Write SQL statements to create the corresponding relations to the ER diagram you designed for Exercise 2.8. If your translation cannot capture any constraints in the ER diagram, explain why.

  Create a plan of the necessary activities to databasse

Create a plan of the necessary activities that would be required to implement a valid database design process

  Logical entity relationship diagram

How can turn a conceptual entity relationship diagram into a logical entity relationship diagram

  How much does the system cost

How much does the system cost? Is there a base price for the server and then additional costs for clients? Consider the pricing model for the school district listed in the Final Project Document.

  Create a database design in visio the college has provided

After reviewing your database design from Lab 1: Creating a Database Design in Visio, the college has provided more information for the database that they want developed.

  Design tables in 3nf various codes for at least three fields

Create tables in 3NF. As you create the database, include different codes for at least three of the fields. Use sample data to populate fields for at least three records in each table.

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