Question: Q4. Insert any three values in the ORDERG58 table. (1 Mark) Q5. Answer the following queries: (i) Alter column name 'address' to be 'city' on

Q4. Insert any three values in the ORDERG58 table. (1 Mark) Q5. Answer the following queries: (i) Alter column name 'address' to be 'city' on the table CUSTOMERG58. (1 Mark) (ii) Select all the columns form CUSTOMERG58. (1 Mark) (iii) Select all the columns from ORDERG58. (1 Mark) (iv) Update the Address for only one customer from your choice. (1 Mark) (v) Select all the Customers whose salary is greater than 5000 and age is lower than 28 from CUSTOMERG58 table. (1 Mark) (vi) Delete any customer from CUSTOMERG58 table, and explain why if it is deleted or not. (1 Mark)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Please answer all questions File Home Q1) Open a blank database called YouriD.accdb (e.g. 52315456.accdb). Q2) Import the Excel File (Dataset_vx.xlsx) into Access (the database you already created)....

I. Table Creation: (8 Marks) 1. Create a new Database and save it as "FE_studentID" e.g. (FE_22j12345) (1 Mark) 2. Create the following tables using design view and find appropriate primary keys. (5...

MYSQL Exercises 1. Write a script that adds an index to the AP database for the zip code field in the Vendors table Write a script that contains the CREATE TABLE statements needed to imple- ment the...

Answer asap please! 1.00 Point: XL Step 10.2.5: Use Flash Fill File Review SIMS Share B Home Insert Page Layout Formulas Data 2 Show Queries Connections s From Table Properties New Refresh Query Do...

Q1. Create the table CUSTOMERE47 with the following attributes and constraints. (1 Mark) Q3. Insert any four values in the table CUSTOMERE47. The fifth value will be your data as shown in the last...

Bus299 Assignment: West Coast Sales (WCS) Database 1. Each employee at WCS has an email address which is always their L..e@wcs.com. Using text functions, put each employee's email address in column...

Q1. Create table team with the following fields and constraints. [2 marks] Field Data type Length Constraints team_ID number 10 Primary key teamName varchar 20 Not null city varchar 25 --- Q2. Create...

Tables_bookstore_database: USE bookstore; /* drop the tables */ DROP TABLE IF EXISTS orderitems; DROP TABLE IF EXISTS orders; DROP TABLE IF EXISTS address; DROP TABLE IF EXISTS customer; DROP TABLE...

Write an SQL statement to list ItemID and ItemDescription for all items that cost $1000 or more. Write an SQL statement to list ItemNumber and Description for all items that cost $1000 or more and...

Project SEE attatchment of mom and pop database In this assignment you will create the physical database from your design created in Project 2. Project 2 was a logical model of the Mom & Pop...

What is a deposition and why is it used?

Read the case and answer the following questions 766 381 WORD POWER semiliterate barely able to read or write Unit 9 Reading Essays Writing Practice 1. Assume you are Brady's husband and feel...

4 0 Helicobacter pylori causes Multiple Choice 0 1 : 1 6 : 2 5 gastritis. duodenal ulcers. stomach ulcers. increased risk for stomach cancer. All of the choices are correct

5. Develop a scenario comparing two PH programs and involving the use of a CBA.

Are there any questions that you want to ask?

2. A good source for seeing the subtle differences between legal and illegal job interview questions is at this job Web site: www.jobweb.com/Interview/help .aspx?id=1343&terms=illegal+questions. Use...

C Do you consider the material you post on various Web sites private? Do you think its ethical for employers to be looking at your postings?