Discuss a significant disadvantage of using the open source technology to integrate data from a database into a Web application.

From your knowledge and experience, discuss two technologies that can be used to integrate data from a database into a Web application. One technology must be open source. The other technology must be proprietary.

In your own words:

  • Identify each technology as open source or proprietary.
  • Compare and contrast the ability of the two technologies to integrate data from a database into a Web application (note this does not mean cost or access to the code).
    • Discuss a significant advantage of using the open source technology to integrate data from a database into a Web application.
    • Discuss a significant advantage of using the proprietary technology to integrate data from a database into a Web application.
    • Discuss a significant disadvantage of using the open source technology to integrate data from a database into a Web application.
    • Discuss a significant disadvantage of using the proprietary technology to integrate data from a database into a Web application.
  • Student experience is very valuable and contributes substance to the discussion. Any personal experience included in the discussion should begin with âIn my five years of experience as â¦â or words to that effect. Do not attribute personal experience as source material because the reader cannot retrieve it.
  • Engage your classmates in further discussion by providing at least two substantive responses to postings made by classma
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

What is the output of the following print( nums[-4] ) if nums = “1234567”5467Error message is displayed.

See Description

  1. SDLC stands for:Software Development Life CycleSoftware Deployment Life CycleSoft Demands Long CollaborationSoftware Details Limitations and Contracts

1 points

QUESTION 2

  1. The last phase of the SDLCis the collection of feedback to begin the SDLC once more.is the collection of feedback for improvement on the next project.Is when the code is finally written and compiled into an application.is understanding the problem in detail.

1 points

QUESTION 3

  1. The first phase of the SDLCis the collection of feedback to begin the SDLC once more.is the collection of feedback for improvement on the next project.is when the code is finally written and compiled into an application.is understanding the problem in detail.

1 points

QUESTION 4

  1. A Use Case diagram:Is used to plan out the structure of objects in a system.is used to illustrate how your program will relate and support your organizationis used to illustrate the interactions between different objects.is used to determine how the program will be used.

1 points

QUESTION 5

  1. What is the output of the following print( nums[-4] ) if nums = “1234567”5467Error message is displayed.

1 points

QUESTION 6

  1. What is the output of the following print( 2: ) if nums = “1234567”56746734567

1 points

QUESTION 7

  1. Which function call would you use if you wanted to separate a string of text into a list of text values?divide()split()index()eval()

1 points

QUESTION 8

  1. What is the output of the following print( :-1 ) if nums = “1234567”123456712345623456734567

1 points

QUESTION 9

  1. What is the output of the following print( :-1 ) if nums = [1, 2, 3, 4, 5, 6, 7]1 2 31 2 3 4 5 62 3 4 5 6 7Nothing, cannot operate on lists.

1 points

QUESTION 10

  1. What is the output of the following print( to_upper(âhello there!â)).hello there!Hello there!Hello There!HELLO THERE!
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Create a new Microsoft Access database named Travel. Note that Microsoft Access does not support the use of SQL scripts to create databases. In Microsoft Word, type the SQL script that you would have used to create the database.

This assignment has two parts:

  1. Hands-on lab
  2. Course project

Part IâHands-on Lab

For the hands-on lab, you will submit a Microsoft Access database and a Microsoft Word document with SQL statements for the following:

  • Create a new Microsoft Access database named Travel. Note that Microsoft Access does not support the use of SQL scripts to create databases. In Microsoft Word, type the SQL script that you would have used to create the database.
  • Now, add a table named Car_Rental to the Travel database. Make sure that you include the Car_Rental_ID field whose datatype is AutoNumber. In Microsoft Word, type the SQL script that you would have used to create the table. Include the following fields:
    • Car_Rental_ID (AutoNumber, primary key, required)
    • Agency (Text(25), required)
    • Size (Text(25), required)
    • Make (Text(12), required)
    • Model (Text(25))
    • Daily_Cost (Currency)
  • Write INSERT statements for adding the following data to the new table:

Agency

Size

Make

Model

Daily_Cost

Avis

Mid

Ford

89.95

Avis

Full

Ford

Taurus

112.95

Hertz

Comp

Chev

Cavalier

69.95

Hertz

Mid

Chev

Malibu

84.99

Hertz

Full

Chev

Impala

114.99

National

Mid

Chrys

Stratus

77.95

National

Full

Chrys

Intrepid

109.95

  • Verify the values inserted by using a query.
  • Display each distinct agency (each agency only once).
  • Display the average cost of a Chrysler rental.
  • Display the total count of cars available.
  • Display the highest-priced vehicle.
  • Display each unique agency with the average car price for that agency.

Part IIâCourse Project

Course Project Part 4âCreating a Database

Continuing with the project you worked on for Weeks 1, 2 and 3, this week, complete the following tasks:

  • In Microsoft Access, create the database and tables that you identified in W3 Assignment 2. In Microsoft Word, write the SQL statements to create the database and tables.
  • Write SQL statements to populate the tables. Run the SQL statements in Microsoft Access for populating the tables.

Assignment Deliverable

After you complete the lab and course project, collate the information from both in a 3- to 4-page report in a Microsoft Word document. Include the SQL scripts in the Microsoft Word document. Include the Travel database as a separate attachment.

Submission Details

Name your document SU_ITS3102_W4_A2_LastName_FirstInitial.doc.

Name the Travel database SU_ITS3102_W4_A2_LastName_FirstInitial_Travel.accdb.

Assignment 2 Grading Criteria

Maximum Points

Created a database named Travel and added a table named Car_Rental. Also added a column named Car_Rental_ID to the Car_Rental table and set its field type to AutoNumber.

5

Completed the INSERT statements for adding the given data to the Car_Rental table and verified the values inserted.

5

Wrote accurate SQL statements to:

  • Display each distinct agency.
  • Display the average cost of a Chrysler rental.
  • Display the total count of cars available.
  • Display the highest-priced vehicle.
  • Display each unique agency with the average car price for that agency.
 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Identify an example of one table of data that the company might have and seven data fields that it might collect for that table.

When responding to your peers, comment on possible problems for a particular company or industry sector when data is not well managed.

Peer Response:

Describe why big data has become a hot topic in the business world

Well, I can say from experience as well as echo what the article stated which is that its critical today for companies to find ways to leverage big data to their benefit. The internet opened a world of possibilities and consumers are basically giving data away: where they like to shop, sites they frequent, television shows they like, etc. It would be stupid for a company not to use that information to their advantage to generate more revenue for their organizations. Furthermore, big data allows companies to cater selections perfectly for their customers, resulting in almost (and what you hope are) guaranteed sales. The goal is to make money â big data gives you an opportunity to not only widen your market, but also allow you to determine what direction to take your organization in the future in order to be successful. As the article says, the trick is to figure out how to organize and leverage that data. Additionally, I was reading an article a month or two ago in AdWeek, and the author (Julie Fleischer, Vice President of Product Marketing at Neustar) is famous in the industry for calling all data âcrapâ and I think she is totally right. Itâs useless unless you know how to consume it and quantify it. The key is not just data, its quality data.

The other thing about big data to me is, where does the line get drawn? Many might feel that keeping this kind of information is invasive, which it is in a sense. So how do we walk the line between jumping into a personâs home and procuring data? I always find myself conflicted by this question so Iâd be interested to know what you guys might think.

Pick a company and explain what it does.

Altice USA is an international telecommunications company. They provide any and all telecommunications related services in 5 countries, including phone service, internet, proprietary content and cable video services.

Identify an example of one table of data that the company might have and seven data fields that it might collect for that table. For example, every bank has a table that contains all customer personal information, including last name, first name, social security number, account number, street address, city, state, and ZIP code. (Note: Street address, city, state, and ZIP code are all different fields)

Altice USA would likely want the following fields for the cable video services department: box serial number, number of reboots, time spent on each channel or show, channel tuning, demographic information (this is a laundry list of data fields on its own, but we will keep in simple for the purpose of the assignment), income information, household tuning counts per network and that is just a few. I would imagine the amount of data fields would circle the earth twice! This makes me come back to my point earlier about it being critical to find ways to organize the data properly, as well as quantify how useful it is to the organization. While procuring the data is critical, for extremely large companies like Altice, its equally critical to know exactly how to use the data obtained to the companyâs benefit.

References: AdWeek, Issue Dated 4/24/2017, âHow To Tell if Your Data is Crapâ by Julie Fleischer

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"