Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Modify the content of the table Below by updating customer with customerid = 103 with your name and show your output. 3) Delete customer named

Modify the content of the table Below by updating customer with customerid = 103 with your name and show your output. 3) Delete customer named "Doug Nickle"; and display all records 1) Based on the data in the table below, use Bash/SQL scripts to create a table called 'customer' and 

So, here's my question when you start writing a program in the app, for example, PUTTY app which I use to write it in bash script such as for this assignment... you start with 

 vi customer.sh 

it takes us to the new page where we have to write

 #!/bin/bash 

CREATE TABLE customer (

CustomerId INTEGER,

Name TEXT,

Address TEXT,

CreditCardNumber TEXT

);

insert the first five records into the customer table

INSERT INTO customer (CustomerId, Name, Address, CreditCardNumber)

VALUES

(101, 'Dennis Cook', '123 Main Street', '2736 2371 2344 0382'),

(102, 'Doug Nickle', '456 Second Ave', '7362 7486 5957 3638'),

(103, 'Randy Wolf', '789 Elm Street', '4253 4773 6252 4436'),

(104, 'Amy Stevens', '321 Yellow Brick Road', '9876 5432 1234 5678'),

(105, 'Robert Person', '654 Lois Lane', '1122 3344 5566 7788');

"SELECT * FROM customer LIMIT 5;"

EOF

well this is my code for this assignment then I do hitting ESC shift+: and type wq, and it takes me to the main page after that I wrote 

cat customer.sh

(it shows my whole script here)

then I wrote bash customer.sh 

it shows an error in my scripts I don't know to do it so can u help me with these problems?

1) Based on the data in the table below, use Bash/SQL scripts to create a table called 'customer' and populate/load the table with at least first five records. Customerld 101 102 103 104 105 106 107 Name Dennis Cook Doug Nickle Randy Wolf Amy Stevens Robert Person David Coggin Susan Klaton Address 123 Main Street 456 Second Ave 789 Elm Street 4253 4773 6252 4436 321 Yellow Brick Road 9876 5432 1234 5678 654 Lois Lane 1122 3344 5566 7788 987 Broadway 8473 9687 4847 3784 345 Easy Street 2435 4332 1567 3232 Credit CardNumber 2736 2371 2344 0382 7362 7486 5957 3638

Step by Step Solution

There are 3 Steps involved in it

Step: 1

It seems like you are trying to combine Bash scripting with SQL commands which is ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Concepts of Database Management

Authors: Philip J. Pratt, Mary Z. Last

8th edition

1285427106, 978-1285427102

More Books

Students also viewed these Databases questions

Question

1. The next area, Now we will turn to, or The second step is.

Answered: 1 week ago

Question

What is multiplicity?

Answered: 1 week ago

Question

What is meant by the sharing of data?

Answered: 1 week ago

Question

How do you sort data in an Access query?

Answered: 1 week ago